> fe @\puser Ba==F8Y@"1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1
Arial1
Arial"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)0.000000000
0.0000000.00000000000+_(* #,##0_);_(* \(#,##0\);_(* "-"??_);_(@_)0.000000.0000
0.0000.0 0.000E+00
0.0000E+00 + ) , * " " " " p p "x@ "x@ "x@ "x "x "x@ " # &x@ x x ! | `'Sheet18Sheet2 HSheet38ZSheet4'mSheet5vSheet6ۗSheet7, ;1
;' ;( ;( ; ;8 ;&
`iZR3 @@
Mean:Automobile Accident Investigation by Sloppy Research, Inc.AlcoholPropertyPeople Parent'sGenderAgeLevelDamageKilledConvictionsMFA Automobile Accident Investigation by Sloppy Research, Inc.hypothesizedpopulation meanalphasample meansample standard deviationcountstandard error of meanz from data critical value for zF. LevelM. Level+t-Test: Two-Sample Assuming Equal VariancesVarianceObservationsPooled VarianceHypothesized Mean Differencedft StatP(T<=t) one-tailt Critical one-tailP(T<=t) two-tailt Critical two-tailIcontent of males was higher than females for people who were in accidentsJwhere drivers were under 26 years old and there was alcohol and property Gdamage involved. Test this hypothesis at the .05 level of significance.)Analysis: t from the data of -1.8378 is males was higher than females.%and the null hypothesis is rejected. $less than 0.05 indicating rejection of the null hypothesis<0.196 for the .05 level of significance for this two-tail 6test and we reject the null hypothesis. Average blood :of significance whether the number of incidents went down.Before After#t-Test: Paired Two Sample for MeansPearson CorrelationSThe state legislature hired Sloppy Research, Inc. to studied the affects of alcohol/5Analysis: The data has a t-value of 2.66 which is not?beyond 3.14 and we accept (fail to reject) the null hypothesis.1Note the p-value of 0.019 is not below 0.01 which@also indicate accepting (failing to reject) the null hypothesis.
Age of Person15-1718-2021-25Anova: Single FactorSUMMARYGroupsCountSumAverageANOVASource of VariationSSMSP-valueF critBetween Groups
Within GroupsTotal Analysis:8Analysis: F from the data of 11.1 is beyond the critical5as Excel requires the block samples be of equal size.Gdamage involved. Treatment ages of 15-17, 18-20, and 21-25 were chosen.Mcontent differs for people of different ages for people who were in accidents7value of F of 3.35 and the null hypothesis is rejected.FAverage blood alcohol contents is not the same for these 3 treatments.HSloppy Research, Inc. is interested in whether the average blood alcohol<=1.2>1.2>0Observed Outcomes'Blood Alcohol Content and People Killed
B. Alcohol# KilledTotalsp=0below the alpha of .01 and we easily reject the 3null hypothesis. Blood alcohol content affects the !at the .01 level of significance.SUMMARY OUTPUTRegression Statistics
Multiple RR SquareAdjusted R SquareStandard Error
RegressionResidual InterceptSignificance FCoefficients Lower 95% Upper 95%OIf there is a relationship, they are interested in the variability in property Gpredict the expected property damage for an accident in which the bloodGrelationship between average blood alcohol content and property damage NThe coefficient of correlation of 0.926 indicates a high positive correlation 'alcohol and property damage involved. alcohol content was 1.2.3Intercept coefficient of 111856 is the y-intercept.7E) Standard error of 11372 indicates the average error *level coefficient of 101935 is the slope.1G) Regression equation is Y.x = -111856 +101935x.
<The expected property damage from an accident in which the blood alcohol content was 1.2 isLThe coefficient of determination of 0.857 indicate that 85.7 percent of the Xvariability in property damage is accounted for by variability in blood alcohol content.1the accounted for variability from 85.7% to 86.3%@Analysis: Adding the variable age to the analysis only increase WAnswer each question and hand in the disk with your named placed in the space provided.!Name ____________________________B Statistics Test on Correlation and Regression+alcohol count these years was not the same.%The average blood alcohol content of )beyond the critical value for t of 1.7011Scounseling on the number of traffic incidents happening to chronic alcohol abusers.UThe number of traffic incidents occurring during the 5 years prior to the counseling >Counseling did not lowered the number of automotive incidents.FSloppy Research, Inc. is interested in the strength in the arithmetic Ddamaged explained by blood alcohol content. They would also like to 2between blood alcohol content and property damage.1Analysis: The p-value of 0.00049 is substantiallyKcontent affects the number of people killed in accidents where drivers wereHunder 26 years old and there was alcohol and property damage involved. Jof significance whether blood alcohol content and number of people killed are independent.dLast year Sloppy Research, Inc. reported that the average blood alcohol content was 1.19 for drivers RInstructions: This test consists of 7 questions each located on a separate sheets.ewho were in accidents where drivers were under 26 years old and there was alcohol and property damage9z from the data of 0.1.97 is beyond the critical value ofkinvolved. Test at the .05 level of significance whether a sample of 30 collected this year indicates there Khas been a change in average blood alcohol content for this type of driver.Iwhere drivers were under 26 years old and there was alcohol and property !Note that the p-value of 0.038 is% Traffic Incidents and CounselingNwas compared to the number of incidents after the counseling. Test at the .01 5populations with equal average blood alcohol content.HTest at the .05 level of significance whether these treatment come from 9Note: We will not do a two factor analysis with this dataMTo aid in this analysis, they made the following chart. Test at the .01 level,in predicting property damage is 11,372.15.Afor accidents where drivers were under 26 years old and there wasEof the variability in property damage can be explained by adding age WF) .05 level test: Anova p-value of 2.3171E-13 is below the .05 level of significance >so we reject the null hypothesis that the slope could be zero.NNote: It should be noted that curvilinear analysis would yield better results.5number killed and these variables are not independentC5) Sloppy Research, Inc. is interested in determining how much moreQto the correlation study of the last question. Was the additional informational worth the effort? Explain.Not really worth the effort!Q Statistics Test on Hypothesis Testing Test Answers6/
(!K |[ (
l
W2
EPp!#=%I
@2)T268
dMbP?_*+%&?'Q?((\?)p=
ף?MCanon Bubble-Jet BJC-210@nyyhh@MSUDCanon Bubble-Jet BJC-210d"dhh??U}}}$
}}m}I}$}m}
m
2
h
~
++
,,------
T
&
(
$5@[@@@
$6@^@@@
$9@[@@@
7}? Fڱa?
$1@[@L@
fROj[? "(?
$3@?@@@
&@3@
$5@[@@@
iV?
$5@^@@
~
$5@^@L@
~
<@
$8@^@@?
!⏿g
$5@[@p@
"kT$䣣?
$6@[@@@
#\7?
$kT$䣳?
%T}$c@
$.@[@@?:
&Ft6\hhZ`\\```*~ !"#$%&'()*+,-./01
$ 5@[@p@
)
!$!0@a@X@?
!
"$"6@^@p@
"+
#$#3@@e@@?
#
$$$4@n@OA@?
$*
%$%5@@`@@
&$&5@a@j@
&
'$'5@a@@?
',
($(6@[@@@
(-
)$)7@[@@
*$*8@[@@?
+$+2@d@@@?
,$,1@?L@?@
-$-5@^@@@
.$..@^@|@?
/$/4@^@@
0$05@a@L@?
1$15@@`@@(TDDDDD6DDD66666666>@A
z:
7
@':EG
dMbP?_*+%&?'?MCanon Bubble-Jet BJC-210@nyyhh@MSUDCanon Bubble-Jet BJC-210d"bhh??U}$}}$}I}I}$}m'
~
]@
$ .@[@@?
$
5@[@@@
$5@[@p@
~
@
$0@a@X@?
$
6@^@p@
$6@^@@@
# b/?
% &B
$3@@e@@?
$4@n@OA@@
$9@[@@@
# v M3?
% &B
$5@@`@@
$5@a@j@
# >@
% &B
$5@a@@?
$6@[@@@
$ 7n? D D A
$7@[@@
$8@[@@??
( ^[?D D D
$1@[@L@
$3@?@@@
" &\? 333333?A(
$5@[@@@
$2@d@@@?
M
$5@^@@
$1@?L@?@
.
$5@^@L@
/
$5@^@@@
BS
XTp66R@@k@Dk@k@l6p6j6DDDD !"#$%&
$ .@^@|@?
!
$!8@^@@?
"$"4@^@@?
#
$#5@[@p@
$$$5@a@L@?
%$%5@@`@@
&
$&6@[@@@x666666>@
7
@0JUY
dMbP?_*+%&?'?MCanon Bubble-Jet BJC-210@nyyhh@MSUDCanon Bubble-Jet BJC-210d"dhh??U}}m}}m}
}}}} }
I}m0
T
$.@[@@?
$5@[@@@
$
5@[@p@
$9@[@@@
Y
$6@[@@@
X
$7@[@@
[~
W
\
$8@[@@??
Z
$1@[@L@
U 2@?
"3@D D
$5@[@@@
V @@
"&@ D D
$5@[@p@
\" 6@
D D "
@D
D
">@ D D
$6@[@@@
$6@^@p@
Y
$6@^@@@
X
$5@^@@
[~
W
$5@^@L@
Z
$5@^@@@
U' $+@
DD D'
$DDDDDD@ DD
D
$.@^@|@?
V' $"""""" @
DD D'
$wwwwww@DD
D
$8@^@@?
$4@^@@?
%]+Xi4.@?e
e
A2
$5@@`@@
$5@@`@@
DlFT666TDnD6TD`D6s6 !"#$%&'(+,-./
$ 0@a@X@?
^
!$!5@a@j@
!_
"$"5@a@@?
"
#$#5@a@L@?
#`
$
$$3@?@@@
%$%1@?L@?@
&$&2@d@@@?
'$'3@@e@@?
($(4@n@OA@@+,-./
/
DDDD66666>@7
@)6\il
dMbP?_*+%&\(\?'?)Q?MCanon Bubble-Jet BJC-210@nyyhh@MSUDCanon Bubble-Jet BJC-210d"\hh??U}}I}}}I}}$}m} }
}}}
}m
Age)
T
Q
'
P
$.@[@@?
:
$.@^@|@?
;
<
=
>
$
0@a@X@?
[@d@[@
$1@[@L@^@@e@[@
?
$1@?L@?@a@?@`@
@
A
B
C
$2@d@@@?[@n@a@
;@@_@`7A`?
$3@@e@@??^@a@
<@@@e@K7?
$3@?@@@~
[@
!=4@@]@6Vؼ?
$4@n@OA@@~
^@
$4@^@@?~
^@
$5@[@@@~
^@
"D""""""
$5@[@p@~
[@
#E
#F
#
#G
#
#H
#I
$5@@`@@~
a@
J@HS*>?~
@@HS*>?>hVhU3&@N3?hB
@
$5@a@j@~
@`@
K@Zd?~
;@{D̥?
$5@a@@?~
^@
$5@[@@@~
^@
L0@~
=@
$5@^@@~
[@
$5@^@L@~
[@
N
$5@^@@@~
[@
R
$5@[@p@~
[@
S
$5@a@L@?~
^@DlFTNnR`DDh\DRRR !"#$%&'(
$ 5@@`@@~
[@
!$!6@^@p@
!O
"
$"6@^@@@
#$#6@[@@@
$
$$6@[@@@
%$%7@[@@
&$&8@[@@??
'
$'8@^@@?
(
$(9@[@@@RD666666>@7
@omv
dMbP?_*+%&?'zG?MCanon Bubble-Jet BJC-210@nyyhh@MSUDCanon Bubble-Jet BJC-210d"dhh??U}$
} }
I Level
5
0
3
1
2
@@
1
2
@@
n۶m۶@
n۶m۶@
@@
@<@yy?
@@
@@
@@
4
XL<2?
@?
~
@@
~
@
!}n!J@
"a.?
#/$ @
$a.?
%Ϩ
@
6
7
8
9
<""""B,LXRDJFF44444
>@7
@9xz
dMbP?_*+%&Q?'RQ?(333333?)Q?MCanon Bubble-Jet BJC-210@nyyhh@MSUDCanon Bubble-Jet BJC-210d"ahh??U}$} }}m
}
}m}}} I}
m
}
}
Level9
p
r
n
o
s
$.@[@@?
$5@[@@@
$5@[@p@
$9@[@@@
$6@[@@@
$7@[@@
$8@[@@??
a
$1@[@L@
$5@[@@@
&b&$
$5@[@p@
cppF?$
$6@[@@@
d$y|o?$
$6@^@p@
eE?$
$6@^@@@
fտa6@$
$5@^@@
~
>@$
$5@^@L@$<"FT666666NDv~~~~z ! "#$ % &'( )*+,-./0
1
2
3
4
5
6
7
8
$ 5@^@@@
D $ ''
!$!.@^@|@?!
!
!F
! G
!
!j!$!((
"
$"8@^@@?
"'g~
"'?"'-8EB" '-8EB"
'Ȏ̂ e@"'NP="
#$#4@^@@?
#'h~
#'<@#'>A# '^
l՞A#
''
$$$5@@`@@
$(L~
$(=@$(ɐB$ (((
%$%5@@`@@%
&$&0@a@X@?&
&k
&f
& !
&
H
&l
&m
'$'5@a@j@
''i''Y_O''g䑲(@' ' /p%'
'9RGrg=''ѷ
0<''D9O%
($(5@a@@?
((((\+@((lEƟ@( (j%)@(
*ONP=((]@(([@
)$)5@a@L@?
*
$*3@?@@@
*M
+$+1@?L@?@
+q
,$,2@d@@@?
,
-$-3@@e@@?
-z
.$.4@n@OA@@
.{
/u
0
1
2
3t
4v
5w
6)x
7y+7 xq.Ap@D'D(333333?
86U vN6DDDDD=(
v
<NMM?_
]`H @"H??3`
`
`
`
@+3d23 M
NM43Q:
DamageQ;.Q;.Q3_4E4D
$% M 3O&
Q4$% M 3O&Q4FA
3OhN
3*#M43*#M4% xM3O&Q
.Blood Alcohol Content'4% qrMZ3O|&Q
"Property Damage'4523
O43d"
3_M
NM MM<444% Ph;M3O2&
Q
V)Property Damage and Blood Alcohol Content'44e
e
e
>@7
@'i
dMbP?_*+%&p=
ף?'?(ffffff?)ףp=
?MCanon Bubble-Jet BJC-210@nyyhh@MSUDCanon Bubble-Jet BJC-210d"dhh??U}}m}}}}m}I
} '*
** ** **** * **** ***
$ .@[@@?
$
5@[@@@
a
$5@[@p@
$9@[@@@
&b&
$
6@[@@@
c
?
$7@[@@
du?
$8@[@@??
eDbBOJ?
$1@[@L@
f\+@
$5@[@@@
~
>@
$5@[@p@
$6@[@@@
D
$6@^@p@
F
G
j
$6@^@@@
g~
@ ]v0gB
]v0gBH?AU@vK=
$5@^@@
h~
;@ MlA
=A
$5@^@L@
L~
=@ ɐB
$5@^@@@
$.@^@|@?
k
f
!
H
l
m>)
$8@^@@?
i*3 ZY7N@
-U8+-@?)=}&
?P5D
$4@^@@?
;¼ >@S@
z;=.G(Y?43
U@
$5@@`@@
1`@ -$@
02v(@Av=p S@
&&n@
$5@@`@@
$0@a@X@?
$5@a@j@BvXFT6D6NVVVVR6Dt666 !"#$%&
$ 5@a@@?
}
!$!5@a@L@?
!|
"
$"3@?@@@
"
#$#1@?L@?@
$$$2@d@@@?
%$%3@@e@@?
&$&4@n@OA@@0xDDD666> @"""7
Oh+'0HPl|
Walter Antoniottieuserr AMicrosoft Excel@/hhC@ո~)@RF՜.+,0 PXdlt|
7 Sheet1Sheet2Sheet3Sheet4Sheet5Sheet6Sheet7Worksheets
!"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTVWXYZ[\^_`abcdRoot Entry FWorkbookSummaryInformation(UDocumentSummaryInformation8]