Unit
8
LAB
Stat
Project
LAB
Unit
8:
Stat
Project
[(Required'Graded)
25
points)
CSLO
A.7,
CSLOB.3,CSLO
F.6,CSLO
G]
The
goal
of
this
lab
is
to
test
the
lincar
correlation
between
the
two
Quantitative
Vanables:
to
find
the
equation
of
the
regression
line
for
the
vanables;
and
to
use
the
line
for
prediction.
Important
Note:
The
interpretation
of
Microsoft
Excel
output
is
part
of
this
lab,
the
output
itself
i1s
not
sufficient
to
complete
this
lab.
Make
sure
to
answer
each
question
in
complete
sentences.
U.S.
Department
of
Transportation
As
part
of
a
study
on
transportation
safety,
the
U.S.
Department
of
Transportation
collected
data
on
the
number
of
fatal
accidents
per
1000
licenses
and
the
percentage
of
licensed
drivers
under
the
age
of
21
in
a
sample
of 42
cities.
Data
collected
over
a
one-
year
period
follow.
These
data
are
contained
in
the
file
named
Safety.xIxs
uploaded
along
with
this
lab
assignment.
Managerial
Report
1.
Use
Microsoft
Excel
to
construct
a
scatter
plot
for
number
of
fatal
accidents
and
percentage
of
dnivers
under
the
age
of
21.
Paste
the
output
below,
please
do
not
upload
a
separate
Excel
file.
Make
sure
your
graph
1s
clearly
labeled
within
Excel
(x
and
y
axis,
and
a
title).
Develop
numerical
and
graphical
summaries
of
the
data
as
well
using
the
descriptive
statistics
tool.
ro
.
Use
Excel’s
regression
tool
to
conduct
regression
analysis
to
investigate
the
relationship
between
the
number
of
fatal
accidents
and
the
percentage
of
dnivers
under
the
age
of
21.
Use
the
computer
output
to
answer
the
following
questions:
a)
What
i1s
your
independent
vanable,
X,
in
this
problem?
b)
What
is
your
dependent
vanable,
Y,
in
this
problem?
¢)
What
is
the
Line
of
regression
for
this
problem?
d)
What
is
the
slope?
Explain
what
it
means
in
the
context
of
this
problem.
¢)
What
is
the
y
intercept?
Explain
what
it
means
in
the
context
of
this
problem.
