Question

1. The attached MS-Excel file contains data on 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.

Answer 1

You have not produced the Excel data, but I can tell you how to do questions (a) and (b).

a) I'm guessing that Type of Bus Manufacturer is a separate column. To sort the data by type of Bus Manufacturer, select the entire data, click on Data, select Sort and a dialog box will appear. In the drop-list for Sort By, select Type of Bus Manufacturer and your data is sorted!

To calculate Average Cost, click on the cell where you want to show the average. Type "=AVERAGE(number1,number2,....)". After inserting the opening bracket, you just need to select the values of cost the paticular type of manufacturer. You can repeat this for all kinds of manufacturers.

To calculate Standard Deviation of Maintenance, use the formula "=STDEV.P(values)". The values would be the Maintenance of each Type of Bus Manufacturer.

b) Use the same steps used in (a). Just tweak the values according to the question.