In: Statistics and Probability
A local bottling company has determined the number
of machine breakdowns
per month and their results are below:
Breakdowns (x) Probability
(x-mean)^2
0
............................0.15...............?
1
............................0.41...............?
2 ............................0.22
..............?
3
............................0.17...............?
4
............................0.04...............?
5
............................0.01...............?
Use the SUMPRODUCT function in Excel to answer parts a
and b.
a) The expected number (mean) of machine
breakdowns per month is:
b) The variance of the machine breakdowns per
month is:
c) The standard deviation of the machine
breakdowns per month is: