Please Show Excel Solution With Formulas Step By Step

A B C D E 19 18 5 2 90 3 80 19 20 21 5 5 6 4 100 1 75 22 2 95 6 6 3 85 23 24 6 4 105 80 25 7 1 N 26 27 100 90 3 4 7 7 7 8 8 28 29 110 1 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 85 30 2 105 31 3 95 8 4 115 32 33 1 85 34 2 110 35 9 9 9 9 10 3 3 105 36 4 120 37 1 10 2 38 39 40 10 10 3 4 4 A B E F G H K L M N o P Q R S T season 1 60 We have a data set for 9 years and there are four season throughout a year. By using linear regression method, creat seasonal forecast for year 10 (periods 37, 38, 39, and 40). 1 sales 1 1 2 3 3 4 1 2 1 1 2 2 2 The rubric Correct answer 3 points Correct formula & wrong answer 1.5 points Wrong formula or no attempt O point The forecast 3 2 4 3 3 1 2 3 3 3 3 4 4 1 4 1 Period year 2 1 3 2 4 3 5 4 6 5 7 6 8 7 9 8 10 9 11 10 12 11 13 12 14 13 15 14 16 15 17 16 18 17 19 18 20 19 21 20 22 21 23 22 24 23 25 24 26 25 27 26 28 27 29 28 30 29 4 4 2 3 4 1 2 70 55 80 55 75 65 84 60 80 70 90 65 85 74 95 70 90 80 100 75 95 85 105 80 100 90 110 85 5 5 5 5 3 4. 1 6 6 6 2 3 4 6 7 1 7 2 7 7 7 8 3 4 1 1