Question

(30 pts) Henry Goodgame has noticed over the years that the attendance at the Homecoming tailgate can be affected by the anticipated weather. He believes he can predict the attendance based on the chance of rain. He gathered the data below.

% Chance of Rain	Attendance
20	15,000
40	8000
80	5000
10	14000
60	7000
50	8000

For this year’s Homecoming the forecasted chance of rain was 30%. What is the probability you would expect more than 10,000 in attendance?

Answer 1

Answer to the question)

we can run a regression analysis for th given data in excel to find the regression line equation and then predict the value for 30% chance of rain

.

for this enter the data in excel

clcik on data tab

click on data analysis

select regression

following window appears on screen

.

.

Enter the y range as the attedance data since that is wht we need to predict

enter the x range as chance of rain

tick on the check box of labels

click ok

We get the following output:

.

From the coefficient's column we get the regression equation as

attendance = 15870 -147 * rain

.

We got rain = 30

So predicted attendance = 15870- 147*30

Predcted attendance = 11460