Question

In: Math

Consider the following table summarizing the speed limit of a certain road and the number of...

Consider the following table summarizing the speed limit of a certain road and the number of accidents occurring on that road in January. Posted Speed Limit 52 50 43 36 21 22. Reported Number of Accidents 27 26 23 18 18 11. 1) Find the slope of the regression line predicting the number of accidents from the posted speed limit.Round to 3 decimal places. 2) Find the intercept of the regression line predicting the number of accidents from the posted speed limit. Round to 3 decimal places. 3) Predict the number of reported accidents for a posted speed limit of 25mph. Round to the nearest whole number.

Solutions

Expert Solution

Consider the following table summarizing the speed limit of a certain road and the number of accidents occurring on that road in January. Posted Speed Limit 52 50 43 36 21 22. Reported Number of Accidents 27 26 23 18 18 11.

Find the slope of the regression line predicting the number of accidents from the posted speed limit.Round to 3 decimal places.

Slope= 0.405

2) Find the intercept of the regression line predicting the number of accidents from the posted speed limit. Round to 3 decimal places.

Intercept=5.384

3) Predict the number of reported accidents for a posted speed limit of 25mph. Round to the nearest whole number.

The estimated regression line is number of accidents =5.384+0.405*speed limit

When speed limit is 25,

Predicted number of accidents =5.384+0.405*25=15.509

=16 ( rounded)

Excel Addon Megastat used.

Menu used: correlation/Regression ---- Regression Analysis

Regression Analysis

0.823

n

6

r

0.907

k

1

Std. Error of Estimate

2.832

Dep. Var.

Number of Accidents

Regression output

confidence interval

variables

coefficients

std. error

   t (df=4)

p-value

95% lower

95% upper

Intercept

a =

5.384

Speed

b =

0.405

0.094

4.315

.0125

0.144

0.665

ANOVA table

Source

SS

df

MS

F

p-value

Regression

149.409

1   

149.409

18.62

.0125

Residual

32.091

4  

8.023

Total

181.500

5  

Predicted values for: Number of Accidents

95% Confidence Interval

95% Prediction Interval

Speed

Predicted

lower

upper

lower

upper

Leverage

25

15.51

10.96

20.05

6.42

24.59

0.334


Related Solutions

#1) Consider the following table summarizing the speed limit of a certain road and the number...
#1) Consider the following table summarizing the speed limit of a certain road and the number of accidents occurring on that road in January Posted Speed Limit 51 48 43 35 22 20 Reported Number of Accidents 25 29 25 17 19 14 a) Find the slope of the regression line predicting the number of accidents from the posted speed limit. Round to 3 decimal places. b) Find the intercept of the regression line predicting the number of accidents from...
The city of Springville is considering to raise the speed limit on a certain road from...
The city of Springville is considering to raise the speed limit on a certain road from 60km/hour to 75km/hour. a) Identify one benefit and one cost that would result from this change in speed limit. b) Identify the simple or complex method that can be used to monetize each impact that you have mentioned in part ‘a’. Briefly explain the methods. c) Are there reasons why the CBA Analyst should be cautious about any of the approaches that you explained...
the posted speed limit on a certain residential road is 30mph. the residents believe that drivers...
the posted speed limit on a certain residential road is 30mph. the residents believe that drivers are speeding on this road on average. they observe 20 randomly selected drivers on this road, and find the mean speed to be 31.8mph with a standard deviation of 4.2mph. is the resident's belief accrue? X= µ = n= x-bar= σ=
The speed limit of a road is 65 miles per hour. The speed of a car...
The speed limit of a road is 65 miles per hour. The speed of a car on the highway follows a normal distribution with a mean of 70 and standard deviation of 5. What percent of the distribution breaks the speed limit? The speed limit of a road is 65 miles per hour. The speed of a car on the highway follows a normal distribution with a mean of 70 and standard deviation of 5. A police officer will only...
A road includes dangerous geometric features for high speed travel which limit the travel speed on...
A road includes dangerous geometric features for high speed travel which limit the travel speed on the highway in this area. Among alternatives, it is proposed to upgrade the road so that travel speed may be increased. The upgrade will cost initially $ 38,500,000 and the annual maintenance cost is 800,000 $. It will result in: 10 minutes reduction in travel time for the average running vehicle. The estimated time cost is $3.5/hr.  Decrease in the number of accidents...
A scientific study on speed limits gives the following data table. Average speed limit Average annual...
A scientific study on speed limits gives the following data table. Average speed limit Average annual fatalities 25 16 27 29 29 38 32 71 35 93 Using technology, it was determined that the total sum of squares (SST) was 4029.2, the sum of squares regression (SSR) was 3968.4, and the sum of squares due to error (SSE) was 60.835. Calculate R2 and determine its meaning. Round your answer to four decimal places. Select the correct answer below: R2=0.0153 Therefore,...
We consider data in the following table, summarizing sales of a product (in thousands). For each...
We consider data in the following table, summarizing sales of a product (in thousands). For each of the questions, justify your answer. Year Quarter Sales 2015 1 2 3 4 4.95 4.25 6.15 6.65 2016 1 2 3 4 5.85 5.35 6.95 7.55 2017 1 2 3 4 6.15 5.75 7.65 7.95 (3.1) Assuming the given time-series shows evidence of seasonality, Determine the estimate sales values. (5) (3.2) What is the value of the root mean squared error for the...
We consider data in the following table, summarizing sales of a product (in thousands). For each...
We consider data in the following table, summarizing sales of a product (in thousands). For each of the questions, justify your answer. Year Quarter Sales 2015 1 2 3 4 4.95 4.25 6.15 6.65 2016 1 2 3 4 5.85 5.35 6.95 7.55 2017 1 2 3 4 6.15 5.75 7.65 7.95 (3.1) Assuming the given time-series shows evidence of seasonality, Determine the estimate sales values. (5)
The following is an incomplete F-table summarizing the results of a study of the variance of...
The following is an incomplete F-table summarizing the results of a study of the variance of life satisfaction scores among unemployed, retired, part-time, and full-time employees. Source of Variation SS df MS F Between groups 23 Within groups (error) 36 Total 153 (a) Complete the F-table. (Round your values for mean squares and F to two decimal places.) Source of Variation SS df MS F Between groups 23 Within groups (error) 36 Total 153 (b) Compute omega-squared (ω2). (Round your...
The following is an incomplete F-table summarizing the results of a study of the variance of...
The following is an incomplete F-table summarizing the results of a study of the variance of life satisfaction scores among unemployed, retired, part-time, and full-time employees. Source of Variation SS df MS F Between groups       23    Within groups (error)    36       Total 145          (a) Complete the F-table. (Round your values for mean squares and F to two decimal places.) Source of Variation SS df MS F Between groups 23 Within groups (error)...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT