The file P10_49.xlsx contains the amount of money spent advertising a product and the number

of units sold for eight months. Assume that the only factor influencing monthly sales is

advertising.

a. Create a scatterplot of these data and use Excel or StatTools to fit the following three curves:

– linear: y = a + bx

– exponential: x

ab

y=

– power: b

ax

y=

Which equation fits the data best?

b. What is the value of b in the best-fitting equation and how can you interpret it?

c. Using the best-fitting equation, predict sales during a month in which $60,000 is spent on

advertising.

d. What would be the equation of the corresponding regression model should you decide to run it?

#### Top Answer

Dear Student Please find... View the full answer

### Recently Asked Questions

- A researcher asks the question "Is there a relationship between GRE total scores and GPAs in the master's programs in electrical engineering?" The researcher's

- How can an agent ensure the earliest possible commencement of a rehabilitation program? You have received a medical report which states a worker is able to

- Get the first midterm grade Get the second midterm grade Calculate the average Display the average If the average is greater than 96: Congratulate the student