X AutoSave Off Ch18_13v3_18e (2) - Excel Search (Alt+Q) 1485493 X File Home Insert Draw Page Layout Formulas Data Review View Help Comments Share Calibri 11 ~ A A" ab General Insert Ap O Conditional Format as Delete Paste B $ ~ % " Cell Sort & Find & Analyze Formatting Table Styles ~ Format Filter * Select v Data Undo Clipboard Font Alignment Number Styles Cells Editing Analysis A1 XV fx Period A B C D E F G H J K L M N O P Q Period Sales 1 1001 1129 AWN 843 1044 5 1012 6 703 40 00 7 682 8 712 10 9 646 11 10 686 12 11 909 13 12 469 14 13 566 15 14 488 16 15 688 17 16 675 18 17 303 19 18 381 20 Ch18_13v3_18e (+ Ready + 100% Type here to search O O W GX 11:17 AM 53OF O ENG 12/9/2021* Homework Help - Q&A from Onl x Question 2 - Unit 8 Assignment - X + V X > C A ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=08launchUrl=https%253A%252F%252FIms.mheducation.com%252Fmghmiddleware%2... Q @ * * . .. Unit 8 Assignment Saved Help Save & Exit Submit 2 Check my work Using the time series data in the table. respond to the following items. Period Sales 5 1 $1,361 points 1,129 3 843 4 Skipped 1,844 5 1,912 6 793 7 682 8 712 9 646 BOOK 18 686 11 909 12 469 13 566 14 Print 488 15 688 16 675 17 393 18 381 References Click he l Data File places.) d-1. Compute all possible forecasts using a trend forecasting model using simple linear regression? (Round your answers to 2 decimal Period Sales Predicted Sales Absolute Error 1,001 2 1,129 3 843 4 1,044 5 1,012 703 7 682 8 712 9 846 10 Mc Graw Type here to search O O W X DE ENG 11:17 AM 12/9/2021* Homework Help - Q&A from Onl x 5 Question 2 - Unit 8 Assignment - X + V X > C A ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252FIms.mheducation.com%252Fmghmiddleware%2... @ @ * * . .. Unit 8 Assignment Saved Help Save & Exit Submit 2 Check my work 10 686 11 606 12 489 5 13 566 points 14 488 Skipped 15 688 16 675 17 303 18 381 Book Print References d-2. What is the MAD? (Round your answer to 2 decimal places.) MAD d-3. What is the trend equation based on the regression analysis? (Round your answers to 2 decimal places.) Sales = time period. Mc Graw Type here to search O O W X DENG 11:18 AM 12/9/2021* Homework Help - Q&A from Onl x Question 2 - Unit 8 Assignment - X + V X > C A ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=08launchUrl=https%253A%252F%252FIms.mheducation.com%252Fmghmiddleware%2... Q @ * * . .. Unit 8 Assignment Saved Help Save & Exit Submit Check my work 2 5 d-3. What is the trend equation based on the regression analysis? (Round your answers to 2 decimal places.) points Skipped Sales = time period. Book Print e. What is the predicted annual change of industry sales? (Round your answer to 2 decimal places.) Predicted annual change of industry sales References f. Predict sales for the next three periods. (Round your answers to 2 decimal places.) Predicted sales Sales (19) Sales (20) Sales (21) Mc Graw Type here to search O W X DE ENG 11:18 AM O 12/9/2021