SOLUTION: years: 1930, 1940, 1950; 1960; 1970, 1980, 1990 workers:29.4, 32.3, 45.2, 54.2, 70.9, 90.6, 103.9 (millions) Let x equal the number of years since 1990. Find the line of regre

Algebra ->  Probability-and-statistics -> SOLUTION: years: 1930, 1940, 1950; 1960; 1970, 1980, 1990 workers:29.4, 32.3, 45.2, 54.2, 70.9, 90.6, 103.9 (millions) Let x equal the number of years since 1990. Find the line of regre      Log On


   

Question 14321: years: 1930, 1940, 1950; 1960; 1970, 1980, 1990
workers:29.4, 32.3, 45.2, 54.2, 70.9, 90.6, 103.9
(millions)
Let x equal the number of years since 1990. Find the line of regression. How many pairs of points can be formed from the 7 data points in the table?
Can you please help me solve this?
Answer by khwang(438) About Me  (Show Source):
You can put this solution on YOUR website!
Youu can use the function Linest of Excel to find the equation of regression line.
m(slope) =1.306428571 (= INDEX(LINEST(B1:B7,A1:A7),1)
b (y-ntercept)=-2499.671429 (= INDEX(LINEST(B1:B7,A1:A7),2)
reg. line eq. y = mx + b
There are C(7,2) = 21 possible pairs of points and hence there are 21
possible lines (if no3 of the 7pts are collinear. You should know this
basic fact.)

Kenny