Getting ready

To prepare for this recipe, do the following:

1. Open Power BI Desktop.
2. Import the data from the Ch11R11Data.xlsx Excel file located in the GitHub repository. Ensure that the created table is called R11_2TailZScores.
3. Create the following tables:

R11_Precision = 
    SELECTCOLUMNS(
        GENERATESERIES(.01,.1,.01),
        "Precision",
        [Value]
    )

R11_Proportion = 
    SELECTCOLUMNS(
        GENERATESERIES(.1,.9,.1),
        "Proportion",
        [Value]
    )

These three tables represent inputs into our sample size formula. The R11_2TailZScores table is also a lookup table for the z-score corresponding to a desired confidence level.