Develop a regression model using the financial database


Assignment

1. Use the RRSP Database. Suppose a researcher wants to determine if the average of the total annual RRSP contribution is not equal to 2,389,147 ($*1,000). Use the province of New Brunswick in the RRSP Database as a sample, and perform a hypothesis test at a 1% level of significance. Assume that annual RRSP contribution is normally distributed in the population.

2. Using the appropriate technique selected from this chapter and the RRSP Database, test to determine

a. if Alberta taxpayers contribute more towards their RRSP than Ontario taxpayers.
b. if Alberta's RRSP contribution population variance is greater than Ontario's.

Let and assume the unknown population variances to be unequal.

3. Do various financial indicators differ significantly according to type of company? Use a one-way ANOVA and the Financial Database to answer this question. Let Type of Company be the independent variable with seven levels (as listed in Analyzing the Databases in Chapter 1). Compute three one-way ANOVAs, one for each of the following dependent variables: Average Yield, Dividend per Share, and Average P/E Ratio. On each ANOVA, if there is a significant overall difference between Type of Industry, compute multiple comparisons to determine which pairs of types of industries, if any, are significantly different.

4. Develop a regression model from the RRSP Database to predict the RRSP annual contribution by the Age of the Contributor for the province of Quebec. Discuss the model and its strength on the basis of statistics presented in this chapter. Now develop another regression model for the province of Ontario. Discuss the model and its strengths. Compare the two models. Does it make sense that age is a predictor of contribution? Why or why not?

5. Develop a regression model using the Financial Database. Use Total Revenues, Average Yield, Dividend Growth, and Dividend per Share to predict the Average P/E Ratio for a company. How strong is the model? Which variables seem to be the best predictors?

6. Use the Canadian Stock Market Database to develop a regression model to predict Composite Index from Week of the Month. Use the composite index for weeks 1, 2, and 3 to predict the composite index for week 4. You will need to treat Week of the Month as a qualitative variable with four subcategories (only use four since not every month has a fifth week). Drop out the least significant variable if it is not significant at a=0.05 and rerun the model. How much did r square drop? Continue this process until only significant predictors are left. Describe the final model.

7. Use the Energy Resource Database to forecast year 36 of North American hydro energy production by using simple exponential smoothing. Let and . Compare the forecast with the actual figure. Which of the two models produces the forecast with the least error? Repeat the same test using the European data set. Is there any difference between North America and Europe in energy production through Hydro?

8. In the RRSP Database, is the RRSP average annual contribution independent of province? The data given below are for the provinces from the Atlantic region of Canada. Use a chi-square test of independence to answer the question,

RRSP Contribution/Atlantic Region

Newfoundland and Labrador

P.E.I.

Nova Scotia

New Brunswick

Total

Less than $2,100

1 

6 

2 

5 

14

$2,100 to $2,200

0 

2 

4 

3 

9 

$2,200 to $2,300

5 

1 

4 

2 

12

$2,300 to $2,400

0 

2 

2 

1 

5 

Over $2,400

6 

1 

0 

1 

8 

Total

12

12

12

12

48

Solution Preview :

Prepared by a verified Expert
Applied Statistics: Develop a regression model using the financial database
Reference No:- TGS02394422

Now Priced at $105 (50% Discount)

Recommended (90%)

Rated (4.3/5)