The data shown in the following table and stored in Solar Power represent the yearly amount of

Question:

The data shown in the following table and stored in Solar Power represent the yearly amount of solar power generated by utilities (in millions of \(\mathrm{kWh}\) ) in the United States from 2002 through 2016:

YearSolar Power Generated (millions of kWh)YearSolar Power Generated (millions of kWh)
200255520101,212
200353420111,818
200457520124,327
200555020139,253
2006508201418,321
2007612201526,473
2008864201636,754
2009892

a. Plot the data.

b. Compute a linear trend forecasting equation and plot the trend line.

c. Compute a quadratic trend forecasting equation and plot the results.

d. Compute an exponential trend forecasting equation and plot the results.

e. Using the models in (b) through (d), what are your annual trend forecasts of the yearly amount of solar power generated by utilities (in millions of kWh) in the United States in 2017 and 2018 ?

Step by Step Answer:

Related Book For  book-img-for-question
Question Posted: