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 a. 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 Spa Hepsi Mattiolek 0.955 Soare 0.511 AS 0.09 Standard Q 9000 ANOVA Ango Resita Tot 1 7 55 MES 1 1135 0.91135 71 8733394 622- OG 0.01107 water . Saami Star Pole LESS 201 010 20.08 00 1 225 017 6.02 0.00 OR Interpret the slope: For every unit increase in study hours, apa increases/decreases by __ What percent of variation in spa is explained by varying study hours? The correlation between study hours and goals indicating a weak/strong and negative/positive relationship. Forecast gpa based on studying 5 hours per week. . Partial 1/2 pts Question 8 e part 1 For every unit increase in study hours, spa (increases or decreases) cremer by 3 Answer 1: increases Answer 2 3 incorrect 0/2 pts Question 9 e part 2 What percent of variation in spa is explained by varying study hours? 87 Incorrect 0/2 pts Question 10 e part 3 Correlation 23 Partial Question 11 1/2 pts e part 3 correlation is weak and positive Answer 1: Answer 2 DOVE Incorrect Question 12 0/2 pts e part 4 forecast gpa based on studying 5 hours per week (2 decimals) 287 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 a. 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 Spa Hepsi Mattiolek 0.955 Soare 0.511 AS 0.09 Standard Q 9000 ANOVA Ango Resita Tot 1 7 55 MES 1 1135 0.91135 71 8733394 622- OG 0.01107 water . Saami Star Pole LESS 201 010 20.08 00 1 225 017 6.02 0.00 OR Interpret the slope: For every unit increase in study hours, apa increases/decreases by __ What percent of variation in spa is explained by varying study hours? The correlation between study hours and goals indicating a weak/strong and negative/positive relationship. Forecast gpa based on studying 5 hours per week. . Partial 1/2 pts Question 8 e part 1 For every unit increase in study hours, spa (increases or decreases) cremer by 3 Answer 1: increases Answer 2 3 incorrect 0/2 pts Question 9 e part 2 What percent of variation in spa is explained by varying study hours? 87 Incorrect 0/2 pts Question 10 e part 3 Correlation 23 Partial Question 11 1/2 pts e part 3 correlation is weak and positive Answer 1: Answer 2 DOVE Incorrect Question 12 0/2 pts e part 4 forecast gpa based on studying 5 hours per week (2 decimals) 287