Eliminate all of the insignificant variables, Applied Statistics

Assignment Help:

The file Midterm Data.xls has a tab labeled "Many vs. S&P" which presents historical price data for several assets, a volatility condition (VIDX = 1 if the NYSE volatility is greater than 0.04), Schlumberger, Westinghouse Air Brake, Ford and Eastman Kodak. Create a multiple regression model of the S&P 500 using the other asset prices as the independent (x) variables.

Answer the following questions based on the Excel output report. Support your answers with numbers from the output report. Use level of significance = 0.05.

• Write the estimated multiple regression equation. Note: Use actual variable names and numbers. If using symbols, define them before using in the equation.

• Clearly explain the meaning of b1 (the coefficient of Schlumberger). Note: Use actual variable names and numbers in answering your question. b1 is the slope is not a sufficient answer.

• Clearly explain the meaning of b2 (the coefficient of Westinghouse Air Brake). Note: Use actual variable names and numbers in answering your question. b2 is the slope is not a sufficient answer.

• Clearly explain the meaning of b3 (the coefficient of Ford). Note: Use actual variable names and numbers in answering your question. b3 is the slope is not a sufficient answer.

• Clearly explain the meaning of b4 (the coefficient of Eastman Kodak). Note: Use actual variable names and numbers in answering your question. b4 is the slope is not a sufficient answer.

• Clearly explain the meaning of b5 (the coefficient of Volatility). Note: Use actual variable names and numbers in answering your question. b5 is the slope is not a sufficient answer.

• Is the regression equation significant? Give reasons for your answer. (Hint: The answer to this question requires test of the hypothesis: Ho: 1 = 2 = 3 = 4 = 5 = 0 vs. Ha: At least one j is not equal to zero, where j = 1...5)

• Which variables in the current equation are significant and which are not significant? Give reason for your answer. (Hint: The answer to this question requires test of hypothesis: Ho: j = 0 vs. Ha: j 0 for j = 1...5).

• Eliminate all of the insignificant variables and show the final regression equation.

• Considering the original regression equation from a), if you already have an S&P 500 fund in your portfolio, what is the best new asset to place in the portfolio? (Remember, you want your portfolio to be as diverse as possible.) Are there any possible practical limitations to using some of these stocks in a portfolio.


Related Discussions:- Eliminate all of the insignificant variables

Evaluate gross reproduction rate, Evaluate Gross Reproduction Rate: Fr...

Evaluate Gross Reproduction Rate: From the data given below compute : i)   General  Fertility  Rate ii)  Specific  Fertility  Rate iii)  Total  Fertility  Rate iv)

Calculation of degrees of freedom, Calculation of Degrees of Freedom Fi...

Calculation of Degrees of Freedom First we look at how to calculate the number of DOF for the numerator. In the numerator since we calculate the variance from the sample means,

Population census, what are the challenges affecting population census in d...

what are the challenges affecting population census in developing countries

Probability, There are 15 types of ice cream: A,B,C,D,E,F,G,H,I,J,K,L,M,N, ...

There are 15 types of ice cream: A,B,C,D,E,F,G,H,I,J,K,L,M,N, and O. How many combinations are there to sample 5 flavors if you sample 1 flavor 4 times? How many combinations are t

Coefficient of variation, Coefficient of Variation or C.V. To compare t...

Coefficient of Variation or C.V. To compare the variability between or more series, coeffiecnt of variation is used, it is relative measure of dispersion, it innovated and used

Graphical calculation for mode, For calculating the mode of the grouped dat...

For calculating the mode of the grouped data graphically, the following procedure is adopted. Draw a histogram of the data; the modal class is the tallest rectangle.

E-mail messages should be answered quickly, Do people of different age grou...

Do people of different age groups differ in their response to e-mail messages? A survey by the Cent of the Digital Future of the University of Southern California reported that 70.

JET Copies Case Problem, Read the “JET Copies” Case Problem on pages 678-67...

Read the “JET Copies” Case Problem on pages 678-679 of the text. Using simulation estimate the loss of revenue due to copier breakdown for one year, as follows: 1. In Excel, use a

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd