{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"images":13},"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":129,"n_cols":10,"rows_kept":129}
["A1)"]
[185]
[225]
[240]
[196]
[175]
[180]
[194]
[147]
[223]
[]
["Mean",{"$f":"AVERAGE(A2:A10)","v":196.11111111111111}]
["Stdev",{"$f":"STDEV(A2:A10)","v":29.00191564554158}]
["t value",{"$f":"TINV(0.05,8)","v":2.306004135204167}]
["n=",9]
["Lower limit",{"$f":"B12-(B14*B13)/SQRT(B15)","v":173.818265308624}]
["Upper limit ",{"$f":"B12+(B14*B13)/SQRT(B15)","v":218.40395691359822}]
[]
["So the 95% CI is (173.8183,218.404)"]
[]
[]
[]
["A2)"]
[null,"The 95% CI for the mean difference is given by:"]
[]
[]
[]
[null,null,"sample 1","sample 2"]
[null,null,120,122]
[null,null,145,142]
[null,null,130,135]
[null,null,160,158]
[null,null,152,155]
[null,null,143,140]
[null,null,126,130]
[null,null,121,120]
[null,null,115,124]
[null,null,135,130]
[]
[null,"Mean",{"$f":"AVERAGE(C29:C38)","v":134.7},{"$f":"AVERAGE(D29:D38)","v":135.6}]
[null,"Stdev",{"$f":"STDEV(C29:C38)","v":14.92239182496487},{"$f":"STDEV(D29:D38)","v":13.184165586878157}]
[null,"n",10,10]
[null,"SP=",{"$f":"SQRT((9*(C41^2+D41^2))/(18))","v":14.080127840328736}]
[null,"Lower limit=",{"$f":"((D40-C40)-TINV(0.05,8)*C43*(SQRT(1/5)))","v":-13.620503558351425}]
[null,"Upper limit",{"$f":"((D40-C40)+TINV(0.05,8)*C43*(SQRT(1/5)))","v":15.420503558351436}]
[null,null,"."]
[null,"So the 95% CI for the  difference is (-13.6205,15.4205)"]
[]
[]
["A3)","The 95% CI for the differnce iin proportion is given by:"]
[]
[]
[]
[]
[{"$nulls":5},0.14,null,null,0.86]
[]
[{"$nulls":5},0.22,null,null,0.78]
[]
[{"$nulls":4},"n1,n2=",100]
[]
[{"$nulls":4},"Z=",{"$f":"NORMSINV(0.975)","v":1.9599639845400536}]
[]
[{"$nulls":4},"Lower limit=",{"$f":"(F57-F55)-F61*SQRT((F55*I55/F59)+(F57*I57)/100)","v":-0.02591062154678747}]
[{"$nulls":4},"Upper limit=",{"$f":"(F57-F55)+F61*SQRT((F55*I55/F59)+(F57*I57)/F59)","v":0.18591062154678745}]
[]
[{"$nulls":4},"So the CI is (-0.02591,0.1859110)"]
[]
[]
["A4)","The 95% CI for the difference In means is given by "]
[]
[]
[]
[null,null,"Men","Female"]
[null,null,3,5]
[null,null,4,3]
[null,null,6,1]
[null,null,8,2]
[null,null,2,0]
[null,null,1,4]
[null,null,0,3]
[null,null,2,1]
[]
[null,"Mean",{"$f":"AVERAGE(C74:C81)","v":3.25},{"$f":"AVERAGE(D74:D81)","v":2.375}]
[null,"STDEV",{"$f":"STDEV(C74:C81)","v":2.659215781283755},{"$f":"STDEV(D74:D81)","v":1.685018016012207}]
[null,"n=",8]
[null,"Sp=",{"$f":"SQRT(7*(C84^2+D84^2)/14)","v":2.226063148892489}]
[null,"Lower limit=",{"$f":"(C83-D83)-TINV(0.05,7)*C86*0.5","v":-1.75690145372409}]
[null,"upper limit=",{"$f":"(C83-D83)+C86*TINV(0.05,7)*0.5","v":3.50690145372409}]
[null,"CI=(-1.7569,3.5069)"]
[]
[]
["A5)"]
["a)","The 95 % Ci for the proportion is given by"]
[]
[]
[]
[]
[{"$nulls":5},{"$f":"44/120","v":0.36666666666666664}]
[]
[{"$nulls":5},{"$f":"1-F98","v":0.6333333333333333}]
[]
[{"$nulls":4},"n=",120]
[{"$nulls":4},"Z=",{"$f":"NORMSINV(0.975)","v":1.9599639845400536}]
[]
[{"$nulls":4},"Lower limit=",{"$f":"F98-F103*SQRT(F98*F100/F102)","v":0.2804464010714702}]
[{"$nulls":4},"Upper limit=",{"$f":"F98+F103*SQRT(F98*F100/F102)","v":0.4528869322618631}]
[]
[{"$nulls":4},"Thus 95% ci is(0.2804,0.45287)"]
[]
[]
["b)","The 95% CI for the differnce in proportion is given by:"]
[]
[]
[]
[]
[]
[{"$nulls":6},{"$f":"44/65","v":0.676923076923077},null,null,{"$f":"1-G117","v":0.32307692307692304}]
[]
[{"$nulls":6},{"$f":"21/120","v":0.175},null,null,{"$f":"99/120","v":0.825}]
[]
[]
[{"$nulls":5},"n1,n2=",120]
[]
[{"$nulls":5},"Z=",{"$f":"NORMSINV(0.975)","v":1.9599639845400536}]
[]
[{"$nulls":5},"LOWER LIMIT",{"$f":"(G117-G119)-G124*SQRT((G117*J117+G119*J119)/120)","v":0.39411418574035145}]
[{"$nulls":5},"Upper limit",{"$f":"(G117-G119)+(G124*SQRT((G117*J117+G119*J119)/G122))","v":0.6097319681058024}]
[]
[{"$nulls":5},"The ci is(0.3941,0.6097)"]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0}