Create a histogram that summarizes your data set

Assignment Help Applied Statistics

Reference no: EM133461185

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: EM133461185

Questions Cloud

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

Where in the globe are there economic concepts : Where in the globe are there economic concepts? Where can an economist's perspective help us to make sense of society's mysteries?

Community problem-solving eras of policing : Define and give a brief history of the political, reform and community problem-solving eras of policing. What were the problems with policing during each era?

Why would you increase or decrease the tax rate : which are some of the goods or services (name at least three) that you would concentrate on? Would you increase or decrease the tax rate? Why?

Bob supervisors take to encourage ethical decision : Bob is a police officer assigned to the juvenile division. What steps could Bob's supervisors take to encourage an ethical decision?

User Account

All Pages