Algorithm for sample availability prediction in a hospital-based epidemiological study spreadsheet-based sample availability calculator

Looking at the population’s behavior by taking samples is quite uncertain due to its big and dynamic structure and unimaginable variability. All quantitative sampling approaches aim to draw a representative sample from the population so that the results of the studying samples can then be generalized back to the population. The probability of detecting a true effect of a study largely depends on the sample size and if taking small samples will give lowers statistical power, higher risk of missing a meaningful underlying difference. The probability of rejecting the null hypothesis i.e., finding significant difference using the sample largely depends upon the statistical power. There are a lot of online tools used for calculating the sample size, but none tell us about the availability of samples from single site in a fixed span. This study aims to provide an efficient calculation method for the availability of samples during a specific period of a research study which is an important question to be answered during the research study design. So, we have designed a spreadsheet-based sample availability calculator tool implemented in MS-Excel 2007.