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

Standard deviation, Standard Deviation The main drawback of the deviati... Standard Deviation The main drawback of the deviation measures of dispersion, as discussed earlier, is that the positive and negative deviations cancel out each other. Use of t

Collaboration policy,  Each question, by default, should be solved INDIVID...  Each question, by default, should be solved INDIVIDUALLY, unless marked as \collaborative". Questions marked as \collaborative" implies that for those questions you are encourage

Test for equality of two means, Let X 1  and X 2  be two independent po... Let X 1  and X 2  be two independent populations with population means μ 1  and  μ 2  respectively. Two samples are taken, one from each population, of sizes n 1  and n 2  re

Double Exponential Smoothing, whats mean by Double Exponential Smoothing whats mean by Double Exponential Smoothing

Compute the roughness of several parametric densities, An approximation to ... An approximation to the error of a Riemannian sum: where V g (a; b) is the total variation of g on [a, b] dened by the sup over all partitions on [a, b], including (a; b

Eliminate all of the insignificant variables, The file Midterm Data.xls ha... 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 grea

Optimal number of cluster, Try different numbers of clusters in your progra... Try different numbers of clusters in your program (K=2...15) and build a plot that shows the dependency between number K and value of RSS function on the last iteration. What is th

Bivariate distribution, f(x,y)=c(6-x-y) ,o find P(X+Y f(x,y)=c(6-x-y) ,o find P(X+Y

Computer application for data analysis, Differentiate between data and data... Differentiate between data and database

Testing of hypothesis, Testing of Hypothesis One objective of sampling... Testing of Hypothesis One objective of sampling theory is Hypothesis Testing. Hypothesis testing begins by making an assumption about the population parameter. Then we gather