Advanced Sample Size Calculation Tutorial

I am seeking a freelancer who can comprehensively teach me various sample size calculation techniques and sampling methods, both theoretically and practically, using MS Excel, SPSS, and GPower software. The primary focus will be on clinical or biostatistical studies. The ideal candidate should be proficient in explaining the principles behind sample size determination, including methods such as the confidence interval method and hypothesis testing method. They should also be able to guide me through the use of different formulas, such as Cochran's and Yamane's formulas, and demonstrate how to apply these in practical scenarios using the mentioned software tools. In addition to sample size calculations, I am interested in learning about different sampling methods, including probability sampling (simple random sampling, stratified sampling, cluster sampling, and systematic sampling) and non-probability sampling (convenience sampling, purposive sampling, and voluntary response sampling). The freelancer should provide detailed explanations and practical examples of these methods, ensuring I understand how to select appropriate samples that are representative of the population being studied. The training should include hands-on sessions where I can apply these techniques to real-world data sets, particularly in the context of clinical trials and biostatistical research. The freelancer should be able to demonstrate how to use MS Excel for basic sample size calculations, SPSS for more advanced statistical analysis, and GPower for power analysis and sample size determination. This comprehensive approach will help me gain a thorough understanding of both the theoretical and practical aspects of sample size calculation and sampling methods, enabling me to apply these skills effectively in my research.