excel assigment

profileahmed98
Quiz2.xlsx
Home>English homework help>excel assigment

Q1

Problem 1
DHM 1101 DHM 2003 DHM 2403 DHM 3103 DHM 4031
72 82 85 91 100
65 81 87 92 100
60 83 88 90 99
58 73 87 89 100
73 77 85 93 100
59 74 85 91 98
55 76 85 90 99
62 78 86 89 100
65 76 86 92 99
69 77 87 93 100
72 75 88 90 99
64 78 85 89 98
67 79 85 90 99
45 75 86 93 99
67 76 83 94 100
71 77 88 92 100
69 75 87 94 99
71 79 85 93 100
69 74 84 94 99
68 78 83 93 98

Q2

Problem 2
Before After
1.3 6.5
2.5 8.7
2.3 9.8
8.1 10.2
5 7.9
7 6.5
7.5 8.7
5.2 7.9
4.4 8.7
7.6 9.1
9 8.4
7.6 6.4
4.5 7.2
1.1 5.8
5.6 6.9
6.2 5.9
7 7.6
6.9 7.8
5.6 7.3
5.2 4.6

Q3

Problem 3
Vanilla Strawberry Chocolate
Young 10.0 8.0 7.5
9.0 8.5 8.0
8.0 9.0 7.5
9.0 8.0 8.0
10.0 8.0 8.0
9.5 8.0 7.5
9.0 8.0 6.5
8.5 8.0 7.5
10.0 8.5 7.0
9.0 8.0 7.0
8.0 8.0 7.0
9.0 8.0 6.5
Middle Age 8.0 5.0 7.0
7.5 4.0 7.0
7.0 3.5 7.0
7.5 4.0 7.0
8.0 5.5 7.0
8.0 4.0 7.5
7.0 6.0 7.5
7.0 4.5 7.0
8.5 5.0 7.5
7.0 5.0 6.5
8.0 5.5 7.0
7.0 6.0 6.5
Old 5.0 8.0 10.0
6.0 7.5 9.5
7.0 7.0 10.0
7.5 7.5 9.5
6.0 8.0 10.0
6.0 8.0 10.0
5.0 7.0 10.0
5.5 7.0 9.0
6.5 8.5 9.5
6.5 7.0 10.0
6.0 8.0 9.5
5.5 7.0 10.0

Q4

Problem 4
Karate Kung Fu
6.75 9.75
7.65 9.00
9.00 8.05
5.50 8.10
5.25 9.35
6.95 9.05
6.15 8.05
5.35 8.15
7.75 9.85
5.05 8.90
7.35 9.60
6.05 9.40
6.55 8.60
7.95 8.80
8.60 9.20
6.50 8.90
6.45 9.90
5.55 8.20
6.70 8.50
5.40 8.95

Q5

Problem 5
Boys Girls
72 64
70 63
75 65
76 66
69 67
73 68
74 69
75 68
76 68
77 69
72 69
71 67 Entire Class Reference for Graph
Mean Boys Girls
Median Avg. 0.00 0.00
Mode StDev. 0.00 0.00
Min
Max
Range
SD
Percentiles Population Reference Data
Boys Girls Boys Girls
Tallest Mean SD Mean SD
Shortest 69.13 2.63 64.15 2.50

Q6

Problem 6
Income ($) Amount spent on food ($)
1000 100
2000 200
4000 360
8000 720
16000 1280
32000 2560
64000 4480
128000 8960
256000 15360
512000 30720
1024000 51200
2048000 102400
4096000 163840
8192000 327680
16384000 491520
32768000 ?