What is the equation of the trend line

Assignment Help Operation Management

Reference no: EM131694138

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)

Reference no: EM131694138

Questions Cloud

Find the variance of service time at the bank : The service time in queues should not have a large variance; otherwise, the queue tends to build up. A bank regularly checks service time by its tellers.

American water keeps data flowing : Do significant research outside of the book " American Water Keeps Data Flowing " and demonstrate that you have in a very obvious way.

How a company utilized a cost accumulation system : Explain how the system was used and, specifically, how overhead was allocated - Discuss how the use of cost accumulation enhanced the companys operations

Prepare a market research strategy for any airlines company : Prepare a market research strategy for any airlines company

What is the equation of the trend line : Create a scatter chart of the AJ Auto data. What is the equation of the trend line?

Explain the acquisition strategy : How should an organization decide on how "cutting edge" it should be in its IT acquisition strategy?

Some of these brief paragraphs were combined : Would the narrative be more effective if some of these brief paragraphs were combined?

Define an activity based cost system : Define an Activity Based Cost System (ABC) and what it is used for - Discuss how an Activity Based Cost System can be used for a manufacturer of flat screen

The actual number of patients at the dental clinic : The actual number of patients at the dental clinic for the first 6 weeks of school year are listed in the table below

User Account

All Pages