The quarterly sales data (number of copies sold) for a college textbook over the past three years follow: Quarter Year 1 Year 2 Year 3 1690 1800 1850 940 900 1100 2625 2900 2930 4 2500 2360 2615

Is this right?

please assist with this NON GRADED problem.   data file information is below Price Mileage Age 16998 35000 3 17599 16000 3 15998 42000 3 15998 61000 4 11599 102000 7 13998 109000 4 14998 60000 5 11599 88000 9 12599 58000 8 14998 27000 6 15998 32000 4 11599 95000 8 10499 123000 8 14599 54000 5 10599 68000 11 16998 40000 4 20998 7000 1 11599 81000 9 12599 70000 6 13599 86000 5 11599 92000 7 9599 120000 10 18998 20000 2 12599 63000 7 12599 70000 6 10998 88000 10 11998 86000 6 12998 60000 6 17599 45000 2 9998 96000 11 9998 60000 11 16998 36000 2 17599 45000 2

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.