Assignment:
A) Find the linear regression equation (line of best fit), determine the correlation, and then make a prediction.
1. The table below gives the amount of time students in a class studied for a test and their test scores. Graph the data on a scatter plot, find the line of best fit, and write the equation for the line you draw.
Hours Studied

1

0

3

1.5

2.75

1

0.5

2

Test Score

78

75

90

89

97

85

81

80

Linear Regression Equation:
Correlation Coefficient (r):
Type of Correlation:
Is the correlation strong? Explain
Using the linear regression equation predict astudents test score if they studied for 4 hours.
2. The table below gives the amount of Krabby Patties made by Spongebob for each year he's worked.
Graph the data on a scatter plot, find the line of best fit, and write the equation for the line you draw.
Years worked

1

2

3

4

5

6

Patties made

6,500

7,805

10,835

11,230

15,870

16,387

Linear Regression Equation:
Correlation Coefficient (r):
Type of Correlation:
Is the correlation strong? Explain
Using the linear regression equation predict how many Krabby Patties he will make after working 10 years.
3. The table below gives the estimated world population (in billions) for various years.
Year

1980

1990

1997

2000

2005

2011

Population

4400

5100

5852

6080

6450

7000

Linear Regression Equation:
Correlation Coefficient (r):
Type of Correlation:
Is the correlation strong? Explain
Using the linear regression equation predict the world population in the year 2015.
4. The table below shows the income for an employee over his first 8 years of work. Use this to estimate his income for his 15th year of work.
Years

1

2

3

4

5

6

7

8

Income

45,000

46,814

48,212

52,870

54,125

58,532

61,075

62,785

Linear Regression Equation:
Correlation Coefficient (r):
Type of Correlation:
Is the correlation strong? Explain
Using the linear regression equation predict his income for his 15th year of work.
B) Attached you will find an excel sheet data on the effect of 5 variables (Cylinder, displacement, horsepower, weight, seconds or acceleration) on the Gasoline consumption per 1000 miles. Based on the data please workout the following.
a) Regression model
b) Regression coefficient
c) Correlation coefficient between
 Gasoline consumption and cylinder
 Cylinder and displacement
 Gasoline consumption and acceleration
d) Find the pvalue for
i. Total regression line
ii. Cylinder
iii. Displacement
iv. Horse power
v. Weight
vi. acceleration
e) identify the variable which has
i. a significant impact
ii. Less significant impact
f) Predict the Gasoline consumption per 1000 mile using the following data
i. Cylinder  6
ii. Displacement  2.2
iii. Horse power  2.4
iv. Weight  3.8
v. Acceleration  12
Attachment: Gasoline consumption Data.rar