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).
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEifM5j0wrjp0N40wmzba0r7DWcYixl-SY8V1fqovjhOKDh_MW_8iVzscm2-OaQcQcne_dnfUFKoax68jexBXCwcIsRMXQkU-XttbDnJan5aRid3MGlTVFpiJLecMh4SPEzsdBu0_B4zkyE/s640/Screen+Shot+2013-05-24+at+20.52.18.png)
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