Calculate Error Percentage - Excel by ecb12316

VIEWS: 0 PAGES: 1

Calculate Error Percentage document sample

More Info
									                                      Calculating a Statistically Valid Sample Size

     x      =   1.96       2      *       PQ                                           n       =         x
                 p                                                                                 1+         (x-1)
                                                          N=   Population Size                                  N
                                                          p=   Desired Precision Level
Population  =   351,526                                   P=   Expected Rate of Perfomance
Precision   =       3.00                                  Q=   100 - P
Performance =      99.00


          x =   1.96       2          *            99.00         1.00                        n =               42.2576
                3.00
                                                                                                        1+    42.2576 -1
            = 0.6533333 2             *              99                                                        351526

                                                                                               =               42.2576
            = 0.4268444               *              99
                                                                                                        1+     41.2576
                                                                                                               351526
          x =       42.3
                                                                                               =              42.2576
                                                                                                        1+ 0.000117367
                           Population Size                                351,526
                           Confidence Level (usually 95%)                     95%              =              42.2576
                           Expected Error rate not over                      1.0%                            1.000117
                           Precision percentage of Plus or Minus             3.0%
                           Valid Statistically valid sample size            42

								
To top