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.

Posted Date: 3/16/2013 5:39:04 AM | Location : United States

Ask an Expert

Related Discussions:- Eliminate all of the insignificant variables, Assignment Help, Ask Question on Eliminate all of the insignificant variables, Get Answer, Expert's Help, Eliminate all of the insignificant variables Discussions

Write discussion on Eliminate all of the insignificant variables
Your posts are moderated

Write your message here..

Related Questions

Calculation for continuous series or grouped data, Calculation for Continuo... Calculation for Continuous Series or Grouped Data = where, m = mid-point of class   =

Systematic sampling, Systematic Sampling In Systematic Sampling ... Systematic Sampling In Systematic Sampling each element has an equal chance of being selected, but each sample does not have the same chance of being selected. Here,

Mode, Mode Mode is the value of the observation which occurs with the  ... Mode Mode is the value of the observation which occurs with the   greatest  frequency and thus  it is the most fashionable value, Mode has been derived from French  word  La  m

Prediction interval, Prediction Inte rval We would like to construct a... Prediction Inte rval We would like to construct a prediction interval around    which would contain the actual Y. If n  ≥  30,     ± Zs e  would be the interval, where Z

PERCENTAGES, CALCULATE THE PERCENTAGE OF REFUNDS EXPECTED TO EXCEED $1000 U... CALCULATE THE PERCENTAGE OF REFUNDS EXPECTED TO EXCEED $1000 UNDER THE CURRENT WITHHOLDING GUIDELINES

Measurement error models., how can we use measurement error method with eig... how can we use measurement error method with eight responses variables (we do not have explanatory variable in the data )?.the data analyse 521 leaves ..

Properties of standard deviation, PROPERTIES   1. The value of stand... PROPERTIES   1. The value of standard deviation remains the same if, in a series each of the observation is increased or decreased by a constant quantity. In statistical lan

#title.partial market equilibrium, what is non linear modl what is non linear modl

Determine the subset of variables, Agency revenues. An economic consultant ... Agency revenues. An economic consultant was retained by a large employment agency in a metropolitan area to develop a regression model for predicting monthly agency revenues ( y ).

Range, Range Official Exports Target 2000-2001 ... Range Official Exports Target 2000-2001 Product ($ million) Plantation 500 Agriculture and Alli