Need help with Week 4 QNT Paper Statistics- Complete paper by 6PM Pacific Monday

profilelilredcorvette
excel_data_for_individual-2.xlsx

Sheet2

Sheet1

ID On Display? Sales Age ID On Display? Sales Age ID On Display? Sales Age
1 yes $44.00 35 38 no $33.00 41 75 yes $59.00 28
2 yes $53.00 26 39 yes $52.00 25 76 yes $54.00 29
3 no $56.00 31 40 no $23.00 28 77 yes $41.00 25
4 yes $26.00 42 41 yes $43.00 45 78 yes $55.00 32
5 yes $43.00 41 42 yes $44.00 35 79 no $37.00 26
6 no $53.00 26 43 no $40.00 39 80 yes $34.00 25
7 yes $43.00 25 44 no $30.00 37 81 yes $54.00 41
8 yes $31.00 33 45 yes $37.00 29 82 yes $35.00 45
9 yes $43.00 40 46 yes $37.00 28 83 no $40.00 28
10 yes $36.00 42 47 no $41.00 42 84 yes $40.00 27
11 yes $39.00 37 48 no $47.00 26 85 no $42.00 32
12 yes $47.00 28 49 yes $47.00 37 86 no $46.00 30
13 yes $47.00 28 50 no $49.00 35 87 yes $28.00 40
14 no $44.00 25 51 yes $60.00 28 88 no $37.00 40
15 yes $33.00 36 52 no $28.00 26 89 no $42.00 36
16 yes $50.00 41 53 yes $45.00 29 90 yes $55.00 37
17 no $49.00 45 54 no $38.00 30 91 no $38.00 25
18 yes $51.00 42 55 no $48.00 35 92 yes $51.00 28
19 yes $33.00 26 56 yes $53.00 39 93 no $55.00 40
20 yes $59.00 33 57 yes $55.00 45 94 no $39.00 43
21 yes $49.00 35 58 yes $34.00 42 95 yes $40.00 36
22 yes $39.00 41 59 yes $59.00 43 96 no $34.00 25
23 yes $39.00 36 60 no $31.00 38 97 yes $64.00 29
24 yes $37.00 41 61 yes $54.00 37 98 yes $48.00 25
25 yes $48.00 26 62 yes $57.00 25 99 yes $27.00 30
26 yes $45.00 29 63 yes $38.00 25 100 no $50.00 40
27 yes $29.00 30 64 yes $53.00 36
28 no $41.00 41 65 yes $35.00 38
29 no $53.00 42 66 no $43.00 45
30 yes $41.00 39 67 yes $34.00 41
31 yes $33.00 28 68 yes $33.00 40
32 no $38.00 25 69 yes $27.00 40
33 yes $41.00 45 70 no $47.00 30
34 yes $37.00 32 71 no $49.00 30
35 no $38.00 38 72 yes $44.00 32
36 yes $26.00 26 73 no $36.00 37
37 yes $52.00 29 74 yes $49.00 26