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.

College Algebra
10th Edition
ISBN:9781337282291
Author:Ron Larson
Publisher:Ron Larson
ChapterP: Prerequisites
SectionP.6: The Rectangular Coordinate System And Graphs
Problem 2ECP
icon
Related questions
Question

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 appropriate? Why?
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 7 steps with 7 images

Blurred answer
Recommended textbooks for you
College Algebra
College Algebra
Algebra
ISBN:
9781337282291
Author:
Ron Larson
Publisher:
Cengage Learning
Trigonometry (MindTap Course List)
Trigonometry (MindTap Course List)
Trigonometry
ISBN:
9781337278461
Author:
Ron Larson
Publisher:
Cengage Learning
Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
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
Algebra and Trigonometry (MindTap Course List)
Algebra and Trigonometry (MindTap Course List)
Algebra
ISBN:
9781305071742
Author:
James Stewart, Lothar Redlin, Saleem Watson
Publisher:
Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill