Friday, May 24, 2013

Statistics 101: Two-Sample Hypothesis Testing


I am slowly going through Statistical Analysis with Excel book and I am making simulation worksheets to understand the concepts. 




I have created the the worksheet with two populations and two pulled samples to get my mind on standard error of the difference between means which is used in Two-Sample Hypothesis Testing. I have used both Z-Test (when populations variances are known) and T-Test (when we don't know population data).


You can download the Excel workbook HERE. The file is around 11MB due population data (are we simulating or not? :) ) 


No comments:

Post a Comment