Question

Note: Data for these problems are in the Module 2 Individual Assignments Data file - there is a tab for each problem, All ansYear Semester GPA Fall 2.65 First Year Winter 2.93 Spring 2.87 Fall 3.05 Sophomore Winter 3.42 Spring 3.29 Fall 3.3 Junior Wi

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) Compute the forecasts using the naive forecasting method. What is the MAD? b) Compute the forecast for Senior Year- Fall Semester using the naive forecasting method c) Compute the forecasts using the two-period moving average. What is the MAPE? d) Compute the forecast for Senior Year- Fall Semester using the two-period moving average e) 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 average using weights of 0.4, 0.35, and 0.25 g) Compute the forecasts using exponential smoothing with a smoothing constant of 0.25 and a forecast for First Year - Fall Semester of 2.60. What is the MSE? h) Compute the forecast for Senior Year - Fall Semester using exponential smoothing with a smoothing constant of 0.25 and a forecast for First Year- Fall Semester of 2.60 i) Comparing one of the error measurements (MAD, MSE, or MAPE) - which is the best forecasting method? Which is the worst forecasting method?
Year Semester GPA Fall 2.65 First Year Winter 2.93 Spring 2.87 Fall 3.05 Sophomore Winter 3.42 Spring 3.29 Fall 3.3 Junior Winter 3.6 Spring3.25
0 0
Add a comment Improve this question Transcribed image text
Answer #1


Solcct%ng asad on gRven data owS 283 2 3285-5 3 336 312 285.550.5 2 530-25 4 3 342311 5 406 336244 14111409 39 구 45 1 36 2 5 Piye D 283 +288 29s-S 2 486.s hecast Value hecast value teSh 24 is 542 e) (as Ye@i moaae bh sste value 33.75 Scned with CamScPage dl 1 283 2 280 3 336 388 323.35 5 1406 1354 . 5 | 323 . จ518225 6 412 3553531-5 4 41L 405-5330.5 8 435419-2s 45.52-5 L42336+389+ 283+288 ש -323.5 esno- Catul vaeocaste vae teValue 491 = 30.68 Cs Scanned wit CamScanner

Add a comment
Know the answer?
Add Answer to:
Note: Data for these problems are in the Module 2 Individual Assignments Data file - there is a tab for each problem, A...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • All answers should be entered using two decimal places unless otherwise specified. If both decimal places...

    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. M 2 _ IND 1 . Mariah Henderson is a WCU studen t who has just finished her junior year. The data in Worksheet IND 1 summarizes her grade point average (GPA) for each of the last 9 semesters. a) Compute...

  • Forecasting Models. This is one problem that requires the use of Excel newly created, blank Excel...

    Forecasting Models. This is one problem that requires the use of Excel newly created, blank Excel file, with no use of copy and pasting anything into the spreadsheet or use any kind of a template. (a) Calculate the forecast of Jeannette's GPA for the fall semester of her senior year using a 3-period moving average. (b) Calculate the forecast of Jeannette's GPA for the fall semester of her senior year using a 3-period weighted moving average, with the weights 1,...

  • 1Year Sales (in $1000s) 283 288 336 388 406 412 416 435 428 435 462 452...

    1Year Sales (in $1000s) 283 288 336 388 406 412 416 435 428 435 462 452 474 476 497 487 523 528 532 552 4 4 6 6 9 10 11 10 12 11 13 12 14 13 1514 16 15 17 16 18 17 19 18 20 19 21 20 23 24 Module 2 Assisted Problems Note: Data for these problems are in the Module 2 Assisted Assignments Data file-there is a tab for each problem. All answers should...

  • answer 1-3 please don't copy from previous post. good luck Problems #3, 5, 7 (P3) The...

    answer 1-3 please don't copy from previous post. good luck Problems #3, 5, 7 (P3) The owner of the Chocolate Outlet Store wants to forecast chocolate demand. Demand for the preceding four years is shown in the following table: Year Demand (Pounds) 1 68,800 2 71,000 3 75,500 4 71,200 Forecast demand for Year 5 using the following approaches: (1) a three-year moving average; (2) a three-year weighted moving average using .40 for Year 4, .20 for Year 3, and...

  • Name 1. Observations of the demand for a certain part stocked at a parts supply depot during the ...

    Name 1. Observations of the demand for a certain part stocked at a parts supply depot during the calendar year 1999 were Month Janua Demand 89 57 144 221 Februa March ril Ma June Jul August September October November December 280 223 286 212 275 188 312 Determine the forecasts for July though December of the year 1999 considering 2, 3, and 6- month moving averages Compute the MAD for the obtained forecasts. Which method gave you better results? Determine...

  • TEST, I need Help A.S.A.P PLease!!! I need to submit this within the next hour and a half. It's...

    1. Regression is always a superior forecasting method to exponential smoothing, so regression should be used whenever the appropriate software is available. (Points :1)TrueFalse2. Time-series models rely on judgment in an attempt to incorporate qualitative or subjective factors into the forecasting model. (Points : 1)TrueFalse3. A trend-projection forecasting method is a causal forecasting method. (Points : 1)TrueFalse4. Qualitative models attempt to incorporate judgmental or subjective factors into the forecasting model. (Points : 1)TrueFalse5. The naive forecast for the next period...

  • Consider the following time series data. Week 1 2 3 4 5 6 Value 19 13 16 12 18 14 a. Whic...

    Consider the following time series data. Week 1 2 3 4 5 6 Value 19 13 16 12 18 14 a. Which of the following is a correct time series plot for this data? - Select your answer -plot #1plot #2plot #3Item 1 What type of pattern exists in the data? - Select your answer -VerticalHorizontalScatterItem 2 b. Develop the three-week moving average forecasts for this time series. Compute MSE and a forecast for week  (to 2 decimals if necessary)....

  • The following data are monthly sales of jeans at a local department store.

     4. The following data are monthly sales of jeans at a local department store. The buyer would like to forecast sales of jeans for the next month, July. (a) Forecast sales of jeans for March through June using the naive method, a two-period moving average, and exponential smoothing with an a = 0.2. (Hint: Use naive to start the exponential smoothing process.) (b) Compare the forecasts using MAD and decide which is best. (c) Using your method of choice, make a forecast for...

  • PLEASE ONLY ANSWER IF YOU CAN DO WHAT IS BLANK, I DON'T NEED HELP WITH WHAT...

    PLEASE ONLY ANSWER IF YOU CAN DO WHAT IS BLANK, I DON'T NEED HELP WITH WHAT IS FILLED OUT ALREADY. THANK YOU! Problem 15-03 (Algorithmic) Consider the following time series data. Week 1 2 3 4 5 6 Value 1914 16 10 17 15 Using the naive method (most recent value) as the forecast for the next week, compute the following measures of forecast accuracy: a. Mean absolute error (MAE) b. Mean squared error (MSE) c. Mean absolute percentage error...

  • please i need asap answer 1. Given the data below, compute for the following: a) Forecasts...

    please i need asap answer 1. Given the data below, compute for the following: a) Forecasts for P5 to P12 using a 4-period simple moving average b) Forecasts for P5 to P12 using a 4-month weighted moving average with the following weights: Most recent period = 0.40 2nd most recent period = 0.30 3rd most recent period = 0.20 4th most recent period = 0.10 Assuming a forecast of 5,000 units for Period 4 and a = 0.30, compute for...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT