# Use excel solving the following problems

Description

Use excel solving the following problems and put the solution into printable version. Please put the solutions in individual file for each problem.

16. The article “Characterization of Highway Runoff in
Austin, Texas, Area” (J. of Envir. Engr., 1998: 131–
137) gave a scatterplot, along with the least squares line,
of x = rainfull volume (mº) and y = runoff volume (m)
for a particular location. The accompanying values were
5
12
14
17
23
30
40
47
y
4
10
13
15
15
25
27
46
r
55
67
72
81
96
112
127
у
38
46
53
70
82
99
100
a. Does a scatterplot of the data support the use of the
simple linear regression model?
b. Calculate point estimates of the slope and intercept
of the population regression line.
c. Calculate a point estimate of the true average runoff
volume when rainfall volume is 50.
d. Calculate a point estimate of the standard deviation o.
e. What proportion of the observed variation in runoff
volume can be attributed to the simple linear regres-
sion relationship between runoff and rainfall?
17. The article “Towards Improving the Properties of
Plaster Moulds and Castings” (J. Engr. Manuf., 1991:
265–269) describes several ANOVAs carried out to study
how the amount of carbon fiber and sand additions affect
various characteristics of the molding process. Here we
give data on casting hardness and on wet-mold strength.
Sand
Carbon Fiber Casting Wet-Mold
0
0
0
0
0
15
15
30
30
0
0
15
15
30
30
0
0
0
.25
.25
.25
.25
.25
.25
.50
.50
.50
.50
.50
.50
61.0
63.0
67.0
69.0
65.0
74.0
69.0
69.0
69.0
74.0
74.0
72.0
67.0
69.0
69.0
74.0
74.0
74.0
34.0
16.0
36.0
19.0
28.0
17.0
49.0
48.0
43.0
29.0
31.0
24.0
55.0
60.0
45.0
43.0
22.0
48.0
0
15
15
30
30
b. Carry out an ANOVA on the casting hardness obser-
vations using a = :.05.