SCM 301 Forecasting Activity The following table shows a student's GPA for the last 9 semesters: Year Freshman Freshman Freshman Sophomore Sophomore Sophomore Junior Junior Junior Semester Fall Spring Summer Fall Spring Summer Fall Spring Summer GPA 2.5 2.2 2.7 3.0 2.6 3.0 3.2 2.7 3.3 Report all answers rounded to 2 decimals. Copy and paste table into excel to be efficient. 2. Forecast the senior fall semester GPA using a 4-period moving average. b. Forecast the senior fall semester GPA using exponential smoothing. Set a-0.4 and start with a naive forecast for the freshman spring semester based on freshman fall for your first calculation (which will be freshman summer). c. Create a linear trend equation in excel based on the gpa's provided. Forecast the next 2 semesters (senior fall and spring) using your trend equation where x=1 freshman fall. d. Do a naive forecast for freshman spring through junior summer to calculate MAD, MPE, and MAPE for this forecasting technique. e. Use the excel output below to answer the following questions regarding the relationship between weekly study hours and gpa. 0.955 0311 RS AG tandard au 9.000 ANOVA 1 M 0.93133 118 TL TOUS 6. TH w 261 11 0.10 0.83 2009 0.00 118 013 . 21 0 Interpret the slope: For every unit increase in study hours, gpa increases/decreases by What percent of variation in apa is explained by varying study hours? The correlation between study hours and gpa is _indicating a weak/strong and negative/positive relationship Forecast gpa based on studying 5 hours per week. . Question 1 a MA4 (2 decimals) Question 2 b. Exponential smoothing forecast (2 decimals) D Question 3 part 1 Senior Fall (2 decimals) = Question 4 part 2 Senior spring (2 decimals) = Question 5 d. MAD- Module 7. les al C Chegg Se Untitled d. d. MSE - Question 7 d. MAPE (as %, rounded to nearest whole such as XX%) - Question 8 e part 1 For every unit increase in study hours, gpa increases or decreases) by Question 9 e. part 2 What percent of variation in pa is explained by varying study hours? Question 10 part 3a Correlation - Question 11 e, part 3b correlation is weak and Select) Question 12 part 4 forecast spa based on studying 5 hours per week (2 decimals)