Question: NOTE: Use 4 decimals for all your calculations and answers. If it's not possible, use 3 or 2 decimals depending on the situation, but for

NOTE: Use 4 decimals for all your calculations and answers. If it's not possible, use 3 or 2 decimals depending on the situation, but for the vast majority of calculations and answers, 4 decimals will be the norm.

The sales manager of various branches of a sports equipment store has launched a national advertising campaign for a few months. The monthly costs (in thousands of dollars) for advertising over a 10-month period and the corresponding net revenue (in thousands of dollars) before tax are presented in the table below.

MonthNet Revenue Before Tax (y) $000Monthly Ad Cost (x) $000
January13511
February21218
March18012.2
April21219.8
May20017.5
June16215.2
July15014.2
August17216.5
September15513
October18015

Based on the distribution of the points, one can assume that there is a linear relationship between these two variables.

a) Identify i) the dependent variable; ii) the independent variable. b) Determine the coefficients of the regression line given that NOTE: You must use a different formula than the one in d) for b1. n = 10 ?xy = 27340 x? = 15.2400 y? = 175.8000 sx = 7.6093 sy = 689.9556 c) Calculate the correlation coefficient between the two variables using the expression r = (?xiyi - n x? y?) / ((n - 1)sx sy) d) Verify the slope calculation of the regression line using the expression b1 = r (sy / sx) e) The manager wants to spend $17,000 on advertising in November. What net revenue can she expect if she uses the regression equation as a prediction tool? f) The assistant manager suggests a big push and spending $24,000 on advertising. Do you think the suggestion is "reasonable"? Explain.

NOTE: Use 4 decimals for all your calculations and answers. If it's

\f

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!