please see attached

References

Black, K. (2017). Business Statistics: For Contemporary Decision Making, (9th Edition). Hoboken, NJ: Wiley.

You may submit this assignment in an Excel spreadsheet, or in Word. Make sure you show your calculations and follow APA format (i.e. in-text citations; Reference page; headings; etc.)

Download the Statistics Concepts and Descriptive Measures Data Set.

Choose one of the following datasets to complete this assignment: (hint: you will use the same dataset for the Signature Assignment due Week 6)

Consumer Food

Financial

Hospital

Answer 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 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:

Evaluate the standard deviation and range

Interpret the standard deviation and 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

2

>Consumer Food

= NE 2 = MW

= S

= W

9

0

1 1

9

1 1

7

06

9

1 1

2

9

1 1

8

1 1

6

0

9

1 1

9

4

1 1

7

4

6

1 1

4

4

5

5

1 1

14

5

1 1

0

8

05

7

1 1

22

5

8

1 1

05

684

06

1 1

2

1 1

8

1 1

0

3

76

1 1

14

1 1

67

55

3

1 1

5

4

83

07

1 1

94

0

14

1 1

1 1

7

1

5

1 1

1

69

1 1

19

87

1 1

952

1 1

6

1 1

08

4

87

1 1

7

51

1 1

40

2

0 1 1

6

57

1 1

83

6

6

1 1

9

26

4

9

1 1

79

928

0 1 1

77

24

1 1

1 1

0

1 1

38

19

1 1

28

0

1 1

2

3

1 1

00

2

1 1

1 2

2

1 2

6

1 2

8

1 2

43

1 2

09

1

1 2

1 2

81

74

1 2

33

33

8

1 2

1 2

47

1 2

4

55

1 2

52

1 2

3

1 2

5

1 2

31

1 2

3

1 2

553

1 2

6

1 2

62

7

1 2

9551

34

57

2 1

43

2 1

2

7

2 1

0

32

2 1

2 1

36

0 2 1

6

2 1

79

70

2 1

2 1

9

11

2 1

7204

2 1

2 1

2

3

2 1

3

8

0 2 1

1

45

2 1

2 1

2 1

2

2 1

7

2 1

44

22

2 1

3

68

2 1

23

2 1

23

2 1

1

09

2 1

1

1

2 1

9

0

2 1

2 1

9

9

65

2 1

2 1

2 1

6

2 2

97

146 2 2

2 2

02

2 2

0

2 2

6

7

22

2 2

2 2

68

9

2 2

2

2 2

7

2 2

2

2 2

4

2 2

2 2

2 2

12

2 2

3 1

1

6

5

3 1

63

3 1

9522

8

3 1

0

05

8

3 1

3 1

3 1

3

1

3 1

9

3 1

55

817 3 1

7

1

3 1

31

3 1

3 1

3 1

81

3 1

6

0

3 1

79

3 1

7

3 1

9093

69

3 1

3 1

13

3 2

4

3 2

9286

31

3 2

1

3 2

79

3 2

4

6

2

3 2

3 2

3 2

9

1

3 2

47

7

3 2

5188

41

3 2

89

3 2

3 2

90

4

3 2

6

3 2

240 3 2

0 3 2

3 2

6

8

3 2

9

0 3 2

7

5

4 1

5

4 1

4 1

4

4 1

30

4 1

7

4 1

8185

24

4 1

9

4 1

3

52

4 1

25

94

4 1

63

36

5

4 1

02

7

4 1

7436

6

4 1

2

4 1

25

4 1

4 1

4 1

2

4 1

4 1

4 1

32

4 1

4 1

4 1

9

89

4 1

31

4 1

89

4 1

6426

4 1

96

5839 4 1

4 1

7

4 1

2

84

4 2

7

4 2

4 2

4 2

4 2

1

4 2

4 2

8

4 2

4 2

4 2

4 2

62

4 2

3

4 2

8

90

4 2

4 2

1

7

4 2

4 2

3

4 2

4 2

4 2

4 2

4 2

4 2

4 2

9908

4 2

Annual Food Spending ($)	Annual Household Income ($)	Non mortgage household debt ($)	Region:																																																																																																																																																																																																																																																																																																																																																																																																																																																																																												1																																																																																																																																																																					3																																																																																					4	Location: 1 = Metro 2 = Outside Metro
		8			9																																																																								0																																					5																																					6					69																																	7			23				18
					56			84			35		45					70		52
			10	5		26	87							16					14
14				11	7						40	41				21			83
			13	55	6				31				82	1			88				66
			15				19				79				64	2	1	89
26		94				25	81	8			77
9			12	5	7		42	15			76
13				51		7	20					27			68
				63	3								80				46	8			54
76			22	5				24									28
						43	4				140	6			99
			38					29					48
66				74				49	246	13			59
			73						47			414			91		408
2911	2		67	1	58
8026	48	7			53				167
				85		555	16					78
10			34					71		214
			86							50		98			191
8821	46403	7	8								17
8678	51	92				1		44
14		33		847	17	2	95
			96	5	90				62		166
	9		286		57			141				61
	820	58	355	19		538
		164	8				169			151
12		75	6	9522			146
		177	9	613
77		39	5	779			220
				153	8	827			189
	457				32	7		97
	116				65
		128		699			273			30
16	232	91			108	9876
9621	5	407	1	9908
8		171	4		72		178
		121	77	427	3	134
	864	59805			496
			124						60		334		663
9				185	54				114	185				93
7862	40680	1	520
9	775	58		263		148
6771	5	200	21	713
3059		396	12				179
13	211		703	1	322
7408	46450	5	602
			115	76140		338
			142		808	1		147
3				352	31899	2	762
2	630			216	2663
	9093	6	592				113
				126	65	923	5	132
9559	62811	1		261
6				112	4			233	3					149
			104	65134		15	196
12630	64621	2		143
4578			36		5	502
	9551	62910	1	1		37
				102	70727	1		328
		576		118
		101	56	549	16		136
8955	5	966	1	162
10		197	5	735				184
11	234	56		447	10871
9	320		611
9089	5		152	4902
1	2	300		799			172
11484	66733	15			145
11	215	7	535			156
40795	8975
5579	39128	6576
			117	75482	12	508
	935	6	399
		776		458	6		671
4261	38	223	8576
9830	66787	1178
12	386	7	785	936
8673	55825	1	416
				109			570	9018
9910		6426				127
9928	75881			174
4	264	34343		213
	797	41			243		210
8290	5	302		2015
	1266	66991		925
7272	49719	20	838
9784			583								160
9		187	50477	9407
5866	39112	20	409
9	456		5	188	11668
6270					347
9518	62348	5201
10968	78704				170
8865	5	362	32004
	922	5		157			159
4913	34761	17704
6976		609		1779
		815	51281	8167
	288	25013	18763
	806	59238	10815
8895	47	344	1					181
8	444	52645	22469
	6148	35309	17			139
4563	34355					106
	8185	50630	21187
			339	2	905	1	573
	7436	48721		183
50459	1	647
1				129		728	2				123
10403	56		954	22218
4693	39343	24696
5	626	3	883	1	437
1				186	55021	35576
		130	77	605
8783	5		793	1	859
13031	63343		255
3681	36		479	17950
5549	40381	14	257
4108	26309		265
314	4	1421	2	247
	7700			545	29065
7479	40551	3			175
	503	6	404
9863	54422	24334
8043	51836				262
9552	73600	3	637
51873			296
7987	48003		1726
3	875	36519		135
		107	7	515	10659
6888	44974	23711
5479	48923	4594
6949	4	376	2			122
10650		759	3	335
41423		336
5	311		401	17791
4691	36772	5829
8056		596	1	959
	11304	53654	2		306
8112	59067
8696	65962
5869	37		254	10157
	377	3	356	14143
1	182	56934
	1	308	88822	1	756
10986	5	963	27863
5762	38407	18867
1	1	617	78627		1189
9895	47	710		229
16293	64443	3				168
58871		354
13	972	87954	1			154
	1124	54778			125
4635		398					194
							100		495	1			219
	8426			601	1	378
49139	2	235
11747	5				105	4553
15397	70500				120
6842	54894	16217
9678	60570	4106
1	285	57625	31			228
10114	56	956	25907
	8496	61400	1093
6689		505	17106
	15696	72774	17793
9	841	69981	21		607
	1252	66891		176
10210		674	19	995
8	868	64782				144
38987	17864
	110	64867
10086	50421	8689
		258	27076	17534
1	249	51784		202
8456	54135	2		203
6801	53291	23			342
6339	49804	34	943
7802	52	205	28579
9717		7	284	22349
	6026	46238	20		165
5618	45938		1053
10217	77716	18	516
8338	59711	7980
9048	42106	19786
4017		364	9935
10906	5	340	18177
1	514		712	6696
8830	66759	20972
		848	57616		2876
1	1358	76221	1	373
	1055	78202	5920
6969	55164	24795
	13219	61171	21482
3543	3	4093	25969
7	326	50647	10750
8458	59898	22940
11766	52884	25970
73629	7112

Financial

6

2

4

2.08

3

19

6

6

1

6

7

0

0.2

0.6

6

7.1

9

3 1.4

4

1.4

7

6

1.4

2

6.1

7

1.1

7

72

22

3.8

3.8

5

6

9

2.6

5

2.3

5

7

2

1

775

0.1

3 954

2.4

0.9

7

0

3

6

8

2 1.1

3

8

1.8

1

18

1.2

1

0.4 0.16

3

8

2

7.7 3.6

3

1.2

2

53

2.08 2.1

2

8

3

16

3

1

12.3

1

2

6.1 0.33

3

4.2

1.8

6

12.3

0.2

7

1

0.5

7

2.8

3

9

9

12.2

3.7

1

1.3 0.7 0.2 22

2 966 613 228

1.1

4

7.9 1.18 2.4

4

2

6.9

1.2

2

1

1.3

3 179 326 8.3

14

4 3226

1.4 1.5

2

1

47

2.2 1

3

8 1.66 6.6 1.5

6

14.5

2.3 1.04 13.3

5

1.5

24.1

6

1.8

1

1

10.6

2.3

26.7

6

0.4

3.1

2

19

2.6 1.01 14.5

7

9

3.9 0.9

5

8

1.7

16

1

2.4 1.2 16.2

5

11 1.59 1.2 0.5 26

1

7.9

2.1 1.19 16.3

5

37

1.7

2

6

12.6 2.47 2.9 0.6 8.3

7

3.1

2

4

7.2 0.48 1.1 0.5

2

2805 12.3

1 0.36

7

12.3

2.6

18

5 555 848

0.9 0.16 22.4

2

1

25 2.1 2.6 1

3 799

6.8 1.6

3 2587

4.1 0.9 14.4

2

3 2.8 1.2 14.5

6

16

1.5 0.6

5

713 9.4 0.6 1.4

3

5.2

1

7.7 2.1 3.8

26.9

7

6

1.6 1 17.1

5

6

27.9 1.7 1.1 0.68

5

80

5.8

3.1 1.08

7

3

6 129 194

1.48 1.5 0.35 16.3

2

2.3

3

11.4 1.8 7.7

12

6

0.3

17

2

0

2.13 2.2

13.4

4 2300 885

1.8 0.32 17

5

1.5

1

0

0

1.8

17.4

5 980

20.5

0.3

7

18 2.7 2.8 1 13

6

14.7 1.8 0.9 0.3

7

3.1

11.5

1

1.75 0.6

6

2.39 1.7

14.2

7

0.8 0.24 23

6

0.9 0.4 17

7

9.5

3.5 1.1

2

1.6 0.79

5 1172 1726 7.5

0.5 0.16 29

7 6064

2 0.8

6

1.3

17

7

4

12.6

2.4

19.8

7

9.6

1.2

17.2

5

1.04 1.4

4

972 9.2

3

2

4.8

1.8 0.35 20.5

4 13219

2.7

27.2

2

14

2.9

6 601 1252 7.8 1.57 3.7 1 17

Company	Type	Total Revenues	Total Assets	Return on Equity	Earnings per Share	Average Yield	Dividends per Share	Average P/E Ratio
AFLAC	7	251	29454	1	7.1			2.08							0.9				0.2		1						1.5
Albertson’s	14690	5219	2						1.4				1.6						0.6
Allstate	20106	80918	2	0.1		3.5					0.3		10.6
Amerada Hess		834	7935	0.08							1.1	69		8.3
American General	3362	80620					2.1	2							1.2
American Stores	19139	8536		1		2.2		1.01	0.34	23.5
Amoco	36287	32489	16.7			2.7					3.1	1		6.1
Arco Chemical	3995	4116	6.2	1.14				2.8	4			0.4
Ashland	14	319	7777		9.5				3.8					2.3	1				2.4
Atlantic Richfield		192			253	2								1.8	5.41	2.83
Bausch & Lomb		1916	2773			0.8					2.6			1.04
Baxter International	6				138	8707	11.5	1.06	1.13	4	7.2
Bristol-Myers Squibb	16	701		1497	44.4	3.14	1.52		2	4.1
Burlington Coat	1777					12.3		1.18	0.02	1		2.9
Central Maine Power	2299				0.16		7.8	7	9.6
Chevron	4	195	35473	18.6	4.95	2.28	1	5.2
CIGNA	14935	108	199	1		3.7		4.8		11.4
Cinergy	4353				885		13.3		1.59	5.1		22.4
Dayton Hudson	27757	14191					1.7		0.33		16.2
Dillard’s	6817	5592		9.2	2.31	15.7
Dominion Resources		767	20	193			7.9	2.15		6.8	2.58	1			7.7
Dow Chemical	20018	24040	2	3.6	3.24	11.6
DPL	1356	3585	1	3.9	5.3	0.91	14.3
E. I. DuPont DeNemours		466	42942	2			1.3	1.23		27.9
Eastman Chemical		467		5778			16.3	3.63	1.76
Edison International	9235	2	510	1.73		4.2	13.6
Engelhard	3631	2586	1.9	0.38	61.8
Entergy	9	562	27001	1.03		6.9	25.4
Equitable	9666	15	1438	2.86					0.5		13.4
Ethyl		1064	1067	53.6		0.7	5.6			12.6
Exxon		137	242	9	6064	1	9.4	3.37	1.63		17.1
FPL Group		636	1		244	3.57	1.92		14.4
The GAP	6508	3338	33.7
Georgia Gulf		2.39		0.32	11.8
GIANT Food	4		231	1522	0.78		26.9
A & P	1026	2995		1.66			0.35	17.8
Great Lakes Chemicals				131	2270	5.5		1.19	0.62	40.5
Green Mountain Power Company		1.57	7.3	1.61
Hannaford Bros.		1227	9.9	0.54	2	6.6
Hercules	1866		241	3.18				14.5
Houston Industries	6873	18		415	13.7
Jefferson-Pilot	2578	23131	3.47
Johnson & Johnson	22629	21	453		26.7	2.41	0.85
Liberty	660	3185	11.1	3.34	0.77	12.7
The Limited	9189		430		0.79		0.48
Lincoln National	4899	77175	0.21	1.96	300.2
Lubrizol	1674	1462	2.66
Lyondell Petrochemical	3010			155	46.2	3.58	6.4
Mallinkrodt	1868		298	14.8		2.47	0.66
May Department Stores	12685	9930			20.5	3.11
McKesson	20857	5608
Mercantile Stores	3144	2178	3.53
Merck				236	25	812	36.6	3.74	1.69	26.6
Millennium Chemicals	3048		432
Mobil	65906	43559	16.8	4.01	2.12		17.2
Monsanto	7514			1077	90.7
Morton	2388		1.48	25.2
Murphy Oil	2138	2238	2.94	1.35
Mylan Laboratories	13.5	0.82
NALCO Chemical	1434	441	18.3
Nevada Power	2339	10.1	1.65		14.2
NIPSCO		4937	14.1	1.53
Olin	2410		1946		17.4
Orion Capital	1591	3884	4.15	9.8
Owens & Minor	3117	0.18	21.7
Pacific Corporation	6278	13880		0.68	4.6		1.08	34.2
J. C. Penney	30546	23493		2.13
Pennzoil	2654			440	1	5.8	3.76
Pfizer	12504		1533	35.4
Pharmacia & Upjohn	6710			103	0.61	56.2
Phillips Petroleum	15424	13	860	19.9	3.61	1.34	12.4
Poe & Brown	25.1
PPG	7379	6868	28.5	3.94	1.33		14.7
PP&L Resources	3049	9	485	1.67
Progressive	4		190	7560	18.7	5.31		0.24
Rohm & Haas	3999		390		19.8	0.63
Ruddick	12.5	1.02
Schering-Plough	6778	6	507	51.2	1.95	0.74	24.6
Sears, Roebuck	41296			387	20.3	2.99	0.92
Stryker	985	1.28	0.11		27.2
Sun	10531	4667
Sunamerica	2114	35637	19.5
Texaco	46667	29600	20.9	4.87		1.75
The TJX Companies	7389	2610	26.3	0.09	8.2
Torchmark	2283	10967	1	7.5	0.59
Tosco	13282	5975	10.9	1.37
Travelers	37609	386555	14.9	2.54
Ultramar Diamond Shamrock	10882	5595	1.94	16.1
Union Carbide	6502	6964	28.8	4.53	10.7
United States Surgical Corporation	1.21
UNOCAL	7530	28.9	2.65	15.5
UNUM	4077	13200	15.2	2.59	0.56
USX-Marathon	1	575	10565	1.58	0.76
Valero Energy	5756	2493	2.03	0.42
Warner-Lambert	8			180	8031	30.7	0.51	35.7
WEIS Markets	1819	1.87	0.94	16.9
Wellman	1083	1319	0.97
Winn-Dixie Stores	2921	15.3	1.36	0.98
WITCO	2187	2298	1.55	1.12	24.9
Zenith Nation Insurance

Hospital

Hospital

1 1 2 1 210

107

31

1

2 1 1 1 347 16065

1077

3 1 2 1

356

65

4 1 1 1 142

100

355

328

5 7 1 1 40 905 9

50

168

181

6 4 2 1 220

3

159

7

0

1077

7 4 4 1 137

65

735

19

742

8 4 2 1 80 636 48

1

2768 131

9 1 2 1 440

253

3

2

10 1 1 1 48

21

257

233

11 1 1 1 56

7 27

169

241

12 6 3 1 46

4

30

430

203

13 6 3 1 109 2805 43

0

325

14 6 2 1 306

233

15 6 4 1 7 756 2

211

0

347

16 6 1 1 16 342 11

16

2015 79

17 6 3 1 167 8426 84

505

18 6 2 1 444

219

0

19 6 3 1 236

112

20 6 3 1 247

124

0

75

99

959

21 6 3 1 93

50

325

22 6 2 1 236

142

954

23 6 2 1 220

3

24 6 1 1 228

140

671

25 6 3 1 83 2648 28

300

26 6 2 1 273

154

753

27 6 2 1 225

3

607

28 6 3 1 236

144

29 6 3 1 80

42

995

94

354

30 6 2 1 78 7761 77

408

31 5 2 1 197

32 5 2 1 60

27

503

386

33 5 2 1 31

15

126 8496

144

34 2 2 1 264

179

35 2 2 1 246

175

36 2 2 1 556

37 1 3 2 56 860 32 5778 0

96

38 1 2 1 120 5502 74

0

39 1 1 1 674

414

44

40 1 2 1 414

253

1074

41 1 3 1 320

180

1421

1

42 1 1 1

184

762

5

43 1 2 1 344

243

44 1 2 1 168

115

496

670

45 1 1 1 315

215

3

1653

46 1 3 2 88

48

0

167

47 1 3 1 245

124

793

48 1 2 1 311 15196 189

4

841

49 1 1 1 233

181

113

50 1 1 1 46 812 9

0

93

51 1 3 1 103

28

0

373

52 1 2 1

288

173 20848

263

53 1 1 1 186

108

1064

943

54 1 2 1 177

154

04

759

605

55 7 2 1 149

76

1

596

56 7 3 1 286

165

57 3 1 2

508 295 0 0

568

58 3 3 1 242

101

1

0

507

59 3 2 1 128

69

8

7

479

60 3 2 1 33 925 12

99

7

136

61 3 2 1 255

185

62 3 2 1

378

63 3 2 1 191 9899 114

1308

885

64 3 3 2 60

49

0

243

65 3 2 1 155

106

66 3 2 1 626

91

67 3 2 1 105 1456 43

126

337

68 3 4 1 59

29

556

69 3 2 1 258

125

70 3 2 1 47

17

415

322

71 3 1 1 22

10

216

185

72 3 3 1 53

14

339

205

73 3 1 1 244

1

173

4

74 3 2 1 352

207

7

75 3 2 1 366 7284 223

815

76 3 2 1 194

82

520

712

77 3 1 1 109 458 64

35

156

78 3 2 1 285

139

79 3 2 1 175 8080 109

793

875

80 3 1 2 342

298 0 0

790

81 3 3 1 140 2876 52

0

4

308

82 3 1 1 50 404 34

14

70

83 3 1 2 214 794 168 0 0

5

494

84 3 3 2 80 746 21

0

111

85 1 4 1 467

2

390

0

86 1 1 1 80 823 47

0

244

87 1 2 1 160

80

776

525

88 1 3 1 106 3870 50

451

89 1 3 2 40 859 113

0

9

94

90 1 2 1 99

45

145

7925 297

91 1 1 1 133

76

847

92 1 3 1 138

129

1

234

93 2 2 1 88

60

319

401

94 2 2 1 573

418

1

95 2 2 1 44 1497 17

295

7700 198

96 2 2 1 225

138

496

1231

97 2 2 1 105

64

589

545

98 2 2 1 100

62

806

663

99 2 1 1 186

131

701

9

820

100 2 2 1

265

101 3 4 2 485 4112 456

0

102 3 2 2 64

40

0

126

103 3 1 1 495

310

104 3 3 1 114 538 72 0 0

251

105 3 3 2 62 883 19

0

85

106 3 4 1 149

112

0

432

107 3 1 2 427 592 375 0 0

864

108 3 3 2 40

15 0 0

66

109 3 2 1 129

78

556

110 3 1 1 149

123

169

347

111 3 2 1 71 617 54

66

239

112 3 2 1 256

96

827

973

113 1 3 1 153

82

570

439

114 1 1 2

0

115 1 1 1 70

30

0 4937

102

116 3 1 2 69

56

0

262

117 3 4 1 71

36

342

885

118 3 3 1 243

127

494

549

119 3 1 2 206

180 0 0

611

120 3 4 1 62

59

0

330

121 5 2 1 219

127

0

1471

122 5 1 1 54 143 37

0

7

75

123 5 4 1 24

13

286

1

262

124 5 2 1 151

100

235

328

125 3 3 1 160

47

9

339

11304 377

126 3 1 1 262

194

398

2

575

127 3 2 1 296

172

1916

128 5 3 1 671

516

2620

129 5 3 1 184

120

571

130 5 1 1 249

179

714

703

131 2 4 1 157

140

0

535

132 2 3 2 100 510 78 935 0

1533 160

133 2 3 2 100

68

0

202

134 2 2 1 375

186

779

135 2 2 1 123 4093 91

0

370

136 2 1 1 457

340

137 5 1 1 263

254

138 5 2 1 160

108

1071

815

139 5 2 1 69

61

352

576

140 2 2 1 153 3611 174

254

502

141 2 1 2 260 163 306

0

00

808

142 2 3 2 34 213 28 0 0 4861

50

143 2 2 1 479

395

699

728

144 2 2 1 973

923

145 2 1 1 440 21004 335

146 1 2 1 51 111 46

0

1053 68

147 1 1 1 347

316

148 1 4 2 612 3378 416

0

1358

149 1 1 1 141

74

339 31187

576

150 1 2 1 115 2030 86

130

284

151 3 2 1 50 944 38

91

145

152 3 2 1 261

147

2312

153 3 4 2 334

232

0

1124

154 3 1 2 228 515 138 0 0

336

155 3 2 1 85

38

509

415

156 3 2 1 357

245

1026

1779

157 3 1 2 189

171 0 0

338

158 3 3 1 139

51

447

453

159 3 4 1 60

28

1161

437

160 3 1 2 164

797

0

261

161 7 2 1 105

56

922

609

162 7 1 1 114

69

562

647

163 7 1 1 73 568 40

78 6148 2917 61

164 7 4 1 314

163

0

165 7 2 1 350

231

2232

166 2 1 2 602 570 523 0 0

948

167 2 4 1 74

31

0

409

168 2 2 2 53

43 848 0 6584

153

169 2 2 1 152

66

710

741

170 2 2 1 317

231

1165

171 1 4 1 43 1438 11

466

538

172 1 3 1 269

144

1106

789

173 1 3 1 79

43

376

11190 395

174 3 4 1 181

185

0

956

175 3 2 1 122

82

637

362

176 1 2 2 65

49

0

144

177 1 3 1 97

24

352

229

178 1 3 1 169

63

447

396

179 1 2 1 407

274

1227

180 1 3 1 160

93

963

731

181 1 4 1 117

86

182 1 3 2 80 1266 28

0 6026

102

183 1 3 2 100 767 25

0

106

184 1 3 1 370

181

868

939

185 5 3 1 123

39

1189

392

186 5 1 1 380

302

3516

187 5 2 1 149

80

785

188 5 2 1 112 7260 63

2171

607

189 2 2 1 61 2730 31

364

273

190 2 2 2 219

170

0

630

191 1 1 1 260

203

1379

192 1 2 1 350 12132 296

0

193 1 3 1 121

83

583

194 7 2 1 206

84

601

514

195 7 1 1 70

29

387

216

196 7 2 1 334 15696 187

1946

197 7 2 1 190

77

545

1055

198 5 1 2 122 441 104 0 0

399

199 5 1 1 170

85

838

834

200 5 1 1 73 352 47

51

104

Geog. Region	Control	Service	Beds	Admissions	Census	Outpat. Visits	Births	Tot. Exp.	Payroll Exp.	Personnel
7713	86982	312			568	2		206	792
		198	149222	127223	55799	1762
511	23028	2		225	1027	157093	61326	2	310
4338	36710	24462	10503
		133	13730	6368
1			556	88721	3810	9		325	3	392
5347	188885	45458		269
10209	6151
15954	77343				173		9899	40956	1594
1827	33977	11569	5664
161	1	7925	11356	5084
	295	27170	15200	7085
30263		20848	9709
9871	43128	2049	62778	28958	676
96000		2030	12300
7217	3836
66073		2648	41417	20633
18258	170223			245	144966	61667	1543
8280	31022	1465	67997	31285	755
5449	44425		1231		418
5247	29551	1993	28318	12	589
11301	90178	2275	8	8080	32191
9466				111	172146	1		494	10	731	38668	1091
10444	95649	1313	116486	49017
15507		451	20625	3009
9249	51102	1689	67519	28066
7763		150	91654		158	60080	21	944
10688	68482	2017	94401	38757	929
6671	35221			260	13464
37		370	2045	38825	15951
9553		119	153994	1686	105672	46710	1251
	2730	16060	29444	12583
1112	36735	3918
13		395	267091	2026	153844	86780	2047
12264	140152	1412	128312	63615	1343
12811	461	68	330	1517	122809	6	3516	1723
7079	3202
36461	50	823	20346	529
26547	294682	2719	367706		1653	3694
12260	81885	85696	34117	1042
4147	47636	29699	1	239		1071
	315	12804	92458	108848	4	357	1	525
16539	185313	3194	141031	56421	1983
7566	66309	56	207	22128
15853	9	337	1442	131	297	52	366
2662	6533	9617	4735
8733	78773	1107	63442	28088
115155	2989	10	939	47744
1466	18659	9840	5593		316
11519	4417	2455
	2312	30661	31628	10847
331	2305	35600	10389
10541	76176	56185	24373
4469		571	43406	21388
5994		11190	1	317	40014	17450
11142	173393	1751	75810	3	2620		1165
488	26298	21070
5682	3	746	57236	21461
5511	3	789	714	30063		1471
24679		794	3388
13780	146454	2243	143118	56630		1456
481	28390	796525	3966	270244	113093	3486
85986	83223	38537
1247	35955	20151	8139
9893	192386	2514	105	523	40048	1001
31452	460	236900	3714	323725	1	439	3301
47152	15701	7478
4706	292105	33014	6272	1193
9950	1	21004	1327	88222	35949		1161
1940	45057	22	274	11191
1241	31833	10900	5542
1475	43357	14830	6624
		973	103595	1217	71691	3	380	1224
14974	110754	2641	15	509	61771	1704
181430		790	55926	24520
5356	48413	42104	17721
26770	6428	3280
11624	599315	1168	127796	56476	1769
200048	65083	28006
1259	28246	18783
3192		2232	9346
13468	2547	1235
21517		1379
10074		4861	2591
	612	179676	114160	69051	1618
10409	8086	3623
	6584	91769	45492	18955
53424	24529	9420	472
2251	4663		256
3313	30814	16296
6306	172253	1284	55663	22064
2764	17907	32936	10177
	4112	85800	29164	13663
26392		12132	2154	329667	128158	3928
35357	17714
8187	89248	84347	45164
6251	103225	43323	17837
5335	172105	53578	28592
8184	87453	76537		3378
		375	21169	331478	3968	188190	86172	2581
109270	103822	58336	1298
1785	7749	8723	4871
21327	312733	3655	2	31187	100456	2534
16083	7789
5850	5283	2637
1897	69776	34946	23156
53604	34280
1049	4479		2171
9507	64109	3063	58597	22611
1589	13721	14738	7040
48469	7934	4130
7203	107440	88779	43895
6156	4170	35543	13390
1297	1407		1106	5551	73334	47273	1849
1609	14630	3172
1666	6376	14307		7260
3477	238060	53307	22512
5667	161912	43013	20808
1499	21260	14755
1256	68886	29581	13762
9275	42058	160226	72855
3224	3043				163
1503	105101	21939		948
1764	27889	17395	6604
3228		2917	26343
3689	57144		3611	18621
14018	139	741	1275	156543	58378
37375	119462	5699	239458	100322
7699	53313	1364	56221	18421
7931	88869	45034	24427
2018	102547	46804	22395
2082
2271	13405	17874	7685
11821	184144	102559	47925	1330
36172	36922	15160
16987	304839	2202	322786	170956	3123
19776	362424	3346	196619	81345	2745
7798	87511	68084	30310
2814	64651	35452	18210
69833	24702	12706
56662	50850			350
2032
4848	262583	55313	24742
24753	339009	2462	343160	188865	4087
550588	3311	275305	147417	3012
1257	2435
19026	287498	4207	180781	83474	3090
129088	104009	55542
4080	54460	15242
32678	13706	5352
14995	6885	3841
10112	86607	1143	155709	78535
4410	109111	80088	43948
27911	17394
3233	67906	26229	12487
14900	279079	143322	72409
1076	27683	17784
4014	59061	36847	10861
3108	202739	27790	14969
1132	42432	12990	7256
7528	98805	48914	23004
6685	27365	48855	24584
11443
8408	289471	176241	86574	2074
17484	196534	2122	173817	80414
62703	38412
1426	85674	41680	16082
1963	4779
5373	65824	38863	16583
14275	162753	131696	70732	1625
287501	43490	25993
11508	172047	84731	28639
4044	83963	39452
3217	169698	71806	39192
2938	65898	26355	10272
3246	51167	14183	7723
2481	62150	15241	6424
5348	64834	38483	11568
16466	134581	148287	54588	2256
6504	30246	54167	21347
12209	813369	3038	118076	51986	1477
3813	3084
5742	6390	2695
8974	53406	80866	30372
4085	56073	31770	10260
16647	31412	2849	241842	98138
8479	209595	1728	56095	21266
163261	43977	21292
59584	23025	9410
2161	14923	31366	18090
13943	138404	2993	97659	42580
100323	96458	45898	1108
7894	85585	1964	46491	21744
4567	107027	39836	20671
2089	24369	17257	7425
102641	168045	78118	1593
6395	244254	79859	33639
15321	8878
7244	167454	58247	25018
9714	4565	2228

Statistics Concepts and Descriptive Measures

2

>Grading Guide

2

Statistics Concepts and Descriptive Measures Grading Guide

QNT/561 Version 9

Applied Business Research and Statistics

Copyright

Copyright © 2017, 2015, 2014, 2013, 2012, 2011, 2010, 2009, 2008 by University of Phoenix. All rights reserved.

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.

Edited in accordance with University of Phoenix® editorial standards and practices.

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

Grading Guide

Content		Met		Partially Met		Not Met		Comments:
This assignment has an Excel® dataset spreadsheet attached. Students will be required to do one of the three datasets only and submit.
Download the Consumer Food, Financial, or 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: · 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: · Evaluate the standard deviation and range · Interpret the standard deviation and 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
	Total Available		Total Earned
85	#/85

Met

Partially Met

Not Met

Comments:

Total Available

Total Earned

 

Writing Guidelines
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.
35	#/35

Assignment Total	#	120	#/120
Additional comments: