- 1). Open a new Microsoft Excel spreadsheet. Your cursor will appear in cell "A1."
- 2). Type the normal distribution in cell "A1" as follows: Normal(1;0).
- 3). Type the "Probability Density Function" in cell "A2" by typing the following formula:
=DistPdf(Distribution;x) - 4). Type the "Mode" in cell "A3" by typing the following formula:
=DistMode(Distribution) - 5). Type the "Cumulative Distribution Function" in cell "A4" by typing the following formula:
=DistCdf(Distribution;x) - 6). Type the "Variance" in cell "A5" by typing the following formula:
Variance =DistVar(Distribution) - 7). Type the "Mean" in cell "A6" by typing the following formula:
=DistMean(Distribution)
next post