solve question 3,4&5

solve question 3,4&5 by solving ms excel

solve question 3,4&5 from ms excel sheet

the can connected edited 18 A B c 0 HE 2 755 431 4 27 12 14 22 31 28 5 485 70.8 85.4 13 78 a) Graph the data and show the best fit line on the graph. by What is the equation of the best fittine? c) What grade do you predict for a student who has 34 hours of study? 7 8 0 10 12 13 14 15 TO 11 111 35 27 11 17 14 21 165 25 27 20 10 31 481 392 55 93 70.5 20 635 605 30 21 22 23 24 2: Jan 10, 2022. Mar. 26, 2022 Home Care Business Decision Making Topic 3 LA 23 3 Not yet wered Manut Te Use the "Time senestaring activity excel document order topic 3 in mode to answer the following us What is the forecast value for penod ng 3 method to her Enter the number only "Round your number to two decal places only For examp, 106567 is to be bored as 10.65 " Answer Nest pas Previous page Men Time series learning activity-Use this document to complete the LA.13) Jump to Home Cases Basic&cision Making Topic LAD 4 NY answered Moto 100 Use the les louring activity document under topic in modtonwerth What is the Forecast value for period 16 using the potential moog method is the compte "Eher number as a decimal value with two digits the **Do not use any words or symbol F A Next Previous page Jump to Time sens learning activity-Use this document to complete the LA #3) Bol Home Cons Business Decin Making Topic Q5 Use the "Time sensowning activity or document under topic in mode to answer the foot What is the MAE for forecast in het in the SMA **Enter the number only Do not words or syntes Manel Select one 0 0 O 1154 733 Finish attempt Previous page FI 0 | VM Eog could 120 A 150 penod G 3 4 5 a) Using the 3-MA forecasting method, predict the sale's volume for period 16. b) Calculate the amount of MAE and MSE for this 11 11 B Sales volume 1 38 2 10 3 31 4 35 5 43 0 45 2 49 37 45 10 30 11 50 12 56 13 se 10 61 15 57 10 11 12 14 15 10 17 10 19 20 21 92 23 24 25 20 NZEN 28 Home / Coutses Business Analytics & Dession Making Topic 3: LA #3 Question 3 Not yet wered Marked out of 1.00 Use the Time series learning activity excel document under topic in mooie to answer the following question What is the forecast value for period 16 using the 3-MA method in sheet 23 "Enter the number only "Round your number to two decimal places only For example, 10 6567 is to be entered as 1068 Flag un bon Answer Previous page ed Home Courses Business Analytics & Decision Making Topic 37 LA#3 Quesbon 4 Not yet answered Use the "Time series leaming activity excel document under topic 3 in moodie to answer the following question What is the Forecast value for period 16 using the exponential smoothing method with the damping factor of 357 Enter number is a decimal vakie with two digits after the dot" "Do not use any words or symbols Marked out of 100 pag Question Answer Previous page . Time series loaming activity-(Use this Jump to. wered me Courses Business Analytics & Decision Making Topic 3 / LA 13 Question 5 Not yet answered Use the Time senes learning activity" excel document under topic 3 in moodie to answer the following question What is the MAE for the forecast in sheet 2 using the SMA? **Enter the number only **Do not use any words or symbols" Marloed out of 100 Flag question Select one O a 887 Ob 11 54 Oc733 O d. 511 Previous page