logo

I will use the national center for education statistics website

4 Pages195 Words105 Views
   

Added on  2021-09-23

I will use the national center for education statistics website

   Added on 2021-09-23

ShareRelated Documents
I will use the national center for education statistics website and obtain data for tuition costs of
colleges and universities for database work. Specifically, I will concentrate on the data about the
annual average total tuition, fees, room and board rates charged on all college and university
students for the time 1985-2016. Below is an overview of the data:
Moving Average
The number of periods in the moving average method is 4. The prediction of the average fee to
be charged in the educational year 2016-2017 is $21,609.
I will use the national center for education statistics website_1
4
Analysis of Forecast Error
MAD MSE MAPE
2655.82142928715697.413.96317%
Data
Period Number Data error
110696
213572
314724
415218
515719Formula Needed --> 13552.500002166.52166.54693722.2513.78%
616586Formula Needed --> 14808.250001777.751777.753160395.06310.72%
717145Formula Needed --> 15561.750001583.251583.252506680.5639.23%
817523Formula Needed --> 16167.000001356135618387367.74%
918072Formula Needed --> 16743.250001328.751328.751765576.5637.35%
1018268Formula Needed --> 17331.50000936.5936.5877032.255.13%
1118973Formula Needed --> 17752.000001221122114908416.44%
1219404Formula Needed --> 1940419404376515216100.00%
1319912Formula Needed --> 18679.250001232.751232.751519672.5636.19%
1420315Formula Needed --> 19139.250001175.751175.751382388.0635.79%
1520839Formula Needed --> 19651.000001188118814113445.70%
1621291Formula Needed --> 20117.500001173.51173.51377102.255.51%
1721875Formula Needed --> 20589.250001285.751285.751653153.0635.88%
1822432Formula Needed --> 21080.000001352135218279046.03%
Number of
Periods
Averaged
Indicates which cells
in column to the right
need a formula
Moving
average
forecast absolute
value of error
squared
error
percentage
error
Weighted moving average
In prediction of the next time period university and college fee using weighted moving average, I
use a period of 3 and 5 weights, 5= preceding educational year, 4= 1 preceding educational year,
3= 2 preceding educational years, 2= 3 preceding educational years, 1= preceding educational
years.
The next educational period average fee will be $21,701.
I will use the national center for education statistics website_2

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Rising College Tuition Fees: The Burden on Students and the Soaring Costs of Education
|5
|1089
|272

Curve-fitting Project - Linear Model
|6
|585
|18

English for Academic Purpose - DOC
|12
|2174
|47

Performance Analysis and Forecasting for TourneSol Company
|13
|1575
|300

Comparisons and Contrasts of Exponential Smoothing Methods
|5
|630
|153

Econometrics Project
|10
|1393
|415