FOR1. Open file Nuclear Power. Select data for Canada. Address the following questions. a. Provide a plot of...

50.1K

Verified Solution

Question

General Management

FOR1. Open file Nuclear Power.Select data for Canada. Address the followingquestions.

a. Provide a plot of the data over timein the space below. (2 pts)

[plot here]

b. Choose an appropriate forecastingmodel and forecast for the next 3 periods (provide forecast in thetable below). Explain model selection approach. (8 pts)

Period

Forecast

2007

2008

2009

c. Using the same data, forecast thenext 3 periods in the time series using the 5-period moving averageand indicate the values below. (3 pts)

Period

Forecast

2007

2008

2009

d. Using the same data, forecast forthe next 3 periods in the time series using the single exponentialsmoothing technique with a smoothing constant of 0.3 and indicatethe values below. (3 pts)

Period

Forecast

2007

2008

2009

e. Compare results from models b, c and d. Which forecast modeldo you recommend to use for the next 3 periods? Justify yourrecommendation (6 pts)

DATA:

Nuclear ElectricPower Production (Billion KWH)
YearUSCanadaFrance
1980251.1235.8863.42
1981272.6737.899.24
1982282.7736.17102.63
1983293.6846.22135.99
1984327.6349.26180.47
1985383.6957.1211.19
1986414.0467.23239.56
1987455.2772.89249.27
1988526.9778.18260.29
1989529.3575.35288.72
1990576.8669.24298.38
1991612.5780.68314.77
1992618.7876.55321.52
1993610.2990.08349.78
1994640.44102.44341.98
1995673.492.95358.37
1996674.7388.13377.47
1997628.6477.86375.71
1998673.767.74368.59
1999728.2569.82374.53
2000753.8969.16394.4
2001768.8372.86400.02
2002780.0671.75414.92
2003763.7371.15419.02
2004788.5385.87425.83
2005781.9987.44428.95
2006787.2293.07427.68

Answer & Explanation Solved by verified expert
4.5 Ratings (730 Votes)
We shall be doing this for only Canada as provided in thequestion The work will be done on excel The images are providedafter the explanationa Please see the plot below for the data on Canada againstyears in the screenshotb We can see that there is an overall general upward trendHence we can use a linear regression model for forecasting    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students