g

Please use and upload answers as Excel.

MS Excel can be used for many statistical functions, including forecasting. Scoring breakdown as follows: For each product line, develop the forecast for Month 35 (0.5 points) Use the data from Month 1 to Month 34 (0.5 points) Add trend line for each product line (0.5 points) Use the software to display the regression equation on the chart for each product line (0.5 points) To earn full credit, the submission shall be submitted as a MS Excel file. Data spreadsheet is attached below. Product 1 Sales Product 2 Sales Product 3 Sales 25,387 30,944 7,958 12,559 31,404 37,008 31,106 27,457 22,719 33,447 4,696 10,316 10,511 31,136 43,457 33,979 35,632 29,464 27,898 4,489 14,640 45,316 35,925 6,945 29,220 26,861 36,126 32,608 40,146 41,916 38,151 7,791 9,628 11,866 35,872 39,658 29,145 6,503 7,445 14,066 44,533 34,260 34,917 33,346 29,022 28,082 7,250 13,265 10,394 1 6 Month 7 Month 1 8 Month 2 9 Month 3 10 Month 4 11 Month 5 12 Month 6 13 Month 7 14 Month 8 15 Month 9 16 Month 10 17 Month 11 18 Month 12 19 Month 13 20 Month 14 21 Month 15 22 Month 16 23 Month 17 24 Month 18 25 Month 19 26 Month 20 27 Month 21 28 Month 22 29 Month 23 30 Month 24 31 Month 25 32 Month 26 33 Month 27 34 Month 28 35 Month 29 36 Month 30 37 Month 31 38 Month 32 39 Month 33 40 Month 34 41 Forecast: Month 35 (or 42 43 41,246 32,682 35,326 48,319 43,902 42,120 50,287 41,746 36,701 45,968 13,153 15,363 14,073 43,191 35,453 9,404 11,295 32,211 41,709 34,645 32,800 45,831 38,023 13,961 14,394 13,207 11,900 8,706 45,874 40,254 33,282 32,944 31,888 37,210 15,179 43,553 48,520 16,765 12,456 49,980 37,760 35,577 43,185 53,619 12,837 10,385 8,979 10,779 45,305 47,294 46,005 52,873 55,066 MS Excel can be used for many statistical functions, including forecasting. Scoring breakdown as follows: For each product line, develop the forecast for Month 35 (0.5 points) Use the data from Month 1 to Month 34 (0.5 points) Add trend line for each product line (0.5 points) Use the software to display the regression equation on the chart for each product line (0.5 points) To earn full credit, the submission shall be submitted as a MS Excel file. Data spreadsheet is attached below. Product 1 Sales Product 2 Sales Product 3 Sales 25,387 30,944 7,958 12,559 31,404 37,008 31,106 27,457 22,719 33,447 4,696 10,316 10,511 31,136 43,457 33,979 35,632 29,464 27,898 4,489 14,640 45,316 35,925 6,945 29,220 26,861 36,126 32,608 40,146 41,916 38,151 7,791 9,628 11,866 35,872 39,658 29,145 6,503 7,445 14,066 44,533 34,260 34,917 33,346 29,022 28,082 7,250 13,265 10,394 1 6 Month 7 Month 1 8 Month 2 9 Month 3 10 Month 4 11 Month 5 12 Month 6 13 Month 7 14 Month 8 15 Month 9 16 Month 10 17 Month 11 18 Month 12 19 Month 13 20 Month 14 21 Month 15 22 Month 16 23 Month 17 24 Month 18 25 Month 19 26 Month 20 27 Month 21 28 Month 22 29 Month 23 30 Month 24 31 Month 25 32 Month 26 33 Month 27 34 Month 28 35 Month 29 36 Month 30 37 Month 31 38 Month 32 39 Month 33 40 Month 34 41 Forecast: Month 35 (or 42 43 41,246 32,682 35,326 48,319 43,902 42,120 50,287 41,746 36,701 45,968 13,153 15,363 14,073 43,191 35,453 9,404 11,295 32,211 41,709 34,645 32,800 45,831 38,023 13,961 14,394 13,207 11,900 8,706 45,874 40,254 33,282 32,944 31,888 37,210 15,179 43,553 48,520 16,765 12,456 49,980 37,760 35,577 43,185 53,619 12,837 10,385 8,979 10,779 45,305 47,294 46,005 52,873 55,066