x | P[X=x] | xP[X=x] | x-mu | (x-mu)^2P[X=x] |
0 |
=BINOM.DIST(0,49,0.76,FALSE) |
=A2*B2 |
=A2-B52 |
=D2^2*B2 |
1 |
=BINOM.DIST(1,49,0.76,FALSE) |
=A3*B3 |
=A3-B52 |
=D3^2*B3 |
2 |
=BINOM.DIST(2,49,0.76,FALSE) |
=A4*B4 |
=A4-B52 |
=D4^2*B4 |
3 |
=BINOM.DIST(3,49,0.76,FALSE) |
=A5*B5 |
=A5-B52 |
=D5^2*B5 |
4 |
=BINOM.DIST(4,49,0.76,FALSE) |
=A6*B6 |
=A6-B52 |
=D6^2*B6 |
5 |
=BINOM.DIST(5,49,0.76,FALSE) |
=A7*B7 |
=A7-B52 |
=D7^2*B7 |
6 |
=BINOM.DIST(6,49,0.76,FALSE) |
=A8*B8 |
=A8-B52 |
=D8^2*B8 |
7 |
=BINOM.DIST(7,49,0.76,FALSE) |
=A9*B9 |
=A9-B52 |
=D9^2*B9 |
8 |
=BINOM.DIST(8,49,0.76,FALSE) |
=A10*B10 |
=A10-B52 |
=D10^2*B10 |
9 |
=BINOM.DIST(9,49,0.76,FALSE) |
=A11*B11 |
=A11-B52 |
=D11^2*B11 |
10 |
=BINOM.DIST(10,49,0.76,FALSE) |
=A12*B12 |
=A12-B52 |
=D12^2*B12 |
11 |
=BINOM.DIST(11,49,0.76,FALSE) |
=A13*B13 |
=A13-B52 |
=D13^2*B13 |
12 |
=BINOM.DIST(12,49,0.76,FALSE) |
=A14*B14 |
=A14-B52 |
=D14^2*B14 |
13 |
=BINOM.DIST(13,49,0.76,FALSE) |
=A15*B15 |
=A15-B52 |
=D15^2*B15 |
14 |
=BINOM.DIST(14,49,0.76,FALSE) |
=A16*B16 |
=A16-B52 |
=D16^2*B16 |
15 |
=BINOM.DIST(15,49,0.76,FALSE) |
=A17*B17 |
=A17-B52 |
=D17^2*B17 |
16 |
=BINOM.DIST(16,49,0.76,FALSE) |
=A18*B18 |
=A18-B52 |
=D18^2*B18 |
17 |
=BINOM.DIST(17,49,0.76,FALSE) |
=A19*B19 |
=A19-B52 |
=D19^2*B19 |
18 |
=BINOM.DIST(18,49,0.76,FALSE) |
=A20*B20 |
=A20-B52 |
=D20^2*B20 |
19 |
=BINOM.DIST(19,49,0.76,FALSE) |
=A21*B21 |
=A21-B52 |
=D21^2*B21 |
20 |
=BINOM.DIST(20,49,0.76,FALSE) |
=A22*B22 |
=A22-B52 |
=D22^2*B22 |
21 |
=BINOM.DIST(21,49,0.76,FALSE) |
=A23*B23 |
=A23-B52 |
=D23^2*B23 |
22 |
=BINOM.DIST(22,49,0.76,FALSE) |
=A24*B24 |
=A24-B52 |
=D24^2*B24 |
23 |
=BINOM.DIST(23,49,0.76,FALSE) |
=A25*B25 |
=A25-B52 |
=D25^2*B25 |
24 |
=BINOM.DIST(24,49,0.76,FALSE) |
=A26*B26 |
=A26-B52 |
=D26^2*B26 |
25 |
=BINOM.DIST(25,49,0.76,FALSE) |
=A27*B27 |
=A27-B52 |
=D27^2*B27 |
26 |
=BINOM.DIST(26,49,0.76,FALSE) |
=A28*B28 |
=A28-B52 |
=D28^2*B28 |
27 |
=BINOM.DIST(27,49,0.76,FALSE) |
=A29*B29 |
=A29-B52 |
=D29^2*B29 |
28 |
=BINOM.DIST(28,49,0.76,FALSE) |
=A30*B30 |
=A30-B52 |
=D30^2*B30 |
29 |
=BINOM.DIST(29,49,0.76,FALSE) |
=A31*B31 |
=A31-B52 |
=D31^2*B31 |
30 |
=BINOM.DIST(30,49,0.76,FALSE) |
=A32*B32 |
=A32-B52 |
=D32^2*B32 |
31 |
=BINOM.DIST(31,49,0.76,FALSE) |
=A33*B33 |
=A33-B52 |
=D33^2*B33 |
32 |
=BINOM.DIST(32,49,0.76,FALSE) |
=A34*B34 |
=A34-B52 |
=D34^2*B34 |
33 |
=BINOM.DIST(33,49,0.76,FALSE) |
=A35*B35 |
=A35-B52 |
=D35^2*B35 |
34 |
=BINOM.DIST(34,49,0.76,FALSE) |
=A36*B36 |
=A36-B52 |
=D36^2*B36 |
35 |
=BINOM.DIST(35,49,0.76,FALSE) |
=A37*B37 |
=A37-B52 |
=D37^2*B37 |
36 |
=BINOM.DIST(36,49,0.76,FALSE) |
=A38*B38 |
=A38-B52 |
=D38^2*B38 |
37 |
=BINOM.DIST(37,49,0.76,FALSE) |
=A39*B39 |
=A39-B52 |
=D39^2*B39 |
38 |
=BINOM.DIST(38,49,0.76,FALSE) |
=A40*B40 |
=A40-B52 |
=D40^2*B40 |
39 |
=BINOM.DIST(39,49,0.76,FALSE) |
=A41*B41 |
=A41-B52 |
=D41^2*B41 |
40 |
=BINOM.DIST(40,49,0.76,FALSE) |
=A42*B42 |
=A42-B52 |
=D42^2*B42 |
41 |
=BINOM.DIST(41,49,0.76,FALSE) |
=A43*B43 |
=A43-B52 |
=D43^2*B43 |
42 |
=BINOM.DIST(42,49,0.76,FALSE) |
=A44*B44 |
=A44-B52 |
=D44^2*B44 |
43 |
=BINOM.DIST(43,49,0.76,FALSE) |
=A45*B45 |
=A45-B52 |
=D45^2*B45 |
44 |
=BINOM.DIST(44,49,0.76,FALSE) |
=A46*B46 |
=A46-B52 |
=D46^2*B46 |
45 |
=BINOM.DIST(45,49,0.76,FALSE) |
=A47*B47 |
=A47-B52 |
=D47^2*B47 |
46 |
=BINOM.DIST(46,49,0.76,FALSE) |
=A48*B48 |
=A48-B52 |
=D48^2*B48 |
47 |
=BINOM.DIST(47,49,0.76,FALSE) |
=A49*B49 |
=A49-B52 |
=D49^2*B49 |
48 |
=BINOM.DIST(48,49,0.76,FALSE) |
=A50*B50 |
=A50-B52 |
=D50^2*B50 |
49 |
=BINOM.DIST(49,49,0.76,FALSE) |
=A51*B51 |
=A51-B52 |
=D51^2*B51 |
Mean: | =SUM(C:C) | | | |
Variance: | =SUM(E:E) | | | |