DS123_Lab_6

# DS123_Lab_6 - Bradley Dorn Lab 6 DS 123/3:30pm Question 1...

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

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

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 04/18/2008 for the course DS 123 taught by Professor Taylor during the Spring '08 term at CSU Fresno.

### Page1 / 4

DS123_Lab_6 - Bradley Dorn Lab 6 DS 123/3:30pm Question 1...

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

View Full Document
Ask a homework question - tutors are online