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.

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!

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...

### 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