# Excel ## “Easy” Excel Inverse Triangular Distribution for Monte Carlo Simulations Redux

Back in the dark ages when access to computers was not all that common, I was faced with developing a project schedule for, to me, a complex construction project. I was not that long out of school, so I sought out my boss with the hope he would give me some guidance on how to …

## One-sample Sigma Known z-test for the Mean

Joel, I have not checked all your calculations, but the process you used looks good. I note that this is a problem where you are given a lot of raw data. Which technology did you use? I ask because problems where you have to manually enter a lot of raw data often lead to mistakes …

## Simple One-sample z-test for the Mean when Sigma is Known

Here is a way to do a simple one-sample z test when we know the population standard deviation sigma. If this was a left tail test as indicated by an < in the alternative hypothesis, the standardized test statistic (z) of -1.753 falls in the rejection region below the z-critical of -1.645 and that would …

## Empirical Rule Cheat Sheet

Empirical Rule percentiles are the percentage of data below (to the left of) an x value. Use this Quick and Easy calculator to find percentiles when you are given the population mean and standard deviation and x values. In most intro stats classes, you will only be given x values whose z-scores are integers. If …

## Confidence Interval for Difference Between Proportions

Enter your data in the blue cells and the answers will be in the yellow cells.