Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Module 2 Individual Assignment Problems Note: Data for these problems are in the Module 2 Individual Assignments Data file -there is a tab for each

image text in transcribed
image text in transcribed
image text in transcribed
Module 2 Individual Assignment Problems Note: Data for these problems are in the Module 2 Individual Assignments Data file -there is a tab for each problem, All answers should be entered using two decimal places unless otherwise specified. If both decimal places are zeros-then just enter the integer value. Percentages should be entered without "%"sign- 3.45% should be entered as 3.45. M2 IND1. Mariah Henderson is a WCU student who has just finished her junior year. The data in Worksheet IND1 summarizes her grade point average (GPA) for each of the last 9 semesters. a) b) c) d) e) Compute the forecasts using the naive forecasting method. What is the MAD? Compute the forecast for Senior Year - Fall Semester using the naive forecasting method. Compute the forecasts using the two-period moving average. What is the MAPE? Compute the forecast for Senior Year -Fall Semester using the two-period moving average Compute the forecasts using the three-period weighted moving average using weights of 0.4 0.35, and 0.25. What is the MAD? f) Compute the forecast for Senior Year-Fall Semester using the three-period weighted moving 8) Compute the forecasts using exponential smoothing with a smoothing constant of 0.25 and a h) Compute the forecast for Senior i) Comparing one of the error measurements (MAD, MSE, or MAPE)- which is the best forecasting average using weights of 0.4, 0.35, and 0.25. forecast for First Year-Fall Semester of 2.60. What is the MSE? smoothing constant of 0.25 and a forecast for First Year-Fall Semester of 2.60 method? Which is the worst forecasting method? Year Fall Semester using exponential smoothing with a M2 IND2. A regional limousine service examined their routes for the past 15 weeks. The data in Worksheet IND2 provides and record of the total miles drive in each week. Compute the forecasts using the four-period moving average. What is the MAPE? Compute the forecast for Week 16 using the four-period moving average. Compute the forecasts using exponential smoothing with a smoothing constant of 0.15 and a forecast for Week 1 of 20,000. What is the MAD? Compute the forecast for Week 16 using exponential smoothing with a smoothing constant of 0.15 and a forecast for Week 1 of 20000. Compute the forecasts using linear regression using Excel's slope and intercept function. What is the MAD? Compute the forecast for Week 16 using linear regression. Comparing one of the error measurements (MAD, MSE, or MAPE)- which is the best forecasting method? Which is the worst forecasting method? a) b) c) d) e) f) 8) Jr 36 Year Semester GPA Fall 2.65 3 First Year Winter 2.9 Spring2.87 3.05 6 Sophomore Winter 3.42 3.29 3.3 9 Junior Winter 9 Junior Winter3.6 3.25 24 37 40 41 43 45 47 49 ND1 IND2 IND3 IND4 1, 2 3 4 5 6 7 8 9 10 1 2 3

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Main Memory Database Systems

Authors: Frans Faerber, Alfons Kemper, Per-Åke Alfons

1st Edition

1680833243, 978-1680833249

More Books

Students also viewed these Databases questions

Question

Demonstrate three aspects of assessing group performance?

Answered: 1 week ago