As the senior sales manager of SparkShop, you want to determine how much various forms of...

Transcribed Image Text:

As the senior sales manager of SparkShop, you want to determine how much various forms of advertising impact the sale of products. Moreso, you want to determine whether you can utilize advertising expenses to predict product sales. You decide to utilize data from the company's enterprise resource planning (ERP) platform. The data that you obtain contains a product number that is unique to each product sold by the company; the amount of television, radio, and newspaper ad spending (in thousands of dollars) for each product over the past year, and the total product sales for each product over the past year (reported in millions of dollars). Utilizing the data, develop the following regression models to determine the most accurate predictive model that can be created at the 5% level of significance: TV Ad Spending as a sole predictor of Product Sales Radio Ad Spending as a sole predictor of Product Sales Newspaper Ad Spending as a sole predictor of Product Sales TV, Radio, and Newspaper Ad Spending as predictors of Product Sales In a Microsoft Word document, answer the following questions: What is the most accurate regression model based on the dataset? How much variance in product sales does the model account for. On the second page of the same document, write a brief professional memo to the company's marketing director that summarizes your conclusions in a way that someone who is not educated on statistical practices can understand the implications of your findings. As the senior sales manager of SparkShop, you want to determine how much various forms of advertising impact the sale of products. Moreso, you want to determine whether you can utilize advertising expenses to predict product sales. You decide to utilize data from the company's enterprise resource planning (ERP) platform. The data that you obtain contains a product number that is unique to each product sold by the company; the amount of television, radio, and newspaper ad spending (in thousands of dollars) for each product over the past year, and the total product sales for each product over the past year (reported in millions of dollars). Utilizing the data, develop the following regression models to determine the most accurate predictive model that can be created at the 5% level of significance: TV Ad Spending as a sole predictor of Product Sales Radio Ad Spending as a sole predictor of Product Sales Newspaper Ad Spending as a sole predictor of Product Sales TV, Radio, and Newspaper Ad Spending as predictors of Product Sales In a Microsoft Word document, answer the following questions: What is the most accurate regression model based on the dataset? How much variance in product sales does the model account for. On the second page of the same document, write a brief professional memo to the company's marketing director that summarizes your conclusions in a way that someone who is not educated on statistical practices can understand the implications of your findings.