Recent content by SerenityNetworks

  1. SerenityNetworks

    [Excel] Determine errors that would have been encountered if required confidence for sample size was met (when it wasn't)

    Thanks kat. That's the solution I was pondering this morning. I can't think of anything better and it is consistent across all ranges of sample sets. I appreciate the confirmation. I agree to that this will end up being a management decision. I just want to offer a well thought through...
  2. SerenityNetworks

    [Excel] Determine errors that would have been encountered if required confidence for sample size was met (when it wasn't)

    The blue formulas are the ones per contract. The yellow is a gap in the contract for which we are trying to help find a fair and accurate method for assessing penalties.
  3. SerenityNetworks

    [Excel] Determine errors that would have been encountered if required confidence for sample size was met (when it wasn't)

    Hmmm. That seemed a great idea at first glance. But it has some inconsistencies. With a smaller sample size (3889) the one who misses 5 would be penalized the same as one that missed 4. For larger sample sizes (38890) the ones who miss 32 to 40 are penalized more heavily than one that missed...
  4. SerenityNetworks

    [Excel] Determine errors that would have been encountered if required confidence for sample size was met (when it wasn't)

    No, sorry. I have not been clear. This is not industrial testing where double sampling or any kind of resampling is occurring. This is vehicle detection testing. A vehicle passes and it is either detected or it is not detected. In my example, 3889 vehicles passed the detection area. If 1...
  5. SerenityNetworks

    [Excel] Determine errors that would have been encountered if required confidence for sample size was met (when it wasn't)

    In this case, I'm talking about what I understand to be confidence level. In my example, the 90% confidence level that is required says that if the audit were repeated over and over again (above and beyond the 3889 samples we audited), the results would match the results from the actual 3889...
  6. SerenityNetworks

    [Excel] Determine errors that would have been encountered if required confidence for sample size was met (when it wasn't)

    In my case, I perform an accuracy audits where, for example, my required accuracy is 99.90% and my required confidence level is 90.00%. In my case, the calculations are binomial; that is, a single test is either right or it's wrong, then I move to the next. There is no resampling. I use Excel...