Question

1) A study of a hypertension drug’s effectiveness is being conducted. It is considered that the probability that 0 patients of 4 will be brought under control is 0.007, 1 out of 4 brought under control is 0.075, 2 of 4 is 0.267, 3 of 4 is 0.410, and all 4 is 0.241. Let X be the random variable representing the number of patients whose hypertension is brought under control. Find the following (5 pts each):

a) set up distribution table

b) find E(X)

c) find E(X^2)

d) find V(X)

e) find standard deviation of X

**PLEASE SHOW HOW TO DO IN EXCEL

Answer 1

x	p(x)	xp(x)	x2p(x)
0	0.007	0	0
1	0.075	0.075	0.075
2	0.267	0.534	1.068
3	0.41	1.23	3.69
4	0.241	0.964	3.856
Total	1	2.803	8.689

================================================

b)

================================================

================================================

================================================

=============================================

I have shown all the formula , N provided the excel table with the help of that i have calculated the results