I need to know how to to question 8 in excel 
AutoSave Ofi He statisticsQuickstove-VO-Seunathana_Perry_H... - Search Seunathana Hole SH X File Home Insert Draw Page Layout Formulas Data Review G21 fx View Help Assignment Share Comments Assignment Tasks Quickstove IO Use the CONFIDENCE.NORM (see note if you are using Excel 2007) function in cell G21 to 8 calculate a 95% confidence interval for the forecasted Firebox Upgrade kits sales you calculated in cell G17. [6 points) Statistical Analysis Response Task 13 Number of months in the dataset. A B C D E Month 1 1 2 3 4 5 6 1 2 $3,582 Average Firebox Combo Sales 7 3 4 5 6 7 $417 8 9 10 11 Average Firebox Upgrade Sales. Firebox Sales by Month Firebox Deluxe Combo Firebox Upgrade Kit $1,139.87 $59.97 $2,409.72 $99.95 $ $3,389.17 $99.95 $3,091.43 $139.93 $3,879.28 $765.62 $6,078.88 $787.60 $3,560.29 $631.68 $3,552.34 $527.74 $4,481.21 $593.65 $3,051.44 $493.75 $3,469.39 $549.72 $4,563.21 $411.79 $3,795.36 $154.92 1111.37 Population standard deviation for Firebox Combos. 12 9 251.84 Population standard deviation for Firebox Upgrades. 0.69 13 14 15 16 10 11 12 13 Correlation between Firebox combo sales and Firebox upgrade sales. 17 $582.49 Combo sales $4,600 How many dollars in upgrade sales would you expect to realize if combo sales are $4,600 in month 14**? 18 What is the 95% contidence interval"** for upgrade sales? Upper 95% contidence interval level. 19 20 21. 22 23 24 25 26 27 28 29 30 31 32 33 Howard, the manager of QuickStove, LLC, has decided to examine the relationship between sales for Firebox combo sets and Firebox upgrade kits. He has compiled 13 months of sales data for both items. Conduct the requested statistical analyses to examine the nature of the relationship between combo sales and upgrade sales. After conducting some market research, Howard is confident that Firebox combo kit sales will total about $4,600 next month. Based on the relationship between combo sales and upgrade sales, project the likely upgrade kit sales for next month. Construct a 95% confidence interval for your projected upgrade sales next month. Lower 95% confidence interval level * Note: the STDEV.P function is not availoble in Excel 2007. If you are using Excel 2007, use the STDEVP function instead. ** Note: the FORECAST LINEAR function is not available prior to Excel 2016. If you are using a prior version of Excel, use the FORECAST function instead. *** Note: the CONFIDENCE.NORM function is not available in Excel 2007. If vou are using Quickstove Shoes + Ready 85% H Type here to search O 4:32 PM 3/15/2021 IM = AutoSave Ofi He statisticsQuickstove-VO-Seunathana_Perry_H... - Search Seunathana Hole SH X File Home Insert Draw Page Layout Formulas Data Review G21 fx View Help Assignment Share Comments Assignment Tasks Quickstove IO Use the CONFIDENCE.NORM (see note if you are using Excel 2007) function in cell G21 to 8 calculate a 95% confidence interval for the forecasted Firebox Upgrade kits sales you calculated in cell G17. [6 points) Statistical Analysis Response Task 13 Number of months in the dataset. A B C D E Month 1 1 2 3 4 5 6 1 2 $3,582 Average Firebox Combo Sales 7 3 4 5 6 7 $417 8 9 10 11 Average Firebox Upgrade Sales. Firebox Sales by Month Firebox Deluxe Combo Firebox Upgrade Kit $1,139.87 $59.97 $2,409.72 $99.95 $ $3,389.17 $99.95 $3,091.43 $139.93 $3,879.28 $765.62 $6,078.88 $787.60 $3,560.29 $631.68 $3,552.34 $527.74 $4,481.21 $593.65 $3,051.44 $493.75 $3,469.39 $549.72 $4,563.21 $411.79 $3,795.36 $154.92 1111.37 Population standard deviation for Firebox Combos. 12 9 251.84 Population standard deviation for Firebox Upgrades. 0.69 13 14 15 16 10 11 12 13 Correlation between Firebox combo sales and Firebox upgrade sales. 17 $582.49 Combo sales $4,600 How many dollars in upgrade sales would you expect to realize if combo sales are $4,600 in month 14**? 18 What is the 95% contidence interval"** for upgrade sales? Upper 95% contidence interval level. 19 20 21. 22 23 24 25 26 27 28 29 30 31 32 33 Howard, the manager of QuickStove, LLC, has decided to examine the relationship between sales for Firebox combo sets and Firebox upgrade kits. He has compiled 13 months of sales data for both items. Conduct the requested statistical analyses to examine the nature of the relationship between combo sales and upgrade sales. After conducting some market research, Howard is confident that Firebox combo kit sales will total about $4,600 next month. Based on the relationship between combo sales and upgrade sales, project the likely upgrade kit sales for next month. Construct a 95% confidence interval for your projected upgrade sales next month. Lower 95% confidence interval level * Note: the STDEV.P function is not availoble in Excel 2007. If you are using Excel 2007, use the STDEVP function instead. ** Note: the FORECAST LINEAR function is not available prior to Excel 2016. If you are using a prior version of Excel, use the FORECAST function instead. *** Note: the CONFIDENCE.NORM function is not available in Excel 2007. If vou are using Quickstove Shoes + Ready 85% H Type here to search O 4:32 PM 3/15/2021 IM =
