Hello everyone,
I’m currently working on a Customer Satisfaction (CSAT) dashboard in AWS QuickSight, and I want to calculate the required sample size to ensure that the survey results are statistically valid. Specifically, I’m looking to calculate the sample size needed for a 95% confidence level with a 0.5% margin of error for a population of around 1,000 active clients.
I understand the standard sample size formula involves:

The Zscore (for 95% confidence, this is 1.96),

The population proportion (p) (which I’m assuming to be 0.5 for the most conservative estimate),

The margin of error (set to 0.5%).

ZZZ = 1.96 (for 95% confidence),

p=0.5p = 0.5p=0.5,

e=0.005e = 0.005e=0.005 (margin of error),

N=1,000N = 1,000N=1,000 (active clients).
Has anyone successfully implemented such a calculation in AWS QuickSight? Are there any alternative methods or workarounds for calculating sample sizes within QuickSight, or would you recommend calculating it externally and then importing the result?
Any guidance or examples would be greatly appreciated!