This worksheet contains values required for MegaStat charts. Boxplot 12/5/2012 16:43.50 2 1559681 2 2093854 3 2093854 3 2359023 1 2359023 3 2359023 3 3039261 2 3039261 2 3565718 2 3039261 1 3039261 1 2093854 2 2093854 1 -742364.5 3 -742364.5 1 675744.9 3 675744.9 1 4457370 3 4457370 1 5875479 3 5875479 Dotplot 12/5/2012 16:44.17 1559681 1 1603596 1 1607733 1 1679013 1 1721920 1 1739859 1 1965955 1 2091918 1 2099663 1 2102240 1 2123721 1 2177617 1 2219444 1 2242803 1 2347251 1 2370794 1 2420171 1 2630458 1 2776354 1 2831385 1 2882756 1 3028033 1 3043003 1 3061770 1 3262109 1 3324246 1 3377371 1 3460280 1 3542406 1 3565718 1 Team X1 League Opened Seating Capacity X2 X3 X4 Arizona Diamondbacks 0 1998 48633 Atlanta Braves 0 1996 49586 Baltimore Orioles 1 1992 45971 Boston Red Sox 1 1912 37495 Chicago Cubs 0 1914 41009 Chicago White Sox 1 1991 40615 Cincinnati Reds 0 2003 42319 Cleveland Indians 1 1994 43429 Colorado Rockies 0 1995 50398 Detroit Tigers 1 2000 41255 Houston Astros 0 2000 40981 Kansas City Royals 1 1973 37903 Los Angeles Angels 1 1966 45957 Los Angeles Dodgers 0 1962 56000 Miami Marlins 0 2012 36742 Milwaukee Brewers 0 2001 41900 Minnesota Twins 1 2010 39504 New York Mets 0 2009 41922 New York Yankees 1 2009 50287 Oakland Athletics 1 1966 35067 Philadelphia Phillies 0 2004 43651 Pittsburgh Pirates 0 2001 38362 San Diego Padres 0 2004 42691 San Francisco Giants 0 2000 41915 Seattle Mariners 1 1999 47860 St. Louis Cardinals 0 2006 43975 Tampa Bay Rays 1 1990 34078 Texas Rangers 1 1994 48194 Toronto Blue Jays 1 1989 49260 Washington Nationals 0 2008 41487 Salary 2012 Wins Attendance BA ERA HR X5 X6 X7 X8 X9 X10 74.3 81 2.18 0.259 3.93 165 83.3 94 2.42 0.247 3.42 149 81.4 93 2.1 0.247 3.9 214 173.2 69 3.04 0.26 4.7 165 88.2 61 2.88 0.24 4.51 137 96.9 85 1.97 0.255 4.02 211 82.2 97 2.35 0.251 3.34 172 78.4 68 1.6 0.251 4.78 136 78.1 64 2.63 0.274 5.22 166 132.3 88 3.03 0.268 3.75 163 60.7 55 1.61 0.236 4.56 146 60.9 72 1.74 0.265 4.3 131 154.5 89 3.06 0.274 4.02 187 95.1 86 3.32 0.252 3.34 116 118.1 69 2.22 0.244 4.09 137 97.7 83 2.83 0.259 4.22 202 94.1 66 2.78 0.26 4.77 131 93.4 95 2.24 0.249 4.09 139 198 74 3.54 0.265 3.85 245 55.4 94 1.68 0.238 3.48 195 174.5 81 3.57 0.255 3.83 158 63.4 79 2.09 0.243 3.86 170 55.2 76 2.12 0.247 4.01 121 117.6 94 3.38 0.269 3.68 103 82 75 1.72 0.234 3.76 149 110.3 88 3.26 0.271 3.71 159 64.2 90 1.56 0.24 3.19 175 120.5 93 3.46 0.273 3.99 200 75.5 73 2.1 0.245 4.64 198 81.3 98 2.37 0.261 3.33 194 Errors SB X11 X12 90 93 86 101 106 58 101 97 105 94 70 109 89 87 96 110 122 100 99 59 118 105 113 132 98 134 98 104 103 149 99 158 107 135 101 79 74 93 111 122 101 116 112 73 121 155 115 118 72 104 107 91 114 134 85 91 101 123 94 105 Average Salary 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 Average Salary $512,930 $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 $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 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 300 350 400 450 500 550 Histogram Percent 40.0 35.0 30.0 25.0 20.0 15.0 10.0 5.0 0.0 Maintenance upper < < < < < < 350 400 450 500 550 600 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 15 18.8 37 46.3 66 82.5 77 96.3 80 100.0 Frequency Distribution - Quantitative Maintenance 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 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 Miles 80 827.53 1,188.20 34.47 741 908 167 806.00 827.00 851.50 45.50 815.00 0 0 0 0 BoxPlot 800 850 900 950 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 cumulative frequency percent 6 7.5 14 17.5 26 32.5 46 57.5 66 82.5 75 93.8 79 98.8 80 100.0 1/28/2010 16:06.08 (1) 600 650 700 750 800 Miles 850 900 950 850 900 950 1/28/2010 16:06.08 (1) DotPlot 600 650 700 750 800 Miles 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 Maintenance X2 Age X3 Miles X4 Type X5 Bus-Mfg X6 Passenger X7 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 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 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 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 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 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 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 520 814 353 492 426 449 10 4 4 836 757 817 Diesel Diesel Gasoline Bluebird Bluebird Keiser 55 Passenger 55 Passenger 55 Passenger Balance 1756 748 1501 1831 1622 1886 740 1593 1169 2125 1554 1474 1913 1218 1006 2215 137 167 343 2557 2276 1494 2144 1995 1053 1526 1120 1838 1746 1616 1958 634 580 1320 1675 789 1735 1784 1326 2051 1044 1885 1790 765 1645 32 1266 890 2204 2409 1338 2076 1708 2138 2375 1455 1487 1125 1989 2156 ATM Services 13 9 10 10 14 17 6 10 6 18 12 12 6 10 12 20 7 5 7 20 15 11 17 10 8 8 8 7 11 10 6 2 4 4 6 8 12 11 16 14 7 10 11 4 6 2 11 7 14 16 14 12 13 18 12 9 8 6 12 14 Debit 4 2 1 4 6 3 3 8 4 6 6 7 5 3 4 3 2 4 2 7 4 2 3 7 4 4 6 5 2 4 2 7 1 5 7 4 7 5 8 4 5 6 4 3 9 0 7 1 5 8 4 5 3 5 4 5 4 4 3 5 Interest 0 1 0 0 0 0 0 1 0 0 1 1 0 1 0 1 0 0 0 1 1 0 0 0 1 0 1 1 0 1 1 1 0 1 1 0 0 0 0 1 1 1 0 0 0 0 0 0 0 0 1 1 1 0 0 1 1 1 0 1 City 1 0 0 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 1 0 1 0 1 0 0 0 0 0 0 1 0 0 0 0 1 1 0 1 0 0 1 0 0 0 0 0 1 0 1 0 0 1 0 2 1 1 3 4 1 3 1 4 2 3 1 1 1 1 4 3 4 1 4 3 1 3 2 3 2 3 3 2 2 2 4 1 1 2 4 3 1 3 4 1 2 3 4 4 3 4 1 2 2 2 2 1 4 2 3 4 2 2 2