Assignment 5

pdf

School

Oregon State University, Corvallis *

*We aren’t endorsed by this school

Course

375

Subject

Aerospace Engineering

Date

Dec 6, 2023

Type

pdf

Pages

Uploaded by SuperRaccoon3811

Ryan Noble Assignment 5 Applied Quantitative Methods 5/4/2022 1. Time Series Plot: There appears to be a seasonal trend pattern in the data. 2. Sales = 1089.33 + 3.33 (Qtr1) + 81.67 (Qtr2) + 78 (Qtr3) Excel Output:

3. Quarter Forecast Quarter 1 1092.66 Quarter 2 1171 Quarter 3 1167.33 Quarter 4 1089.33

4. MAE 82.50 MSE 9565.67 MAPE 7.41 5. Sales = 864.08 + 87.80 (Qtr1) + 137.98 (Qtr2) + 106.16 (Qtr3) + 28.16t Excel output:

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

6. Quarter Forecast 1 1230.11 2 1346.07 3 1512.21 4 1646.52 7. MAE 26.50 MSE 1109.41 MAPE 2.40 8. It appears that the model I created in question #5 provides a better forecast. This is because the MAE, MSE, and MAPE are all lower than the ones for the model created in question #2.

Assignment 5

Related Documents