Question
The South Dakota Department of Game and Fish (SDDGF) wants to lengthen the pheasant-hunting season to bring in more tourist revenue. SDDGFs thinking is that
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 2 = .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?
Step by Step Solution
3.53 Rating (160 Votes )
There are 3 Steps involved in it
Step: 1
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 ...
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Systems analysis and design
Authors: Alan Dennis, Barbara Haley Wixom, Roberta m. Roth
5th edition
978-1118057629, 1118057627, 978-111880817
