ࡱ > }
! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ? @ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _ ` a b c d e f g h i j k l m n o p q r s t u v w x y z { | R F a-xm*~ W o r k b o o k S u m m a r y I n f o r m a t i o n ( D o c u m e n t S u m m a r y I n f o r m a t i o n 8 x P \ p Sophia DeMartini B a = = `T88 X@ " 1 Calibri1 Verdana1 Verdana1 Verdana1 Calibri1 Calibri1 Verdana1 Calibri1 Calibri1 @ Calibri "$"#,##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\);_(* "-"??_);_(@_) 6 1 _(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_) 0 + _(* #,##0_);_(* \(#,##0\);_(* "-"??_);_(@_) : 5 _(* #,##0.0000_);_(* \(#,##0.0000\);_(* "-"??_);_(@_) 0.0 0.0000% 0.00000 0.00000000% 8 3 _(* #,##0.000_);_(* \(#,##0.000\);_(* "-"??_);_(@_) < 7 _(* #,##0.00000_);_(* \(#,##0.00000\);_(* "-"??_);_(@_) General #,##0.0 0.0%
#,##0.00 ) , * A A , @ , @ A A , @ 8 d q: F c -2 NW g F SW c -2 NW g F SW ̙ ̙ 3f 3 f ff 3f 3f 3 33 3 3f 33 333 \ ` y Results by question c Results by score
$ Binomial Distribution SE Chi-squared test h How Many Quarters Ϯ Standard Normal
solver_adj:
solver_adj: "
solver_cvg -C 6? "
solver_cvg -C 6?
solver_drv
solver_drv
solver_est
solver_est
solver_itr d
solver_itr d
solver_lin
solver_lin
solver_neg
solver_neg
solver_num
solver_num
solver_nwt
solver_nwt
solver_opt< 6
solver_opt< 6? "
solver_pre ư> "
solver_pre ư>
solver_scl
solver_scl
solver_sho
solver_sho
solver_tim d
solver_tim d "
solver_tol ? "
solver_tol ?
solver_typ
solver_typ
solver_val d
solver_val d g ` (
3 A @ @
a+ Right Wrong Number of questions Probability of correct Probability of this outcome Question # Right # Wrong % right Chi sq term Actual Count <-- p-value <-- Chi squared statistic
Std. Devs. Count Prob Cumulative Prob bottom top mean stddev Expected count
<-- (O-E)^2/E N Average number correct ,{ > L E?x? ! M s qp6 xsCst6tp6 Д0 &>,}b`! +xtto &t tc a %@ s v _ _ vvtÁv v ttw(t mLwt vwHt wt d , th{ tw Luwt mLwLu v wt wLu t, th{ Luw C,t ,wHv@ v vuO,Lu u u v Xuvxy` Xu.z,J pu vuvvvvxy` v vu%#S uuHvy` ` , Twx a Twx
a * TwXu mLXTw t Xv XTw Hv TwX H] TwDXv xy` xvH] Tw ` ` ` v M} Tw vve} v Tw , ȱ[ d*
P
e
d MbP?_ * + % & ffffff?' ffffff?( ?) ? " 8333333?333333?uU
} } } }
_ ? ?
~
$@
? ! $@ D D ( D D D @ $@ D L L L L @ $@ @ $@ @ $@ @ $@ @ $@
@
$@
"@ $@ $@ $@ ) 8 g T T T T T T T P H 0 (
> @ @ 7
P O B#
d MbP?_ * + % & ffffff?' ffffff?( ?) ? " 333333?333333? U
} } } } }
} * } U U ?
-
~
$@
~
V@ $@ D ! D D ~
@ "@ D ?
D L ~
@ @ L @ ~
@ @ @ ~
? @ @ ~
@ @ ~
@ @ ~
@ @ ~
@ @
~
?
"@ ~
$@ ) ~
# $@
% : # !@ $ e e B % !%
k F n i c L L L L L L L L ' P H 0 ( ) ? ) ? @
> @ @
P $ N/
d MbP?_ * + % & ffffff?' ffffff?( ?) ? " 333333?333333? U
} } } } }
} } } U } * }
U U ?
-
~
$@
~
V@ $@ D ! D D @ Z * /C`P? D D D A S8 @( L D "@ D ?
D L @ Z }N?
L D D A m$"_@( @ L @ @ Z ~N? m$"_?( @ @ ? Z cb? }]?( @ @ Z 0ۆ? g&?( @ @ Z SH3EaX? y?( @ @ Z vW,)"? Tm8V?( @ @ Z ayX> ?(
@ @
Z {L v> >(
?
"@
Z
e+eSC> !
v(x> D
D
$@ Z |= ! & .>
D D # $@
% # ?
% # #@
% " $ ,b u
0 ( .
t
s : N ?
C h a r t 1 %! ] @ x
a P P P PZjk & pfffff?' pfffff?(
?)
? " @ XX433333?433333? 3 P H @ 0 ( S
3 d 2 3 R R
R R T T U U
&Gz S S 4 3 Q
ActualQ ; Q ; Q 3 _ ff 6 R R R R T T ff U U
M M c c d T T c c U U Da
g" # S S 4 E S S 4 3 Q
ExpectedQ ; Q ; Q 3 _ -2 R R R R T T -2 U U
M M -2 -2 d T T -2 -2 U U
g" # S S 4 E S S 4 D $ % 0 3 O & Q R R S S 4 $ % 3 O & Q 4 F A M
` 3 O o C 3 b R R R R V
V d & ! T T U U ) k
g. c ( gQ qR S S 4 3 * N & ! R R T T U U ! T T U U ) ) -$͒ S S 4 % M : 3 O 8 Y & Q
# of correct answers2 3 R R R R T T U U
N M ctV} S S 4 ' < 9 t x`
xxxxxxxxxxxxxxxxxxxx S S 4 % Q 0 M :Z 3 O 4 & Q
# of people2 3 R R R R T T U U
N M eV} S S 4 ' < crHr
xxxxxxxxxxx S S 4 5 2 3 R R T T U U
M rHV} S S 4 3 "
R R T T U U
g J _ 3 O k % 0 3 O & Q 4 2 3 R R R R T T U U
N M rHV} S S 4 < -$͒ S S 4 $ % 3 O Q 2 3 R R R R T T U U
N M S S 4 ' S S 4 S S 4 S S 4 D oC -$͒
g[ T S S
4 e e e g a
> @ x x @
P ?F R
d MbP?_ * + % & ffffff?' ffffff?( ?) ? " 333333?333333?n=U
} } } } }
} } } U } * }
/
/
?
-
~
$@
~
V@ $@ D ! D D @ Z * /C`P? D D D A S8 @( L D 1n*e?( L L L
"@ D ?
D L @ Z }N?
L D D A m$"_@( xp?( @ L @ @ Z ~N? m$"_?( 4`?( @ @ ? Z cb? }]?(
m=?( @ @ Z 0ۆ? g&?( g&?( @ @( Z SH3EaX? y?( y?( @ @ Z vW,)"? Tm8V?( Tm8V?( @ @
Z ayX> ?( ?( @ @
Z {L v> >( >(
?(
"@
Z
e+eSC>
!
v(x>
D
D
v(x>(
$@ Z |= ! & .> D D & .>( # $@
% # ?
% # #@
% # 2ϕ?
%
/ +? D % B A
+ +? e e A2 " p 8 A P ( @
t
s : N ?
C h a r t 1 %! ] @ 8` P P P PZjk & pfffff?' pfffff?(
?)
? " @ XX433333?433333? 3 P H ` 0 ( n - c s zSmM
3 d 2 3 R R
R R T T U U
&Gz S S 4 3 Q
ActualQ ; Q ; Q 3 _ ff 6 R R R R T T ff U U
M M c c d T T c c U U Da
" # S S 4 E S S 4 3 Q
ExpectedQ ; Q ; Q 3 _ -2 R R R R T T -2 U U
M M -2 -2 d T T -2 -2 U U
" # S S 4 E S S 4 D $ % 0 3 O & Q R R S S 4 $ % 3 O & Q 4 F A M
` 3 O o C 3 b R R R R V
V d & ! T T U U ) k
. U ( Q R `@ S S 4 3 * N & ! R R T T U U ! T T U U ) ) -$͒ S S 4 % M : 3 O 8 Y & Q
# of correct answers2 3 R R R R T T U U
N M ctV} S S 4 ' < 9 t x`
xxxxxxxxxxxxxxxxxxxx S S 4 % Q 0 M :Z 3 O 4 & Q
# of people2 3 R R R R T T U U
N M eV} S S 4 ' < crHr
xxxxxxxxxxx ` S S 4 5 2 3 R R T T U U
M rHV} S S 4 3 "
R R T T U U
g J _ 3 O k % 0 3 O & Q 4 2 3 R R R R T T U U
N M rHV} S S 4 < -$͒ S S 4 $ % 3 O Q 2 3 R R R R T T U U
N M S S 4 ' S S 4 S S 4 S S 4 D oC -$͒
[ U YlS S
4 e e e
> @ x x @
P f i 3{ )
d MbP?_ * + % & ffffff?' ffffff?( ?) ? " 333333?333333?n=U
} } * } } } } f U U ?
-
~
@_@~
&W_ [ D L D Ze> L D D A% * &8<> D D D A%
~
@o@ w6?
fΒ:q> ) \<+'> A @ L D D A%~
~ Fs@ &{> 3>
& pg@ D D ~
`} J!@ ~0>( ҵ>
/ ! F}B@ d D D ?A( ffffff Ї l)@ > 1;Av> ~
00@ e :> *Ӎr> xO4@ ./>( %r> ~
z 1 8@ c [u> 5౫> ~
@z I}M;@ /D> .>
ffffff
p%?@
$$Ǵ>
5>
~
aA@ kꥋ> Jך ? ~
`x 11C@( x]
>( wa7 ? ~
w
,'W E@
}{ >
+1? ~
w G}OztG@
$q> ٷQQB ? ~
v xhZI@ !z> ; a$? m5AK@ Q̋%> |}.? J33333 'M@ t+ ? Y-6? }fffff
:
O@ qٌ? jֲႮ?? q
'zP@ #?&r? O|!F? 1UmQ@ 4? G شO? Ĝ`R@ NM ?( V? J33333 k&WdSS@ =ꆈ$?( ɑ^? }fffff 6+FT@ zM+?( ;&d? G}:U@ K]:1? i4cfl? gW?-V@ CIbm7? B!s? ! gn W@ 8 d;>? " WNoy? J33333
x6JX@ f_.PC?( ,ɀ? 3 }fffff aY@ շmH? $
?( \Y@ YN? "iy? % )Z@ 6R? & 0Q K? \hX[@ @GW?( ɂK?( + D ! l8 k k o k k o k k k k k o o o o o o o o o o o o o o o ! U " U # $ % & ' ? ( ) * - + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ? fffff 0\@ ïJ\?( ( R
g? ! ! ڨ]@( ! ! @ D L D ! Lema? ! ! ! @ L D D A% ! sue? 1 " `33333 " W;^@ ! " ۶Fd? * ! " }x(HѦ? " # Ǚ # Ά_@( b ! # M g? # ! # kc? 7 $ - $ 1'!P`@ ! $ =/Zk?( , ! $ GF? $ % fffff % `@ ! ! % z2#p? % ! % Ww? - & & OCa@ " ! & [hFyr? . ! & d:Ǹ? & ' `33333 ' Ra@ ! ' uZt?( ' ! ' ]4u? C ( Ǚ ( &&W~6b@ $ ! ( n
{w? 0 ! ( lxg]? ( ) - ) P b@ % ! ) qpz? ) ! ) |N? A * ' * z6})c@ & ! * |?( 2 ! * cUn=H? * + + Dc@ ' ! + ujX:? + ! + 2 ? ; , gffff , F}E d@ ( ! , _ pe@( # ! / =gك? / ! /
? ? 0 43333ӿ 0 hg9f@( , ! 0 of?( 8 ! 0 w#t?( 0 1 jɿ 1 l8|f@ - ! 1 h8?( 1 ! 1 ! 6 5 ,? 6 7 1? 7 &]Vi@ / ! 7 =gك? 7 ! 7 )7? G 8 ? 8 i@( 4 ! 8 q
?( @ ! 8 72u ? 8 9 23333? 9 0VIj@ 5 ! 9 \?( 9 ! 9 Q9? I : effff? :
#j@ 6 ! : @? > ٨Il@ : ! > I
{w? F ! > *!? > ? 23333? ? ar#m@ 7 ! ? uZt?( ? ! ? \4iYQ? O D lo o o o o o o o o o o o o o o o o o o o o o o o o o o o o o @ A U B U C D E F G ? H I J - K L M N O P Q R S T U V W X Y Z [ \ ] ^ _ @ s? @ ;m@ < ! @ %iFyr? H ! @ ? @ A fffff? A /ruGn@ = A A ` D L D A 9 3#p? A A A ` L D D A% A qj? Q B ? B Yޏn@ > A B >/Zk? J A B 6$?( B B B e $ L D D A% C @? C ?( T A L 6Pc!? L B M @ M ;q@ I A M Ibm7? M A M u? U B N V@ N {!r@ J A N N]:1?( V A N ˜:?( N B O #fffff@ O 6ruG^r@ G A O ~M+?( O A O fـ? _ B P 23333@ P J6&r@ L A P =ꆈ$? X A P ? P B Q @ Q _r@ M A Q NM ? Q A Q $=? B R @ R ts@( N A R 7? Z A R ? R B S V @ S ^ A V 6$? V B W @ W ܒ+Dt@ O A W #z> W A W ^9S?( c B X V
@ X Vpt@ T A X r'q> ` A X Aru ? X B Y #fffff@ Y g Y A Y pFh?( a B Z 23333@ Z t@ V A Z ;`
> b A Z x"?( Z B [ @ [ 07u@ S A [ oꥋ>( [ A [ Ԫ? B \ Efffff@ \ Fg}tu@ X A \ +$$Ǵ> C% A \ \ޕ? \ B ] @ ] Z+/ku@ Y A ] L/D> ] A ] 8? e B ^ 33333@ ^ ol6u@ Z A ^ ]u> # A ^ NT,? ^ B _ x@ _ Q+v@ W A _ C1/> _ A _ 4)? B D lo o o o o o o o o o o o o o o o o o o o o o o o o o o o o ` a U b U c d e ` @ ` w6Egv@ \ A ` ::> ' A ` \?( ` B a Efffff@ ( a ;v@ ] D Da D * a > a Da D D A% a o? B b @ ( b ev@ ^ D Db D * b X0>( / Db D D A% b bE?( b B c 33333@ ( c Z1 w@ _ D Dc D * c &{> c Dc D D A% c V? B d m@ ( d Zw@ d D Dd D * d jΒ:q> ` Dd D D A% d L? d B e @ ( e Kȗw@ a D De D * e d_e> e De D D A% e of?
B d o p ( A
t
s : N ?
C h a r t 2 o ] @ tW P P P PZjk & pfffff?' pfffff?(
?)
? " @ XX433333?433333? 3 P H 0 (
.3 d 2 3 R R
R R T T U U
&Gz S S 4 e e 3 Q :
ProbQ ; e Q ; e Q 3 _ ff 6 R R R R T T ff U U
M M ] c c d T T c c U U Da
" # % _S S 4 E S S 4 D $ % 0 ^ 3 O & Q R R S S 4 $ % ^ 3 O & Q 4 F A 3 O ( _ F 3 * &
! R R R R T T U U ) S S 4 3 * N &
! R R T T U U ) Za
S S 4 5 2 3 R R T T U U
M aV} S S 4 3 d "
R R T T U U $ % `b 3 O Q 2 3 R R R R T T U U
N M S S 4 ' S S 4 3 _ R R T T U U
M M ] x T T U U S S 4 S S 4 S S 4 D ( _ F % p P 3 O Q ' 4 -$͒
[ S S
4 e e e e
> @ x x @
P f ǯ
d MbP?_ * + % & ffffff?' ffffff?( ?) ? " 333333?333333?n=U
} } * } ! } U
} } f U U ?
-
!
~
! c D L D ?di> L D D A% * &8<> D D D A% ! 6٠u> \<+'> A @ L D D A%~
~ ! 333333 Yi> 3>(
& D D ~
`} ! d w6> ҵ>
~
? ffffff ! ffffff ^TD> 1;Av>
~
! e =S> *Ӎr> ! Wq'>( %r> ~
z ! 333333 b ',G4? 5౫>( ~
@z ! 6 c4? .>
ffffff
! ffffff
*Z?f?
5>
~
! ☊!?( Jך ? ~
`x ! 333333 ?so *? wa7 ? ~
w
! ffffff
"3?
+1? ~
w !
>k^;?( ٷQQB ? ~
v ! ]c
D? ; a$? ! GїL? |}.? J33333 ! J33333
AM0T? Y-6? }fffff
! }fffff
( P8\?( jֲႮ?? ! ? fffff ! fffff w2̰? ( R
g? ! ! ! ! ! @ D L D ! c6? ! ! ! @ L D D A% ! sue? ) " `33333 " ! `33333 ! " |}? * ! " }x(HѦ? " # Ǚ # ! Ǚ ! # ƭdNe? # ! # kc? + $ - $ ! - ! $ ? V? , ! $ GF? $ % fffff % ! fffff ! ! % E*? % ! % Ww? - & & ! " ! & 4g?( . ! & d:Ǹ? & ' `33333 ' ! `33333 # ! ' ? ' ! ' ]4u? / ( Ǚ ( ! Ǚ $ ! ( ۃ? 0 ! ( oxg]? ( ) - ) ! - % ! ) 3? ) ! ) |N? 1 * ' * ! ' & ! * אm? 2 ! * gUn=H? * + + ! ( ' ! + nBpN?( + ! + 2 ?( 3 , gffff , ! gffff ( ! , ? 4 ! , z4:? , - 33333 - ! 33333 ) ! - r$HS? - ! - 8\? 5 . . ! * ! . m =? 6 ! . ;? . / ٿ / ! ٿ + ! / Ȍ,켑? / ! /
? 7 0 43333ӿ 0 ! 43333ӿ , ! 0 ph? 8 ! 0 w#t? 0 1 jɿ 1 ! jɿ - ! 1 L}? 1 ! 1 :ch? 9 2 ; 2 ! ; . ! 2 ϑ^g?( : ! 2 .[us? 2 3 3 ! / ! 3 Q63E? 3 ! 3 m? ; 4 ? 4 ! ? 0 ! 4 ^g? < ! 4 *hREF? 4 5 ɖ? 5 ! ɖ? 1 ! 5 }?( 5 ! 5 }K? = 6 13333? 6 ! 13333? 2 ! 6 黟ph? > ! 6 4 ,? 6 7 1? 7 ! 1? 3 ! 7 2,켑? 7 ! 7 )7?( ? 8 ? 8 ! ? 4 ! 8 =? @ ! 8 82u ? 8 9 23333? 9 ! 23333? 5 ! 9 %HS? 9 ! 9 Q9?( A : effff? : ! effff? 6 ! : F? B ! : p2\qA? : ; 嘙? ; ! 嘙? 7 ! ; \oBpN? ; ! ; M{8?( C < ? < ! ?( 8 ! < אm? D ! < _j- ? < = L? = ! L? 9 ! = 3? = ! = R K? E > @? > ! @?( : ! > ۃ? F ! > )!? > ? 23333? ? ! 23333? ; ! ? ? ? ! ? \4iYQ?( G D lo o o o o o o o o o o o o o o o o o o o o o o o o o o o o o @ A U B U C D E F G ? H I J - K L M N O P Q R S T U V W X Y Z [ \ ] ^ _ @ s? @ ! s? < ! @ 4g? H ! @ ?( @ A fffff? A ! fffff? = A A ` D L D A E*? A A A ` L D D A% A qj? I B ? B ! ? > A B V? J A B 6$? B B B e $ L D D A% C @? C ! @? ? A C EdNe?( C A C ;I?? K B D 23333? D ! 23333? @ A D ~? L A D _x]s? D B E s? E ! s? A A E 6? E A E K4Ϩ?( M B F fffff? F ! fffff? B A F 2̰? N A F W? F B G ? G ! ? C A G
<6? G A G 3郡E? O B H @ H ! @ D A H ė? P A H ov=m? H B I V@ I ! V@ E A I R:й)? I A I {t[?( Q B J #fffff@ J ! #fffff@ F A J t^R? R A J ³E%? J B K 23333@ K ! 23333@ G A K
|?( K A K kyiؼ? S B L @ L ! @ H A L SU? T A L 6Pc!? L B M @ M ! @ I A M L!Ecы? M A M u?( U B N V@ N ! V@ J A N 1W? V A N ˜:? N B O #fffff@ O ! #fffff@ K A O at5? O A O fـ?( W B P 23333@ P ! 23333@ L A P $ax? X A P ? P B Q @ Q ! @ M A Q Wx?!'r? Q A Q $=? Y B R @ R ! @ N A R Z( _ A _ 4)?( B D lo o o o o o o o o o o o o o o o o o o o o o o o o o o o o ` a U b U c d e ` @ ` ! @( \ A ` B=S> A ` \?( ` B a Efffff@ ( a ! Efffff@( ] D Da D * a
^TD> a Da D D A% a o? B b @ ( b ! @ ^ D Db D * b Ew6> Db D D A% b bE? b B c 33333@ ( c ! 33333@ _ D Dc D * c h Yi> c Dc D D A% c V? B d m@ ( d ! m@ ` D Dd D * d ٠u>( Dd D D A% d L? d B e @ ( e ! @ a D De D * e di>( e De D D A% e of?
B d o $ (
$ t
$
s : N ?
C h a r t 2
a "9 7 ] $@ d P P P PZjk & pfffff?' pfffff?(
?)
? " @ XX433333?433333? 3 P H ( 0 ( 0
( 3 d 2 3 R R
R R T T U U
e$
S S 4 e e 3 Q :
ProbQ ; e Q ; e Q 3 _ ff 6 R R R R T T ff U U
M M ] c c d T T c c U U
s /" # S S 4 E S S 4 D $ % 0 P 3 O & Q R R S S 4 $ % P 3 O & Q 4 F A ' a L 3 O ' b L 3 * @ & ! R R R R T T U U ) S S 4 3 * N # ! 4 5 2 3 R R T T U U
M V} S S 4 3 d "
R R T T U U $ % `b 3 O Q 2 3 R R R R T T U U
N M S S 4 ' S S 4 3 _ R R T T U U
M M ] x T T U U S S 4 S S 4 S S 4 D ' bL % p 3 O Q ' 4 -$͒
s /[ S S
4 e e e e s / s
> @ @
Oh +'0 @ H X t
' jrauser Sophia DeMartini Microsoft Macintosh Excel @ >d@ wm*
՜. +,0 H P X l t |
" ' Amazon.com Results by question Results by score Binomial Distribution Chi-squared test How Many Quarters Standard Normal Worksheets F Microsoft Excel Sheet 8FIB Excel.Sheet.8 C o m p O b j
T