Question: Please find the following using data from the following table: Measures of location Measures of variability Mean-absolute deviation (MAD) - MA, ES Exponential smoothing forecast
Please find the following using data from the following table:
- Measures of location
- Measures of variability
- Mean-absolute deviation (MAD) - MA, ES
- Exponential smoothing forecast - at least 3 different alphas
- Linear regression forecast
Prediction Absolute At-1+(1-)Ft-1 Prediction Absolute
Quarter FCF Revenues MA-3 Error Value Alpha =0.2 Error Value
3/31/2011 $138,473.34 $718,553.00
6/30/2011 $111,259.84 $788,610.00
9/30/2011 $213,220.00 $821,839.00
12/31/2011 $186,550.00 $875,575.00
3/31/2012 $14,340.00 $869,791.00 $814,873.60
6/30/2012 $30,390.00 $889,163.00 $848,995.60
9/30/2012 $16,660.00 $905,089.00 $872,291.40
12/31/2012 -$58,151.00 $945,239.00 $896,971.40
3/31/2013 -$24,370.00 $1,023,961.00 $926,648.60
6/30/2013 $1,490.00 $1,069,372.00 $966,564.80
9/30/2013 $25,350.00 $1,105,999.00 $1,009,932.00
12/31/2013 -$16,300.00 $1,175,230.00 $1,063,960.20
3/31/2014 $23,030.00 $1,270,089.00 $1,128,930.20
6/30/2014 $59,180.00 $1,340,407.00 $1,192,219.40
9/30/2014 $71,000.00 $1,409,432.00 $1,260,231.40
12/31/2014 -$126,699.00 $1,484,728.00 $1,335,977.20
3/31/2015 -$140,420.00 $1,573,129.00 $1,415,557.00
6/30/2015 -$349,300.00 $1,644,694.00 $1,490,478.00
9/30/2015 -$583,090.00 $1,738,355.00 $1,570,067.60
12/31/2015 -$920,557.00 $1,823,333.00 $1,652,847.80
3/31/2016 -$237,020.00 $1,957,736.00 $1,747,449.40
6/30/2016 -$474,120.00 $2,105,204.00 $1,853,864.40
9/30/2016 -$963,430.00 $2,290,188.00 $1,982,963.20
12/31/2016 -$1,473,984.00 $2,477,541.00 $2,130,800.40
3/31/2017 -$396,380.00 $2,636,635.00 $2,293,460.80
6/30/2017 -$996,140.00 $2,785,464.00 $2,459,006.40
9/30/2017 -$1,449,710.00 $2,984,859.00 $2,634,937.40
12/31/2017 -$1,785,948.00 $3,285,755.00 $2,834,050.80
3/31/2018 -$273,390.00 $3,700,856.00 $3,078,713.80
6/30/2018 -$819,490.00 $3,907,270.00 $3,332,840.80
9/30/2018 -$1,549,230.00 $3,999,374.00 $3,575,622.80
12/31/2018 $2,680,479.00 $4,186,841.00 $3,816,019.20
3/31/2019 $3,948,585.25
6/30/2019 $4,031,161.67
9/30/2019 $4,093,107.50
12/31/2019 $1,868,447.22
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
