Sunday, July 4, 2021

Perform a One Sample Proportion Test in Excel

This video covers how to perform a one sample test for proportion. This type of test used to estimate the proportion of a population. It compares the proportion to a target or reference value . Unfortunately Excel doesn't have a function in the Data Analysis Tool-pack to do this in a few steps, but it's not that hard if you lay out the calculations in a column and then re-use if needed.

No comments:

Post a Comment