Week
Three: Group Activity
- Are We in Trouble?
Learning
Activities
|
In the first two
activities, you demonstrated your abilities to collect data,
determine the descriptive statistics for that data (assuming
a normal distribution), and analyzed the measurement system to
determine possible measurement errors.
This activity focuses
on linking the analysis skills learned in the first two activities
to the questions, "Does our product meet our customer requirements?"
and "What % of our product will fall outside of the specified
requirements?"
You will be asked
to work the exercise:
Setting a Light
Bulb Warranty Period
|
 |
Are we meeting
our customer's requirements? What % are out of tolerance?
The web site that
provides instruction about the standard normal distribution and
the standard tables. In addition, the web site provides two MS
Excel worksheets, one that calculates the normal probabilities
from the average, standard deviation, and specifications and the
second table provides the cumulative normal distribution from
0 to 5.09 z's
Link
to Carillon Technologies Site - Standard Normal Distribution
Review the standard
normal tables in the reference materials, the Quality Toolkit and
in AIAG's Statistical Process Control pages 5 - 18.
Setting the Light Bulb Warranty
Period
From the NCE/AME Statistical Distribution
Module
"A warranty period is the period of
time that a manufacturer guarantees that the product will meet
the requirements of the customer. Any problems occuring during
this period will be resolved at the manufacturer's expense."
The company wishes to set a warranty period
for a 7 volt AC lamp bulb.
1. Given the following data construct a
histogram, and perform a statistical analysis of the data.
|
Hours
to Burn Out |
Number
of Bulbs |
| 80
-120 |
1 |
| 120
- 160 |
4 |
| 160
- 200 |
25 |
| 200
- 240 |
4 |
| 240
- 280 |
1 |
2. Using the mean and standard deviation
of the light bulb data that you calculated, predict the number
of hours until a light bulb will burn out given that we want a
warranty period when a maximum of 1%, 2.5% or 5% of the bulbs
will burn out.
3. If a light bulb sells for $0.40 and it
costs $0.05 to produce, which warranty period would you choose,
given that marketing states at a high quality warranty can at
best effect up to a 10% increase in selling price.
Assessment
 |
Warranty Problem:
Post your answers, to questions 1-3,
to the discussion board with the appropriate excel or word file
attached. Be prepared to discuss your results. |