Data Analysis for Business

profilemom166
Assignment111.xlsx
Home>Business & Finance homework help>Data Analysis for Business

State Populations

State Population
Alabama 4.8
Alaska 0.7
Arizona 6.4
Arkansas 2.9
California 37.3
Colorado 5 Class info
Connecticut 3.6 # of classes class width range
Delaware 0.9 8 4.6 .6-37.3
Florida 18.8
Georgia 9.7
Hawaii 1.4
Idaho 1.6 population
Illinois 12.8
Indiana 6.5
Iowa 3.0
Kansas 2.9
Kentucky 4.3
Louisiana 4.5
Maine 1.3
Maryland 5.8
Massachusetts 6.5
Michigan 9.9
Minnesota 5.3
Mississippi 3
Missouri 6
Montana 0.9
Nebraska 1.8
Nevada 2.7
New Hampshire 1.3
New Jersey 8.8
New Mexico 2
New York 19.4
North Carolina 9.5
North Dakota 0.7
Ohio 11.5
Oklahoma 3.8
Oregon 4.3
Pennsylvania 12.7
Rhode Island 1
South Carolina 4.6
South Dakota 0.8
Tennessee 6.3
Texas 25.1
Utah 2.8
Vermont 0.6
Virginia 8
Washington 6.7
West Virginia 1.9
Wisconsin 5.7
Wyoming 0.6

AP Test Results

Correct
112
73
126
82
92
115
95 Class info
84 # of classes class width range
68 5 15 68-142
100
72
92
128
104
108 population
76
141
119
98
85
69
76
118
132
96
91
81
113
115
94
97
86
127
134
100
102
80
98
106
106
107
73
124
83
92
81
106
75
95
119

FreqData

Data
14
19
24
19 Class info
16 # of classes class width range
20 5 4 10 - 29
24
20
21
22
24
18
17 Population
23
26
22
23
25
25
19
18
16
15
24
21
16
19
21
23
20
22
22
16
16
16
12
25
19
24
20

CorpRevenue

Corporation Revenue
Amerisource Bergen 71
Archer Daniels Midland 70
AT&T 124
Bank of America 113 Class info
Berkshire Hathaway 108 # of classes class width range
Boeing 61 9 12 42-149
Cardinal Health 91
Caterpillar 51
Chevron 263 some data are outside the range for the frequency distribution
Citigroup 112 make a notation of this using an "*" to denote that not all the data is accounted for in the
ConocoPhillips 231 frequency distribution.
Costco Wholesale 72
CVS Caremark 87
Dell 61
Dow Chemical 58 Sample
Exxon Mobil 443
Ford Motors 146
General Electric 149
Goldman Sachs 54
Hewlett-Packard 118
Home Depot 71
IBM 104
JPMorgan Chase 101
Johnson & Johnson 64
Kroger 76
Lowe's 48
Marathon Oil 74
McKesson 102
Medco Health 51
MetLife 55
Microsoft 60
Morgan Stanley 62
Pepsico 43
Pfizer 48
Procter & Gamble 84
Safeway 44
Sears Holdings 47
State Farm Insurance 61
Sunoco 52
Target 65
Time Warner 47
United Parcel Service 51
United Technologies 59
UnitedHealth Group 81
Valero Energy 118
Verizon 97
Walgreen 59
Walmart 406
WellPoint 61
Wells Fargo 52

MarathonAges

Age
49
44 Class info
50 # of classes class width range
46 13 4 21-72
31
27
52
72 sample
33
46
52
24
43
44
43
26
40
57
43
30
50
35
66
59
37
55
64
37
36
31
31
21
56
32
40
43
61
43
50
47

NBAPoints

1 LeBron James, MIA 27.0
2 Kevin Durant, OKC 28.8
3 James Harden, HOU 26.4 Class info
4 Kobe Bryant, LAL 27.1 # of classes class width range
5 Russell Westbrook, OKC 22.9 6 3 11.2-29.1
6 Carmelo Anthony, NY 28.4
7 David Lee, GS 19.2
8 Stephen Curry, GS 21.0
9 LaMarcus Aldridge, POR 20.8 Sample
10 Paul George, IND 17.6
11 Tony Parker, SA 21.1
12 Jrue Holiday, PHI 19.2
13 Dwyane Wade, MIA 21.2
14 Nicolas Batum, POR 15.5
15 Josh Smith, ATL 17.2
16 Al Horford, ATL 16.7
17 Al Jefferson, UTA 17.6
18 Blake Griffin, LAC 18.5
19 Paul Pierce, BOS 18.3
20 Damian Lillard, POR (Rookie) 18.3
21 Kyrie Irving, CLE 23.3
22 Dwight Howard, LAL 16.4
23 Brandon Jennings, MIL 18.9
24 Luol Deng, CHI 16.5
25 Deron Williams, BKN 17.0
26 Joakim Noah, CHI 11.7
27 Zach Randolph, MEM 15.7
28 Rudy Gay, TOR 18.0
29 Kemba Walker, CHA 17.7
30 Chandler Parsons, HOU 14.6
31 Greg Monroe, DET 15.7
32 David West, IND 17.2
33 Monta Ellis, MIL 18.2
34 O.J. Mayo, DAL 17.5
35 Marc Gasol, MEM 13.6
36 Ty Lawson, DEN 16.3
37 Chris Paul, LAC 16.2
38 Greivis Vasquez, NO 13.6
39 Chris Bosh, MIA 17.1
40 Tim Duncan, SA 16.7
41 Joe Johnson, BKN 17.0
42 DeMarcus Cousins, SAC 17.3
43 DeMar DeRozan, TOR 17.5
44 Evan Turner, PHI 14.0
45 Danilo Gallinari, DEN 16.9
46 Klay Thompson, GS 16.3
47 Paul Millsap, UTA 15.1
48 Nikola Vucevic, ORL 12.3
49 Brook Lopez, BKN 18.7
50 George Hill, IND 14.6

SATScores

SAT Scores
1665
1275 Class info
1650 # of classes class width range
1590 8 150 938-2137
1475
1490
1525
2135 Sample
1560
1880
1680
1560
1355
1280
1150
1420
1440
940
1645
1060
1485
1755
1260
1390
1780
1585
1990
1375
1730
1175

StartUps

Amount Raised (in Millions)
$81 Class info
$80 # of classes class width range
$69 11 24 14-277
$73
$192
$91
$47
$154 Sample
$48
$54
$61
$51
$119
$50
$18
$272
$24
$72
$118
$112
$103
$130
$81
$110
$54
$58
$57
$38
$40
$129
$166
$77
$60
$21
$49
$54
$78
$131
$49
$156
$168
$78
$20
$60
$63
$40
$78
$52
$55
$31

LowTemp

State Average Low temp
Georgia 53
Texas 59
Maryland 45 Class info
Alabama 53 # of classes class width range
Massachusetts 44 9 4 35-70
New York 40
North Carolina 49 Population
Illinois 41
Ohio 43
Ohio 43
Ohio 44
Texas 57
Colorado 36
Michigan 42
Connecticut 40
Texas 60
Indiana 44
Florida 58
Missouri 48
Nevada 59
California 56
Kentucky 49
Tennessee 54
Florida 70
Wisconsin 40
Minnesota 37
Tennessee 49
Louisiana 61
New York 48
Oklahoma 51
Florida 63
Pennsylvania 47
Arizona 63
Pennsylvania 42
Oregon 45
Rhode Island 43
North Carolina 50
Virginia 48
California 53
New York 39
California 48
Utah 42
Texas 59
California 58
California 51
California 50
Washington 46
Missouri 48
Florida 65
Virginia 52
DC 50

AvgSnowFall

State Average Snowfall Class info
Georgia 2.9 # of classes class width range
Texas 0.6 8 12.5 0-99.9
Maryland 20.2
Alabama 1.6
Massachusetts 43.8 Population
New York 94.7
North Carolina 4.3
Illinois 36.7
Ohio 11.2
Ohio 68.1
Ohio 27.5
Texas 1.5
Colorado 53.8
Michigan 42.7
Connecticut 40.5
Texas 0.1
Indiana 25.9
Florida 0
Missouri 13.4
Nevada 0.3
California 0
Kentucky 12.5
Tennessee 3.8
Florida 0
Wisconsin 46.9
Minnesota 54
Tennessee 6.3
Louisiana 0
New York 25.1
Oklahoma 7.8
Florida 0
Pennsylvania 22.4
Arizona 0
Pennsylvania 41.9
Oregon 3
Rhode Island 33.8
North Carolina 3.9
Virginia 10.3
California 0
New York 99.5
California 0
Utah 56.2
Texas 0.7
California 0
California 0
California 0
Washington 5
Missouri 17.7
Florida 0
Virginia 5.8
DC 14.5