DS123_Lab_6

DS123_Lab_6 - Bradley Dorn Lab 6, DS 123 3/12/08/3:30pm...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Bradley Dorn Set right and left margins to 0.5''' (under File-Page Setup). Lab 6, DS 123 Set coumn width for Column C to 2, for Column D to 25. 3/12/08/3:30pm Set Column width for Column E and F to 10. Set cell D22 on right-justified text. Question 1. First, compute the sample variances. You need to input their values. FROM xr11043 Values Equations Used NewProg OldProg NewProg 16978.61 "=VAR(range of data) 1246 927 OldProg 8543.15 "=VAR(range of data) 845 1028 1024 1079 Then run the Data Analysis Tool Kit. Don't forget to change alpha to 0.025! 1238 827 913 758 z-Test: Two Sample for Means 1123 1074 1074 1026 NewProg OldProg 970 966 Mean 1041.1 1004.98 952 1039 Known Variance 16978.61 8543.05 966 949 Observations 40 40 1091 845 Hypothesized Mean Difference 0 1122 981 z 1.43 1007 929 P(Z<=z) one-tail 0.08 1091 939 z Critical one-tail 1.64 1243 1145 P(Z<=z) two-tail 0.15 1075 1007 z Critical two-tail 1.96 1107 1046 932 923 1124 926 931 1144 894 1042 850 1183 1097 1028 1030 945 770 1001 1103 1087 1333 963 1016 1063 834 1049 1040 1155 1159 1163 950 981 1286 1014 1065 1001 1159 1005 1077 937 987 1081 1094 877 858 1037
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 4

DS123_Lab_6 - Bradley Dorn Lab 6, DS 123 3/12/08/3:30pm...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online