The South Dakota Department of Game and Fish (SDDGF) wants to lengthen the pheasant-hunting season to bring in more tourist revenue. SDDGF’s thinking is that most pheasants are killed during the first 2 weeks of the season; therefore, a longer season will not deplete the bird population. Using sample data from all past hunting seasons, Rodney Ringneck, the SDDGF’s data analyst, regresses the number of birds surviving the season on the length in days in the season.

He finds: Y =547,000-214X ; s.e. _b = 415; R ² = .15; n = 35.

(a) Interpret the intercept and slope, test the slope for significance, and interpret the R-squared.

(b) Predict how many birds will survive if the season is 60 days long.

(c) Is SDDGF's thinking correct (that a longer season will not significantly deplete the bird population)?

How would I show regression in Excel using the data analysis tool?

Answer rating: 100% (QA)

Aim 1 To interpret the intercept and slopeto test the slope for significance and to interpret Rsquared value 2 To predict how many birds will survive ... View the full answer