How well does the improved process fulfill customer

Assignment Help Applied Statistics

Reference no: EM133461189

Workshop: Histograms and Descriptive Statistics

The tools practiced in this workshop are:
• Histograms
• Descriptive statistics

Situation:
Consider that you/your group works for a housekeeping company, and you have been tasked with collecting data to document the current status of your cleaning performance. This data is needed to establish a baseline measurement at the beginning of your Lean Six Sigma project so that you will have a measurement to compare against later once the process has been improved.
Please note that the customer specifications for your cleaning service process are:
Target: 30 ± 5 minutes (lower specification limit: 25 min and upper specification limit: 35 min)

Instructions:
Use information from your training manual in Measure Phase - Lessons 9-11 to assist you with the activities that follow. Be sure to follow the "best practices" for each tool you use in this workshop.

Your baseline data of cleaning times is provided. Use Microsoft Excel to calculate your descriptive statistics and create a histogram of your data.

Activities: (also see next page)
1. For the cleaning times documented by your cleaning process, what is the:
a. Average cleaning time in minutes?
b. Standard deviation in minutes?
c. Range in minutes?
2. Create a histogram that summarizes your data set (i.e., measurements of the cleaning times in minutes) Your histogram should have at least 10 bars:
[Create your histogram on the Workshop Data Sheet "Cleaning Time Data" and submit the Excel spreadsheet with your workshop.]
3. Near the end of your Lean Six Sigma project, after you have implemented solutions to improve your cleaning process, you measure the process performance again and get the following results:

Cleaning time - Average: 30 minutes; standard deviation: 15 minutes cm; range: 10-75 min

a. Have you improved the process? Yes or no and why.
Hint: Perform a before and after comparison by comparing the baseline measurements in Activity #1a-c of this Workshop with the measurements given in this question.

b. How well does the improved process fulfill customer requirements?
Hint: Perform another comparison by comparing the measurements given in this question to the customer specifications given in the "Situation" part of this Workshop.

4. Use QI Macros to create a Histogram for the data in the "Help Desk Time" tab in the Workshop Data Sheet.

Note: Save the completed spreadsheet and submit it with your workshop.

Attachment:- workshop data.rar

Reference no: EM133461189

Questions Cloud

Why phishing attack works : Gives a critical literature review and in-depth understanding of why phishing attack works. For some parts use tables and lists to make it more creative

How does the unemployment rate compare to pre-covid levels : How does the unemployment rate compare to pre-covid levels? To other countries in the Caribbean? To the UK? To the US?

What determines the price elasticity of demand for eggs : What determines the price elasticity of demand for eggs? Find out what other food prices have risen or fallen a lot in recent months, and explain why.

When an economy is on the keynesian segment : explain why an increase in spending when an economy is on the Keynesian segment of the AS curve causes a large increase in RGDP but only a small increase

How well does the improved process fulfill customer : How well does the improved process fulfill customer requirements - Use QI Macros to create a Histogram for the data in the "Help Desk Time" tab in the Workshop

How diminishing marginal utility might cause consumers : Explain how diminishing marginal utility might cause consumers to switch from one good or service to another. Share an example of a time you made such a choice

Explain the intended effect of the australian reserve bank : Explain the intended effect of the Australian Reserve Bank's monetary policy and illustrate your explanation with an appropriate graphical analysis

Describe what you would expect elasticity to look like for : Pick one type of elasticity and a good (or pair of goods) Describe what you would expect elasticity to look like for the good(s) and explain why you think it

Create a histogram that summarizes your data set : Create a histogram that summarizes your data set (i.e., measurements of the cleaning times in minutes) Your histogram should have at least 10 bars

User Account

All Pages