YearPopulation17903,929,21418005,308,48318107,239,88118209,638,453183012,866,020184017,069,453185023,191,876186031,443,321187039,818,449188050,155,783189062,947,714190075,994,575191091,972,2661920105,710,6201930122,775,0461940131,669,2751950150,697,3611960179,323,1751970203,302,0311980226,545,8051990248,709,8732000281,421,9062010308,745,538Use excel to calculate the Least Squares Regression Line for the census data? (need to include correct values for a and b)Using the line, you calculated in number 5, what would you predict the population to have been in 1985? EXPLAIN.Should you use the previously calculated Regression Line to predict population in the year 2200? EXPLAIN.

Name: YearPopulation17903,929,21418005,308,48318107,239,88118209,638,4531830
Uploaded: 2024-03-20T07:07:12.000Z
Channel: Bartleby
Description: YearPopulation17903,929,21418005,308,48318107,239,88118209,638,453183012,866,020184017,069,453185023,191,876186031,443,321187039,818,449188050,155,783189062,947,714190075,994,575191091,972,2661920105,710,6201930122,775,0461940131,669,2751950150,697,3

We have used the excel data analysis tool to run the regression analysis.

Answered: Use excel to calculate the Least…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Topic Video

Question

100%

Year	Population
1790	3,929,214
1800	5,308,483
1810	7,239,881
1820	9,638,453
1830	12,866,020
1840	17,069,453
1850	23,191,876
1860	31,443,321
1870	39,818,449
1880	50,155,783
1890	62,947,714
1900	75,994,575
1910	91,972,266
1920	105,710,620
1930	122,775,046
1940	131,669,275
1950	150,697,361
1960	179,323,175
1970	203,302,031
1980	226,545,805
1990	248,709,873
2000	281,421,906
2010	308,745,538

Use excel to calculate the Least Squares Regression Line for the census data? (need to include correct values for a and b)
Using the line, you calculated in number 5, what would you predict the population to have been in 1985? EXPLAIN.
Should you use the previously calculated Regression Line to predict population in the year 2200? EXPLAIN.

Expert Solution

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

$Hypothesis Tests and Confidence Intervals for Means$

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