How to plot exponentially the P(0.8 < x < 1.0) with a mean of .88?? Please show the work of plotting a graph exponentially using excel? I am getting confused.
Steps:
Input X (0 to 5 as shown below) and use exponential distribution formula ie,
With mean 0.88,
x | P(x) |
0.1 | 1.0 |
0.2 | 0.9 |
0.3 | 0.8 |
0.4 | 0.7 |
0.5 | 0.6 |
0.6 | 0.6 |
0.7 | 0.5 |
0.8 | 0.5 |
0.9 | 0.4 |
1 | 0.4 |
1.1 | 0.3 |
1.2 | 0.3 |
1.3 | 0.3 |
1.4 | 0.2 |
1.5 | 0.2 |
1.6 | 0.2 |
1.7 | 0.2 |
1.8 | 0.1 |
1.9 | 0.1 |
2 | 0.1 |
2.1 | 0.1 |
2.2 | 0.1 |
2.3 | 0.1 |
2.4 | 0.1 |
2.5 | 0.1 |
2.6 | 0.1 |
2.7 | 0.1 |
2.8 | 0.0 |
2.9 | 0.0 |
3 | 0.0 |
3.1 | 0.0 |
3.2 | 0.0 |
3.3 | 0.0 |
3.4 | 0.0 |
3.5 | 0.0 |
3.6 | 0.0 |
3.7 | 0.0 |
3.8 | 0.0 |
3.9 | 0.0 |
4 | 0.0 |
4.1 | 0.0 |
4.2 | 0.0 |
4.3 | 0.0 |
4.4 | 0.0 |
4.5 | 0.0 |
4.6 | 0.0 |
4.7 | 0.0 |
4.8 | 0.0 |
4.9 | 0.0 |
5 | 0.0 |
5.1 |
Plot for P(0.8<x<1.0):
Please rate my answer and comment for doubt
Get Answers For Free
Most questions answered within 1 hours.