AJ Auto center uses television advertising. The owner is wondering if the expense TV ads are worth the money. Is there a relationship between the number of ads they purchase per month and the number of vehicles sold in that month? Their historical data for the number of ads their place and the vehicles sold is listed below.
Ads placed, Vehicles sold
15, 6
9, 4
40, 16
20, 6
25, 13
25, 9
15, 10
35, 16
Create a scatter chart of the AJ Auto data. What is the equation of the trend line? If AJ Auto placed 31 ads next month, how many cars could they expect to sell? What is the Standard Error of the Estimate? What is the Coefficient of Correlation? What is the Coefficient of Determination? Would you recommend that the owner of AJ Auto continue or discontinue their TV ads? Why? ((Need to answer with the excel form)