# Statistics Concepts and Descriptive Measures

Description

Purpose of Assignment The purpose of this assignment to orient students to the key concepts in statistics. This assignment will introduce students to the language of statistics. Students will also get a chance to warm-up on evaluating some basic descriptive statistics using Excel® prior to the course start. Assignment StepsThis assignment has an Excel® dataset spreadsheet attached. You will be required to only do one of the three datasets. Resource: Microsoft Excel®, Statistics Concepts and Descriptive Measures Data SetDownload the Statistics Concepts and Descriptive Measures Data Set. Choose one of the following datasets to complete this assignment:Consumer FoodFinancialHospitalAnswer each of the following in a total of 90 words:For each column, identify whether the data is qualitative or quantitative.Identify the level of measurement for the data in each column.For each column containing quantitative data:Evaluate the mean and medianInterpret the mean and median in plain non-technical termsUse the Excel =AVERAGE function to find the meanUse the Excel =MEDIAN function to find the medianFor each column containing quantitative data:Evaluate the standard deviation and rangeInterpret the standard deviation and range in plain non-technical termsUse the Excel =STDEV.S function to find the standard deviationFor range (maximum value minus the minimum value), find the maximum value using the Excel =MAX function and find the minimum value using the Excel’s =MIN function Click the Assignment Files tab to submit your assignment.

Region: 1 Location:
Annual
Annual
Non
= NE 2 = 1 = Metro
Food
Househol mortgage MW 3 =
2=
Spending d Income household S
4 = Outside
(\$)
(\$)
debt (\$)
W
Metro
8909
56697
23180
1
1
5684
35945
7052
1
1
10706
52687
16149
1
1
14112
74041
21839
1
1
13855
63182
18866
1
1
15619
79064
21899
1
1
2694
25981
8774
1
1
9127
57424
15766
1
1
13514
72045
27685
1
1
6314
38046
8545
1
1
7622
52408
28057
1
1
4322
41405
6998
1
1
3805
29684
4806
1
1
6674
49246
13592
1
1
7347
41491
4088
1
1
2911
26703
15876
1
1
8026
48753
16714
1
1
8567
55555
16783
1
1
10345
71483
21407
1
1
8694
50980
19114
1
1
8821
46403
7817
1
1
8678
51927
14415
1
1
14331
84769
17295
1
1
9619
59062
16687
1
1
9286
57952
14161
1
1
8206
58355
19538
1
1
16408
81694
15187
1
1
12757
69522
14651
1
1
17740
96132
0
1
1
7739
57796
22057
1
1
15383
88276
1896
1
1
4579
32264
7979
1
1
11679
65928
0
1
1
12877
69924
27330
1
1
16232
91108
9876
1
1
9621
54070
19908
1
1
8171
47238
17819
1
1
12128
77427
31340
1
1
8642
59805
4963
1
1
12400
60334
6632
1
1
9185
54114
18593
1
2
7862
9775
6771
3059
13211
7408
11581
14233
3352
2630
9093
12652
9559
6112
10431
12630
4578
9551
10262
9551
10143
8955
10197
11234
9320
9089
12300
11484
11215
7204
5579
11723
9353
7761
4261
9830
12386
8673
10944
9910
9928
4264
7971
8290
12669
7272
9784
40680
58263
52008
39643
70309
46450
76140
80833
31899
21647
65924
65923
62811
42335
65134
64621
36553
62910
70727
57634
56549
59662
57350
56447
61136
51526
79979
66733
75359
40795
39128
75482
63998
45845
38223
66787
77852
55825
57022
64263
75881
34343
41243
53021
66991
49719
58399
15202
1486
21713
12179
13221
5602
33874
11478
2762
2663
11355
5132
12613
3149
15196
21433
5502
11376
13287
11857
16136
11627
18432
10871
0
4902
17270
15145
15611
8975
6576
12508
0
6671
8576
1178
936
14167
9018
12768
17423
21323
21009
20151
9250
20838
16065
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
9187
5866
9456
6270
9518
10968
8865
9226
4913
6976
8152
2887
8062
8895
8444
6148
4563
8185
3391
7436
9522
11290
10403
4693
5626
11869
13055
8783
13031
3681
5549
4108
6314
7700
7479
9093
9863
8043
9552
9286
7987
3875
10746
6888
5479
6949
10650
50477
39112
51886
34797
62348
78704
53620
51577
34761
60968
51281
25013
59238
47344
52645
35309
34355
50630
29056
48721
50459
72805
56954
39343
38833
55021
77605
57937
63343
36479
40381
26309
41421
54579
40551
50369
54422
51836
73600
51873
48003
36519
75152
44974
48923
43769
75947
9407
20409
11668
146
5201
17002
32004
15922
17704
17799
8167
18763
10815
11814
22469
17139
10612
21187
15735
18363
16478
21238
22218
24696
14371
35576
817
18591
25531
17950
14257
26581
22470
29065
31757
6404
24334
26213
36374
29631
17261
13579
10659
23711
4594
21221
33357
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
1
1
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
2
2
2
2
2
2
2
2
2
2
5188
5311
4691
8056
11304
8112
8696
5869
3776
11829
13087
10986
5762
11617
9895
16293
8185
13972
11243
4635
10063
8426
7436
11747
15397
6842
9678
12852
10114
8496
6689
15696
9841
12529
10210
8868
6426
11096
10086
2587
12492
8456
6801
6339
7802
9717
6026
41423
40189
36772
59690
53654
59067
65962
37254
33568
56934
88822
59635
38407
78627
47710
64443
58871
87954
54778
39825
49536
60102
49139
51052
70500
54894
60570
57625
56956
61400
50532
72774
69981
66891
67431
64782
38987
64867
50421
27076
51784
54135
53291
49804
52205
72841
46238
33641
17791
5829
19594
23066
240
0
10157
14143
0
17565
27863
18867
11894
22930
31687
35424
11549
12552
19494
12195
13787
22356
4553
12025
16217
4106
31228
25907
1093
17106
17793
21607
17689
19995
14489
17864
5839
8689
17534
20284
22037
23342
34943
28579
22349
20165
3
3
3
3
3
3
3
3
3
3
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
2
2
2
2
2
2
2
2
2
2
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
2
2
2
2
2
2
2
5618
10217
8338
9048
4017
10906
15148
8830
8481
11358
10553
6969
13219
3543
7326
8458
11766
9908
45938
77716
59711
42106
36462
53403
71290
66759
57616
76221
78202
55164
61171
34093
50647
59898
52884
73629
10538
18516
7980
19786
9935
18177
6696
20972
28767
1373
5920
24795
21482
25969
10750
22940
25970
7112
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
Company
Type
AFLAC
Albertson’s
Allstate
American General
American Stores
Amoco
Arco Chemical
Ashland
Atlantic Richfield
Bausch & Lomb
Baxter International
Bristol-Myers Squibb
Burlington Coat
Central Maine Power
Chevron
CIGNA
Cinergy
Dayton Hudson
Dillard’s
Dominion Resources
Dow Chemical
DPL
E. I. DuPont DeNemours
Eastman Chemical
Edison International
Engelhard
Entergy
Equitable
Ethyl
Exxon
FPL Group
The GAP
Georgia Gulf
GIANT Food
A&P
Great Lakes Chemicals
Green Mountain Power Company
Hannaford Bros.
Hercules
Houston Industries
Jefferson-Pilot
Johnson & Johnson
Liberty
The Limited
Lincoln National
6
4
6
7
6
4
7
2
7
7
5
5
5
1
3
7
6
3
1
1
3
2
3
2
2
3
2
3
6
7
7
3
1
2
4
4
2
3
4
2
3
6
5
6
1
6
Total Revenues Total Assets
Return on Equity
7251
29454
17,1
14690
5219
21,4
20106
80918
20,1
8340
7935
0,2
3362
80620
7,1
19139
8536
12,2
36287
32489
16,7
3995
4116
6,2
14319
7777
9,5
19272
25322
21,8
1916
2773
6
6138
8707
11,5
16701
14977
44,4
1777
775
12,3
954
2299
2,4
41950
35473
18,6
14935
108199
13,7
4353
8858
13,3
27757
14191
18
6817
5592
9,2
7678
20193
7,9
20018
24040
23,6
1356
3585
13,9
46653
42942
21,3
4678
5778
16,3
9235
25101
12,3
3631
2586
6,1
9562
27001
4,2
9666
151438
12,3
1064
1067
53,6
137242
96064
19,4
6369
12449
12,2
6508
3338
33,7
966
613
228
4231
1522
7,9
10262
2995
6,9
1311
2270
5,5
179
326
8,3
3226
1227
9,9
1866
2411
47
6873
18415
8
2578
23131
14,5
22629
21453
26,7
660
3185
11,1
9189
4301
10,6
4899
77175
0,4
Lubrizol
Lyondell Petrochemical
May Department Stores
McKesson
Mercantile Stores
Merck
Millennium Chemicals
Mobil
Monsanto
Morton
Murphy Oil
Mylan Laboratories
NALCO Chemical
NIPSCO
Olin
Orion Capital
Owens & Minor
Pacific Corporation
J. C. Penney
Pennzoil
Pfizer
Pharmacia & Upjohn
Phillips Petroleum
Poe & Brown
PPG
PP&L Resources
Progressive
Rohm & Haas
Ruddick
Schering-Plough
Sears, Roebuck
Stryker
Sun
Sunamerica
Texaco
The TJX Companies
Torchmark
Tosco
Travelers
Ultramar Diamond Shamrock
Union Carbide
United States Surgical Corporation
UNOCAL
UNUM
USX-Marathon
2
7
5
1
5
1
5
2
7
2
2
7
5
2
3
3
2
6
5
3
1
7
5
5
7
6
2
3
6
2
4
5
1
5
7
6
7
1
6
7
6
7
2
5
7
6
7
1674
3010
1868
12685
20857
3144
23637
3048
65906
7514
2388
2138
555
1434
799
2587
2410
1591
3117
6278
30546
2654
12504
6710
15424
129
7379
3049
4190
3999
2300
6778
41296
980
10531
2114
46667
7389
2283
13282
37609
10882
6502
1172
6064
4077
15754
1462
1559
2988
9930
5608
2178
25812
4326
43559
10774
2805
2238
848
1441
2339
4937
1946
3884
713
13880
23493
4406
15336
10380
13860
194
6868
9485
7560
3900
885
6507
38700
985
4667
35637
29600
2610
10967
5975
386555
5595
6964
1726
7530
13200
10565
19
46,2
14,8
20,5
11
7,9
36,6
12,6
16,8
7,2
12,3
12,3
13,5
25
10,1
14,1
17,4
16
9,4
5,2
7,7
15,8
27,9
5,8
19,9
25,1
28,5
11,4
18,7
19,8
12,5
51,2
20,3
20,5
18
14,7
20,9
26,3
17,5
10,9
14,9
9,5
28,8
7,5
28,9
15,2
12,6
Valero Energy
Warner-Lambert
WEIS Markets
Wellman
Winn-Dixie Stores
WITCO
Zenith Nation Insurance
7
5
4
2
4
2
6
5756
8180
1819
1083
13219
2187
601
2493
8031
972
1319
2921
2298
1252
9,6
30,7
9,2
4,8
15,3
14
7,8
Earnings per Share
Average Yield
2,08
2,08
3,56
0,08
2,19
1,01
2,76
1,14
3,8
5,41
0,89
1,06
3,14
1,18
0,16
4,95
4,88
1,59
1,7
2,31
2,15
7,7
1,2
2,08
3,63
1,73
0,33
1,03
2,86
0,71
3,37
3,57
1,3
2,39
1,18
1,66
1,19
1,57
1,4
3,18
1,66
3,47
2,41
3,34
0,79
0,21
Dividends per Share
0,9
1,6
1
1,1
3
1,4
3,1
6,1
2,3
3,8
2,6
2,3
2
0,1
7,8
3
2
5,1
1,2
0,4
6,8
3,6
5,3
2,1
3
4,2
1,9
6,9
0,5
5,6
2,8
3,7
0,7
1,1
2,4
1,2
1,3
7,3
1,5
2,2
6,6
2,3
1,5
1,8
2,3
3,1
Average P/E Ratio
0,22
0,63
0,36
0,6
1,4
0,34
1,4
2,8
1,1
2,83
1,04
1,13
1,52
0,02
0,9
2,28
1,1
1,8
0,33
0,16
2,58
3,24
0,91
1,23
1,76
1
0,38
1,8
0,2
0,5
1,63
1,92
0,2
0,32
0,78
0,35
0,62
1,61
0,54
1
1,5
1,04
0,85
0,77
0,48
1,96
11,5
19
10,6
698,3
21,2
23,5
16,1
40,4
12,4
3,8
2,6
47,2
24,1
12,9
79,6
15,2
11,4
22,4
16,2
15,7
17,7
11,6
14,3
27,9
16
13,6
61,8
25,4
13,4
12,6
17,1
14,4
22
11,8
26,9
17,8
40,5
14
26,6
14,5
13,7
13,3
24,1
12,7
26,7
300,2
2,66
3,58
2,47
3,11
1,59
3,53
3,74
2,47
4,01
0,48
1,48
2,94
0,82
2,1
1,65
1,53
3
4,15
0,6
0,68
2,1
3,76
1,7
0,61
3,61
1,48
3,94
1,8
5,31
2,13
1,02
1,95
2,99
1,28
2,7
1,8
4,87
1,75
2,39
1,37
2,54
1,94
4,53
1,21
2,65
2,59
1,58
2,6
3,9
1,7
2,4
1,2
2,1
1,7
2,9
3,1
1,1
1
2,6
0,9
2,6
6,8
4,1
2,8
1,5
1,4
4,6
3,8
1,6
1,1
3,1
3
1,5
2,3
7,7
0,3
2,2
1,8
1,5
1,8
0,3
2,8
0,9
3,1
0,6
1,7
0,8
0,9
3,5
1,6
0,5
2
1,3
2,4
1,01
0,9
0,66
1,2
0,5
1,19
1,69
0,6
2,12
0,5
0,36
1,35
0,16
1
1,6
0,9
1,2
0,6
0,18
1,08
2,13
1
0,68
1,08
1,34
0,35
1,33
1,67
0,24
0,63
0,32
0,74
0,92
0,11
1
0,3
1,75
0,09
0,59
0,24
0,4
1,1
0,79
0,16
0,8
0,56
0,76
14,5
6,4
16
16,2
26
16,3
26,6
8,3
17,2
90,7
25,2
18
22,4
18,3
14,2
14,4
14,5
9,8
21,7
34,2
26,9
17,1
35,4
56,2
12,4
16,3
14,7
12
17
13,4
17
24,6
17,4
27,2
13
19,5
11,5
8,2
14,2
23
17
16,1
10,7
29
15,5
17
19,8
2,03
1,04
1,87
0,97
1,36
1,55
1,57
1,2
1,4
3
1,8
2,7
2,9
3,7
0,42
0,51
0,94
0,35
0,98
1,12
1
17,2
35,7
16,9
20,5
27,2
24,9
17
Hospital
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
Geog. Region
Control
1
1
1
1
7
4
4
4
1
1
1
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
5
5
5
2
2
2
1
1
1
1
1
1
1
1
1
1
Service
2
1
2
1
1
2
4
2
2
1
1
3
3
2
4
1
3
2
3
3
3
2
2
1
3
2
2
3
3
2
2
2
2
2
2
2
3
2
1
2
3
1
2
2
1
3
Beds
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
2
1
1
1
1
1
1
1
1
2
210
347
511
142
40
220
137
80
440
48
56
46
109
306
7
16
167
444
236
247
93
236
220
228
83
273
225
236
80
78
197
60
31
264
246
556
56
120
674
414
320
315
344
168
315
88
Outpat. Visits
Births
7713
107
86982
312
16065
198
149222
1077
23028
356
222565
1027
4338
100
36710
355
905
9
13350
168
15563
159
88721
3810
5347
65
188885
735
636
48
10209
1
15954
253
77343
1733
1827
21
33977
257
1617
27
17925
169
2954
30
27170
430
2805
43
30263
0
9871
233
43128
2049
756
2
96000
211
342
11
7217
16
8426
84
66073
2648
18258
219
170223
2450
8280
112
31022
1465
5449
124
44425
0
5247
50
29551
1993
11301
142
90178
2275
9466
111
172146
1494
10444
140
95649
1313
2648
28
15507
451
9249
154
51102
1689
7763
150
91654
1583
10688
144
68482
2017
6671
42
35221
995
7761
77
37370
2045
9553
119
153994
1686
2730
27
16060
503
1112
15
36735
126
13395
179
267091
2026
12264
175
140152
1412
12811
461
68330
1517
860
32
5778
0
5502
74
36461
0
26547
414
294682
2719
12260
253
81885
1074
4147
180
47636
1421
12804
184
92458
762
16539
243
185313
3194
7566
115
66309
496
15853
215
93373
1442
2662
48
6533
0
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
1
1
1
1
1
1
1
1
7
7
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
1
1
1
1
1
1
1
1
2
3
2
1
1
3
2
1
2
2
3
1
3
2
2
2
2
2
3
2
2
2
4
2
2
1
3
1
2
2
2
1
2
2
1
3
1
1
3
4
1
2
3
3
2
1
3
2
1
1
1
1
1
1
1
1
1
1
2
1
1
1
1
1
1
2
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
2
1
1
2
2
1
1
1
1
2
1
1
1
1
245
311
233
46
103
331
186
177
149
286
488
242
128
33
255
481
191
60
155
626
105
59
258
47
22
53
244
352
366
194
109
285
175
342
140
50
214
80
467
80
160
106
40
99
133
138
88
8733
15196
1466
812
2312
2305
10541
4469
5994
11142
508
5682
5511
925
13780
28390
9899
1247
9893
31452
1456
4706
9950
1940
1241
1475
9731
14974
7284
5356
458
11624
8080
1259
2876
404
794
746
6122
823
6584
3870
859
3313
6306
2764
4112
124
189
181
9
28
288
108
154
76
165
295
101
69
12
185
378
114
49
106
460
43
29
125
17
10
14
173
207
223
82
64
139
109
298
52
34
168
21
390
47
80
50
113
45
76
129
60
78773
115155
18659
11519
30661
35600
76176
57104
111901
173393
0
37461
37898
24679
146454
796525
85986
35955
192386
236900
47152
292105
121004
45057
31833
43357
103595
110754
181430
48413
26770
599315
200048
0
3192
13468
0
10074
179676
10409
91769
53424
2251
30814
172253
17907
85800
1107
2989
113
0
0
173
1064
759
1317
1751
0
0
714
99
2243
3966
1308
0
2514
3714
126
556
1327
415
216
339
1217
2641
790
520
35
1168
793
0
0
14
0
0
0
0
776
451
0
145
1284
1
319
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
2
2
2
2
2
2
2
3
3
3
3
3
3
3
3
3
3
3
3
1
1
1
3
3
3
3
3
5
5
5
5
3
3
3
5
5
5
2
2
2
2
2
2
5
5
5
2
2
2
2
2
2
1
2
4
2
1
3
3
4
1
3
2
1
2
2
3
1
1
1
4
3
1
4
2
1
4
2
3
1
2
3
3
1
4
3
3
2
2
1
1
2
2
2
1
1
1
1
1
1
1
2
2
1
1
2
1
2
2
1
1
1
1
1
2
1
2
1
1
2
1
1
1
1
1
1
1
1
1
1
1
1
2
2
1
1
1
1
1
1
1
573
44
225
105
100
186
375
485
64
495
114
62
149
427
40
129
149
71
256
153
1297
70
69
71
243
206
62
219
54
24
151
160
262
296
671
184
249
157
100
100
375
123
457
263
160
69
153
26392
1497
8187
6251
5335
8184
21169
4112
1785
21327
538
883
1897
592
1049
9507
1589
617
7203
6156
1407
1609
1666
3477
5667
1499
1256
9275
143
1503
1764
3228
3689
14018
37375
7699
7931
2018
510
2271
11821
4093
16987
19776
7798
2814
3611
418
17
138
64
62
131
265
456
40
310
72
19
112
375
15
78
123
54
96
82
1106
30
56
36
127
180
59
127
37
13
100
47
194
172
516
120
179
140
78
68
186
91
340
254
108
61
174
121321
35357
89248
103225
172105
87453
331478
109270
7749
312733
0
5850
69776
0
0
64109
13721
48469
107440
4170
5551
14630
6376
238060
161912
0
68886
42058
3224
105101
27889
29179
57144
139741
119462
53313
88869
102547
935
13405
184144
36172
304839
362424
87511
64651
69833
2154
295
496
589
806
701
3968
0
0
3655
0
0
0
0
0
3063
169
66
827
570
0
0
0
342
494
0
0
0
0
286
235
339
398
1275
5699
1364
714
0
0
0
779
0
2202
3346
1071
352
254
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
2
2
2
2
2
1
1
1
1
1
3
3
3
3
3
3
3
3
3
3
7
7
7
7
7
2
2
2
2
2
1
1
1
3
3
1
1
1
1
1
1
1
1
1
5
5
5
1
3
2
2
1
2
1
4
1
2
2
2
4
1
2
2
1
3
4
1
2
1
1
4
2
1
4
2
2
2
4
3
3
4
2
2
3
3
2
3
4
3
3
3
3
1
2
2
2
1
1
1
1
1
2
1
1
1
1
2
2
1
1
2
1
1
2
1
1
1
1
1
2
1
2
1
1
1
1
1
1
1
2
1
1
1
1
1
2
2
1
1
1
1
260
34
479
973
440
51
347
612
141
115
50
261
334
228
85
357
189
139
60
164
105
114
73
314
350
602
74
53
152
317
43
269
79
181
122
65
97
169
407
160
117
80
100
370
123
380
149
163
213
4848
24753
21004
111
19026
3378
4080
2030
944
10112
4410
515
3233
14900
1076
4014
3108
1132
7528
6685
568
8408
17484
570
1426
1963
5373
14275
1438
11508
4044
3217
2938
3246
2481
5348
16466
6504
12209
1266
767
8974
4085
16647
8479
306
28
395
923
335
46
316
416
74
86
38
147
232
138
38
245
171
51
28
797
56
69
40
163
231
523
31
43
66
231
11
144
43
185
82
49
24
63
274
93
86
28
25
181
39
302
80
56662
0
262583
339009
550588
1257
287498
129088
54460
32678
14995
86607
109111
0
67906
279079
0
59061
202739
42432
98805
27365
11443
289471
196534
0
85674
848
65824
162753
287501
172047
83963
169698
65898
51167
62150
64834
134581
30246
813369
3813
5742
53406
56073
31412
209595
0
0
699
2462
3311
0
4207
0
339
130
91
1143
0
0
509
1026
0
447
1161
0
922
562
78
0
2122
0
0
0
710
1165
466
1106
376
0
637
0
352
447
1227
963
3038
0
0
868
1189
2849
1728
188
189
190
191
192
193
194
195
196
197
198
199
200
5
2
2
1
1
1
7
7
7
7
5
5
5
2
2
2
1
2
3
2
1
2
2
1
1
1
1
1
2
1
1
1
1
1
1
1
2
1
1
112
61
219
260
350
121
206
70
334
190
122
170
73
7260
2730
2161
13943
12132
7894
4567
2089
15696
6395
441
7244
352
63
31
170
203
296
83
84
29
187
77
104
85
47
163261
59584
14923
138404
100323
85585
107027
24369
102641
244254
0
167454
9714
2171
364
0
2993
0
1964
601
387
1946
545
0
838
51
Tot. Exp. Payroll Exp.Personnel
56831
22061
792
127223
55799
1762
157093
61326
2310
24462
10503
328
13730
6368
181
93257
33920
1077
45458
26919
742
6151
2768
131
98992
40956
1594
11569
5664
233
11356
5084
241
15200
7085
203
20848
9709
325
62778
28958
676
20300
12300
347
3836
2015
79
41417
20633
505
144966
61667
1543
67997
31285
755
123175
41899
959
28318
12589
325
88080
32191
954
107313
38668
1091
116486
49017
671
20625
3009
300
67519
28066
753
60080
21944
607
94401
38757
929
26094
13464
354
38825
15951
408
105672
46710
1251
29444
12583
386
8496
3918
144
153844
86780
2047
128312
63615
1343
122809
63516
1723
7079
3202
96
50823
20346
529
367706
165344
3694
85696
34117
1042
29699
12391
1071
108848
43575
1525
141031
56421
1983
56207
22128
670
131297
52366
1653
9617
4735
167
63442
109394
9840
4417
31628
20848
56185
43406
40014
75810
26298
57236
30063
7947
143118
270244
83223
20151
105523
323725
15701
33014
88222
22274
10900
14830
71691
155097
55926
42104
6428
127796
65083
28246
22324
2547
21517
4861
114160
8086
45492
24529
4663
16296
55663
32936
29164
28088
47744
5593
2455
10847
10389
24373
21388
17450
32620
21070
21461
14717
3388
56630
113093
38537
8139
40048
143991
7478
6272
35949
11191
5542
6624
33804
61771
24520
17721
3280
56476
28006
18783
9346
1235
13795
2591
69051
3623
18955
9420
2569
7925
22064
10177
13663
793
841
316
93
373
263
943
605
596
1165
568
507
479
136
1456
3486
885
243
1001
3301
337
1193
1161
322
185
205
1224
1704
815
712
156
1769
875
790
308
70
494
111
1618
244
525
472
94
297
847
234
401
329667
17714
84347
43323
53578
76537
188190
103822
8723
231187
16083
5283
34946
53604
4479
58597
14738
7934
88779
35543
73334
4937
14307
53307
43013
21260
29581
160226
3043
21939
17395
26343
36112
156543
239458
56221
45034
46804
2082
17874
102559
36922
322786
196619
68084
35452
24702
128158
7700
45164
17837
28592
33789
86172
58336
4871
100456
7789
2637
23156
34280
2171
22611
7040
4130
43895
13390
47273
3172
7260
22512
20808
14755
13762
72855
1637
9481
6604
11304
18621
58378
100322
18421
24427
22395
1533
7685
47925
15160
170956
81345
30310
18210
12706
3928
198
1231
545
663
820
2581
1298
126
2534
251
85
432
864
66
556
347
239
973
439
1849
102
262
885
549
611
330
1471
75
262
328
377
575
1916
2620
571
703
535
160
202
1330
370
3123
2745
815
576
502
50850
4861
55313
343160
275305
2435
180781
104009
31187
13706
6885
155709
80088
27911
26229
143322
27683
36847
27790
12990
48914
48855
6148
176241
173817
62703
41680
6584
38863
131696
43490
84731
39452
71806
26355
14183
15241
38483
148287
54167
118076
6026
6390
80866
31770
241842
56095
35000
2032
24742
188865
147417
1053
83474
55542
15242
5352
3841
78535
43948
17394
12487
72409
17784
10861
14969
7256
23004
24584
2917
86574
80414
38412
16082
4779
16583
70732
25993
28639
11190
39192
10272
7723
6424
11568
54588
21347
51986
3084
2695
30372
10260
98138
21266
808
50
728
4087
3012
68
3090
1358
576
284
145
2312
1124
336
415
1779
338
453
437
261
609
647
61
2074
2232
948
409
153
741
1625
538
789
395
956
362
144
229
396
2256
731
1477
102
106
939
392
3516
785
43977
23025
31366
97659
96458
46491
39836
17257
168045
79859
15321
58247
4565
21292
9410
18090
42580
45898
21744
20671
7425
78118
33639
8878
25018
2228
607
273
630
1379
1108
583
514
216
1593
1055
399
834
104
Statistics Concepts and Descriptive
QNT/561 Version 9
University of Phoenix® is a registered trademark of Apollo Group, Inc. in the United States and/or other countries.
Microsoft®, Windows®, and Windows NT® are registered trademarks of Microsoft Corporation in the United States and/or other countries. All
other company and product names are trademarks or registered trademarks of their respective companies. Use of these marks is not intended
to imply endorsement, sponsorship, or affiliation.
Statistics Concepts and
Descriptive Measures
Edited in accordance with University of Phoenix® editorial standards and practices.
2
Statistics Concepts and
Descriptive Measures
Individual Assignment: Statistics Concepts and Descriptive Measures
Purpose of Assignment
The purpose of this assignment to orient students to the key concepts in statistics. This assignment will
introduce students to the language of statistics. Students will also get a chance to warm-up on evaluating some
basic descriptive statistics using Excel prior to the course start.
Resources Required

Microsoft Excel®
Statistics Concepts and Descriptive Measures Data Set
Content
This assignment has an Excel® dataset
required to do one of the three datasets only
and submit.
Hospital Excel® Data Set.
Note: you have to work on only ONE dataset
and not ALL.
Answer each of the following in a total 90
words:

For each column, identify whether the
data is qualitative or quantitative.
Identify the level of measurement for the
data in each column.
For each column containing quantitative
data:
o
o
o
o

Evaluate the mean and median
Interpret the mean and median in
plain non-technical terms
Use the Excel =AVERAGE function to
find the mean
Use the Excel =MEDIAN function to
find the median
For each column containing quantitative
data:
o
o
Evaluate the standard deviation and
range
Interpret the standard deviation and
Met
Partially
Met
Not Met
3
Statistics Concepts and
Descriptive Measures
Content
o
Met
Partially
Met
Not Met
Total
Available
Total
Earned
3
#/3
Partially
Met
Not Met
Total
Available
Total
Earned
2
#/2
5
#/5
range in plain non-technical terms
Use the Excel =STDEV.S function to
find the standard deviation
For range (maximum value minus the
minimum value), find the maximum
value using the Excel =MAX function
and find the minimum value using the
Excel’s =MIN function
Writing Guidelines
Met
The paper—including tables and graphs,
headings, title page, and reference page—is
consistent with APA formatting guidelines and
meets course-level requirements.
Intellectual property is recognized with in-text
citations and a reference page.
Paragraph and sentence transitions are
present, logical, and maintain the flow
throughout the paper.
Sentences are complete, clear, and concise.
Rules of grammar and usage are followed
including spelling and punctuation.
Assignment Total
#
4