Frequency Distribution - Quantitative Maintenance lower 320 340 360 380 400 420 440 460 480 500 520 540 560 Histogram 20.0 Percent 18.0 16.0 14.0 12.0 10.0 8.0 6.0 4.0 2.0 0.0 Maintenance Descriptive statistics Maintenance count 80 mean 450.29 sample variance 2,882.18 sample standard deviation 53.69 minimum 329 maximum 570 range 241 1st quartile 420.00 upper < < < < < < < < < < < < < 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 median 3rd quartile interquartile range mode low extremes low outliers high outliers high extremes 456.00 489.75 69.75 329.00 0 0 0 0 Frequency Distribution - Quantitative Maintenance lower upper 300 350 400 450 500 550 < < < < < < 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 midpoint width 343 35 378 35 413 35 448 35 483 35 frequency 6 8 12 20 20 Histogram Percent 40.0 35.0 30.0 25.0 20.0 15.0 10.0 5.0 0.0 Maintenance Frequency Distribution - Quantitative Maintenance lower 325 360 395 430 465 upper < < < < < 360 395 430 465 500 500 535 570 < < < 535 570 605 518 553 587 35 35 35 Histogram Percent 30.0 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 9 4 1 80 BoxPlot 600 650 700 750 Miles 800 850 900 950 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 1/28/2010 DotPlot16:06.08 (1) 600 650 Descriptive statistics 700 750 Miles 800 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 DotPlot16:08.20 (1) 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) 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 percent 3.8 15.0 27.5 36.3 13.8 3.8 100.0 percent 7.5 10.0 15.0 25.0 25.0 cumulative frequency percent 3 3.8 15 18.8 37 46.3 66 82.5 77 96.3 80 100.0 cumulative frequency percent 6 7.5 14 17.5 26 32.5 46 57.5 66 82.5 11.3 5.0 1.3 100.0 75 79 80 93.8 98.8 100.0 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 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 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 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 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 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 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 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 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 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 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 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 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 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 64. Refer to the Buena School bus data. Develop a regression equation that expresses the relationship between age of the bus and maintenance. The age of the bus is the independent variable. a. Draw a scatter diagram. What does this diagram suggest as to the relationship between the two variables? Is it direct or indirect? Does it appear to be strong or weak? b. Develop a regression equation. How much does an additional year add to the maintenance cost. What is the estimated maintenance cost for a 10-year-old bus? c. Conduct a test of hypothesis to determine whether the slope of the regression line is greater than zero. Use the .05 significance level. Interpret your findings from parts (a), (b), and (c) in a brief report. e relationship 63. Refer to the Baseball 2012 data, which reports information on the 2012 Major League Baseball season. Let attendance be the dependent variable and total team salary, in millions of dollars, be the independent variable. Determine the regression equation and answer the following questions. a. Draw a scatter diagram. From the diagram, does there seem to be a direct relationship between the two variables? b. What is the expected attendance for a team with a salary of $80.0 million? c. If the owners pay an additional $30 million, how many more people could they expect to attend? d. At the .05 significance level, can we conclude that the slope of the regression line is positive? Conduct the appropriate test of hypothesis. e. What percentage of the variation in attendance is accounted for by salary? f. Determine the correlation between attendance and team batting average and between attendance and team ERA. Which is stronger? Conduct an appropriate test of hypothesis for each set of variables. Team X1 LeagueOpened Seating Capacity Salary 2012 Wins Attendance X2 X3 X4 X5 X6 X7 Arizona Diamondbacks 0 1998 48633 74.3 81 2.18 Atlanta Braves 0 1996 49586 83.3 94 2.42 Baltimore Orioles 1 1992 45971 81.4 93 2.1 Boston Red Sox 1 1912 37495 173.2 69 3.04 Chicago Cubs 0 1914 41009 88.2 61 2.88 Chicago White Sox 1 1991 40615 96.9 85 1.97 Cincinnati Reds 0 2003 42319 82.2 97 2.35 Cleveland Indians 1 1994 43429 78.4 68 1.6 Colorado Rockies 0 1995 50398 78.1 64 2.63 Detroit Tigers 1 2000 41255 132.3 88 3.03 Houston Astros 0 2000 40981 60.7 55 1.61 Kansas City Royals 1 1973 37903 60.9 72 1.74 Los Angeles Angels 1 1966 45957 154.5 89 3.06 Los Angeles Dodgers 0 1962 56000 95.1 86 3.32 Miami Marlins 0 2012 36742 118.1 69 2.22 Milwaukee Brewers 0 2001 41900 97.7 83 2.83 Minnesota Twins 1 2010 39504 94.1 66 2.78 New York Mets 0 2009 41922 93.4 95 2.24 New York Yankees 1 2009 50287 198 74 3.54 Oakland Athletics 1 1966 35067 55.4 94 1.68 Philadelphia Phillies 0 2004 43651 174.5 81 3.57 Pittsburgh Pirates 0 2001 38362 63.4 79 2.09 San Diego Padres 0 2004 42691 55.2 76 2.12 San Francisco Giants 0 2000 41915 117.6 94 3.38 Seattle Mariners 1 1999 47860 82 75 1.72 St. Louis Cardinals 0 2006 43975 110.3 88 3.26 Tampa Bay Rays 1 1990 34078 64.2 90 1.56 Texas Rangers 1 1994 48194 120.5 93 3.46 Toronto Blue Jays 1 1989 49260 75.5 73 2.1 Washington Nationals 0 2008 41487 81.3 98 2.37 BA ERA HR Errors SB X8 X9 X10 X11 X12 0.259 3.93 165 90 93 0.247 3.42 149 86 101 0.247 3.9 214 106 58 0.26 4.7 165 101 97 0.24 4.51 137 105 94 0.255 4.02 211 70 109 0.251 3.34 172 89 87 0.251 4.78 136 96 110 0.274 5.22 166 122 100 0.268 3.75 163 99 59 0.236 4.56 146 118 105 0.265 4.3 131 113 132 0.274 4.02 187 98 134 0.252 3.34 116 98 104 0.244 4.09 137 103 149 0.259 4.22 202 99 158 0.26 4.77 131 107 135 0.249 4.09 139 101 79 0.265 3.85 245 74 93 0.238 3.48 195 111 122 0.255 3.83 158 101 116 0.243 3.86 170 112 73 0.247 4.01 121 121 155 0.269 3.68 103 115 118 0.234 3.76 149 72 104 0.271 3.71 159 107 91 0.24 3.19 175 114 134 0.273 3.99 200 85 91 0.245 4.64 198 101 123 0.261 3.33 194 94 105