Buservice Inc. is a transportation company in the Tampa area that provides bus services. Twelve months...

 

Transcribed Image Text:

Buservice Inc. is a transportation company in the Tampa area that provides bus services. Twelve months ago. Buservice Inc. initiated a project with the intent of reducing the annual maintenance cost, with an experiment executed with two identical new buses. Bus #32 had the TRADITIONAL preventive maintenance program executed as usual, while Bus # 33 had the NEW preventive maintenance program in the first 12 months of its life. The 12-month project was just completed this week and the following table was put together to present the monthly maintenance cost for the first 12 months for both buses: Month 1 5 6 7 8 9 10 11 12 Bus #32 Monthly Maintenance Cost (S/month) 2,450 3,235 3,780 4,275 5,425 6,890 6,580 7,350 8,750 8,250 9,245 10,025 TOPIC. Bus #33 Monthly Maintenance Cost (S/month) 1,250 2,060 1,890 2,290 2,540 2,890 3,750 3,150 4.250 3,590 5,250 4,000 Maintenance Reduction (S/month) a) (1 point) - Create a descriptive statistics analysis in Excel at 95% confidence level for the maintenance cost data for Bus #32 and Bus # 33. Use the output form the descriptive analysis tool and compare average, standard deviation and coefficient of variation between Bus # 32 and # 33. UPLOAD THE EXCEL SPREADSHEET FOR THIS CALCULATION IN ORDER TO GET POINTS FOR THIS TOPIC. b) (1 point) - Use the output from the descriptive statistics analysis in topic (a) and create a confidence interval for 95% confidence level for the monthly maintenance cost for Bus # 32 and # 33. UPLOAD THE EXCEL SPREADSHEET FOR THIS CALCULATION IN ORDER TO GET POINTS FOR THIS c) (1 point) - Create a Scatter Chart with the monthly maintenance cost y-axis and month # on x-axis for both buses. Include axis title and chart title. What is your analysis of this chart? Discuss in detail. UPLOAD THE EXCEL SPREADSHEET FOR THIS CALCULATION IN ORDER TO GET POINTS FOR THIS TOPIC. Buservice Inc. is a transportation company in the Tampa area that provides bus services. Twelve months ago. Buservice Inc. initiated a project with the intent of reducing the annual maintenance cost, with an experiment executed with two identical new buses. Bus #32 had the TRADITIONAL preventive maintenance program executed as usual, while Bus # 33 had the NEW preventive maintenance program in the first 12 months of its life. The 12-month project was just completed this week and the following table was put together to present the monthly maintenance cost for the first 12 months for both buses: Month 1 5 6 7 8 9 10 11 12 Bus #32 Monthly Maintenance Cost (S/month) 2,450 3,235 3,780 4,275 5,425 6,890 6,580 7,350 8,750 8,250 9,245 10,025 TOPIC. Bus #33 Monthly Maintenance Cost (S/month) 1,250 2,060 1,890 2,290 2,540 2,890 3,750 3,150 4.250 3,590 5,250 4,000 Maintenance Reduction (S/month) a) (1 point) - Create a descriptive statistics analysis in Excel at 95% confidence level for the maintenance cost data for Bus #32 and Bus # 33. Use the output form the descriptive analysis tool and compare average, standard deviation and coefficient of variation between Bus # 32 and # 33. UPLOAD THE EXCEL SPREADSHEET FOR THIS CALCULATION IN ORDER TO GET POINTS FOR THIS TOPIC. b) (1 point) - Use the output from the descriptive statistics analysis in topic (a) and create a confidence interval for 95% confidence level for the monthly maintenance cost for Bus # 32 and # 33. UPLOAD THE EXCEL SPREADSHEET FOR THIS CALCULATION IN ORDER TO GET POINTS FOR THIS c) (1 point) - Create a Scatter Chart with the monthly maintenance cost y-axis and month # on x-axis for both buses. Include axis title and chart title. What is your analysis of this chart? Discuss in detail. UPLOAD THE EXCEL SPREADSHEET FOR THIS CALCULATION IN ORDER TO GET POINTS FOR THIS TOPIC.