# Question: The file P10 49 xlsx contains the amount of money spent advertising

The file P10_49.xlsx contains the amount of money spent advertising a product and the number of units sold for eight months.

a. Assume that the only factor influencing monthly sales is advertising. Fit the following three curves to these data: linear (Y = a + bX), exponential (Y = abX), and multiplicative (Y = aXb). Which equation fits the data best?

b. Interpret the best-fitting equation.

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

a. Assume that the only factor influencing monthly sales is advertising. Fit the following three curves to these data: linear (Y = a + bX), exponential (Y = abX), and multiplicative (Y = aXb). Which equation fits the data best?

b. Interpret the best-fitting equation.

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

**View Solution:**## Answer to relevant Questions

A golf club manufacturer is trying to determine how the price of a set of clubs affects the demand for clubs. The file P10_50.xlsx contains the price of a set of clubs and the monthly sales.a. Assume the only factor ...The auditor of Kiely Manufacturing is concerned about the number and magnitude of year-end adjustments that are made annually when the financial statements of Kiely Manufacturing are prepared. Specifically, the auditor ...Suppose the correlation between the average height of parents and the height of their firstborn male child is 0.5. You are also told that:• The average height of all parents is 66 inches. • The standard deviation of the ...The Bohring Company manufactures a sophisticated radar unit that is used in a fighter aircraft built by Seaways Aircraft. The first 50 units of the radar unit have been completed, and Bohring is preparing to submit a ...Based on the data in the file P02_23.xlsx from the U.S. Department of Agriculture, explore the relationship between the number of farms (X) and the average size of a farm (Y) in the United States. a. Use the given data to ...Post your question