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: