Database

profilePramila
DataAnalysiswithStatistics-SeedFile1.xlsx
Home>Applied Sciences homework help>Database

Utility Companies

Company Revenue ($ Billions)
Exelon 23.5
Duke 19.6
AES 18.2
Southern Co 16.5
FirstEnergy 15.3
PG&E 15.0
American Elec 14.9
NextEra Energy 14.3
Dominion Res 13.2
Edison Intl 13.1
PPL 12.3
Con Edison 12.2
Entergy 10.3
Xcel Energy 10.1
PSE Group 9.8
Sempra 9.6
DTE Energy 8.8
NRG Energy 8.4
CenterPoint Energy 7.5
Ameren 6.8

US Oil Refineries

Refinery Location Company Capacity
Baytown, Texas ExxonMobil 675,000
Baton Rouge, Louisiana ExxonMobil 609,000
Texas City, Texas BP 546,750
Lake Charles, Louisiana Citgo 483,500
Whiting, Indiana BP 430,000
Beaumont, Texas ExxonMobil 380,500
Philadelphia, Pennsylvania Sunoco 355,000
Pascagoula, Mississippi Chevron 310,000
Deer Park, Texas Partnership 309,800
Wood River, Illinois WRB 302,000
Port Arthur, Texas Premcor 269,000

Radio Listener Survey

Ages of 229 Radio Listeners Surveyed
33
27 Age Bin Number of Listeners
38 15 – 19
20 20 – 24
28 25 – 29
31 30 – 34
28 35 – 39
54 40 – 44
30 45 – 49
50 50 – 54
25
45
16
39
38
34
28
43
21
33
38
54
39
43
36
17
46
20
29
52
20
36
31
36
35
38
40
32
31
36
47
26
45
36
53
38
31
51
27
35
27
47
31
32
35
42
41
31
31
27
20
37
39
33
44
16
39
28
41
45
25
41
33
32
24
35
34
34
21
44
46
36
35
21
31
40
39
23
21
46
21
30
38
38
34
31
43
33
41
27
45
32
41
31
51
40
34
42
32
41
33
40
26
31
22
42
38
36
43
37
34
25
35
22
33
42
33
47
43
44
43
42
31
47
44
29
16
49
23
38
18
29
33
33
50
47
43
33
40
16
29
34
30
34
30
17
35
32
35
31
27
47
28
46
45
46
21
41
28
38
19
31
49
30
37
32
26
24
26
38
22
36
28
35
33
31
38
26
41
37
54
25
49
41
29
39
53
36
35
19
43
34
20
44
34
38
48
25
38
18
37
38
42
37
46
39
28
47
25
30
26
29
31
35
30
36
29
53
29

Student Data

Class Data
Height (inches) Year in College Intended Major
Student # Sex
1 F 67 3 S
2 M 72 2 P
3 F 70 2 S
4 M 70 1 B Sex Number of Students Percentages
5 F 61 4 P Female
6 F 66 3 B Male
7 M 71 3 H
8 M 67 4 B
9 M 65 3 S Intended Major Number of Students Percentages
10 F 67 3 B Biological Science (B)
11 F 74 3 H Humanities (H)
12 M 68 3 S Physical Science (P)
13 M 74 2 P Social Science (S)
14 F 64 4 P
15 M 69 3 S
16 M 64 3 B Year in College Number of Students Percentages
17 M 72 4 P Seniors
18 M 71 3 B Juniors
19 F 67 2 S Sophomores
20 M 70 4 S Freshman
21 M 66 4 S
22 F 67 2 B
23 M 68 4 S
24 F 71 3 H
25 F 75 1 S
26 F 67 1 B
27 M 68 3 P
28 M 72 4 B
29 F 68 3 P
30 F 66 2 B
31 F 65 2 B
32 F 64 4 B
33 M 72 1 H
34 M 67 4 B
35 M 73 3 S
36 F 71 4 B
37 M 71 3 B
38 M 69 2 S
39 F 69 4 P
40 M 74 4 S
41 M 73 3 B
42 M 68 3 B
43 F 66 2 S
44 M 73 2 P
45 M 73 2 S
46 M 67 4 S
47 F 62 3 S
48 M 68 2 B

Top Box Office Gross

Media Expenditures

Brand Media Expenditures ($M) Shipments in bbls. (M)
Budweiser 120 36.3
Bud Light 68.7 20.7
Miller Lite 100.1 15.9
Coors Light 76.6 13.2
Busch 8.7 8.1
Natural Light 0.1 7.1
Miller Genuine Draft 21.5 5.6
Miller High Lite 1.4 4.4
Busch Light 5.3 4.3
Milwaukee's Best 1.7 4.3

Predicting IPO

Company Shares Price
American Physician 5 15
Apex Silver Mines 9 14
Dan River 6.7 15
Franchise Mortgage 8.75 17
Gene Logic 3 11
International Home Foods 13.6 19
PRT Group 4.6 13
Rayovac 6.7 14
RealNetworks 3 10
Software AG Systems 7.7 13

Stock Fair Value

Company Fair Value ($) Share Price ($)
Air Products and Chemicals 80 98.63
Allied Waste Industries 17 11.02
America Mobile 83 61.39
AT&T 35 41.56
Bank of America 70 41.26
Barclays PLC 68 40.37
Citigroup 53 29.44
Costco Wholesale Corp. 75 69.76
Covidien, Ltd. 58 44.29
Darden Restaurants 52 27.71
Dun & Bradstreet 87 88.63
Equifax 42 36.36
Gannett Co. 38 39
Genuine Parts 48 46.3
GlaxoSmithKline PLC 57 50.39
Iron Mountain 33 37.02
ITT Corporation 83 66.04
Johnson & Johnson 80 66.7
Las Vegas Sands 98 103.05
Macrovision 23 18.33
Marriott International 39 34.18
Nalco Holding Company 29 24.18
National Interstate 25 33.1
Portugal Telecom 15 13.02
Qualcomm 48 39.35
Royal Dutch Shell Ltd. 87 84.2
SanDisk 60 33.17
Time Warner 42 27.6

College Retention

College RR(%) GR(%)
Western International University 7 25
South University 51 25
University of Phoenix 4 28
American InterContinental University 29 32
Franklin University 33 33
Devry University 47 33
Tiffin University 63 34
Post University 45 36
Peirce College 60 36
Everest University 62 36
Upper Iowa University 67 36
Dickinson State University 65 37
Western Governors University 78 37
Kaplan University 75 38
Salem International University 54 39
Ashford University 45 41
ITT Technical Institute 38 44
Berkeley College 51 45
Grand Canyon University 69 46
Nova Southeastern University 60 47
Westwood College 37 48
Everglades University 63 50
Liberty University 73 51
LeTourneau University 78 52
Rasmussen College 48 53
Keiser University 95 55
Herzing College 68 56
National University 100 57
Florida National College 100 61

Jenson Tire

Usage Expense
13 17
10 22
20 30
28 37
32 47
17 30.5
24 32.5
31 39
40 51.5
38 40

NFL

Team Revenue Value
Arizona Cardinals 203 914
Atlanta Falcons 203 872
Baltimore Ravens 226 1062
Buffalo Bills 206 885
Carolina Panthers 221 1040
Chicago Bears 226 1064
Cincinnati Bengals 205 941
Cleveland Browns 220 1035
Dallas Cowboys 269 1612
Denver Broncos 226 1061
Detroit Lions 204 917
Green Bay Packers 218 1023
Houston Texans 239 1125
Indianapolis Colts 203 1076
Jacksonville Jaguars 204 876
Kansas City Chiefs 214 1016
Miami Dolphins 232 1044
Minnesota Vikings 195 839
New England Patriots 282 1324
New Orleans Saints 213 937
New York Giants 214 1178
New York Jets 213 1170
Oakland Raiders 205 861
Philadelphia Eagles 237 1116
Pittsburgh Steelers 216 1015
San Diego Chargers 207 888
San Francisco 49ers 201 865
Seattle Seahawks 215 1010
St Louis Rams 206 929
Tampa Bay Buccaneers 224 1053
Tennessee Titans 216 994
Washington Redskins 327 1538

Studying

Hours Points
45 40
30 35
90 75
60 65
105 90
65 50
90 90
80 80
55 45
75 65

Movie Advertising

Weekly Gross Revenue ($1000s) Televison Advertising ($1000s) Newspaper Advertising ($1000s)
96 5 1.5
90 2 2
95 4 1.5
92 2.5 2.5
95 3 3.3
94 3.5 2.3
94 2.5 4.2
94 3 2.5

Baseball

Team Proportion Won HR ERA
Arizona 0.519 152 3.857
Atlanta 0.623 235 4.106
Chicago 0.543 172 3.842
Cincinnati 0.426 182 5.127
Colorado 0.457 198 5.269
Florida 0.562 157 4.059
Houston 0.537 191 3.88
Los Angeles 0.525 124 3.162
Milwaukee 0.42 196 5.058
Montreal 0.512 144 4.027
New York 0.41 124 4.517
Philadelphia 0.531 166 4.072
Pittsburgh 0.463 163 4.664
San Diego 0.395 128 4.904
San Francisco 0.621 180 3.734
St. Louis 0.525 196 4.642

Computer Reviews

Model Performance Features PCW Rating
Thinkpad X200 77 87 83
VGN-Z598U 97 85 82
U6V 83 80 81
Elitebook 2530P 77 75 78
X360 64 80 78
Thinkpad X300 56 76 78
Ideapad U110 55 81 77
Micro Express JFT2500 76 73 75
Toughbook W7 46 79 73
HP Voodoo Envy133 54 68 72

Waterskiing

Make and Model Beam HP TopSpeed
Calabria Cal Air Pro V-2 100 330 45.3
Correct Craft Air Nautique 210 91 330 47.3
Correct Craft Air Nautique SV-211 93 375 46.9
Correct Craft Ski Nautique 206 Limited 91 330 46.7
Gekko GTR 22 96 375 50.1
Gekko GTS 20 83 375 52.2
Malibu Response LXi 93.5 340 47.2
Malibu Sunsettter LXi 98 400 46
Malibu Sunsetter 21 XTi 98 340 44
Malibu Sunscape 21 LSV 98 400 47.5
Malibu Wakesetter 21 XTi 98 340 44.9
Malibu Wakesetter VLX 98 400 47.3
Malibu vRide 93.5 340 44.5
Malibu Ride Xti 93.5 320 44.5
Mastercraft ProStar 209 96 350 42.5
Mastercraft X-1 90 310 45.8
Mastercraft X-2 94 310 42.8
Mastercraft X-9 96 350 43.2
MB Sports 190 Plus 92 330 45.3
Svfara SVONE 91 330 47.7

Basketball

Team PCT FG% Opp 3 Pt% Opp TO
Atlanta 0.265 0.435 0.346 13.206
Boston 0.471 0.449 0.369 16.176
Chicago 0.313 0.417 0.372 15.031
Cleveland 0.303 0.438 0.345 12.515
Dallas 0.581 0.439 0.332 15
Denver 0.606 0.431 0.366 17.818
Detroit 0.606 0.423 0.262 15.788
Golden State 0.452 0.445 0.384 14.29
Houston 0.548 0.426 0.324 13.161
Indiana 0.706 0.428 0.317 15.647
L.A. Clippers 0.464 0.424 0.326 14.357
L.A. Lakers 0.724 0.465 0.323 16
Memphis 0.485 0.432 0.358 17.848
Miami 0.424 0.41 0.369 14.97
Milwaukee 0.5 0.438 0.349 14.75
Minnesota 0.677 0.473 0.348 13.839
New Jersey 0.563 0.435 0.338 17.063
New Orleans 0.636 0.421 0.33 16.909
New York 0.412 0.442 0.33 13.588
Orlando 0.242 0.417 0.36 14.242
Philadelphia 0.438 0.428 0.364 16.938
Phoenix 0.364 0.438 0.326 16.515
Portland 0.484 0.447 0.367 12.548
Sacramento 0.724 0.466 0.327 15.207
San Antonio 0.688 0.429 0.293 15.344
Seattle 0.533 0.436 0.35 16.767
Toronto 0.516 0.424 0.314 14.129
Utah 0.531 0.456 0.368 15.469
Washington 0.3 0.411 0.341 16.133