Question

The probability distribution of X, the number of defective tires on a randomly selected automobile checked at a certain station is given by the table. X 0 1 2 3 4 p(X) 0.54 0.16 0.06 0.04 0.2 Table 4: Distribution for defective tires

Use excel to find the answers please! thank you

Find a. E(X) =

b. E(X2) =

c. σX =

Answer 1

SOLUTION-

WE SOLVE USING EXCEL:

1.) FIRST, WE ENTER THE DATA IN EXCEL SHEET.

2.) E(X) IS COMPUTED WITH THE FORMULA  

STEPS: =PRODUCT( CELL NUMBER, CELL NUMBER)

3.) NEXT COLUMN IS X- MEAN

4.) NEXT COLUMN IS (X-MEAN)^2

5.) VARIANCE IS COMPUTED WITH THE FORMULA

STEPS: = PRODUCT( CELL NUMBER, CELL NUMBER)

X	P(X)
0	0.54	0	-1.2	1.44	0.7776
1	0.16	0.16	-0.2	0.04	0.0064
2	0.06	0.12	0.8	0.64	0.0384
3	0.04	0.12	1.8	3.24	0.1296
4	0.2	0.8	2.8	7.84	1.568
TOTAL		1.2			2.52

A.) MEAN= E(X) = 1.2

B.) VARIANCE= 2.52

SO,

OR,

C.)

*****IN CASE OF DOUBT, COMMENT BELOW. ALSO LIKE THE SOLUTION, IF POSSIBLE.