Problem 1

"A retail manager seeks a better way to forecast the demand for LED light bulbs. She believes the demand is related to advertising expenditure. The table below shows historical data for the past 5 months.

A) Is there a relationship between sales and advertising? How strong or weak?

B) The company will spend $1,750 next month on advertising. Determine the forecast for sales?"