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

A researcher interested in explaining the level of foreign reserves for the country of Barbados estimated the following multiple regression model using yearly data spanning the period 2001 to 2016: FR=a+BOIL+yEXP+8FDI Where FR = yearly foreign reserves ($000's), OIL = annual oil prices, EXP = yearly total exports ($000's) and FDI = annual foreign direct investment ($000's). The sample of data was processed using MINITAB and the following is an extract of the output obtained: Predictor Сoef StDev t-ratio p-value Constant 5491.38 2508.81 2.1888 0.0491 OIL 85.39 18.46 4.626 0.0006 EXP -377.08 112.19 0.0057 FDI -396.99 160.66 -2.471 ** S = 2.45 R-sq 96.3% R-sq (adj) 95.3% Analysis of Variance Source DF MS F Regression 1991.31 663.77 ?? Error 12 77.4 6.45 Total 15 a) What is dependent and independent variables? b) Fully write out the regression equation c) Fill in the missing values *', ***', '?'and ??' d) Hence test whether B is significant. Give reasons for your answer. e) Perform the F…
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…
A researcher collected statistics on the sales amount of a product in 120 different markets and the advertising budgets used in TV, radio and newspaper media channels for each of these markets. The sales amount are expressed in 1000 units, and the budgets are expressed in 1000 $. The researcher wants to create a simple linear regression model by choosing one among the TV, radio and newspaper advertising budgets to explain the amount of sales.a) Which variable should this researcher choose as an independent variable to the simple regression model? Explain your decision by providing its statistical basis.(use formula)b) Construct the simple linear regression model using the argument you chose and write the equation of the model. Comment b0 and b1.(not excel use formula please)c) Test whether there is a statistically significant, linear relationship between the independent variable and the dependent variable by establishing the relevant hypotheses at the level of α = 0.05 significance.…
Suppose you are estimating a wage regression, where salary is the dependent variable and age, years of education and a dummy variable for male are your independent variables. You are interested in measuring how salary differs between those who have at least a college education with those who have less than a college education. If a person is considered as having a college education when she has more than 12 years of education, how can you measure the difference in salary between college and non-college educated individuals? Select one: a. Multiply coefficient for years of education in original regression by 12 O b. Re-estimate model replacing years of education with a dummy variable for college c. Re-estimate model replacing years of education with a dummy variable for college and one for no college O d. Re-estimate model interacting years of education with a dummy variable for college e. Calculate the difference in predicted salary between an individual with 14 years of education and…
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

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