Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Accounting

Authors: Gail Fayerman

1st Canadian Edition

9781118774113, 1118774116, 111803791X, 978-1118037911

More Books

Students also viewed these Accounting questions