Applying the Empirical Rule in Excel
Assume we have an ordinarily circulated dataset with a mean of 8 and a standard deviation of 2.3. The accompanying screen capture tells the best way to apply the Empirical Rule to this dataset in Excel to find which values 68% of the information falls between, which values 95% of the information falls between, and which values 99.7% of the information falls between:
We will get the below results:
From this result, we can see:
- 68% of the information falls somewhere in the range of 5.7 and 10.3
- 95% of the information falls somewhere in the range of 3.4 and 12.6
- 99.7% of the information falls somewhere in the range of 1.1 and 14.9
To apply the Empirical Rule to an alternate dataset, we essentially have to change the mean and standard deviation in cells C2 and C3. For instance, this is the way to apply the Empirical Rule to a dataset with a mean of 45 and a standard deviation of 4.75:
From this result, we can see:
- 68% of the information falls somewhere in the range of 40.25 and 49.75
- 95% of the information falls somewhere in the range of 35.5 and 54.5
- 99.7% of the information falls somewhere in the range of 30.75 and 59.25
Furthermore, here is another illustration of how to apply the Empirical Rule to a dataset with a mean of 100 and a standard deviation of 4:
From this result, we can see:
- 68% of the information falls somewhere in the range of 96 and 104
- 95% of the information falls somewhere in the range of 92 and 108
- 99.7% of the information falls somewhere in the range of 88 and 112
How to Apply the Empirical Rule in Excel?
It is now and again called the Empirical Rule in light of the fact that the standard initially came from perceptions (exact signifies “in view of perception”). The Normal/Gaussian dispersion is the most widely recognized kind of information dissemination. The estimations are all processed as good ways from the mean and are accounted for in standard deviations.
Contact Us