Question

Consider the following table summarizing the speed limit of a certain road and Type numbers in the the number of accidents occurring on that road in January. Part 1:10 points boxes. Posted Speed Limit 53 49 44 36 21 23 * Part 2: 10 points Part 3: 10 points Reported Number of Accidents 25 28 20 17 18 14 30 points 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 14mph. Round to the nearest whole number.

Answer 1

Bring data in to excel sheet

Select data --> go to insert tab--> choose scatter plot diagram.

Select any data point --> right click --> add trend line --> choose linear --> select display an equation on chart

L M N Format Trendline 1. Posted speed limit Reported number of accidents 53 25 28 Trendline Options 0AWN- Reported number of accidents 20 17 18 14 Exponential y = 0.327x + 8.034 Linear =Əo o O Logarithmic . O Polynomial Order 2 Power 15 Period 2 Moving Average Trendline Name 0 10 20 30 40 50 60 Linear (Reported O Automatic number of accidents) Custom Forecast Forward 0.0 periods Backward 0.0 periods Set Intercept 0.0 ✓ Display Equation on chart Display R-squared value on chart 26

1)Slope: 0.327

2)Intercept: 8.034

3)Prediction: X = 14

Regression equation: y = 0.327x + 8.034

y = 0.327*14 + 8.034

y = 12.612

y = 13 (rounded to nearest whole number)