Smart Parking Space App Presentation

profileFrankie1200
dat565_v3_wk6_exercises_timseriesmodeling_megastat.docx

DAT/565 v3

Data for Time Series Modeling Exercise Questions Requiring MegaStat

DAT/565 v3

Page 2 of 2

Data for Time Series Modeling Exercise Questions Requiring MegaStat

Use the following data for Wk 6 time series modeling exercise questions that require MegaStat.

Time Series Modeling Exercise 14-30, Connect Question 7

See output and graph MegaStat:

Qtr1 Index

Qtr2 Index

Qtr3 Index

Qtr4 Index

0.800

0.979

0.901

1.320

Time Series Modeling Exercise 14-32, Connect Question 8

Columns 2-4 contain calculation of seasonal indexes. From MegaStat:

1

2

3

4

1005

-

-

1.045

0.957

1006

0.890

1.084

1.053

0.927

1007

0.910

1.099

1.043

0.952

1008

0.928

1.129

1.054

0.909

1009

0.932

1.074

1.032

0.952

1010

0.942

1.032

-

-

mean

0.920

1.083

1.045

0.940

adjusted

0.923

1.087

1.048

0.942

Time Series Modeling Exercise 14-7, Connect Question 16

From MegaStat:

Error

a = .10

a = .20

a = .30

Mean Squared Error

0.039

0.028

0.021

Mean Absolute Percent Error

3.8%

3.1%

2.7%

Percent Positive Errors

42.3%

46.2%

51.9%

Forecast for Period 53

4.3

4.37

4.43

Data courtesy of McGraw-Hill Education

Copyright 2021 by University of Phoenix. All rights reserved.