Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Buservice Inc. is a transportation company in the Tampa area that provides bus services. Twelve months ago. Buservice Inc. initiated a project with the
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.
Step by Step Solution
★★★★★
3.38 Rating (151 Votes )
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started