The steps you will follow for this project are as follows: 1) Download the Excel data file. 2) Click on the Video button on the bottom left or within the Get More Help menu for this question now. This tutorial video will walk you through this exercise, step-by-step. 3) Perform the requirements on the data file. 4) Check your work in the Excel file with these check figures. 5) Use your Excel file to answer the four multiple choice questions below. (You will have to scroll down to see all of the questions.) Resources A) Information on how to update Excel and Office 365 . B) If you do not have Office 365 , click here to learn how to get it for free. C) Troubleshooting FAQ. \begin{tabular}{|r|r|r|r|r|} \hline \multicolumn{1}{|c|}{ A24 } & & \end{tabular} Requirements Employees at stores owned by the nationwide Russo Grocery chain frequently hand out free samples of new food products to entice shoppers to purchase new products. Sometimes the free sample distribution leads to stockouts of the product if management has not adequately predicted the demand for the new product. Other times, the chain is left with excess inventory of the new product. Management suspects that the number of free samples distributed can help to predict sales of the new products. The controller at Russo's headquarters has gathered data on the free sample distributions and related new product sales at all Russo stores for the past 60 days. Requirements for the Excel analysis Using the data set online and Excel, perform the following tasks and answer the questions. 1. Create a scatterplot with a linear trendline. Use a Forward Forecast of 100 units. 2. Does the scatterplot indicate that the distribution of free samples can help to predict unit sales of new products? How can you tell? 3. Use the FORECAST.LINEAR function to predict new product sales at the levels of 11,000,11,500, and 12,000 free samples. Does it appear that the number of free samples distributed will be a good predictor of sales of new products? How can you tell? 4. How many units of a new product could Russo expect to sell if it distributes 12,000 free samples of that new product? 5. How many units of a new product could Russo expect to sell if it distributes 12,400 free samples of that new product? Check Figures 12,000 free samples 8,196.882 Print Done This project only has one attempt. Review the check figures with your data file results before answering the questions. If your check figures do not match, do not proceed with answering the questions until you have asked for assistance from your instructor. Using the Excel file you created for Russo, does the scatterplot indicate that the distribution of free samples can help to predict unit sales of new products? How can you tell? A. No. The scatterplot does not indicate that the distribution of free samples increases the number of new sales. B. Yes. The scatterplot indicates that the distribution of free samples increases the number of new sales. Using the Excel file you created for Russo, how many units of a new product could Russo expect to sell if it distributes 11,000 free samples of that new product? A. 8,196.882 B. 8,480.675 C. 7,842.141 D. 7,487.400 Using the Excel file you created for Russo, how many units of a new product could Russo expect to sell if it distributes 11,500 free samples of that new product? A. 7,842.141 B. 8,480.675 C. 8,196.882 D. 7,487.400 Using the Excel file you created for Russo, how many units of a new product could Russo expect to sell if it distributes 12,400 free samples of that new product? A. 7,487.400 B. 8,480.675 C. 7,842.141 D. 8,196.882 The steps you will follow for this project are as follows: 1) Download the Excel data file. 2) Click on the Video button on the bottom left or within the Get More Help menu for this question now. This tutorial video will walk you through this exercise, step-by-step. 3) Perform the requirements on the data file. 4) Check your work in the Excel file with these check figures. 5) Use your Excel file to answer the four multiple choice questions below. (You will have to scroll down to see all of the questions.) Resources A) Information on how to update Excel and Office 365 . B) If you do not have Office 365 , click here to learn how to get it for free. C) Troubleshooting FAQ. \begin{tabular}{|r|r|r|r|r|} \hline \multicolumn{1}{|c|}{ A24 } & & \end{tabular} Requirements Employees at stores owned by the nationwide Russo Grocery chain frequently hand out free samples of new food products to entice shoppers to purchase new products. Sometimes the free sample distribution leads to stockouts of the product if management has not adequately predicted the demand for the new product. Other times, the chain is left with excess inventory of the new product. Management suspects that the number of free samples distributed can help to predict sales of the new products. The controller at Russo's headquarters has gathered data on the free sample distributions and related new product sales at all Russo stores for the past 60 days. Requirements for the Excel analysis Using the data set online and Excel, perform the following tasks and answer the questions. 1. Create a scatterplot with a linear trendline. Use a Forward Forecast of 100 units. 2. Does the scatterplot indicate that the distribution of free samples can help to predict unit sales of new products? How can you tell? 3. Use the FORECAST.LINEAR function to predict new product sales at the levels of 11,000,11,500, and 12,000 free samples. Does it appear that the number of free samples distributed will be a good predictor of sales of new products? How can you tell? 4. How many units of a new product could Russo expect to sell if it distributes 12,000 free samples of that new product? 5. How many units of a new product could Russo expect to sell if it distributes 12,400 free samples of that new product? Check Figures 12,000 free samples 8,196.882 Print Done This project only has one attempt. Review the check figures with your data file results before answering the questions. If your check figures do not match, do not proceed with answering the questions until you have asked for assistance from your instructor. Using the Excel file you created for Russo, does the scatterplot indicate that the distribution of free samples can help to predict unit sales of new products? How can you tell? A. No. The scatterplot does not indicate that the distribution of free samples increases the number of new sales. B. Yes. The scatterplot indicates that the distribution of free samples increases the number of new sales. Using the Excel file you created for Russo, how many units of a new product could Russo expect to sell if it distributes 11,000 free samples of that new product? A. 8,196.882 B. 8,480.675 C. 7,842.141 D. 7,487.400 Using the Excel file you created for Russo, how many units of a new product could Russo expect to sell if it distributes 11,500 free samples of that new product? A. 7,842.141 B. 8,480.675 C. 8,196.882 D. 7,487.400 Using the Excel file you created for Russo, how many units of a new product could Russo expect to sell if it distributes 12,400 free samples of that new product? A. 7,487.400 B. 8,480.675 C. 7,842.141 D. 8,196.882
