View the step-by-step solution to:

BANA 2082 "Business Analytics II" Individual Assignment #1 (10%) Due 2:, Thursday, October 18, 2012 You will be randomly assigned a multiple...

The following data show the, curb weight, horsepower, and 1/4mile speed for 16 Sports Cars and GT cars. Suppose that the price of each sports cars and GT car is also available. The complete data set is as follows.

Sport & GT Car Price(1000's) Curb Weight(lbs) Horsepower Speed(MPH)
Acura Integra Type R 25.035 2577 195 90.7
Acura NXS-T 93.758 3066 290 108.0
BMW Z3 2.8 40.900 2844 189 93.2
Chevy Camaro Z28 24.865 3439 305 103.2
Chevy Corvette CVT 50.144 3246 345 102.1
Dodge Viper RT/10 69.742 3319 450 116.2
Ford Mustang GT 23.200 3227 225 91.7
Honda Prelude SH 26.382 3042 195 89.7
MercedesBenz CLK320 44.988 3240 215 93.0
MercedesBenz SLK230 42.762 3025 185 92.3
Mitsubishi3000GT VR4 47.518 3737 320 99.0
Nissan 240SX SE 25.066 2862 155 84.6
Pontiac Firebird 27.770 3455 305 103.2
Porsche Boxstar 45.560 2822 201 93.2
Toyota Super Turbo 40.989 3505 320 105.0
Volvo C70 41.120 3285 236 97.0

a. Find the estimated regression equation, which usese price and horsepower to predict the 1/4mile speed.

b. plot the standard residuals against ^y. Does the residual plot support the assumption about E? Explain

c. Check for any outliers. What are your conclusion?

d. Are there any influential observations? explain.

The highlighted parts in the document are the mathematical portions I don't understand.

BANA 2082 “Business Analytics II” Individual Assignment #1 (10%) Due 2:00 P.M., Thursday, October 18, 2012 You will be randomly assigned a multiple regression problem from the Statistics for Business and Economics textbook. If you do not have the textbook, you have access to it from the Reserves Desk at Langsam Library. The datafiles associated with the problems are available on Blackboard under “Assignments” and you will find them as the last documents in that area. Your assigned problem will describe the setting for your datafile and maybe have very specific questions, which are typically things you will want address. But your assignment is not to just answer the questions in the problem. Your assignment is to thoroughly develop and solve on EXCEL the best multiple regression model(s) and report all basic results with particular attention to any more interesting results from those model(s). Prepare a Managerial Report that includes… A detailed introduction and explanation of the problem setting including the description of the variables involved & their relationships. Embellish if you wish! For all problems, determine the correlation matrix for the independent variables. This can assist with developing a model with less multicollinearity. A mathematical statement(s) and explanation of any multiple regression model(s) you solve and report. Provide the EXCEL outputs for your regression(s). First, make sure your assumptions for the error terms hold by examining graphs for the residuals and standardized residuals. If your model is questionable you should try to modify it to determine a better model, but you may have to continue anyway with the best model you can develop. Provide and explain well all basic results from EXCEL such as o the estimated regression equation o R a 2 o F test o t tests o p-values o confidence intervals o Give particular note to which variables are significant and which are not. Use your model(s) for prediction.
Background image of page 1
For your report submission please include the following… A cover sheet with a title and your contact information so that someone interested in the report can reach you. After you have finished everything (described, formulated and solved model(s), interpreted the printouts, and written all of the report), create a one-half to one- page “Executive Summary” that indicates what the problem is, what you did to solve it, the final solution, and any other interesting results. This synopsis is for the busy executive who wants to see what is in the report and look at details further if interested. This should be the first page after the cover sheet before the entire report. Please note… Please help each other all you want with inputting data and solving on EXCEL, but the write-up is to be solely your work. You must solve the assigned problem and cannot select and submit another problem. Late assignments are not accepted without prior arrangements. All problems are unique and different styles of papers are expected so we do not expect all papers to necessarily be that similar, beyond making sure that you cover the bullet points above. We are not necessarily looking for an exact solution to an exact question. This assignment is to explore appropriate modeling approaches of finding, solving on EXCEL, and reporting the results of a multiple regression setting. Good Luck and Have Fun With It!
Background image of page 2
Sign up to view the entire interaction

Top Answer

Hi Dear, please find the... View the full answer

8410395 (Analysis).xlsx

SUMMARY OUTPUT Horsepower Residual Plot
0
10
-5 5 SS
2 915.6556134107
13 80.2987615893
15
995.954375 Coefficients
Standard Error
71.3282582041
2.247914489
0.1071856499
0.039182915
0.0844964966...

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online