The following list gives the gross federal debt(in millions of dollars) for the U.S. every 5 years from 1945 to 2000: Year Gross Federal Debt ($millions) 1945 260,123 1950 256,853 1955 274,366 1960 290,525 1965 322,318 1970 380,921 1975 541,925 1980 909,050 1985 1,817,521 1990 3,206,564 1995 4,921,005 2000 5,686,338 Construct a scatter plot with this data. Do you observe a trend? If so, what type of trend do you observe? Use Excel to fit a linear trend and an exponential trend to the data. Display the models and their respective r^2. Interpret both models. Which model seems to be more approprate and why?
The following list gives the gross federal debt(in millions of dollars) for the U.S. every 5 years from 1945 to 2000: Year Gross Federal Debt ($millions) 1945 260,123 1950 256,853 1955 274,366 1960 290,525 1965 322,318 1970 380,921 1975 541,925 1980 909,050 1985 1,817,521 1990 3,206,564 1995 4,921,005 2000 5,686,338 Construct a scatter plot with this data. Do you observe a trend? If so, what type of trend do you observe? Use Excel to fit a linear trend and an exponential trend to the data. Display the models and their respective r^2. Interpret both models. Which model seems to be more approprate and why?
Algebra & Trigonometry with Analytic Geometry
13th Edition
ISBN:9781133382119
Author:Swokowski
Publisher:Swokowski
Chapter10: Sequences, Series, And Probability
Section10.3: Geometric Sequences
Problem 81E
Related questions
Question
- The following list gives the gross federal debt(in millions of dollars) for the U.S. every 5 years from 1945 to 2000:
Year Gross Federal Debt ($millions)
1945 260,123
1950 256,853
1955 274,366
1960 290,525
1965 322,318
1970 380,921
1975 541,925
1980 909,050
1985 1,817,521
1990 3,206,564
1995 4,921,005
2000 5,686,338
- Construct a
scatter plot with this data. Do you observe a trend? If so, what type of trend do you observe? - Use Excel to fit a linear trend and an exponential trend to the data. Display the models and their respective r^2.
- Interpret both models. Which model seems to be more approprate and why?
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 7 steps with 10 images
Knowledge Booster
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.Recommended textbooks for you
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage