Question

In an article, Bissell, et. al., study bridge safety (measured in accident rates per 100 million...

In an article, Bissell, et. al., study bridge safety (measured in accident rates per 100 million vehicles) and the difference between the width of the bridge and the width of the roadway approach (road plus shoulder). The raw data points are:

WidthDiff.

-6

-4

-2

0

2

4

6

8

10

12

Accidents

120

103

87

72

58

44

31

20

12

7

The Excel output of a simple linear regression analysis relating accident to width difference is as follows:

SUMMARY OUTPUT

Regression Statistics

Multiple R

0.9913

R Square

0.9827

Adjusted R Square

0.9802

Standard Error

4.7942

Observations

9

ANOVA

df

SS

MS

F

Significance F

Regression

1

9126.6667

9126.6667

397.0856

0.0000

Residual

7

160.8889

22.9841

Total

8

9287.5556

Coefficients

Standard Error

t Stat

P-value

Lower 95%

Upper 95%

Lower 95.0%

Upper 95.0%

Intercept

72.8889

2.0214

36.0586

0.0000

68.1090

77.6687

68.1090

77.6687

Width

-6.1667

0.3095

-19.9270

0.0000

-6.8984

-5.4349

-6.8984

-5.4349

Identify and interpret the least squares estimate of slope.

The slope is 72.889. For every unit increase in width difference, the mean number of accidents are increased by 72.8889.

The slope is -6.167. For every unit increase in width difference, the mean number of accidents are increased by 6.167.

The slope is 72.889. For every unit increase in width difference, the mean number of accidents are decreased by 72.8889.

The slope is -6.167. For every unit increase in width difference, the mean number of accidents are decreased by 6.167.

Homework Answers

Answer #1

From Given table we have Slope = -6.1667

R squared= 0.9827

r(correlation)= sqrt(0.9827)= -0.9913 (Correlation will be negative because the slope has negative sign).

So r=-0.9913 . Negative correlation.

So the correct interpretation of the least squares estimate of slope is OPTION D

The slope is -6.167. For every unit increase in width difference, the mean number of accidents are decreased by 6.167.

OPTION A and OPTION C can not be correct because the slope value is NOT 72.889. OPTION B can not be TRUE because data are negatively correlated. So correct answer is OPTION D.  

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Use Excel to develop a regression model for the Hospital Database (using the “Excel Databases.xls” file...
Use Excel to develop a regression model for the Hospital Database (using the “Excel Databases.xls” file on Blackboard) to predict the number of Personnel by the number of Births. Perform a test of the slope. What is the value of the test statistic? Write your answer as a number, round your answer to 2 decimal places. SUMMARY OUTPUT Regression Statistics Multiple R 0.697463374 R Square 0.486455158 Adjusted R Square 0.483861497 Standard Error 590.2581194 Observations 200 ANOVA df SS MS F...
3. United Park City Properties real estate investment firm took a random sample of five condominium...
3. United Park City Properties real estate investment firm took a random sample of five condominium units that recently sold in the city. The sales prices Y (in thousands of dollars) and the areas X (in hundreds of square feet) for each unit are as follows         Y= Sales Price ( * $1000) 36 80 44 55 35 X = Area (square feet) (*100) 9 15 10 11 10 a. The owner wants to forecast sales on the basis of...
Use Data Analysis in Excel to conduct the Regression Analysis to reproduce the excel out put...
Use Data Analysis in Excel to conduct the Regression Analysis to reproduce the excel out put below (Note: First enter the data in the next page in an Excel spreadsheet) Home Sale Price: The table below provides the Excel output of a regression analysis of the relationship between Home sale price(Y) measured in thousand dollars and Square feet area (x):    SUMMARY OUTPUT Dependent: Home Price ($1000) SUMMARY OUTPUT Dependent: Home Price ($1000) Regression Statistics Multiple R 0.691 R Square 0.478...
Question 4: Analysts at a major automobile company collected data on a variety of variables for...
Question 4: Analysts at a major automobile company collected data on a variety of variables for a sample of 30 different cars and small trucks.  Included among those data were the EPA highway mileage rating and the horsepower of each vehicle.  The analysts were interested in the relationship between horsepower (x) and highway mileage (y). Given below is the Excel output from regressing starting miles per gallon (MPG) on number of horsepower for a sample of 30 students.     Note: Some of the...
12.4 Study the following Minitab output from a regression analysis to predict y from x. a....
12.4 Study the following Minitab output from a regression analysis to predict y from x. a. What is the equation of the regression model? b. What is the meaning of the coefficient of x? c. What is the result of the test of the slope of the regression model? Let α = .10.Why is the t ratio negative? d. Comment on r2 and the standard error of the estimate. e. Comment on the relationship of the F value to the...
Sales Price.Eggs Ad.Type Price.Cookies 18 4.77 0 4.74 20 4.67 0 4.81 23 4.75 0 4.36...
Sales Price.Eggs Ad.Type Price.Cookies 18 4.77 0 4.74 20 4.67 0 4.81 23 4.75 0 4.36 23 4.74 0 4.29 23 4.63 0 4.17 23 4.56 0 4.66 24 4.59 0 4.73 25 4.75 0 4.11 26 4.75 1 4.21 26 4.49 0 4.25 26 4.41 1 4.62 26 4.32 0 4.53 27 4.68 0 4.44 28 4.66 1 4.19 28 4.42 1 4.37 29 4.71 0 4.29 29 4.66 1 4.57 30 4.46 1 4.21 30 4.36 1 4.77...
Question 1 The travel agency Paradise Retreats has developed a model to predict the price per...
Question 1 The travel agency Paradise Retreats has developed a model to predict the price per night of holiday apartment rentals in the coast of Croatia: ?=550+11?1−5?2 ?: price of the apartment per night (in kunas) ?1: area of the apartment (in square meters) ?2: distance to the beach (in km) According to Paradise Retreats’ model: How much more expensive (in kunas) will be the rental of a 60 square-meter apartment on the beachfront compared with a 60 square-meter apartment...
1. For a pair of sample x- and y-values, what is the difference between the observed...
1. For a pair of sample x- and y-values, what is the difference between the observed value of y and the predicted value of y? a) An outlier b) The explanatory variable c) A residual d) The response variable 2. Which of the following statements is false: a) The correlation coefficient is unitless. b) A correlation coefficient of 0.62 suggests a stronger correlation than a correlation coefficient of -0.82. c) The correlation coefficient, r, is always between -1 and 1....