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

Reviews

Write a Review

Applied Statistics Questions & Answers

  Hypothesis testing

What assumptions about the number of pedestrians passing the location in an hour are necessary for your hypothesis test to be valid?

  Calculate the maximum reduction in the standard deviation

Calculate the maximum reduction in the standard deviation

  Calculate the expected value, variance, and standard deviati

Calculate the expected value, variance, and standard deviation of the total income

  Determine the impact of social media use on student learning

Research paper examines determine the impact of social media use on student learning.

  Unemployment survey

Find a statistics study on Unemployment and explain the five-step process of the study.

  Statistical studies

Locate the original poll, summarize the poling procedure (background on how information was gathered), the sample surveyed.

  Evaluate the expected value of the total number of sales

Evaluate the expected value of the total number of sales

  Statistic project

Identify sample, population, sampling frame (if applicable), and response rate (if applicable). Describe sampling technique (if applicable) or experimental design

  Simple data analysis and comparison

Write a report on simple data analysis and comparison.

  Analyze the processed data in statistical survey

Analyze the processed data in Statistical survey.

  What is the probability

Find the probability of given case.

  Frequency distribution

Accepting Manipulation or Manipulating

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd