In: Math
A survey on men and women’s shopping behavior collected data
from a sample of 50
men and 50 women. The following data on online shopping spending
every month.
Men Women
148 272
211 176
256 251
309 235
190 145
205 179
203 30
208 135
231 200
125 270
149 174
205 123
195 199
178 195
196 192
198 102
110 110
199 184
181 228
168 316
218 170
222 234
206 163
168 245
239 174
130 126
246 227
149 86
262 96
142 185
174 288
181 154
198 217
147 184
143 154
185 217
200 222
166 175
171 265
133 196
295 172
242 113
299 240
209 235
189 269
173 243
109 131
291 134
208 56
227 164
Treat the men as population 1 and the women as population 2.
Formulate the null and
alternative hypotheses and test whether there is evidence of a
difference in the
variances of monthly online shopping spending between men and
women. Please follow
the hypothesis testing steps in arriving at a decision. You must
show all the calculations
in excel spreadsheet.