Question

In: Statistics and Probability

The following data contains the characteristics of 30 motorcycles that will be analyzed using a Regression...

The following data contains the characteristics of 30 motorcycles that will be analyzed using a Regression model. You will study the relationship between a motorcycles' engine power (measured in horsepower) and the motorcycles' weight (measured in pounds).

Power (cf): 145 215 165 85 225 87 175 210 158 86 150 150 76 170 208 150 215 225 220 153 175 130 140 165 180 150 190 110 150 86

Weight (lb): 4082 4735 3693 2310 4951 2672 4464 4382 4363 2220 4135 4096 2065 4654 4633 4464 4615 4425 4354 4129 5140 3504 3449 4209 4955 4997 3850 2962 3761 2226

Declare:

a) Explanatory variable:

b) Response variable:

c) Make a scatter diagram. Describe the axes and scales for each axis.

d) What can you say about the strength, direction, and shape? Answer this subjectively (do not calculate the correlation).

e) Assuming that the scatter diagram above is linear with r2 = 0.7142182. Determine the slope and intercept of the regression line. (use the r program to calculate Sweight, Spower.

f) Write the modeled regression line.

g) Interpret the slope

h) What would be the engine power of a car if its weight were 2.5 tons? h.

i) Plot the regression line on the scatter plot

j) Interpret r. agrees with what was thought in point c

k) Interpret r2

Solutions

Expert Solution

a) Explanatory variable: Weight

b) Response variable:Power

c) The scatter diagram

d) tthe strength is strong ,direction is positive , shape is linear .

e)

Simple Linear Regression Analysis
Regression Statistics
Multiple R 0.8451
R Square 0.7142
Adjusted R Square 0.7040
Standard Error 24.3807
Observations 30
ANOVA
df SS MS F Significance F
Regression 1 41595.6860 41595.6860 69.9768 0.0000
Residual 28 16643.7806 594.4207
Total 29 58239.4667
Coefficients Standard Error t Stat P-value Lower 95% Upper 95%
Intercept -8.5030 20.4114 -0.4166 0.6802 -50.3139 33.3079
Weight 0.0422 0.0050 8.3652 0.0000 0.0319 0.0525

the slope and intercept of the regression line is 0.422 and -8.5030 respectively   

f) the modeled regression line. is y = -8.5030 + 0.0422 x

g) For every 1lb increase in weight the power of vehicle increase by 0.0422cf

h) the engine power of a car if its weight were 2.5 tons would be -8.5030 + 0.0422*5511.56 = 224.08

i) Plot the regression line on the scatter plot

j) r. = 08451 , there is positive strong linear correlation between power and weight . yes it agrees with what was thought in point c

k) r2= 07142 , about 7142% variation in power can be explained by this model


Related Solutions

9. The data presented in Problem 7 are analyzed using muliple linear regression analysis and the...
9. The data presented in Problem 7 are analyzed using muliple linear regression analysis and the models are shown here. In the models, the data are coded as 1= new treatment and 0= standard treatment, and age greater than 65 is coded as 1= yes and 0= no. y= 53.85- 23.54 (Treatment) y= 45.31- 19.88 (Treatment) + 14.64 (Age > 65) y= 45.51 - 20.21 (Treatment) + 14.29 (Age> 65) + .75 (Treatment X Age > 65) Patients < 65...
The data presented in Problem 7 are analyzed using multiple linear regression analysis and the models...
The data presented in Problem 7 are analyzed using multiple linear regression analysis and the models are shown here. In the models, the data are coded as 1 = new medication and 0 = standard medication, and age 65 and older is coded as 1 = yes and 0 = no. ŷ = 53.85 − 23.54 (Medication) ŷ = 45.31 − 19.88 (Medication) + 14.64 (Age 65 +) ŷ = 45.51 − 20.21 ( Medication ) + 14.29 ( Age...
In this problem, we will perform multiple regression on the Boston housing data. The data contains...
In this problem, we will perform multiple regression on the Boston housing data. The data contains 506 records with 14 variables. The variable medv is the response variable. Solve the following problems in R and print out the commands and outputs : To assess the data use library(MASS) data(Boston) (a) First perform a multiple regression with all the variables, what can you say about the significance of the variables based on only the p-values. Next use the ”step” function to...
Regression Project: Data The table below contains the price, demand, and total cost data for the...
Regression Project: Data The table below contains the price, demand, and total cost data for the production of x widgets. Here p is the price (in dollars) of a widget for an annual demand of x widgets, and C is the annual total cost (in dollars) of producing x widgets per year. Demand x (widgets) Price p ($/widget) Total Cost C ($) 10 141 609 20 133 1103 30 126 1618 40 128 2109 50 113 2603 60 97 3111...
GENERAL INSTRUCTIONS Data should be analyzed in Excel. Everything should be appropriately labeled. Simple Regression: Examine...
GENERAL INSTRUCTIONS Data should be analyzed in Excel. Everything should be appropriately labeled. Simple Regression: Examine the relationship between the number of units produced and the total manufacturing overhead by performing Regression Analysis and generating a “Line-fit” plot. Highlight the following in YELLOW on the spreadsheet: What is the coefficient of correlation and what does it say about the relationship? What is the coefficient of determination and what does it say about the relationship? What is the equation of this...
Find the regression equation using the following set of data with y as the response variable....
Find the regression equation using the following set of data with y as the response variable. x y 40.2 82.2 54.2 111.8 43 84.3 30.7 68.5 33 90.8 42.8 78.5 30.9 71.7 28.6 69.8 36.6 83.1 41.1 93.9 26.6 63.9 45.5 95.5 What is the correlation coefficient? use three decimal places. r =   What is the regression line equation. Use each value to three decimal places. ˆyy^ =  +  x What is the predicted value of the response variable, when using a...
Using the following data, conduct a linear regression analysis (by hand). In this analysis, you are...
Using the following data, conduct a linear regression analysis (by hand). In this analysis, you are testing whether SAT scores are predictive of overall college GPA. Also, write out the regression equation. How would you interpret your results? SAT Score GPA 670 1.2 720 1.8 750 2.3 845 1.9 960 3.0 1,000 3.3 1,180 3.2 1,200 3.4 1,370 2.9 1,450 3.8 1,580 4.0 1,600 3.9
Run a linear regression using Excel’s Data Analysis regression tool. Construct the linear regression equation and...
Run a linear regression using Excel’s Data Analysis regression tool. Construct the linear regression equation and determine the predicted total sales value if the number of promotions is 6. Is there a significant relationship? Clearly explain your reasoning using the regression results. Number of Promotions Total Sales 3 2554 2 1746 11 2755 14 1935 15 2461 4 2727 5 2231 14 2791 12 2557 4 1897 2 2022 7 2673 11 2947 11 1573 14 2980
The ledger of Port Hope Corporation at November 30, 2021, contains the following summary data: Cash...
The ledger of Port Hope Corporation at November 30, 2021, contains the following summary data: Cash dividends—common $65,000 Operating expenses $1,120,000 Cash dividends—preferred 25,000 Other comprehensive income—loss on equity investments (before income tax) 83,000 Common shares 325,000 Rent revenue 48,000 Cost of goods sold 7,280,000 Preferred shares ($5 noncumulative) 400,000 Depreciation expense 355,000 Retained earnings, December 1, 2020 755,000 Sales 9,124,000 Your analysis reveals the following additional information: 1. The company has a 25% income tax rate. 2. The communications...
2. Solve using Microsoft Excel: Use the following data to find the equation of the regression...
2. Solve using Microsoft Excel: Use the following data to find the equation of the regression line. X-Bar 2 4 5 6 Y-Bar 7 11 13 20
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT