Question 1 - Improved global competitiveness was a factor in increasing exports of Canadian resource-based products during the period 2011 to 2015, as shown:                                                           

a) Draw a scatter diagram (1)                                                     

b) Obtain the least squares equation and plot the trend line

c) Estimate Canadian resource-based exports for (i) 2017 and (ii) 2019

d) What was the average annual change in exports

Question 2 - Warranty repairs for J.R. Electronics Canada were as follows:            

a) Construct a scatter diagram   

b) Determine the trend line equation and plot the line  

c) Forecast warranty repairs for (i) 2017 and (ii) 2019       

Question 3 - From the trend line equation yp = 520 + 30x, where y represents annual unit sales and 2008 is the first year (x=1), determine

a) The expected sales for 2011

b) The average annual change in unit sales

c) The estimated sales for 2014

Question 4 - Investment spending for the years 2011 to 2015 in billions of dollars IS LISTED BELOW. The least squares equation best describing the data is yp = 56.6 + 8x, with 2011 as the first year (x=1)                                                         

a) Plot the observed values on a line graph                                         

b) Plot the trend line on the graph in part (a)                                     

c) Compute the trend values for the years 2011 to 2015                                

d) Compute the percent of trend for the time period                                    

e) Construct a graph depicting the percent of trend                                        

Question 5 - The equation yp = 2.29 + 1.08x represents the least squares equation for the following data:

Let 2007 be x=1                                                                                

a) Plot the observed values of y and join the points                                                                                        

b) Plot the trend line                                                                                     

c) Compute the trend value for each year yp = 2.29 + 1.08x                         

d) Calculate the cyclical relatives                                                                                              

e) Construct a graph of the cyclical relatives                                                                                        

Question 6 - The number of corporate tax returns processed by a tax accountant for the period 2000 to 2015 is listed below:               

a) Compute the five-year moving averages        

b) Plot the time series and the moving averages               .

Question 7 - Monthly restaurant sales in the clubhouse of a local vacation resort offering golfing and skiing were are listed in the following table.                                                                   

Determine the 12-month moving average.                                                                         

Question 8 - The following data summarize the overnight guests at a bed and breakfast operation from 2011-2014:

a) Compute the quarterly moving average i.e. quarter 1-4, 2-5etc                                            

b) Construct a graph of the time series                                 

c) Depersonalize the data                                           

d) Plot the seasonally adjusted values on the graph in (b)                                            

Reorganize data as follows and complete blank columns