- Data analyst
- Junior
- 30 min
A sample spread report
Plover Dispatch recorded sample as a sample of delivery minutes, with one missing observation. Create numeric result containing the sample standard deviation, excluding missing observations. The denominator must use the number of observed values minus one.
Skills and rubricA sample spread report
- I exclude the missing observation and calculate sample standard deviation with ddof=1 because these deliveries are a sample of the process. The result is in minutes. I report the observed count separately so the missing record does not masquerade as a zero-minute delivery.
- The missing observation reduces the observed sample size. I neither fill it with zero nor include it in the denominator because either choice changes the measured spread. Squaring standard deviation yields variance, which has different units.
- I retain the source records, the saved work and the checked output because another analyst must be able to reproduce this result. I record the observation window and the unresolved limitation. The decision owner approves any exception before this result changes a business action.