Excel - Sampling Distribution & Interval Estimation

profileAbbas1412
project.xls
Home>Mathematics homework help>Numerical analysis homework help>Excel - Sampling Distribution & Interval Estimation

Sampling

Lab2.xls QMTH205 Name:
Population
Student Score Random Number Population Size (N) =
1 84 Population Mean Score =
2 73 Population Standard Deviation =
3 79 Sample Size (n) =
4 88 Sample Mean Score =
5 81 Sample Standard Deviation =
6 80
7 82
8 75
9 75
10 79
11 88
12 80
13 82
14 80
15 75
16 85
17 79
18 91
19 83
20 83
21 81
22 80
23 73
24 78
25 80
26 72
27 82
28 78
29 77
30 83
31 71
32 69
33 88
34 86
35 73
36 80
37 92
38 84
39 79
40 84
41 82
42 74
43 86
44 80
45 80
46 81
47 78
48 91
49 80
50 80
51 76
52 78
53 77
54 82
55 83
56 85
57 84
58 85
59 80
60 81
61 81
62 84
63 87
64 87
65 82
66 85
67 84
68 83
69 85
70 75
71 79
72 79
73 84
74 79
75 75
76 84
77 79
78 73
79 83
80 79
81 78
82 81
83 73
84 79
85 89
86 79
87 83
88 89
89 84
90 84
91 74
92 77
93 82
94 86
95 73
96 83
97 75
98 86
99 77
100 72
101 76
102 88
103 77
104 79
105 79
106 77
107 75
108 77
109 83
110 76
111 88
112 82
113 78
114 78
115 83
116 81
117 86
118 82
119 81
120 85
121 87
122 70
123 85
124 83
125 89
126 80
127 85
128 82
129 79
130 87
131 87
132 84
133 87
134 84
135 82
136 88
137 76
138 73
139 83
140 86
141 87
142 81
143 74
144 71
145 81
146 80
147 79
148 80
149 86
150 67
151 66
152 78
153 73
154 78
155 77
156 73
157 83
158 78
159 74
160 78
161 82
162 75
163 83
164 76
165 79
166 88
167 82
168 71
169 70
170 76
171 81
172 83
173 81
174 84
175 75
176 87
177 83
178 88
179 90
180 77
181 83
182 79
183 80
184 79
185 87
186 78
187 77
188 83
189 76
190 66
191 76
192 77
193 78
194 79
195 80
196 81
197 82
198 83
199 84
200 85

Sigma Known Case

Lab2.xls QMTH205 Name:
Sample Sample mean score
Score Sample Size
98 Margin of error
100 Lower limit
72 Upper limit
92
93
58
71
99
77
54
91
100
95
82
89
91
77
89
92
89
93
100
84
52
86
100
74
52
91
98

Sigma Unknown Case

Lab2.xls QMTH205 Name:
Excel Output
Confidence Interval Estimation:
Sample size =
Sample mean =
Margin of error =
Lower limit =
Upper limit =

Proportion

Lab2.xls QMTH205 Name:
Confidence interval for population proportion Response
Response of Interest No No Yes Yes No Yes Yes Yes No Yes Yes No No No Yes
Count for Response No Yes Yes No No No No Yes Yes No No Yes No Yes No
Sample size Yes No Yes No No No No No No No Yes Yes Yes Yes Yes
Sample proportion No No Yes Yes No Yes Yes No No Yes No Yes Yes Yes Yes
Confidence Level No Yes No No Yes No Yes No Yes Yes Yes No No No No
Z 0.0000 Yes Yes Yes Yes Yes No Yes Yes No Yes Yes No No No Yes
Margin of Error 0.0000 No Yes Yes Yes No No Yes Yes Yes No Yes No No Yes Yes
Upper Limit 0 No Yes Yes No No Yes No Yes Yes Yes No Yes Yes No Yes
Lower Limit 0 Yes No Yes No Yes Yes No Yes No Yes No Yes No No No
No Yes No Yes Yes No Yes No Yes Yes Yes No No No Yes
No No Yes Yes No Yes Yes Yes No Yes Yes Yes No No No
Yes No No No Yes No Yes Yes Yes No No No No No Yes
No No No Yes No Yes Yes Yes No No No Yes No No No
Yes Yes Yes Yes Yes No No Yes Yes No No No No No No
No No No Yes Yes No No Yes Yes No No Yes No Yes No
Yes Yes No Yes No Yes No Yes No Yes No No Yes No Yes
No No Yes No No No No Yes No Yes No No No No Yes
Yes No No No Yes No No No Yes Yes No No No Yes No
Yes No No No No No No Yes Yes Yes Yes No No Yes Yes
No Yes No No No No No Yes Yes Yes No No Yes Yes Yes
Yes No No No Yes Yes Yes No No No No Yes Yes No No
No No No Yes Yes Yes Yes No No No No Yes No No Yes
No No No Yes Yes No Yes No Yes Yes Yes No No No No
No No Yes Yes No Yes Yes Yes No Yes Yes Yes No No No
No No No No Yes Yes Yes Yes Yes No No No No No Yes
No No No Yes No Yes Yes Yes No No No Yes No No No
Yes No Yes No No No No Yes No No Yes No No Yes No
No No No No No Yes Yes Yes No Yes No No Yes No Yes
No No No Yes Yes No Yes No Yes Yes Yes No No No Yes
No No No No No Yes Yes Yes No Yes No No Yes No Yes