Team X1 League Opened Seating Capacity Salary 2012 X2 X3 X4 Attendance BA ERA HR Errors SB X6 X5 Wins X7 X8 X9 X10 X11 X12 Arizona Diamondbacks Atlanta Braves Baltimore Orioles Boston Red Sox Chicago Cubs Chicago White Sox Cincinnati Reds Cleveland Indians Colorado Rockies Detroit Tigers Houston Astros Kansas City Royals Los Angeles Angels Los Angeles Dodgers Miami Marlins Milwaukee Brewers 0 0 1 1 0 1 0 1 0 1 0 1 1 0 0 0 1998 1996 1992 1912 1914 1991 2003 1994 1995 2000 2000 1973 1966 1962 2012 2001 48633 49586 45971 37495 41009 40615 42319 43429 50398 41255 40981 37903 45957 56000 36742 41900 74.3 83.3 81.4 173.2 88.2 96.9 82.2 78.4 78.1 132.3 60.7 60.9 154.5 95.1 118.1 97.7 81 94 93 69 61 85 97 68 64 88 55 72 89 86 69 83 2.18 2.42 2.1 3.04 2.88 1.97 2.35 1.6 2.63 3.03 1.61 1.74 3.06 3.32 2.22 2.83 0.259 0.247 0.247 0.26 0.24 0.255 0.251 0.251 0.274 0.268 0.236 0.265 0.274 0.252 0.244 0.259 3.93 3.42 3.9 4.7 4.51 4.02 3.34 4.78 5.22 3.75 4.56 4.3 4.02 3.34 4.09 4.22 165 149 214 165 137 211 172 136 166 163 146 131 187 116 137 202 90 86 106 101 105 70 89 96 122 99 118 113 98 98 103 99 Minnesota Twins New York Mets New York Yankees Oakland Athletics Philadelphia Phillies Pittsburgh Pirates San Diego Padres San Francisco Giants Seattle Mariners St. Louis Cardinals Tampa Bay Rays Texas Rangers Toronto Blue Jays Washington Nationals 1 0 1 1 0 0 0 0 1 0 1 1 1 0 2010 2009 2009 1966 2004 2001 2004 2000 1999 2006 1990 1994 1989 2008 39504 41922 50287 35067 43651 38362 42691 41915 47860 43975 34078 48194 49260 41487 94.1 93.4 198 55.4 174.5 63.4 55.2 117.6 82 110.3 64.2 120.5 75.5 81.3 66 95 74 94 81 79 76 94 75 88 90 93 73 98 2.78 2.24 3.54 1.68 3.57 2.09 2.12 3.38 1.72 3.26 1.56 3.46 2.1 2.37 0.26 0.249 0.265 0.238 0.255 0.243 0.247 0.269 0.234 0.271 0.24 0.273 0.245 0.261 4.77 4.09 3.85 3.48 3.83 3.86 4.01 3.68 3.76 3.71 3.19 3.99 4.64 3.33 131 139 245 195 158 170 121 103 149 159 175 200 198 194 107 101 74 111 101 112 121 115 72 107 114 85 101 94 93 101 58 97 94 109 87 110 100 59 105 132 134 104 149 158 135 79 93 122 116 73 155 118 104 91 134 91 123 105 Average Salary 1989 $512,930 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 $578,930 $891,188 $1,084,408 $1,120,254 $1,188,679 $1,071,029 $1,176,967 $1,383,578 $1,441,406 $1,720,050 $1,988,034 $2,264,403 $2,383,235 $2,555,476 $2,486,609 $2,632,655 2006 2007 2008 2009 2010 2011 2012 $2,866,544 $2,944,556 $3,154,845 $3,240,206 $3,297,828 $3,305,393 $3,440,000 Frequency Distribution - Quantitative Maintenance lower upper 320 340 360 380 400 420 440 460 480 500 520 540 560 20.0 < < < < < < < < < < < < < 340 360 380 400 420 440 460 480 500 520 540 560 580 midpoint width 330 20 350 20 370 20 390 20 410 20 430 20 450 20 470 20 490 20 510 20 530 20 550 20 570 20 frequency 3 3 1 8 5 12 12 15 7 8 1 3 2 80 percent 3.8 3.8 1.3 10.0 6.3 15.0 15.0 18.8 8.8 10.0 1.3 3.8 2.5 100.0 midpoint width 325 50 375 50 425 50 475 50 525 50 575 50 frequency 3 12 22 29 11 3 80 percent 3.8 15.0 27.5 36.3 13.8 3.8 100.0 cumulative frequency percent 3 3.8 6 7.5 7 8.8 15 18.8 20 25.0 32 40.0 44 55.0 59 73.8 66 82.5 74 92.5 75 93.8 78 97.5 80 100.0 Histogram Percent 18.0 16.0 14.0 12.0 10.0 8.0 6.0 4.0 2.0 0.0 Maintenance Descriptive statistics count mean sample variance sample standard deviation minimum maximum range 1st quartile median 3rd quartile interquartile range mode low extremes low outliers high outliers high extremes Maintenance 80 450.29 2,882.18 53.69 329 570 241 420.00 456.00 489.75 69.75 329.00 0 0 0 0 Frequency Distribution - Quantitative Maintenance lower upper 300 350 400 450 500 550 Percent 40.0 < < < < < < 350 400 450 500 550 600 cumulative frequency percent 3 3.8 15 18.8 37 46.3 66 82.5 77 96.3 80 100.0 Histogram 35.0 30.0 25.0 20.0 15.0 10.0 5.0 0.0 Maintenance Frequency Distribution - Quantitative Maintenance cumulative lower upper 325 360 395 430 465 500 535 570 360 395 430 465 500 535 570 605 midpoint width 343 35 378 35 413 35 448 35 483 35 518 35 553 35 587 35 Histogram 30.0 Percent < < < < < < < < 25.0 20.0 15.0 10.0 5.0 0.0 Maintenance Descriptive statistics count mean sample variance sample standard deviation minimum maximum range 1st quartile median 3rd quartile interquartile range mode Miles 80 827.53 1,188.20 34.47 741 908 167 806.00 827.00 851.50 45.50 815.00 low extremes low outliers high outliers high extremes 0 0 0 0 BoxPlot 1/28/2010 16:03.39 (1) 600 650 700 750 Miles 800 850 900 950 850 900 950 Descriptive statistics count mean sample variance sample standard deviation minimum maximum range 1st quartile median 3rd quartile interquartile range mode Miles 80 827.53 1,188.20 34.47 741 908 167 806.00 827.00 851.50 45.50 815.00 low extremes low outliers high outliers high extremes 0 0 0 0 BoxPlot 1/28/2010 16:06.08 (1) 600 650 700 750 Miles 800 frequency 6 8 12 20 20 9 4 1 80 percent 7.5 10.0 15.0 25.0 25.0 11.3 5.0 1.3 100.0 frequency 6 14 26 46 66 75 79 80 percent 7.5 17.5 32.5 57.5 82.5 93.8 98.8 100.0 1/28/2010 16:06.08 (1) DotPlot 600 650 700 750 Miles 800 850 900 950 Descriptive statistics Miles 80 830.11 1,779.85 42.19 741 1008 267 count mean sample variance sample standard deviation minimum maximum range 1st quartile median 3rd quartile interquartile range mode 806.00 827.00 851.50 45.50 815.00 low extremes low outliers high outliers high extremes 0 0 1 1 BoxPlot 1/28/2010 16:08.20 (1) 600 650 700 750 800 850 Miles 900 950 1000 1050 950 1000 1050 1/28/2010 16:08.20 (1) DotPlot 600 650 700 750 800 850 Miles 900 Correlation Matrix Maintenance Age Miles Maintenance 1.000 .465 .450 Age Miles 1.000 .522 1.000 80 sample size .220 critical value .05 (two-tail) .286 critical value .01 (two-tail) Data Set 3 --Buena School District Bus Data Bus Number X1 135 120 200 40 427 759 10 880 481 387 326 861 122 156 887 686 490 370 464 875 883 57 482 704 989 731 75 162 732 751 600 948 358 833 692 61 9 314 396 365 398 43 500 279 693 884 977 38 725 982 724 603 168 45 754 39 671 418 984 953 507 540 695 193 321 918 101 714 678 768 29 554 767 699 954 705 660 520 814 353 Maintenance X2 329 503 505 466 359 546 427 474 382 422 433 474 558 561 357 329 497 459 355 489 436 455 514 503 380 432 478 406 471 444 493 452 461 496 469 442 414 459 457 462 570 439 369 390 469 381 501 432 392 441 448 468 467 478 515 411 504 504 392 423 410 529 477 540 450 390 424 433 428 494 396 458 493 475 476 403 337 492 426 449 Age X3 7 10 10 10 7 8 5 9 3 8 9 10 10 12 8 3 10 8 3 9 2 7 11 8 9 6 6 3 9 2 10 9 6 8 8 9 4 11 2 6 9 9 5 2 9 9 7 6 5 1 8 4 7 6 14 6 8 9 8 10 7 4 2 11 6 5 4 7 7 7 6 4 6 9 10 4 6 10 4 4 Miles X4 853 883 822 865 751 870 780 857 818 869 848 845 885 838 760 741 859 826 806 858 785 828 980 857 803 819 821 798 815 757 1008 831 849 839 812 809 864 859 815 799 844 832 842 792 775 882 874 837 774 823 790 800 827 830 895 804 866 842 851 835 866 846 802 847 856 799 827 817 842 815 784 817 816 816 827 806 819 836 757 817 Type X5 Diesel Diesel Diesel Gasoline Gasoline Diesel Gasoline Gasoline Gasoline Gasoline Diesel Gasoline Gasoline Diesel Diesel Diesel Gasoline Gasoline Gasoline Diesel Gasoline Diesel Gasoline Diesel Diesel Diesel Diesel Gasoline Diesel Diesel Diesel Diesel Diesel Diesel Diesel Diesel Gasoline Diesel Diesel Diesel Diesel Gasoline Gasoline Diesel Gasoline Diesel Diesel Gasoline Diesel Diesel Diesel Diesel Gasoline Diesel Diesel Gasoline Gasoline Diesel Diesel Diesel Diesel Gasoline Diesel Diesel Diesel Diesel Diesel Diesel Diesel Diesel Gasoline Diesel Diesel Gasoline Diesel Diesel Gasoline Diesel Diesel Gasoline Bus-Mfg X6 Bluebird Keiser Bluebird Bluebird Keiser Keiser Keiser Keiser Keiser Bluebird Bluebird Bluebird Bluebird Thompson Bluebird Bluebird Bluebird Keiser Bluebird Bluebird Bluebird Bluebird Bluebird Bluebird Keiser Bluebird Bluebird Keiser Keiser Keiser Bluebird Keiser Bluebird Thompson Bluebird Keiser Keiser Thompson Thompson Keiser Thompson Bluebird Bluebird Bluebird Keiser Bluebird Bluebird Keiser Bluebird Bluebird Keiser Keiser Thompson Keiser Keiser Bluebird Thompson Bluebird Bluebird Bluebird Bluebird Bluebird Bluebird Thompson Bluebird Bluebird Bluebird Bluebird Keiser Bluebird Bluebird Bluebird Keiser Bluebird Bluebird Keiser Bluebird Bluebird Bluebird Keiser Passenger X7 55 Passenger 42 Passenger 55 Passenger 55 Passenger 55 Passenger 55 Passenger 14 Passenger 55 Passenger 6 Passenger 55 Passenger 55 Passenger 55 Passenger 55 Passenger 55 Passenger 6 Passenger 55 Passenger 55 Passenger 55 Passenger 55 Passenger 55 Passenger 55 Passenger 55 Passenger 55 Passenger 55 Passenger 55 Passenger 42 Passenger 55 Passenger 55 Passenger 42 Passenger 14 Passenger 55 Passenger 42 Passenger 55 Passenger 55 Passenger 55 Passenger 55 Passenger 55 Passenger 6 Passenger 55 Passenger 55 Passenger 14 Passenger 55 Passenger 55 Passenger 55 Passenger 55 Passenger 55 Passenger 55 Passenger 14 Passenger 55 Passenger 55 Passenger 42 Passenger 14 Passenger 55 Passenger 55 Passenger 14 Passenger 55 Passenger 55 Passenger 55 Passenger 55 Passenger 55 Passenger 55 Passenger 55 Passenger 55 Passenger 55 Passenger 6 Passenger 55 Passenger 55 Passenger 42 Passenger 55 Passenger 42 Passenger 55 Passenger 14 Passenger 55 Passenger 55 Passenger 42 Passenger 42 Passenger 55 Passenger 55 Passenger 55 Passenger 55 Passenger Complete the problems below from the textbook. You will need to use the "Baseball 2012 Data" and the "Buena School District Bus Data" files for this assignment. 1. Chapter 10 - Problem 8 2. Chapter 10 - Problem 13 3. Chapter 10 - Problem 51 4. Chapter 10 - Problem 52 For problems requiring computations, please ensure that your Excel file includes the associated cell computations and/or statistics output. This information is needed in order to receive full credit on these problems. Submit output in one Excel file. Statistical Techniques in Business and Economics (Texbook) Read Chapter 10 in Statistical Techniques in Business and Economics. http://gcumedia.com/digitalresources/mcgrawhill/2014/statisticaltechniquesinbusinessand economics_ebook_16e.php 8. At the time she was hired as a server at the Grumney Family Restaurant, Beth Brigden was told, \"You can average $80 a day in tips.\" Assume the population of daily tips is normally distributed with a standard deviation of $9.95. Over the first 35 days she was employed at the restaurant, the mean daily amount of her tips was $84.85. At the .01 significance level, can Ms. Brigden conclude that her daily tips average more than $80? 13. The mean income per person in the United States is $40,000, and the distribution of incomes follows a normal distribution. A random sample of 10 residents of Wilmington, Delaware, had a mean of $50,000 with a standard deviation of $10,000. At the .05 level of significance, is that enough evidence to conclude that residents of Wilmington, Delaware, have more income than the national average? 51. Refer to the Baseball 2012 data, which report information on the 30 Major League Baseball teams for the 2012 season.a. Conduct a test of hypothesis to determine whether the mean salary of the teams was different from $80.0 million. Use the .05 significance level.b. Using a 5% significance level, conduct a test of hypothesis to determine whether the mean attendance was more than 2,000,000 per team. 52. Refer to the Buena School District bus data.a. Select the variable for the number of miles traveled last month. Conduct a test of hypothesis to determine whether the mean number of miles traveled is equal to 840. Use the .01 significance level. Find the pvalue and explain what it means.b. Using the maintenance cost variable, conduct a test of hypothesis to determine whether the mean maintenance cost is less than $500 at the .05 significance level. Determine the pvalue and interpret the result