The following gives the number of accidents that occurred on Florida State Highway 101 during the last 4 months: Month Jan Feb Mar Apr Number of Accidents 25 48 60 90 Using the least-squares regressionLOADING... method, the trend equation for forecasting is (round your responses to two decimal places): ModifyingAbove y with caret = nothing + nothingx Using least-squares regression, the forecast for the number of accidents that will occur in the month of May = nothing accidents (enter your response as a whole number).

The forecast of number of accidents that will occur in the month of May shows that there will be 108 accidents by May

Step-by-step explanation:

The lease square method is also known as regression method on excel.

y = mx + c

where a is the intersect and b is the slope

Step 1: get the slope 'm' by using the command =SLOPE(C2:C5,A2:A5)

Step 2: get the intersect 'c' by using the command =INTERSECT(C2:C5,A2:A5)

c=4 , m=20.7 and x is the period

Step 3: Calculate 'forcast' for each month using the commands =B$9+B$8*A2 on D2 and copy down to May.

Y = mx + c

You should get 107.5 ≈ 108 accidents

529 and 531

step-by-step explanation:

their is no graph showing

step-by-step explanation: