Due date: December 5, 2018Please submit the finished excel document Question 1.

Sep 1, 2021 | Uncategorized

Due date: December 5, 2018Please submit the finished excel document Question 1. (4 marks)On the sheet titled 201C;Student GPA201D; from the data create a bar chart. With bins of 50, 60, 70, 80, 90. (Using either the Frequency Function, or Histogram function in data analysis toolpak.)A. Title the chart Student GPA.B. For a Histogram remove the gaps between the bars.Question 2. (6 marks)On the sheet titled 201C;Gas Usage201D;, find the following descriptive statistics.A. MeanB. ModeC. MedianD. VarianceE. Standard DeviationF. Sample Size
quiz__3__1_.xlsx

Unformatted Attachment Preview

Don't use plagiarized sources. Get Your Custom Essay on
Due date: December 5, 2018Please submit the finished excel document Question 1.
Just from $12/Page
Order Essay

Student #
1234
1237
1240
1243
1246
1249
1252
1255
1258
1261
1264
1267
1270
1273
1276
1279
1282
1285
1288
1291
1294
1297
1300
1303
1306
1309
1312
1315
1318
1321
GPA
84.26832
93.84871
73.00414
59.73942
62.56311
36.65354
38.2372
45.63281
82.7041
36.01485
92.30365
83.08001
84.90849
80.8447
67.85353
85.15098
110.7555
59.59168
52.65411
112.0586
84.5763
96.96634
65.21344
59.55004
82.72818
79.72011
43.7131
78.33853
117.3248
70.4083
Month
Period
Gas Usage
40544
1
202
40575
2
204
40603
3
198
40634
4
102
40664
5
58
40695
6
20
40725
7
18
40756
8
16
40787
9
18
40817
10
58
40848
11
154
40878
12
192
40909
13
206
40940
14
220
40969
15
202
41000
16
98
41030
17
48
41061
18
21
41091
19
17
41122
20
15
41153
21
38
41183
22
62
41214
23
198
41244
24
240
41275
25
247
41306
26
246
41334
27
176
41365
28
110
41395
29
48
41426
30
21
41456
31
16
41487
32
14
41518
33
37
41548
34
98
41579
35
146
41609
36
197
2026;
Purchase answer to see full
attachment

  

Why dont you let a reliable essay writing service handle your assignments ?