ZuoTi.Pro
Question

n0000000000°0000000000000000000000000000000000 554333344444544434443355443434433434343443444 380428482828881582200000507580065005633746567 106786758657468404010910279194532402450513400 1 1121 444444444444344446444444884446666646444646644 58200093025002050008858252030044 5 0 5 0 0 5 0 5 0 5 0 0 5 5 5 0 0 0 5 3 2 9 5 5 0 0 0 555500550050005555 348332360189511062758668346971919292929306664 ei 2 2 1 2 2 2 2 1 2 2 1 1 1 2 2 3 2 3 2 2 2 2 2 2 3 3 2 223232323232333333 B M 232624616453176845987161339589079689676564323 334333343334533232222333222322322222222222222 122 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 5 5 012345678901234 6 7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 123456789Refer to this file when answering the following problem: Problem Data Set 1.xlsx The following data comes from Consumer Reports and was collected over a two year period It gives the Trip MPG over a 195 mile trip, the weight of the vehicle, engine displacement, Number of Cylinders, Horsepower, type of Transmission (0manual, 1-automatic), the number of gears and whether the cars was foreign (1) or domestic (0) Build a model for predicting the Trip MPG based on the information in these variables, and provide the coefficients of your model. Provide ALL answers to two decimal places. Intercept: Weight: Displace: No. Cyl: HP: Trans: Gears: For/Dom:

Refer to this file when answering the following problem: Problem Data Set 1.xlsx 


The following data comes from Consumer Reports and was collected over a two year period It gives the Trip MPG over a 195 mile trip, the weight of the vehicle, engine displacement, Number of Cylinders, Horsepower, type of Transmission (0manual, 1-automatic), the number of gears and whether the cars was foreign (1) or domestic (0) .


Build a model for predicting the Trip MPG based on the information in these variables, and provide the coefficients of your model. 


Provide ALL answers to two decimal places. 


Intercept: Weight: Displace: No. Cyl: HP: Trans: Gears: For/Dom:

math   Statistics-And-Probability   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

M9 Regression Statistics 4 Multiple R 5 R Square 6 Adjusted RSc 0.814013415 7/standardErr. 2.642349624 8 Observations 9 10 ANOVA 0.918478193 0.84360219 45 df Ss MSF gnificance F 12 Regression 13 Residual 7 1393.443 199.0633 28.51089 4.6E-13 37 258.3344 6.982012 44 1651.778 4 Total coefficients andard Err tstat P-value Lower 95%Upper 95%ower 9509pper 95.0% 48.22792673 4.675196 10.3157 1.95E-12 38.75508 57.70077 38.75508 57.70077 X Variable 1 0.009556457 0.001692 -5.64846 1.88E-06 -0.01298 -0.00613 -0.01298 -0.00613 9 X Variable 2 1.634481335 1.579675 -1.03469 0.307527 -4.83521 1.566245 -4.83521 1.566245 OX Variable 3 0.920066555 0.823477 1.117295 0.271071-0.74846 2.588589-0.74846 2.588589 1 X Variable 4 0.023587087 0.027578 0.85527 0.397904 0.0794 0.032292 0.07947 0.032292 2 X Variable5 2.122269075 2.015408 1.053022 0.299159 -1.96134 6.205873 -1.96134 6.205873 3 x Variable 6 2.722031905 1.093481 2.489326 0.017421 0.506428 4.937636 0.50628 4.937636 -1.718584949 1.064764 -1.61405 0.115014 3.876 0.4388333.876 0.438833 16 7 Intercept 8 4x variable 7

0 0
Add a comment
Know the answer?
Add Answer to:
Refer to this file when answering the following problem: Problem Data Set 1.xlsx
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • The data set "mtcars" in R has 11 variables with 32 observations. A data frame with...

    The data set "mtcars" in R has 11 variables with 32 observations. A data frame with 32 observations on 11 variables. [, 1] mpg Miles/(US) gallon [, 2] cyl Number of cylinders [, 3] disp Displacement (cu.in.) [, 4] hp Gross horsepower [, 5] drat Rear axle ratio [, 6] wt Weight (1000 lbs) [, 7] qsec 1/4 mile time [, 8] vs V/S [, 9) am Transmission (0 = automatic, 1 = manual) [,10] gear Number of forward gears...

  • The Motor Trend Car Road Tests dataset mtcars, in faraway R package, was extracted from the...

    The Motor Trend Car Road Tests dataset mtcars, in faraway R package, was extracted from the 1974 Motor Trend US magazine, and comprises fuel consumption and 10 aspects of automobile design and performance for 32 automobiles (1973–74 models). The data frame has 32 observation on 11 (numeric) variables: mpg: Miles/(US) gallon; cyl: Number of cylinders; disp: Displacement (cu.in.); hp: Gross horsepower; drat: Rear axle ratio; wt: Weight (1000 lbs); qsec: 1/4 mile time; vs: Engine (0 = V-shaped, 1 =...

  • 6. The following data was extracted from the 1974 Motor Trend US magazine, and com- prises...

    6. The following data was extracted from the 1974 Motor Trend US magazine, and com- prises fuel consumption , mpg, (response) and 6 aspects of automobile design and per- formance (explanatory variables) for 32 automobiles (1973-74 models). mpg Miles/(US) gallon cyl Number of cylinders disp Displacement (cu.in.) hp Gross horsepower Transmission (0 = automatic, 1 = - manual) am 4 5 6 7 8 50 150 250 LULU O mpg P8 tagad 2008 10 25 QUE 000 cyl DOO DO...

  • Please show full details steps for better understanding. Thank you. 6. The following data was extracted...

    Please show full details steps for better understanding. Thank you. 6. The following data was extracted from the 1974 Motor Trend US magazine, and com- prises fuel consumption , mpg (response) and 6 aspects of automobile design and per- formance (explanatory variables) for 32 automobiles (1973-74 models). mpg Miles/(US) gallon cyl Number of cylinders disp Displacement (cu.in.) hp Gross horsepower am Transmission (0 = automatic, 1 = manual) 50 150 250 mpg 10 25 200 cyl 00 00000 ood 00...

  • 1. For each of the following regression models, write down the X matrix and 3 vector....

    1. For each of the following regression models, write down the X matrix and 3 vector. Assume in both cases that there are four observations (a) Y BoB1X1 + B2X1X2 (b) log Y Bo B1XiB2X2+ 2. For each of the following regression models, write down the X matrix and vector. Assume in both cases that there are five observations. (a) YB1XB2X2+BXE (b) VYBoB, X,a +2 log10 X2+E regression model never reduces R2, why 3. If adding predictor variables to a...

  • ANOVA problem, data given! Please help 8 pts D Question 1 A researcher is interested to...

    ANOVA problem, data given! Please help 8 pts D Question 1 A researcher is interested to find out how the engine displacement, vehicle weight, and the type of transmission [i.e. automatic & manual] affect the automobile gasoline mileage. Type of transmission is represented by one dummy variable: automatic (-1, if transmission is automatic; 0, if transmission is manual) Part of the raw data and the regression output of 40 different car models are given below. Displacementícubic Weightlb) in) Automobile Miles/gallon...

  • The data file Motor Trend is a random sample of 32 automobiles.   The miles per gallon ...

    The data file Motor Trend is a random sample of 32 automobiles.   The miles per gallon (mpg), weight (wt), horsepower (hp) and type of transmission (manual or automatic) is recorded for each sampled automobile. The file is available on Blackboard. Transmission is a categorical variable. Code the variable transmission so that it can be used in a regression model. Your coding should assign a 1 to manual transmission and a 0 to automatic. Develop a regression model with mpg as...

  • Following are data on price, curb weight, horsepower, time to go from 0 to 60 miles...

    Following are data on price, curb weight, horsepower, time to go from 0 to 60 miles per hour, and the speed at 1/4 mile for 16 sports and gt cars. Sports & GT Car/ Price ($1000s)/ Curb Weight (lb.)/ Horsepower /0-60 mph (seconds) /Speed at 1/4 mile (mph): Acura Integra Type R/ 25.035 /2577/ 195/ 7/ 90.7 Acura NSX-T/ 93.758/ 3066/ 290/ 5/ 108 BMW Z3 2.8/ 40.900/ 2844/ 189/ 6.6/ 93.2 Chevrolet Camaro Z28/ 24.865/ 3439/ 305/ 5.4/ 103.2...

  • Use excels data analysis tool to preform a regression on the following set on numbers. Post...

    Use excels data analysis tool to preform a regression on the following set on numbers. Post your results. Then answer the following questions. A consumer Organization want to develop a regression model to predict gasoline mileage (as measured by miles per gallon) based on horsepower of the car's engine and the weight of the car, in pounds. A sample of 50 percent recent car models was selected, with the results recorded. 1. State the multiple regression equation. 2. Interpret the...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT