Answered step by step
Verified Expert Solution
Question
1 Approved Answer
US Birth Rates y = -0.1002x + 214.49 R2 = 0.9152 18.0 16.0 O. . . . ....... 14.0 12.0 10.0 Birth Rate Per 1,000
US Birth Rates y = -0.1002x + 214.49 R2 = 0.9152 18.0 16.0 O. . . . ....... 14.0 12.0 10.0 Birth Rate Per 1,000 People 8.0 Series 1 6.0 . . ...... Linear (Series 1) 4.0 2.0 0.0 1970 1980 1990 2000 2010 2020 2030 Year4. Open the file Birth Rates which contains the number of babies born for every 1000 people from 1981 to 2021. a. Make a scatter graph of the years and the rates with trendline, equation, and R2. To better see the change in the rate over time, change the y-axis minimum to 10. Paste the resultin- - h here. [2 ts]- . y = -0.1002x + 214.49 + Seriesl ......... Linear {Seriesl} 2 a. O a; EL 0 O 0-; H I a; D. a; 4H (U n: .C JJ .: no 1970 1980 1990 2000 2010 2020 2030 Year b. According to the trendline equation, what will the birth rate be in 2025? How much confidence do you have in this prediction? Why? [3pts] c. According to the trendline equation, what was the birth rate in 1951? How much confidence do you have in this prediction? Why? [3pts] d. According to the trendline equation, in what year will there be no babies born? How much confidence do you have in this prediction? Why? [3pts]
Step by Step Solution
There are 3 Steps involved in it
Step: 1
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