Question: Workshop 2: Descriptive Statistics and Histograms The tools practiced in this workshop are: Descriptive statistics Histograms NOTE: Complete the Histogram and descriptive statistics in MS

Workshop 2: Descriptive Statistics and Histograms

The tools practiced in this workshop are:

  • Descriptive statistics
  • Histograms

NOTE: Complete the Histogram and descriptive statistics in MS Excel and cut and paste the results into this document. Submit the MS Word Workshop 2 into the Dropbox in Week 5: Module 4 module.

Situation:

Consider that you/your group works for a pipe manufacturing operation and you have been tasked with collecting data to document the current performance of your production process. 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 pipe production process are:

Target: 0.9 0.3 cm (lower specification limit: 0.6 cm and upper specification limit: 1.2 cm)

NOTE: The raw data that you will use is at the bottom of this workshop.

Instructions:

To create a baseline measurement, you have collected a random sample of the pipes produced from your production process (data is at the bottom of this Workshop). You then measured the diameter (the distance across the round end) in centimeters (cm) of the pipes. You recorded your measurements in a table (see the data at the end of this Workshop). Use Microsoft Excel to calculate your descriptive statistics, create a histogram of your data, and provide answers to the questions below.

Activities: (also see next page)

  1. For the pipes produced by your production process, what is the:(each answer is worth 0.2 pts)
  1. Mean diameter in centimeters (cm)?

  1. Standard deviation in cm?

  1. Minimum in cm?

  1. Maximum in cm?

  1. Range in cm?

  1. Create a histogram that summarizes your data set (i.e., measurements of the pipe diameter in centimeters): (1 pt)
  2. Near the end of your Lean Six Sigma project, after you have implemented solutions to improve your pipe production process, you measure the process performance again and get the following results:

Diameter Mean: 0.95 cm; standard deviation: 0.11 cm; minimum & maximum: 0.8-1.2 cm

  1. Have you improved the process? Yes or no and why. (2 pts)

Hint: Perform a before and after comparison by comparing the baseline measurements in Activity #1a-e of this Workshop with the measurements given in this question.

  1. How well does the improved process fulfill customer requirements? (1 pt)

Hint: Perform another comparison by comparing the measurements given in this question to the customer specifications given in the Situation part of this Workshop.

1.4

1.1

1.2

1.3

1.2

1.1

1.3

1.3

1.2

1.2

1.2

1.2

1.4

1.0

1.3

1.2

1.2

1.2

1.2

1.2

1.3

1.2

1.4

1.1

1.3

1.2

1.3

1.2

1.3

1.2

1.2

1.2

1.4

1.1

1.3

1.4

1.4

1.4

1.0

0.9

0.9

1.2

1.2

1.5

0.9

1.2

1.2

1.3

1.1

1.4

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Q:

Workshop 2: Histograms and Descriptive Statistics The tools practiced in this workshop are: Histograms Descriptive statistics . Situation: Consider that you/your group works for a housekeeping...

Q:

Workshop 2 : Histograms and Descriptive Statistics Practice Tools: Descriptive statistics and Histograms Situation: Suppose you work for a company that makes fruit flavored candy. The high season for...

Q:

Workshop 2: 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...

Q:

Drive (miles) 4 6 6 20 25 25 28 29 33 36 36 36 36 36 40 42 42 54 54 55 63 63 71 71 73 76 76 76 78 80 80 80 80 88 94 State MI SC OR MI GA CA NY TX SC TX CA MI TX OR IL FL IL FL NY OH PA OR MI MI FL NY...

Q:

Guidance for iLab Report for Week 2 The dataset for the Week 2 iLab assignment resides in Doc Sharing as an Excel document, called \"Excel Data Sheet for iLab Assignments\". You will be using...

Q:

Stat 243 Lab 1 - Getting Started in Minitab (Descriptive Statistics and Histograms) Background: All labs in this course will involve the use of Minitab, a statistical software package installed on...

Q:

We had to complete a mock psuedo from our research question. My research question is: How will schools develop and design a building block of curriculum and instructional services in order to provide...

Q:

Welcome! Please read this page (in particular) very carefully. Instructions You need to understand how to send your assignments (deliverables) Instructor: to your instructor. The tabs (bottom of each...

Q:

The tools practiced in this workshop are: Descriptive statistics Histograms NOTE: Complete the Histogram and descriptive statistics in MS Excel and cut and paste the results into this document....

Q:

FEMALE AGE HT 295 17 64.3 2739 32 66.4 2992 25 62.3 3745 55 62.3 4486 27 59.6 4488 29 63.6 4878 25 59.8 4880 12 63.3 4881 41 67.9 4835 32 61.4 4842 31 66.7 6225 19 64.8 8680 19 63.1 8681 23 66.7...

Q:

Write each expression in the form a + bi. a. (2 + 4i) - (5 + 2i) b. (2 + 4i) (5 + 2i) c. 2 + 4i / 5 2i

Q:

The nominal interest rate associated with an ordinary general annuity is 8% compounded quarterly. Rounded to the nearest 0.001%, what is the corresponding periodic rate of interest that matches the...

Q:

Question 1 of 1 2 In a joint tenancy account, who continues to have access to the funds following the death of one account owner? Select the correct answer, and then select Submit.Designated...

Q:

Question 9 The following is a set of hypothetical production possibilities for a nation: Combination Turkeys (thousands) Chickens (thousands) A 0 20 B 4 18 C 8 14 D 12 8 E 16 0 (a)What is the...