No Spac... Heading 1 Header Paragraph s Styles 2. One year's sales data is recorded in the embedded Excel file below. Download the embedded Excel spreadsheet to your computer. Save the file with the name YourNameAssignment2.xlsx. Edit the Excel document according to the tasks that follow. Assignment 2xlsx 3. Find forecasts for each of the following forecasting types by inserting formulas and completing the table: 3-Month Moving Average, 6-Month Moving Average, 3-Month Weighted Moving Average, 6-Month Weighted Moving Average and Exponential Smoothing. Use the cell labels in the Excel spreadsheet as a guide. 4. Find the MADS - Mean Absolute Deviation and MSEs - Mean Squared Error of the following forecasting types by inserting formulas and completing the table: 3-Month Moving Average. 6- Month Moving Average, 3-Month Weighted Moving Average, 6-Month Weighted Moving Average and exponential Smoothing. Use the cell labels in the Excel spreadsheet as a guide. 5. In the space that follows. Insert a scatterplot of the sales data over time below. Use 1 month increments for the X-axis and an increment of 2 on the Y-a 6. Does the scatterplot indicate suggest a linear trend over time? 7. Submit this document and the Excel document for grading. Use the Assignment Link on Blackboard, 8. Post any questions on this assignment to Discussion 2 nome Insert Page Layout Search Formulas Data Review View Help Calibri 111 LE - A A A- Wrap Text aste General B TU Merge Center - lipboard $ - %) * Font Alignment Conditional Formatas Cell Formatting Table Styles Styles Number 11 A B D E H 3. Month Moving Average 6-Moth Moving Average 3.Month Moving Average Weights 3,2,1" 6 - Month Moving Average Weights 6, 5, 4, 3, 2, 1" Exponential Smoothing o.1 3 5 6 7 8 9 10 11 Month Actual Sales January 10 February 12 March 13 April 16 May 19 Jurre 23 July 26 August 30 September 28 October 18 November 16 December 14 12 13 14 Type here to search