Scatter diagram, regression
Quick-print firms in a large downtown business area spend most of their advertising dollars on advertisements on bus benches. A research project involves predicting monthly sales based on the annual amount spent on placing ads on bus benches. A sample of quick-print firms revealed these advertising expenses and sales.
Annual Bus Bench Advertising
($ thousands) Monthly Sales
a. Draw a scatter diagram.
b. Determine the coefficient of correlation.
c. What is the coefficient of determination?
d. Compute the regression equation.
e. Estimate the monthly sales of a quick-print firm that spends $4,500 on bus bench advertisements.
f. Summarize your findings.
SOLUTION This solution is FREE courtesy of BrainMass!
a) Shown in the excel sheet
b)Coefficient of correlation = R^2 = .913 ( from the graph).
So R = .955
c)Coefficient of Determination = 8.8514 ( Frm the graph)
d)Regression Equation : Y = 8.8514x + 21.824
e)Monthly Sales(y) = 8.8514 * 4.5 + 21.824
= 61.6553 ( in thousands of dollars)
f) From the above linear regression equation we can see that over 1000 dollars spend on advertising brings in extra 8851 dollars in monthly sales. Without any advertising we would have a monthly sale of 21,824 dollars.
I have done the problem using excel and the inbuilt capabilities of excel to calculate the regression equation. You can do this by first creating a scatter plot on excel and then adding a trendline from the pull down menu. Hope it is clear.© BrainMass Inc. brainmass.com December 24, 2021, 4:48 pm ad1c9bdddf>