The table below contains made-up data for the total number of COVID-19 cases each day within a country. Day 1 2 3 4 6 7 8 9. 10 COVID cases 60 183 227 216 342 400 620 789 1030 1458 A scatterplot of the data shows that the association is not linear. Using Excel, it is possible to determine various nonlinear regression models. In this case, an exponential regression model is appropriate. Use Excel to determine the least squares exponential regression curve for this data. Chart Elements COVID-19 cases M Axes 1600 Axis Titles 1400 Chart Title 1200 Data Labels Error Bars 1000 Gridlines 800 Legend 600 Trendline Linear 400 Exponential 200 Linear Forecast Two Period Moving Average 4 6 8 10 12 More Options.. What is the equation of the exponential regression curve? O a. y= 69.784 xe0.3052 ·x Ob.y = 45.786 x e0.2093 -x Oc. y = 75.786 x e0.0293 ·x O d.y = 85.684 x e0.9023 ·x %3D QUESTION 11 (previous question continued...) Using the exponential regression curve to extrapolate into the future, on what day will the total number of cases reach 5000? Round to the nearest whole number. [Note that e = 2.71828 is the base of the natural exponential function. This question is more challenging than what you will be asked on the final exam!] DI)

College Algebra
7th Edition
ISBN:9781305115545
Author:James Stewart, Lothar Redlin, Saleem Watson
Publisher:James Stewart, Lothar Redlin, Saleem Watson
Chapter1: Equations And Graphs
Section: Chapter Questions
Problem 10T: Olympic Pole Vault The graph in Figure 7 indicates that in recent years the winning Olympic men’s...
icon
Related questions
Topic Video
Question

Find question 11 using question 10

The table below contains made-up data for the total number of COVID-19 cases each day within a country.
Day
1
2
3
4
6
7
8
9.
10
COVID cases
60
183
227
216
342
400
620
789
1030
1458
A scatterplot of the data shows that the association is not linear. Using Excel, it is possible to determine various nonlinear regression models. In this case, an
exponential regression model is appropriate. Use Excel to determine the least squares exponential regression curve for this data.
Chart Elements
COVID-19 cases
M Axes
1600
Axis Titles
1400
Chart Title
1200
Data Labels
Error Bars
1000
Gridlines
800
Legend
600
Trendline
Linear
400
Exponential
200
Linear Forecast
Two Period Moving Average
4
6
8
10
12
More Options..
What is the equation of the exponential regression curve?
O a. y= 69.784 xe0.3052 ·x
Ob.y = 45.786 x e0.2093 -x
Oc. y = 75.786 x e0.0293 ·x
O d.y = 85.684 x e0.9023 ·x
%3D
QUESTION 11
(previous question continued...) Using the exponential regression curve to extrapolate into the future, on what day will the total number of cases reach 5000?
Round to the nearest whole number.
[Note that e = 2.71828 is the base of the natural exponential function. This question is more challenging than what you will be asked on the final exam!]
DI)
Transcribed Image Text:The table below contains made-up data for the total number of COVID-19 cases each day within a country. Day 1 2 3 4 6 7 8 9. 10 COVID cases 60 183 227 216 342 400 620 789 1030 1458 A scatterplot of the data shows that the association is not linear. Using Excel, it is possible to determine various nonlinear regression models. In this case, an exponential regression model is appropriate. Use Excel to determine the least squares exponential regression curve for this data. Chart Elements COVID-19 cases M Axes 1600 Axis Titles 1400 Chart Title 1200 Data Labels Error Bars 1000 Gridlines 800 Legend 600 Trendline Linear 400 Exponential 200 Linear Forecast Two Period Moving Average 4 6 8 10 12 More Options.. What is the equation of the exponential regression curve? O a. y= 69.784 xe0.3052 ·x Ob.y = 45.786 x e0.2093 -x Oc. y = 75.786 x e0.0293 ·x O d.y = 85.684 x e0.9023 ·x %3D QUESTION 11 (previous question continued...) Using the exponential regression curve to extrapolate into the future, on what day will the total number of cases reach 5000? Round to the nearest whole number. [Note that e = 2.71828 is the base of the natural exponential function. This question is more challenging than what you will be asked on the final exam!] DI)
Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Permutation and Combination
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
College Algebra
College Algebra
Algebra
ISBN:
9781305115545
Author:
James Stewart, Lothar Redlin, Saleem Watson
Publisher:
Cengage Learning
Linear Algebra: A Modern Introduction
Linear Algebra: A Modern Introduction
Algebra
ISBN:
9781285463247
Author:
David Poole
Publisher:
Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt