business Assignment

maq
In-Class-Exercise-9-Data.xlsx
Home>Business & Finance homework help>Management homework help>business Assignment

MLB-Data

TEAM Batting Ave Strike Outs Home Runs Errors Quality Starts Wins Losses League Winning Percentage League
San Francisco 0.3 36 4 1 3 5 2 1 0.714 NL
Chicago Cubs 0.75 53 4 2 5 5 1 1 0.833 NL
LA Dodgers 0.1 59 8 2 5 4 3 1 0.571 NL
St. Louis 0.545 65 1 10 2 3 3 1 0.5 NL
NY Yankees 0.2 35 7 2 1 3 2 0 0.6 AL
Colorado 0.143 38 10 4 2 3 3 1 0.5 NL
Arizona 0.2 61 13 3 1 2 5 1 0.286 NL
San Diego 0.222 50 9 4 1 2 4 1 0.333 NL
Cincinnati 0.286 38 7 5 2 5 1 1 0.833 NL
Toronto 0 71 7 5 4 3 4 0 0.429 AL
Boston 0.25 47 6 3 2 3 2 0 0.6 AL
Houston 0.222 60 12 3 1 2 4 0 0.333 AL
Seattle 0.222 46 6 5 3 2 4 0 0.333 AL
Texas 0 63 10 3 6 3 4 0 0.429 AL
Chicago Sox 0 41 3 4 4 4 2 0 0.667 AL
Detroit 0.667 39 3 1 2 3 1 0 0.75 AL
Pittsburgh 0.111 47 5 7 3 4 2 1 0.667 NL
Baltimore 0 33 4 2 1 5 0 0 1 AL
Milwaukee 0.111 58 12 6 2 3 3 1 0.5 NL
Oakland 0 64 5 7 3 4 3 0 0.571 AL
Cleveland 0 39 8 4 1 2 2 0 0.5 AL
Kansas City 0 41 3 2 2 4 1 0 0.8 AL
Philadelphia 0.333 54 5 4 3 2 4 1 0.333 NL
Miami 0.333 30 6 4 1 1 3 1 0.25 NL
Tampa Bay 0.125 51 10 2 0 2 4 0 0.333 AL
Atlanta 0 48 8 6 2 0 5 1 0 NL
Washington 0.143 33 3 1 3 3 1 1 0.75 NL
NY Mets 0.167 44 2 2 4 2 3 1 0.4 NL
LA Angels 0 31 8 5 3 2 4 0 0.333 AL
Minnesota 0 72 7 4 3 0 6 0 0 AL

ChartDataSheet_

This worksheet contains values required for MegaStat charts.
Residuals X data 4/11/2016 18:19.04
36 1 5 2 1
53 2 5 1 1
59 2 4 3 1
65 10 3 3 1
35 2 3 2 0
38 4 3 3 1
61 3 2 5 1
50 4 2 4 1
38 5 5 1 1
71 5 3 4 0
47 3 3 2 0
60 3 2 4 0
46 5 2 4 0
63 3 3 4 0
41 4 4 2 0
39 1 3 1 0
47 7 4 2 1
33 2 5 0 0
58 6 3 3 1
64 7 4 3 0
39 4 2 2 0
41 2 4 1 0
54 4 2 4 1
30 4 1 3 1
51 2 2 4 0
48 6 0 5 1
33 1 3 1 1
44 2 2 3 1
31 5 2 4 0
72 4 0 6 0
NormalPlot data 4/11/2016 18:19.04
-0.0598302128 -2.0145097338
-0.0382567353 -1.5986872596
-0.037501473 -1.3537248537
-0.0372101652 -1.1706033709
-0.0227488388 -1.0200762328
-0.0225085533 -0.8897011551
-0.0223126588 -0.7729356931
-0.0165500892 -0.665869518
-0.0165258477 -0.5659488219
-0.016430337 -0.4713894656
-0.0153911843 -0.3808740575
-0.0095435881 -0.2933812321
-0.0070413328 -0.2080821362
-0.0034967116 -0.1242732821
-0.0023907968 -0.0413298117
-0.0018821221 0.0413298117
0.0039551545 0.1242732821
0.0054624439 0.2080821362
0.0075938228 0.2933812321
0.0114727687 0.3808740575
0.0119659983 0.4713894656
0.0168847935 0.5659488219
0.0195946528 0.665869518
0.0217297887 0.7729356931
0.0217663404 0.8897011551
0.0302717991 1.0200762328
0.0305984961 1.1706033709
0.032037056 1.3537248537
0.0577385896 1.5986872596
0.0585489422 2.0145097338
Residuals X data 4/11/2016 18:28.20
36 1 5 2 1
53 2 5 1 1
59 2 4 3 1
65 10 3 3 1
35 2 3 2 0
38 4 3 3 1
61 3 2 5 1
50 4 2 4 1
38 5 5 1 1
71 5 3 4 0
47 3 3 2 0
60 3 2 4 0
46 5 2 4 0
63 3 3 4 0
41 4 4 2 0
39 1 3 1 0
47 7 4 2 1
33 2 5 0 0
58 6 3 3 1
64 7 4 3 0
39 4 2 2 0
41 2 4 1 0
54 4 2 4 1
30 4 1 3 1
51 2 2 4 0
48 6 0 5 1
33 1 3 1 1
44 2 2 3 1
31 5 2 4 0
72 4 0 6 0
NormalPlot data 4/11/2016 18:28.04
-0.0598302128 -2.0145097338
-0.0382567353 -1.5986872596
-0.037501473 -1.3537248537
-0.0372101652 -1.1706033709
-0.0227488388 -1.0200762328
-0.0225085533 -0.8897011551
-0.0223126588 -0.7729356931
-0.0165500892 -0.665869518
-0.0165258477 -0.5659488219
-0.016430337 -0.4713894656
-0.0153911843 -0.3808740575
-0.0095435881 -0.2933812321
-0.0070413328 -0.2080821362
-0.0034967116 -0.1242732821
-0.0023907968 -0.0413298117
-0.0018821221 0.0413298117
0.0039551545 0.1242732821
0.0054624439 0.2080821362
0.0075938228 0.2933812321
0.0114727687 0.3808740575
0.0119659983 0.4713894656
0.0168847935 0.5659488219
0.0195946528 0.665869518
0.0217297887 0.7729356931
0.0217663404 0.8897011551
0.0302717991 1.0200762328
0.0305984961 1.1706033709
0.032037056 1.3537248537
0.0577385896 1.5986872596
0.0585489422 2.0145097338

BoxOffice2

First yr box office Total Prod Cost Total Promotional Costs Total Book Sales DH DS Genre
85.09999847 8.5 5.099999905 4.699999809 1 0 Horror
106.3000031 12.89999962 5.800000191 8.800000191 1 0 Horror
50.20000076 5.199999809 2.099999905 15.10000038 1 0 Horror
130.6000061 10.69999981 8.4 12.19999981 1 0 Horror
54.79999924 3.099999905 2.900000095 10.60000038 0 0 Drama
30.29999924 3.5 1.200000048 3.5 0 0 Drama
79.40000153 9.199999809 3.700000048 9.699999809 0 0 Drama
91 9 7.599999905 5.900000095 0 0 Drama
135.3999939 15.10000038 7.699999809 20.79999924 0 1 Sci-fi
89.30000305 10.19999981 4.5 7.900000095 0 1 Sci-fi
95 7 4 10.4 0 1 Sci-fi
100 14 9 3 0 1 Sci-fi