Quarterly demand levels for electricity

Assignment Help Basic Statistics

Reference no: EM13990549

Consider the following quarterly demand levels for electricity (in 1 000 megawatts) in Cape Town from 2008 to 2011.

Months	2008	2009	2010	2011
Jan-Mar	21	35	39	78
Apr-Jun	42	54	82	114
Jul-Sep	60	91	136	160
Oct-Dec	12	14	28	40

(a) Plot the time series of quarterly electricity demand graphically.

(b) Find the least squares trendline for quarterly electricity demand in Cape Town.

(d) Estimate the seasonally adjusted trend values of quarterly electricity demand for quarters 3 and 4 of 2012.

Excel tasks

(e) Use the Insert > Chart tab (line with markers) to plot the time series data in (a).

(f) Use the Add Trendline option (by right clicking on any data value in the line graph) to compute the least squares trendline for electricity demand in (b).

Reference no: EM13990549

Questions Cloud

Carefully explain what will happen to the number of firms : Suppose that, in a perfectly competitive market at the profit-maximizing quantity, the market price is greater than average total cost. Carefully explain what will happen to the number of firms, the market supply, and the price of the good as we move..

How far have you moved the box : A 4.0 kg box is initially at rest on a smooth surface. You then push on the box with a constant 200 N force to the right. How fast is the box moving after you've been pushing for 5.0 s?

Perform a degree-of-freedom analysis for the system : Perform a degree-of-freedom analysis for the system and write the equations you would solve to calculate the values of all unknown variables on the flowchart (including the purge fraction).

Prepare a similar table for velocity with respect to time : Prepare a position time graph for all three objects and compare their motion. For time interval t=10 sec and t= 15sec, which of them moves faster. For time interval t=20sec and t=25 sec, which of the objects move slower.

Quarterly demand levels for electricity : Consider the following quarterly demand levels for electricity (in 1 000 megawatts) in Cape Town from 2008 to 2011.

Prepare the a divisions income statement for the year ended : If the A division were to go out of business, the sale of its assets would bring in $141,000 in cash.

Produce a line graph of the hotel occupancy rate : (a) Produce a line graph of the hotel's occupancy rate per month. (b) Fit a least squares trendline to the hotel occupancy rate data.

Create an environment for terrorist groups to flourish : What effect has immigration had on the development of terrorist groups in Canada? Does Canada’s perceived liberal approach to immigration and refugees create an environment for terrorist groups to flourish?

Discuss the successes and failures of the change process : Using the Ashford University Library, find an article that reviews an organizational change initiative. Summarize the article and discuss the successes and failures of the change process. Analyze the strategies used for the change process and why ..

User Account

All Pages