a) Determine the dependent and independent variables.b) Discuss the expected signs of the coefficientsc) Write the estimated regression equation.d) Are the signs of the coefficient estimates as expected?e) Interpret the estimates of B2 and B3 of the regression model.f) Use p-value method and check whether the individual parameters are statisticallysignificant. Use a = .05.g) Predict the annual sales of an office which had an annual advertising budget ofRs.12500and 20 sales agents. The managing director of ABC real estate company wanted to know why certain branches ofthe company outperformed others. He felt that the key factors in determining total annual sales(y, in Rs. millions) were the advertising budget (in Rs.000s), X1, and the number of sales agents,X2. To analyse the situation, he took a random sample of 15 offices. A multiple regressionmodel of the formY = Bo+ BiX+ B2X2+ewas estimated and the output is shown belowRegression StatisticsR SquaredAdjusted R Squared0.5240.445Standard error7.362F-statisticsProb (F-statistic)12.8480.000Coefficient-19.470.158p-value0.119Standard Erort-statisticsInterceptXIX215.84-1.230.0562,820.0070.9630.7781.240.118

There are three variables. This is multiple regression model. We have to write regression equation…

Answered: The managing director of ABC real…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

The maintenance manager at a trucking company wants to build a regression model to forecast the time (in years) until the first engine overhaul based on four predictor variables: (1) annual miles driven (in 1,000s of miles), (2) average load weight (in tons), (3) average driving speed (in mph), and (4) oil change interval (in 1,000s of miles). Based on driver logs and onboard computers, data have been obtained for a sample of 25 trucks. A portion of the data is shown in the accompanying table. Time Miles Load Speed Oil 7.7 42.9 22.0 44.0 16.0 0.8 98.3 20.0 47.0 34.0 6.3 61.1 22.0 62.0 15.0 E Click here for the Excel Data File b. Estimate the regression model. (Negative values should be indicated by a minus sign. Round your answers to 2 decimal places.) Time = Miles Load Speed oil + + d. What is the predicted time before the first engine overhaul for a particular truck driven 60,000 miles per year with an average load of 25 tons, an average driving speed of 53 mph, and 21,000 miles…
The table below gives the number of hours spent unsupervised each day as well as the overall grade averages for seven randomly selected middle school students. Using this data, consider the equation of the regression line, bo + b₁x, for predicting the overall grade average for a middle school student based on the number of hours spent unsupervised each day. Keep in mind, the correlation coefficient may or may not be statistically significant for the data given. Remember, In practice, it would not be appropriate to use the regression line to make a prediction if the correlation coefficient is not statistically significant. a Answer How to enter your answer (opens in new window) Step 6 of 6: Find the value of the coefficient of determination. Round your answer to three decimal places. 9 S e $ A A Hours Unsupervised Overall Grades V 96 5 t 8 b Oll 0 0.5 1 3.5 4 5 5.5 95 92 85 83 81 73 63 h → U İ 8 i k N 9 O alt I * Р ctri Tables Copy Data Keypad Keyboard Shortcuts Previous step answers…
For major league baseball teams, do higher player payrolls mean more gate money? Here are data for each of the American League teams in the year 2002. The variable x denotes the player payroll (in millions of dollars) for the year 2002, and the variable y denotes the mean attendance (in thousands of fans) for the 81 home games that year. The data are plotted in the scatter plot below, as is the least-squares regression line. The equation for this line is y = 11.43 + 0.23x. Player payroll, x (in Mean attendance, y (in $1,000,000s) thousands) Anaheim 62.8 28.52 Baltimore 56.5 33.09 40- Boston 110.2 32.72 35 Chicago White Sox 54.5 20.74 30- Cleveland 74.9 32.35 25- Detroit 54.4 18.52 Kansas City 49.4 16.30 15- Minnesota 41.3 23.70 10+ New York Yankees 133.4 42.84 Oakland 41.9 26.79 20 40 60 80 100 120 140 Seattle 86.1 43.70 Player payroll, Тarmpa Bay 34.7 13.21 X (in $1,000,000s) Техas 106.9 29.01 Toronto 66.8 20.25 Send data to calculator Send data to Excel Based on the sample data and…
A recent study showed that the hours a person exercised in a week affected the individual'sresting heart rate. It was computed that r = -.68 and the least squares regression line was?̂ = 83-1.4x, where x is the hours exercised and y is the resting heart rate. d. What percentage of variability in resting heart rate can be explained by variability inhours exercised?
The adjusted R-squared accounts for the amount of variance explained while also adjusting for the number of independent variables in the linear regression equation. True or False
The table below gives the age and bone density for five randomly selected women. Using this data, consider the equation of the regression line, yˆ=b0+b1^x, for predicting a woman's bone density based on her age. Keep in mind, the correlation coefficient may or may not be statistically significant for the data given. Remember, in practice, it would not be appropriate to use the regression line to make a prediction if the correlation coefficient is not statistically significant. Age Bone Density35 35043 34053 33954 32155 310 Step 3 of 6 : Determine if the statement "Not all points predicted by the linear model fall on the same line" is true or false.
A trucking company considered a multiple regression model for relating the dependent variable y = total daily travel time for one of its drivers (hours) to the predictors x₁ = distance traveled (miles) and x₂ = the number of deliveries made. Suppose that the model equation is Y = -0.800+ 0.060x₁ +0.900x₂ + e (a) What is the mean value of travel time when distance traveled is 50 miles and four deliveries are made? hr (b) How would you interpret ₁ = 0.060, the coefficient of the predictor x₁? O When the number of deliveries is constant, the average change in travel time associated with a ten-mile (i.e. one unit) increase in distance traveled is 0.060 hours. O The total daily travel time increases by 0.060 hours when the distance traveled increases by 1. O When the number of deliveries is held fixed, the average change in travel time associated with a one-mile (i.e. one unit) increase in distance traveled is 0.060 hours. O The average change in travel time associated with a one-mile (i.e.…
A company that manufactures computer chips wants to use a multiple regression model to study the effect that 3 different variables have on y, the total daily production cost (in thousands of dollars). Let B,, B,, and B, denote the coefficients of the 3 variables in this model. Using 22 observations on each of the variables, the software program used to find the estimated regression model reports that the total sum of squares (SST) is 485.84 and the regression sum of squares (SSR) is 229.91. Using a significance level of 0.10, can you conclude that at least one of the independent variables in the model provides useful (i.e., statistically significant) information for predicting daily production costs? Perform a one-tailed test. Then complete the parts below. Carry your intermediate computations to three or more decimal places. (a) State the null hypothesis H, for the test. Note that the alternative hypothesis H, is given. H, :0 H, : at least one of the independent variables is useful…
The table below gives the number of hours spent unsupervised each day as well as the overall grade averages for five randomly selected middle school students. Using this data, consider the equation of the regression line, yˆ=b0+b1x, for predicting the overall grade average for a middle school student based on the number of hours spent unsupervised each day. Keep in mind, the correlation coefficient may or may not be statistically significant for the data given. Remember, in practice, it would not be appropriate to use the regression line to make a prediction if the correlation coefficient is not statistically significant. Hours Unsupervised 2 3 4 5 6 Overall Grades 94 86 79 71 62 Table Step 1 of 6 : Find the estimated slope, y intercept and correlation coefficient Round your answer to three decimal places. Answer
An oil exploration company wants to develop a statistical model to predict the cost of drilling a new well. One of the many variables thought to be an important predictor of the cost is the number of feet in depth that the must be drilled to create the well. Consequently, the company decided to fit the simple linear regression model, where y = cost of drilling the new well (in $thousands) and x = number of feet drilled to create the well. Using data collected for a sample of n=83 wells, the following results were obtained: = 10.5 + 16.20x Give a practical interpretation of the estimate of the slope of the least squares line. An oil exploration company wants to develop a statistical model to predict the cost of drilling a new well. One of the many variables thought to be an important predictor of the cost is the number of feet in depth that the must be drilled to create the well. Consequently, the company decided to fit the simple linear regression model, where y =…
The table below gives the number of hours spent unsupervised each day as well as the overall grade averages for seven randomly selected middle school students. Using this data, consider the equation of the regression line, yˆ=b0+b1x, for predicting the overall grade average for a middle school student based on the number of hours spent unsupervised each day. Keep in mind, the correlation coefficient may or may not be statistically significant for the data given. Remember, in practice, it would not be appropriate to use the regression line to make a prediction if the correlation coefficient is not statistically significant. Hours Unsupervised 0 1 1.5 2.5 4 5.5 6 Overall Grades 98 86 85 83 80 78 67 Table Step 1 of 6: Find the estimated slope, y intercept, correlation cofficient Round your answers to three decimal places.
The table below gives the age and bone density for five randomly selected women. Using this data, consider the equation of the regression line, yˆ=b0+b1^x, for predicting a woman's bone density based on her age. Keep in mind, the correlation coefficient may or may not be statistically significant for the data given. Remember, in practice, it would not be appropriate to use the regression line to make a prediction if the correlation coefficient is not statistically significant. Age Bone Density35 35043 34053 33954 32155 310 Step 4 of 6 : Determine the value of the dependent variable yˆ at x=0.

SEE MORE QUESTIONS

Recommended textbooks for you

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

Elementary Statistics: Picturing the World (7th E…

Statistics

ISBN:

9780134683416

Author:

Ron Larson, Betsy Farber

Publisher:

PEARSON

The Basic Practice of Statistics

Statistics

ISBN:

9781319042578

Author:

David S. Moore, William I. Notz, Michael A. Fligner

Publisher:

W. H. Freeman

Introduction to the Practice of Statistics

Statistics

ISBN:

9781319013387

Author:

David S. Moore, George P. McCabe, Bruce A. Craig

Publisher:

W. H. Freeman

SEE MORE TEXTBOOKS