Hi. May I have help answering the questions below please? I will make sure to like if helpful! Thank you!
Requirements Employees at stores owned by the nationwide Corbin Grocery chain trequently 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 Corbin's headquarters has gathered data on the free sample distributions and related new product sales at all Corbin 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 9,000,9,500, and 10,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 Corbin expect to sell if it distributes 10,000 free samples of that new product? 5. How many units of a new product could Corbin expect to sell if it distributes 10.700 free samples of that new product? Using the Excel file you created for Corbin, how many units of a new product could Corbin expect to sell if it distributes 9,000 free samples of that new product? A. 7,214.143 B. 6,028.991 C. 6,377.565 D. 6,726.139 Using the Excel file you created for Corbin, how many units of a new product could Corbin expect to sell if it distributes 9,500 free samples of that new product? A. 6,726.139 B. 6,377.565 C. 7,214.143 D. 6,028.991 Using the Excel file you created for Corbin, how many units of a new product could Corbin expect to sell if it distributes 10,700 free samples of that new product? A. 6,726.139 B. 6,028.991 C. 7,214.143 D. 6,377.565 Requirements Employees at stores owned by the nationwide Corbin Grocery chain trequently 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 Corbin's headquarters has gathered data on the free sample distributions and related new product sales at all Corbin 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 9,000,9,500, and 10,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 Corbin expect to sell if it distributes 10,000 free samples of that new product? 5. How many units of a new product could Corbin expect to sell if it distributes 10.700 free samples of that new product? Using the Excel file you created for Corbin, how many units of a new product could Corbin expect to sell if it distributes 9,000 free samples of that new product? A. 7,214.143 B. 6,028.991 C. 6,377.565 D. 6,726.139 Using the Excel file you created for Corbin, how many units of a new product could Corbin expect to sell if it distributes 9,500 free samples of that new product? A. 6,726.139 B. 6,377.565 C. 7,214.143 D. 6,028.991 Using the Excel file you created for Corbin, how many units of a new product could Corbin expect to sell if it distributes 10,700 free samples of that new product? A. 6,726.139 B. 6,028.991 C. 7,214.143 D. 6,377.565
