Question

1. The attached MS-Excel file contains data on the bus fleet of the Johnson Bus Fleet....

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.

Homework Answers

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.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Instructions: Ensure that the version number on the Word file and the Excel data file match....
Instructions: Ensure that the version number on the Word file and the Excel data file match. Type your answers in the blank areas. Save the file as “Chapter 8-9 Exam – Your Name”. Submit your completed Word file on Blackboard under the Exam 3 Folder. The manufacturer of a new line of ink-jet printers would like to include as part of its advertising the number of pages a user can expect from a print cartridge. The results from a sample...
For this discussion forum, refer to the Excel file Discussion 8-1 Data Set that contains information...
For this discussion forum, refer to the Excel file Discussion 8-1 Data Set that contains information on the following: In the healthcare profession, you will be presented with ANOVA tables using different forms of technology (i.e. SPSS, Minitab, Excel, SAS, etc.). An important part of the analysis is to take the results from the ANOVA and make the proper inferences from it. Identify the worksheet (tab) that matches the first letter of your LAST name (i.e., if your last name...
1. Johnson Filtration, Inc., provides maintenance service for water-filtration systems throughout southern Florida. Customers contact Johnson...
1. Johnson Filtration, Inc., provides maintenance service for water-filtration systems throughout southern Florida. Customers contact Johnson with requests for maintenance service on their water-filtration systems. To estimate the service time and the service cost, Johnson’s managers want to predict the repair time necessary for each maintenance request. Management collected data over the last 10 service calls, and ran a multiple regression analysis on this sample. As a result, they developed the following estimated regression equation to predict y = the...
DRIVING ARI FLEET MANAGEMENT WITH REAL-TIME ANALYTICS Automotive Resources International, better known as simple ARI, is...
DRIVING ARI FLEET MANAGEMENT WITH REAL-TIME ANALYTICS Automotive Resources International, better known as simple ARI, is the world's largest privately-held company for vehicle fleet management services. ARI is headquartered in Mt. Laurel, New Jersey and has 2,500 employees and offices throughout North America, Europe, the UK and Hong Kong. The company manages more than 1,000,000 vehicles in the US, Canada, Mexico, Puerto Rico and Europe. Businesses that need vehicles for shipments (trucks, vans, cars, ships, and rail cars) may choose...
Grab your bag of M & Ms and sort them out by color. Record the number...
Grab your bag of M & Ms and sort them out by color. Record the number of each color in row A of the table below. Also record the total number of M&Ms in your bag, n. Calculate the expected value of each color in a bag of size n. Record your results in Row B. Calculate the standard deviation for each color in a bag of size n. Record your results in Row C. Using the Range-Rule-Of-Thumb, calculate the...
MTH 241 COMMON DATA ANALYSIS ASSIGNMENT (Fall 2018) Previous studies have shown that urban bus drivers...
MTH 241 COMMON DATA ANALYSIS ASSIGNMENT (Fall 2018) Previous studies have shown that urban bus drivers have an extremely stressful job, and a large proportion of drivers retire prematurely with disabilities due to occupational stress. These stresses come from a combination of physical and social sources such as traffic congestion, incessant time pressure, and unruly passengers. In the paper, “Hassles on the Job: A Study of a Job Intervention with Urban Bus Drivers” (Journal of Organizational Behavior, Vol. 20, pp....
Assignment: Testing a Manufacturer’s MPG Claim: Part 1 Companies often develop and test hypotheses about their...
Assignment: Testing a Manufacturer’s MPG Claim: Part 1 Companies often develop and test hypotheses about their products. For example, car manufacturers will test their cars to determine fuel efficiency and miles per gallon. To ensure that products are safe and that they perform as advertised, regulatory and consumer protection groups also test companies’ claims. For this Assignment, you are working at a firm that conducts independent testing for heavy industry Recently, an automobile manufacturer has been in the news for...
Data For Tasks 1-8, consider the following data: 7.2, 1.2, 1.8, 2.8, 18, -1.9, -0.1, -1.5,...
Data For Tasks 1-8, consider the following data: 7.2, 1.2, 1.8, 2.8, 18, -1.9, -0.1, -1.5, 13.0, 3.2, -1.1, 7.0, 0.5, 3.9, 2.1, 4.1, 6.5 In Tasks 1-8 you are asked to conduct some computations regarding this data. The computation should be carried out manually. All the steps that go into the computation should be presented and explained. (You may use R in order to verify your computation, but not as a substitute for conducting the manual computations.) A Random...
MATH220 Lab04 Due Date: See ACE Excel File: Lab2204-182.xlsx 1 Question 1: (by hand) A retail...
MATH220 Lab04 Due Date: See ACE Excel File: Lab2204-182.xlsx 1 Question 1: (by hand) A retail establishment accepts either the American Express card or the VISA credit card. A total of 30% of its customers carry an American Express card, 70% carry a VISA card, and 20% carry both. a) Find the probability that a randomly selected customer carries at least one of the two credit cards. i) Draw a Venn diagram and shade the region corresponding to at least...
The assignment is: Next, in SPSS, run frequency distributions for each of the categorical variables and...
The assignment is: Next, in SPSS, run frequency distributions for each of the categorical variables and descriptive statistics for each of the continuous variables. Consider also creating a graph or chart in SPSS to describe these distributions. For variables that have very small frequencies in at least one category (e.g., less than 7 people in a category), think about combining that category with another if it makes conceptual sense (i.e., there are very few Native Americans, does it make sense...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT