Question 7
In Santa Monica, California, it was reported that a “finder’s fee”—an up-front payment of up to $5,000—was being required of prospective tenants seeking to rent special apartments. What is this an example of?
the black market
a price floor
price gouging
a government price ceiling
Question 8
Mesa Petroleum Company built a small park in front of its corporate office. This is an example of __________.
imposing external costs on its shareholders
providing a pure public good
providing external benefits to the community
assuming city responsibilities
Question 9
What is the most frequently cited example of an externality?
service charges
public protest
pollution
sales taxes
Question 10
A negative externality exists when __________.
all costs are taken into account in the demand curve
all costs are taken into account in the supply curve
the market demand curve is not the true demand curve
the marginal social costs are not taken into account in the supply cur
In: Economics
A survey found that women's heights are normally distributed with mean 62.6 in. and standard deviation 2.2 in. The survey also found that men's heights are normally distributed with a mean 67.3 in. and standard deviation 2.8. Complete parts a through c below. a. Most of the live characters at an amusement park have height requirements with a minimum of 4 ft 8 in. and a maximum of 6 ft 2 in. Find the percentage of women meeting the height requirement. The percentage of women who meet the height requirement is %. (Round to two decimal places as needed.) b. Find the percentage of men meeting the height requirement. The percentage of men who meet the height requirement is %. (Round to two decimal places as needed.) c. If the height requirements are changed to exclude only the tallest 5% of men and the shortest 5% of women, what are the new height requirements? The new height requirements are at least in. and at most in. (Round to one decimal place as needed.)
In: Math
Citizen Potawatomi Nation offers many services to its citizens and to other Native Americans throughout its tribal jurisdiction, including housing, community, education, health, veterans, elder and career services. Citizen Potawatomi Nation dedicates resources through federal funding, grants and tribal revenue to provide these and other services to the tribal and community citizens who need them most. In 2011, Citizen Potawatomi Nation clinics had more than 62,000 patient visits, filled more than 1530,000 prescriptions, served more than 14,000 meals to the elderly, assisted nearly 3,000 families through Indian Child Welfare and provided 3,100 scholarships to students.
Citizen Potawatomi Nation has several tribal enterprises that provide services to our citizens and create a substantial economic impact in our communities. Our businesses further the success and prosperity of the Nation by providing employment opportunities for tribal citizens and revenue to support tribal operations.
Our enterprises provide the economic foundation to diversify and expand our current business operations and provide for expanded economic growth in our communities.
With more than 2,200 employees, Citizen Potawatomi Nation operates a variety of tribal enterprises including First National Bank, Grand Casino Hotel & Resort Resort, FireLake Discount Foods and the Community Development Corporation.
Citizen Potawatomi Nation owns and operates the largest tribally owned grocery store in the United States. Our enterprises provide services to our citizens and create a substantial economic impact in our communities. Our businesses further the success and prosperity of the Nation by providing employment opportunities for tribal citizens and revenue to support tribal operations.
Citizen Potawatomi Nation operates two casinos, as well as multiple entertainment venues, retail shops, fuel and convenience stores, golf courses, museums and hotels. Visit one of our entertainment destinations for an evening out or a day of family fun.
Opened in 2006 as Grand Casino, Pottawatomie County’s premier gaming destination includes 2,000 of the latest in Vegas-style slots, various table games and Oklahoma’s only Keno lounge on its 125,000 square feet of gaming space.
In 2014, a “Grand” expansion took place with the addition of a 14-story luxury hotel tower, dining selections such as Flame Brazilian Steakhouse and Grand Café, as well as longtime staples The Grand Buffet and The Grand Stand Sports Grille. The added Grand Event Center hosts top-name entertainers, sporting events and conferences for all business and professional sectors, making Grand Casino Hotel and Resort the premier destination for work and play, located just a few minutes’ drive from Oklahoma City.
First National Bank & Trust Co. is the largest tribally owned national bank in the United States. FNB has branches in Shawnee, Holdenville, Granite, Mangum and two in Lawton, Oklahoma.
First National Bank & Trust Co. began when the charter for First Oklahoma Bank, N.A., was approved on June 30, 1983. With a capital structure of $2.5 million, the bank opened its doors on Oct. 29, 1984. The original incorporators were C. L. Craig Jr., Mark Finley, David Ingram, Jerald O'Connor, Frank Sims and Stephen Sims. Citizen Potawatomi Nation purchased the bank in February 1989.
Since its founding in 1983, First National Bank & Trust Co. has grown steadily through sound financial management practices and by investing time, energy and resources in the communities we serve.
In: Economics
* Please I want answer for these questions and I will give big thump for it. Thanks
Read the following case study and answer the following question.
The Five star Hotel ELV (Extra Low Voltage) project was located in Bahrain and completed in 2011. The purpose of this project was to install, test, and commission the IT, communication infrastructure, and services for the hotel. The ELV project was part of a total program to deliver 11 sub system, including installation of data, voice, music, wireless and CCTV systems. The project stakeholders included the hotel owner, the consultant they had employed on their behalf and various civil, electrical and construction teams involved in implementing the ELV project.
This case study focuses on the Audio visual (AV)sub system, primarily installation of projectors and screens in the meeting rooms and conference facilities. Renosh Thomas as the vendor’s project manager was responsible for issuing the client with complete drawings detailing the projects electrical requirements. Renosh knew these drawings needed to be accurate as these would be handed over to the civil and construction teams for use when building the sites. The final phases of the ELV project required Renosh team to visit the sites, install, and test the electrical equipment.
At initiation and during the project planning phases, the AV requirements were issued and communicated via drawings between the consultant, appointed by the customer and Renosh electrical team. The product specifications were based on lessons learned and templates from a similar project implemented in Dubai. The project scope was determined via the bill of quantities, materials and tender documents.
Renosh received only electrical drawings for the sites and continued to plan the installation requirements based on these drawings, going by the assumption that they were correct, accurate and most recent. Throughout planning, the electrical team was not privy to any of the civil or construction drawings from other teams, and hence remainded completely unaware of structural changes being made on the original plans that they were still working on too.
During installation of the AV system, the team encountered a major problem- the projection was faulty. The projectors and screens were not aligning; images are cut off and unclear. Upon investigation it became apparent that certain structural changes had been added, drawings and calculations inaccurate.
The customers response to this communication oversight was to respond by sending Renosh a full collection of civil and construction drawings including all the latest revisions. Renosh spent considerable time reviewing the drawings to identify the relevant adjustments. This resulted in delays, rework and wasted time as he ploughed through drawings, many of which were excessive to his requirements.
The problem the installation team encountered was that ceilings had been elevated higher than the original design and this had been approved by the customer who failed to communicate the new changes and approvals to Renosh electrical team. Renosh revised and issued new electrical drawings to the customer that went through the approval process again.
The site had been handed over from civil and construction completed with decoration. However, this vital communication error resulted in the solution requiring reworking of parts of the site, such as opening the ceilings to access the electrical panels and make the new changes. This impacted the schedule by 8-10 days and reworked costs of opening, adjusting and redecorating the site.
Questions:
In: Operations Management
#4 PART 8
a meteorologist who sampled 16 thunderstorms found that the average speed at which they traveled across a certain states was 14 miles per hour. The standard deviation of the sample was 1.3 miles per hour.
find the 92% confidence interval of the mean
the number of unhealthy days based on the AQI (Air Quality Index) for a. random sample of metropolitan areas is shown. Construct an 87% confidence interval based on data. Assume variable is normally distributed.
61 40 5 14 21 23 3 15 6 50. ____ < u < _____
__________________________________________________
a random sample of 345 college students were asked if they believed that places could be haunted, and 35 responded yes. Estimate the true proportion of college students who believe in the possibility of haunted places with 90% confidence. According toTime magazine, 37% of Americans believe that places can be haunted. Round to five decimal places
____ < p < _____
in a study, 68% of 905 randomly selected adults said they believe in the republicans favor the rich. If the margin of error was 4 percentage points, what is the confidence level used for the proportion?
a federal report indicated that 26% of children under age 6 live in poverty in alabama, an increase over previous years. how large a sample is needed to estimate the true proportion of children under age 6 living in poverty in alabama within 5% with 99% confidence
n= _____
Obesity is defined as a body mass index (BMI) of 30 kg/m^2 or more. A 99% confidence interval for the percentage of U.S. men aged 70 years and over who were obese were found to be 20.0% to 21.0
n= ____ (it is NOT 43, 259)
it is believed that 25% of u.s. homes have direct satellite television receiver. 90% confidence within 2 percentage points?
n= _____
a recent study indicated that 23% of the 160 women over age 55 in the study were widows. how large a sample must you take to be 90% confident that the estimate is within 0.05 of the true proportion of women over age 55
n=_____
in a recent year, a study found that 78% of adults ages 18-29 had internet access at home. Did research on 182 undergraduates total and found that 166 had access. Estimate the true proportion with 90% confidence.
_____ < p < ____
In: Statistics and Probability
Download the Gas Consumption Data into Excel:
Gas tax (cents per gallon),Average income (dollars),Paved
Highways (miles),Proportion of population with driver's
licenses,Consumption of gas (millions of gallons)
9,3571,1976,0.525,541
9,4092,1250,0.572,524
9,3865,1586,0.58,561
7.5,4870,2351,0.529,414
8,4399,431,0.544,410
10,5342,1333,0.571,457
8,5319,11868,0.451,344
8,5126,2138,0.553,467
8,4447,8577,0.529,464
7,4512,8507,0.552,498
8,4391,5939,0.53,580
7.5,5126,14186,0.525,471
7,4817,6930,0.574,525
7,4207,6580,0.545,508
7,4332,8159,0.608,566
7,4318,10340,0.586,635
7,4206,8508,0.572,603
7,3718,4725,0.54,714
7,4716,5915,0.724,865
8.5,4341,6010,0.677,640
7,4593,7834,0.663,649
8,4983,602,0.602,540
9,4897,2449,0.511,464
9,4258,4686,0.517,547
8.5,4574,2619,0.551,460
9,3721,4746,0.544,566
8,3448,5399,0.548,577
7.5,3846,9061,0.579,631
8,4188,5975,0.563,574
9,3601,4650,0.493,534
7,3640,6905,0.518,571
7,3333,6594,0.513,554
8,3063,6524,0.578,577
7.5,3357,4121,0.547,628
8,3528,3495,0.487,487
6.58,3802,7834,0.629,644
5,4045,17782,0.566,640
7,3897,6385,0.586,704
8.5,3635,3274,0.663,648
7,4345,3905,0.672,968
7,4449,4639,0.626,587
7,3656,3985,0.563,699
7,4300,3635,0.603,632
7,3745,2611,0.508,591
6,5215,2302,0.672,782
9,4476,3942,0.571,510
7,4296,4083,0.623,610
7,5002,9794,0.593,524
1) Looking at the variables, which ones do you think will affect gasoline consumption? Of the variables you think are important, which direction do you think the effect will be (i.e., what sign will its coefficient take)? 2) Now run a regression with gas consumption as the dependent variable and use the independent variables that you think are important. Discuss your results.
In: Economics
Some manufacturers claim that non-hybrid sedan cars have a lower mean miles-per-gallon (mpg) than hybrid ones. Suppose that consumers test 21 hybrid sedans and get a mean of 32 mpg with a standard deviation of 7 mpg. Thirty-one non-hybrid sedans get a mean of 21 mpg with a standard deviation of four mpg. Suppose that the population standard deviations are known to be six and three, respectively. Conduct a hypothesis test at the 5% level to evaluate the manufacturers claim.
NOTE: If you are using a Student's t-distribution for the problem, including for paired data, you may assume that the underlying population is normally distributed. (In general, you must first prove that assumption, though.)
1) State the distribution to use for the test. (Round your answers to two decimal places.)
Xhybrid − Xnon−hybrid ~ _______ (___________ , ____________)
2) What is the test statistic? (If using the z distribution round your answer to two decimal places, and if using the t distribution round your answer to three decimal places.)
3) What is the p-value? (Round your answer to four decimal
places.)
4) Sketch a picture of this situation. Label and scale the horizontal axis and shade the region(s) corresponding to the p-value.
5) Alpha (Enter an exact number as an integer,
fraction, or decimal.)
α =
In: Statistics and Probability
Professor Moore, who lives a many miles outside a college town, records the time he takes to drive to the college each morning. Below are the times (in minutes) for 22 consecutive weekdays. The data are contained in the gray columns in the following table and have been ordered from smallest to largest.
|
Observation |
Driving Time (min) |
Observation |
Driving Time (min) |
|
1 |
52 |
12 |
62.7 |
|
2 |
57.9 |
13 |
63.7 |
|
3 |
58.2 |
14 |
64.9 |
|
4 |
59 |
15 |
65.8 |
|
5 |
59.2 |
16 |
66.6 |
|
6 |
59.3 |
17 |
67.8 |
|
7 |
59.6 |
18 |
69.3 |
|
8 |
59.8 |
19 |
70 |
|
9 |
60.5 |
20 |
73.7 |
|
10 |
61 |
21 |
81.5 |
|
11 |
61.1 |
22 |
93.8 |
A) Create a frequency table. Starting point and bin size is your choice.
B) What is the
1) median,
2) First quartile
3) Third quartile
4) Interquartile range
C) Use the interquartile range (IQR) to calculate if there are any outliers.
In: Statistics and Probability
| Data Set 3 --Buena School District Bus Data | ||||||
| Bus Number | Maintenance | Age | Miles | Type | Bus-Mfg | Passenger |
| X1 | X2 | X3 | X4 | X5 | X6 | X7 |
| 135 | 329 | 7 | 853 | Diesel | Bluebird | 55 Passenger |
| 200 | 505 | 10 | 822 | Diesel | Bluebird | 55 Passenger |
| 40 | 466 | 10 | 865 | Gasoline | Bluebird | 55 Passenger |
| 387 | 422 | 8 | 869 | Gasoline | Bluebird | 55 Passenger |
| 326 | 433 | 9 | 848 | Diesel | Bluebird | 55 Passenger |
| 861 | 474 | 10 | 845 | Gasoline | Bluebird | 55 Passenger |
| 122 | 558 | 10 | 885 | Gasoline | Bluebird | 55 Passenger |
| 887 | 357 | 8 | 760 | Diesel | Bluebird | 6 Passenger |
| 686 | 329 | 3 | 741 | Diesel | Bluebird | 55 Passenger |
| 490 | 497 | 10 | 859 | Gasoline | Bluebird | 55 Passenger |
| 464 | 355 | 3 | 806 | Gasoline | Bluebird | 55 Passenger |
| 875 | 489 | 9 | 858 | Diesel | Bluebird | 55 Passenger |
| 883 | 436 | 2 | 785 | Gasoline | Bluebird | 55 Passenger |
| 57 | 455 | 7 | 828 | Diesel | Bluebird | 55 Passenger |
| 482 | 514 | 11 | 980 | Gasoline | Bluebird | 55 Passenger |
| 704 | 503 | 8 | 857 | Diesel | Bluebird | 55 Passenger |
| 731 | 432 | 6 | 819 | Diesel | Bluebird | 42 Passenger |
| 75 | 478 | 6 | 821 | Diesel | Bluebird | 55 Passenger |
| 600 | 493 | 10 | 1008 | Diesel | Bluebird | 55 Passenger |
| 358 | 461 | 6 | 849 | Diesel | Bluebird | 55 Passenger |
| 692 | 469 | 8 | 812 | Diesel | Bluebird | 55 Passenger |
| 43 | 439 | 9 | 832 | Gasoline | Bluebird | 55 Passenger |
| 500 | 369 | 5 | 842 | Gasoline | Bluebird | 55 Passenger |
| 279 | 390 | 2 | 792 | Diesel | Bluebird | 55 Passenger |
| 884 | 381 | 9 | 882 | Diesel | Bluebird | 55 Passenger |
| 977 | 501 | 7 | 874 | Diesel | Bluebird | 55 Passenger |
| 725 | 392 | 5 | 774 | Diesel | Bluebird | 55 Passenger |
| 982 | 441 | 1 | 823 | Diesel | Bluebird | 55 Passenger |
| 39 | 411 | 6 | 804 | Gasoline | Bluebird | 55 Passenger |
| 418 | 504 | 9 | 842 | Diesel | Bluebird | 55 Passenger |
| 984 | 392 | 8 | 851 | Diesel | Bluebird | 55 Passenger |
| 953 | 423 | 10 | 835 | Diesel | Bluebird | 55 Passenger |
| 507 | 410 | 7 | 866 | Diesel | Bluebird | 55 Passenger |
| 540 | 529 | 4 | 846 | Gasoline | Bluebird | 55 Passenger |
| 695 | 477 | 2 | 802 | Diesel | Bluebird | 55 Passenger |
| 321 | 450 | 6 | 856 | Diesel | Bluebird | 6 Passenger |
| 918 | 390 | 5 | 799 | Diesel | Bluebird | 55 Passenger |
| 101 | 424 | 4 | 827 | Diesel | Bluebird | 55 Passenger |
| 714 | 433 | 7 | 817 | Diesel | Bluebird | 42 Passenger |
| 768 | 494 | 7 | 815 | Diesel | Bluebird | 42 Passenger |
| 29 | 396 | 6 | 784 | Gasoline | Bluebird | 55 Passenger |
| 554 | 458 | 4 | 817 | Diesel | Bluebird | 14 Passenger |
| 699 | 475 | 9 | 816 | Gasoline | Bluebird | 55 Passenger |
| 954 | 476 | 10 | 827 | Diesel | Bluebird | 42 Passenger |
| 660 | 337 | 6 | 819 | Gasoline | Bluebird | 55 Passenger |
| 520 | 492 | 10 | 836 | Diesel | Bluebird | 55 Passenger |
| 814 | 426 | 4 | 757 | Diesel | Bluebird | 55 Passenger |
| 120 | 503 | 10 | 883 | Diesel | Keiser | 42 Passenger |
| 427 | 359 | 7 | 751 | Gasoline | Keiser | 55 Passenger |
| 759 | 546 | 8 | 870 | Diesel | Keiser | 55 Passenger |
| 10 | 427 | 5 | 780 | Gasoline | Keiser | 14 Passenger |
| 880 | 474 | 9 | 857 | Gasoline | Keiser | 55 Passenger |
| 481 | 382 | 3 | 818 | Gasoline | Keiser | 6 Passenger |
| 370 | 459 | 8 | 826 | Gasoline | Keiser | 55 Passenger |
| 989 | 380 | 9 | 803 | Diesel | Keiser | 55 Passenger |
| 162 | 406 | 3 | 798 | Gasoline | Keiser | 55 Passenger |
| 732 | 471 | 9 | 815 | Diesel | Keiser | 42 Passenger |
| 751 | 444 | 2 | 757 | Diesel | Keiser | 14 Passenger |
| 948 | 452 | 9 | 831 | Diesel | Keiser | 42 Passenger |
| 61 | 442 | 9 | 809 | Diesel | Keiser | 55 Passenger |
| 9 | 414 | 4 | 864 | Gasoline | Keiser | 55 Passenger |
| 365 | 462 | 6 | 799 | Diesel | Keiser | 55 Passenger |
| 693 | 469 | 9 | 775 | Gasoline | Keiser | 55 Passenger |
| 38 | 432 | 6 | 837 | Gasoline | Keiser | 14 Passenger |
| 724 | 448 | 8 | 790 | Diesel | Keiser | 42 Passenger |
| 603 | 468 | 4 | 800 | Diesel | Keiser | 14 Passenger |
| 45 | 478 | 6 | 830 | Diesel | Keiser | 55 Passenger |
| 754 | 515 | 14 | 895 | Diesel | Keiser | 14 Passenger |
| 678 | 428 | 7 | 842 | Diesel | Keiser | 55 Passenger |
| 767 | 493 | 6 | 816 | Diesel | Keiser | 55 Passenger |
| 705 | 403 | 4 | 806 | Diesel | Keiser | 42 Passenger |
| 353 | 449 | 4 | 817 | Gasoline | Keiser | 55 Passenger |
| 156 | 561 | 12 | 838 | Diesel | Thompson | 55 Passenger |
| 833 | 496 | 8 | 839 | Diesel | Thompson | 55 Passenger |
| 314 | 459 | 11 | 859 | Diesel | Thompson | 6 Passenger |
| 396 | 457 | 2 | 815 | Diesel | Thompson | 55 Passenger |
| 398 | 570 | 9 | 844 | Diesel | Thompson | 14 Passenger |
| 168 | 467 | 7 | 827 | Gasoline | Thompson | 55 Passenger |
| 671 | 504 | 8 | 866 | Gasoline | Thompson | 55 Passenger |
| 193 | 540 | 11 | 847 | Diesel | Thompson | 55 Passenger |
The attached MS-Excel file contains data on the contains data the bus fleet of the Buena School district. Download the file and analyze the characteristics of the Buena Bus fleet.
In: Accounting
| Data Set 3 --Buena School District Bus Data | ||||||
| Bus Number | Maintenance | Age | Miles | Type | Bus-Mfg | Passenger |
| X1 | X2 | X3 | X4 | X5 | X6 | X7 |
| 135 | 329 | 7 | 853 | Diesel | Bluebird | 55 Passenger |
| 200 | 505 | 10 | 822 | Diesel | Bluebird | 55 Passenger |
| 40 | 466 | 10 | 865 | Gasoline | Bluebird | 55 Passenger |
| 387 | 422 | 8 | 869 | Gasoline | Bluebird | 55 Passenger |
| 326 | 433 | 9 | 848 | Diesel | Bluebird | 55 Passenger |
| 861 | 474 | 10 | 845 | Gasoline | Bluebird | 55 Passenger |
| 122 | 558 | 10 | 885 | Gasoline | Bluebird | 55 Passenger |
| 887 | 357 | 8 | 760 | Diesel | Bluebird | 6 Passenger |
| 686 | 329 | 3 | 741 | Diesel | Bluebird | 55 Passenger |
| 490 | 497 | 10 | 859 | Gasoline | Bluebird | 55 Passenger |
| 464 | 355 | 3 | 806 | Gasoline | Bluebird | 55 Passenger |
| 875 | 489 | 9 | 858 | Diesel | Bluebird | 55 Passenger |
| 883 | 436 | 2 | 785 | Gasoline | Bluebird | 55 Passenger |
| 57 | 455 | 7 | 828 | Diesel | Bluebird | 55 Passenger |
| 482 | 514 | 11 | 980 | Gasoline | Bluebird | 55 Passenger |
| 704 | 503 | 8 | 857 | Diesel | Bluebird | 55 Passenger |
| 731 | 432 | 6 | 819 | Diesel | Bluebird | 42 Passenger |
| 75 | 478 | 6 | 821 | Diesel | Bluebird | 55 Passenger |
| 600 | 493 | 10 | 1008 | Diesel | Bluebird | 55 Passenger |
| 358 | 461 | 6 | 849 | Diesel | Bluebird | 55 Passenger |
| 692 | 469 | 8 | 812 | Diesel | Bluebird | 55 Passenger |
| 43 | 439 | 9 | 832 | Gasoline | Bluebird | 55 Passenger |
| 500 | 369 | 5 | 842 | Gasoline | Bluebird | 55 Passenger |
| 279 | 390 | 2 | 792 | Diesel | Bluebird | 55 Passenger |
| 884 | 381 | 9 | 882 | Diesel | Bluebird | 55 Passenger |
| 977 | 501 | 7 | 874 | Diesel | Bluebird | 55 Passenger |
| 725 | 392 | 5 | 774 | Diesel | Bluebird | 55 Passenger |
| 982 | 441 | 1 | 823 | Diesel | Bluebird | 55 Passenger |
| 39 | 411 | 6 | 804 | Gasoline | Bluebird | 55 Passenger |
| 418 | 504 | 9 | 842 | Diesel | Bluebird | 55 Passenger |
| 984 | 392 | 8 | 851 | Diesel | Bluebird | 55 Passenger |
| 953 | 423 | 10 | 835 | Diesel | Bluebird | 55 Passenger |
| 507 | 410 | 7 | 866 | Diesel | Bluebird | 55 Passenger |
| 540 | 529 | 4 | 846 | Gasoline | Bluebird | 55 Passenger |
| 695 | 477 | 2 | 802 | Diesel | Bluebird | 55 Passenger |
| 321 | 450 | 6 | 856 | Diesel | Bluebird | 6 Passenger |
| 918 | 390 | 5 | 799 | Diesel | Bluebird | 55 Passenger |
| 101 | 424 | 4 | 827 | Diesel | Bluebird | 55 Passenger |
| 714 | 433 | 7 | 817 | Diesel | Bluebird | 42 Passenger |
| 768 | 494 | 7 | 815 | Diesel | Bluebird | 42 Passenger |
| 29 | 396 | 6 | 784 | Gasoline | Bluebird | 55 Passenger |
| 554 | 458 | 4 | 817 | Diesel | Bluebird | 14 Passenger |
| 699 | 475 | 9 | 816 | Gasoline | Bluebird | 55 Passenger |
| 954 | 476 | 10 | 827 | Diesel | Bluebird | 42 Passenger |
| 660 | 337 | 6 | 819 | Gasoline | Bluebird | 55 Passenger |
| 520 | 492 | 10 | 836 | Diesel | Bluebird | 55 Passenger |
| 814 | 426 | 4 | 757 | Diesel | Bluebird | 55 Passenger |
| 120 | 503 | 10 | 883 | Diesel | Keiser | 42 Passenger |
| 427 | 359 | 7 | 751 | Gasoline | Keiser | 55 Passenger |
| 759 | 546 | 8 | 870 | Diesel | Keiser | 55 Passenger |
| 10 | 427 | 5 | 780 | Gasoline | Keiser | 14 Passenger |
| 880 | 474 | 9 | 857 | Gasoline | Keiser | 55 Passenger |
| 481 | 382 | 3 | 818 | Gasoline | Keiser | 6 Passenger |
| 370 | 459 | 8 | 826 | Gasoline | Keiser | 55 Passenger |
| 989 | 380 | 9 | 803 | Diesel | Keiser | 55 Passenger |
| 162 | 406 | 3 | 798 | Gasoline | Keiser | 55 Passenger |
| 732 | 471 | 9 | 815 | Diesel | Keiser | 42 Passenger |
| 751 | 444 | 2 | 757 | Diesel | Keiser | 14 Passenger |
| 948 | 452 | 9 | 831 | Diesel | Keiser | 42 Passenger |
| 61 | 442 | 9 | 809 | Diesel | Keiser | 55 Passenger |
| 9 | 414 | 4 | 864 | Gasoline | Keiser | 55 Passenger |
| 365 | 462 | 6 | 799 | Diesel | Keiser | 55 Passenger |
| 693 | 469 | 9 | 775 | Gasoline | Keiser | 55 Passenger |
| 38 | 432 | 6 | 837 | Gasoline | Keiser | 14 Passenger |
| 724 | 448 | 8 | 790 | Diesel | Keiser | 42 Passenger |
| 603 | 468 | 4 | 800 | Diesel | Keiser | 14 Passenger |
| 45 | 478 | 6 | 830 | Diesel | Keiser | 55 Passenger |
| 754 | 515 | 14 | 895 | Diesel | Keiser | 14 Passenger |
| 678 | 428 | 7 | 842 | Diesel | Keiser | 55 Passenger |
| 767 | 493 | 6 | 816 | Diesel | Keiser | 55 Passenger |
| 705 | 403 | 4 | 806 | Diesel | Keiser | 42 Passenger |
| 353 | 449 | 4 | 817 | Gasoline | Keiser | 55 Passenger |
| 156 | 561 | 12 | 838 | Diesel | Thompson | 55 Passenger |
| 833 | 496 | 8 | 839 | Diesel | Thompson | 55 Passenger |
| 314 | 459 | 11 | 859 | Diesel | Thompson | 6 Passenger |
| 396 | 457 | 2 | 815 | Diesel | Thompson | 55 Passenger |
| 398 | 570 | 9 | 844 | Diesel | Thompson | 14 Passenger |
| 168 | 467 | 7 | 827 | Gasoline | Thompson | 55 Passenger |
| 671 | 504 | 8 | 866 | Gasoline | Thompson | 55 Passenger |
| 193 | 540 | 11 | 847 | Diesel | Thompson | 55 Passenger |
The attached MS-Excel file contains data on the contains data the bus fleet of the Johnson Bus Fleet. Download the file and analyze the characteristics of the Johnson Bus fleet.
a.Sort the data by type of Bus Manufacturer and calculate the Average Cost and Standard Deviation of Maintenance for each Manufacturer
b. Sort the data by Fuel Type and calculate the cost of Maintenance and the Average Mileage and Standard deviation of mileage by each fuel type of fuel
c. Present your results in a table. Cut and paste your chart and table into MS-Word and attach your results.
In: Statistics and Probability