The South Dakota Department of Game and Fish (SDDGF) wants to lengthen the pheasant-hunting season to...

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.

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

Solutions

Expert Solution

A). Y=547,000-214X

Intercept - that means when x is Zero ( at day 0, beginning) number of birds are 547,000

Slope - If the season is 1 day long then number of birds would be killed are 214.

test the slope for significance - T value = -214/415 = 0.515663. By checking the P( >|t|) value you can take the decision

R square = Sum of squared Regression / Sum of square Total. Here value is 0.15 that means only 15% of total variance can be explained by the independent variable.

B). Number of birds birds will survive if the season is 60 days long = 547,000 - 214 *60 = 547,000 - 12,840 = 534,160

C). SDDGF's thinking is not correct, that means a longer season will significantly deplete the bird population because the slope value is 214 and negative. When X will take larger value then Y value will decrease based on the equation.

Regression in Excel using the data analysis tool

You have to select "Regression" in data analysis tool. Please mention "Input Y range" and "Input X range" in the suitable boxes. In the output option mention "Output Range" as well

Please let me know for any doubts. I would be happy to discuss more in details.

orchestra answered 2 years ago

Next > < Previous

Related Solutions

According to the South Dakota Department of Health, the number of hours of TV viewing per...

According to the South Dakota Department of Health, the number of hours of TV viewing per week is higher among adult women than adult men. A recent study showed women spent an average of 33 hours per week watching TV, and men, 24 hours per week. Assume that the distribution of hours watched follows the normal distribution for both groups, and that the standard deviation among the women is 5.0 hours and is 5.9 hours for the men. What percent...

The Fish and Game Department stocked a lake with fish in the following proportions: 30% catfish,...

The Fish and Game Department stocked a lake with fish in the following proportions: 30% catfish, 15% bass, 40% bluegill, and 15% pike. Five years later it sampled the lake to see if the distribution of fish had changed. It found that the 500 fish in the sample were distributed as follows. Catfish Bass Bluegill Pike 121 76 237 66 In the 5-year interval, did the distribution of fish change at the 0.05 level? (a) What is the level of...

SOUTH DAKOTA CORPORATION(2-3) SOUTH DAKOTA CORPORATION uses a job-order costing system with normal costing. At the...

SOUTH DAKOTA CORPORATION(2-3) SOUTH DAKOTA CORPORATION uses a job-order costing system with normal costing. At the start of the period, the company had the following balances: Raw Materials inventory $ 2,500 Work in process inventory - Finished goods inventory 27,400 At the start of the period, only Job Alpha was in finished goods. During the month of February, the following transactions occurred: Purchased raw materials on account for $24,500. Requisitioned $23,000 of materials for use in production. Of the...

1. The Arizona Fish and Game department has a lottery for elk tags in an effort...

1. The Arizona Fish and Game department has a lottery for elk tags in an effort to control the population of elk in Northern Arizona. There are two proposed methods of deciding how many tags to auction: A) Auction 6 % of the current population each year. B) Auction 7500 tags per year regardless of the population. Clearly one method is a better policy since it monitors the current population. However; ignoring the birth rate of elk, decide if policy...

The Wisconsin Fish and Game Department stocked a lake with 30% catfish, 15 % bass, 40%...

The Wisconsin Fish and Game Department stocked a lake with 30% catfish, 15 % bass, 40% bluegill, and 15% Northern Pike. Five years later they took a random sample of 500 fish from the lake and found 120 catfish, 85 bass, 220 bluegill, and 75 Northern Pike. At the 5% level of significance, can we show that the distribution of fish changed over the 5-year interval? State and test appropriate hypotheses. State conclusions.

Write fairly complete pseudocode for the Fish Wars card game. Fish Wars is a card game...

Write fairly complete pseudocode for the Fish Wars card game. Fish Wars is a card game where two players get 13 cards each. The cards have face values of 1-10 plus one shark card and two peace cards. The game is played in 13 rounds. Each round, the players each play one card face down and then flip them up at the same time. The player with the higher number (plus any battle bonus) wins. No one wins on a...

Hester’s Hatchery raises fish. At the end of the current season she has 2,100 fish in...

Hester’s Hatchery raises fish. At the end of the current season she has 2,100 fish in the hatchery. She can harvest any number of fish that she wishes, selling them to restaurants for $5 a piece. Because big fish make little fish, for every fish that she leaves in the hatchery this year, she will have two fish at the end of next year. The price of fish is expected to be $5 each next year as well. Hester relies...

what are the Professional Nursing and State-Level Regulations in California and south Dakota

Fisherman Alex and John fish in the South China Sea. They can choose to fish for...

Fisherman Alex and John fish in the South China Sea. They can choose to fish for 8 months or 12 months. If they both fish for 8 months, they can catch 800 kilograms fish each. If they both fish for 12 months, they can catch 1200 kilograms fish each. If Alex fishes for 8 months but John fishes for 12 months, Alex can only catch 800 kilograms fish but John can catch 1200 kilograms fish. If John fishes for 8...

A question of interest to game managers is the hunting strategy of predators. Do they just...

A question of interest to game managers is the hunting strategy of predators. Do they just take the first prey that comes along, or are the selective? In a study of winter prey selection in a National Park, radio-tagged wolves were observed to have killed prey according to the table below. Wolves were identified as the predators by their tracks in the snow. At the most recent census in the National Park there were about 3,500 white-tailed deer, 1,000 elk,...

Subjects