Tutorial 6 Linear Regression and Correlation
Tutorial 6 Linear Regression and Correlation
Tutorial 6 Linear Regression and Correlation
1. The following table shows the amount of water, in cm3, applied to seven similar plots
on an experimental farm. It also shows the yield of hay in tones per acre.
2. Two people, X and Y were asked to give marks out of 20 for seven brands of fish
finger. The results recorded in the table.
Brands A B C D E F G
X’s mark 8 10 18 2 1 4 15
Y’s mark 5 14 12 9 4 1 19
3. A mother monitored the growth of her baby and recorded the length h cm and weight y
h3
x=
kg at various stages in the baby’s development. The new variable 10000 was
calculated and the values of x and y are given in the table below.
a. Plot a scatter diagram to illustrate the data and comment on whether a linear
relationship between y and x is likely to provide suitable model for the
relationship between y and x.
b. Obtain the regression line of y on x.
c. Estimate the weight of the baby when it was 75 cm long.
4. A car manufacturer is testing the braking distance, y meters for different speeds, x
km/h when the brakes were applied.
5. Values of x and y for a set of bivariate data are given in the following table.
6. An old film is treated with chemical in order to improve the contrast. Preliminary tests
on 9 samples drawn from a segment of the film produced the following results.
Sample A B C D E F G H I
x 1 1.5 2 2.5 3 3.5 4 4.5 5
y 49 60 66 62 72 64 89 90 96
The quantity x is a measure of the amount of chemical applied, and y is the contrast
index, which takes values between 0 and 100.
7. Before hiring new employees, the personnel director for a company decides to do a
regression analysis of the company’s current salary structure. She believes that an
employee’s salary is related to the number of years of work experience (YEARS) and
to the number of years of post-high school education (POSTHSED). The following
EXCEL output is produced from the sample data she has gathered:
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.785
R Square 0.886
Adjusted R
Square 0.884
Standard Error 3164
Observations 194
ANOVA
Significanc
df SS MS F eF
1479211827 739605913
Regression 2 2 6 738.9 0
Residual 191 1912102400 10011007
1670422118
Total 192 4
Coefficient Standard
s Error t Stat P-value
Intercept 29436.2 581.3 50.4 0
POSTHSED 1306.1 255.3 5.12 0
YEARS 832.63 44.49 18.71 0
8. A manufacturer found that a significant relationship exist among the number of hours
an assembly line employee works per shift x1 , the total number of items produced x2 ,
and the number of defective items produced y. The multiple regression equation is
yˆ 9.6 2.2 x1 1.08 x2 .
a. Predict the number of defective items produced by an employee who has worked
9 hours and produced 24 items.
b. Interpret each coefficient in the given equation.
a. Predict the income of a person who is 32 years old and has a GPA of 3.4.
b. Interpret each coefficient in the given equation.
ANSWERS
1. a. yˆ 3.67 0.04 x
b. r 0.9766
c. y 4.7235, y 9.3275 , the prediction is reliable
3. b. yˆ 1.6858 0.1772 x
c. x 42.187, y 9.1616kg