Using the yearly amount of solar power generated by utilities (in millions of kWh) in the United
Question:
Using the yearly amount of solar power generated by utilities (in millions of kWh) in the United States from 2002 through 2014 data for Problem 16.16 on page 569 (stored in SolarPower ),
a. fit a third-order autoregressive model to the amount of solar power installed and test for the significance of the third-order autoregressive parameter. (Use α = 0.05.)
b. if necessary, fit a second-order autoregressive model to the amount of solar power installed and test for the significance of the second-order autoregressive parameter. (Use α = 0.05.)
c. if necessary, fit a first-order autoregressive model to the amount of solar power installed and test for the significance of the first-order autoregressive parameter. (Use α = 0.05.)
d. forecast the yearly amount of solar power generated by utilities (in millions of kWh) in the United States in 2015 and 2016.
Step by Step Answer:
Statistics For Managers Using Microsoft Excel
ISBN: 9780134173054
8th Edition
Authors: David M. Levine, David F. Stephan, Kathryn A. Szabat