Variance [Binomial Distribution]

The Problem

Let X be a random variable following a Binomial distribution. All Binomial distributions have two parameters: number of trials and success probability. For X, n = 38 and p = 0.64. An example of where such a distribution may arise is the following:

You have a bag of candy made by Statistics, Inc. The company makes only two flavors: sour apple and anchovie. In its processing plant, 64% of the candy made is sour apple. Your bag holds 38 pieces. Define the random variable X as the number of sour apple pieces of candy in your bag.

For those who like pictures, here is a graphic of the probability mass function. Note that the distribution is skewed left:

With this information, calculate the variance of the random variable, σ² or V[X].

Your Answer

In the box below, please enter the variance of the random variable described above, then click on the “Check your answer!” button. Please round your answer to the ten-thousandths place.

Your guess:

Another Binomial Distribution

Would you like to continue working on this topic? If so, click here for another Binomial distribution.

Assistance

Show Formula

Show Solution

Show the R Code

Show the Excel Code

Hide the Excel Code

Copy and paste the following code into your Excel spreadsheet window, making sure the value x ends up in A1 after pasting.

How to calculate the expected value in Excel.
x	P[X=x]	xP[X=x]	x-mu	(x-mu)^2P[X=x]
0	=BINOM.DIST(0,38,0.64,FALSE)	=A2*B2	=A2-B41	=D2^2*B2
1	=BINOM.DIST(1,38,0.64,FALSE)	=A3*B3	=A3-B41	=D3^2*B3
2	=BINOM.DIST(2,38,0.64,FALSE)	=A4*B4	=A4-B41	=D4^2*B4
3	=BINOM.DIST(3,38,0.64,FALSE)	=A5*B5	=A5-B41	=D5^2*B5
4	=BINOM.DIST(4,38,0.64,FALSE)	=A6*B6	=A6-B41	=D6^2*B6
5	=BINOM.DIST(5,38,0.64,FALSE)	=A7*B7	=A7-B41	=D7^2*B7
6	=BINOM.DIST(6,38,0.64,FALSE)	=A8*B8	=A8-B41	=D8^2*B8
7	=BINOM.DIST(7,38,0.64,FALSE)	=A9*B9	=A9-B41	=D9^2*B9
8	=BINOM.DIST(8,38,0.64,FALSE)	=A10*B10	=A10-B41	=D10^2*B10
9	=BINOM.DIST(9,38,0.64,FALSE)	=A11*B11	=A11-B41	=D11^2*B11
10	=BINOM.DIST(10,38,0.64,FALSE)	=A12*B12	=A12-B41	=D12^2*B12
11	=BINOM.DIST(11,38,0.64,FALSE)	=A13*B13	=A13-B41	=D13^2*B13
12	=BINOM.DIST(12,38,0.64,FALSE)	=A14*B14	=A14-B41	=D14^2*B14
13	=BINOM.DIST(13,38,0.64,FALSE)	=A15*B15	=A15-B41	=D15^2*B15
14	=BINOM.DIST(14,38,0.64,FALSE)	=A16*B16	=A16-B41	=D16^2*B16
15	=BINOM.DIST(15,38,0.64,FALSE)	=A17*B17	=A17-B41	=D17^2*B17
16	=BINOM.DIST(16,38,0.64,FALSE)	=A18*B18	=A18-B41	=D18^2*B18
17	=BINOM.DIST(17,38,0.64,FALSE)	=A19*B19	=A19-B41	=D19^2*B19
18	=BINOM.DIST(18,38,0.64,FALSE)	=A20*B20	=A20-B41	=D20^2*B20
19	=BINOM.DIST(19,38,0.64,FALSE)	=A21*B21	=A21-B41	=D21^2*B21
20	=BINOM.DIST(20,38,0.64,FALSE)	=A22*B22	=A22-B41	=D22^2*B22
21	=BINOM.DIST(21,38,0.64,FALSE)	=A23*B23	=A23-B41	=D23^2*B23
22	=BINOM.DIST(22,38,0.64,FALSE)	=A24*B24	=A24-B41	=D24^2*B24
23	=BINOM.DIST(23,38,0.64,FALSE)	=A25*B25	=A25-B41	=D25^2*B25
24	=BINOM.DIST(24,38,0.64,FALSE)	=A26*B26	=A26-B41	=D26^2*B26
25	=BINOM.DIST(25,38,0.64,FALSE)	=A27*B27	=A27-B41	=D27^2*B27
26	=BINOM.DIST(26,38,0.64,FALSE)	=A28*B28	=A28-B41	=D28^2*B28
27	=BINOM.DIST(27,38,0.64,FALSE)	=A29*B29	=A29-B41	=D29^2*B29
28	=BINOM.DIST(28,38,0.64,FALSE)	=A30*B30	=A30-B41	=D30^2*B30
29	=BINOM.DIST(29,38,0.64,FALSE)	=A31*B31	=A31-B41	=D31^2*B31
30	=BINOM.DIST(30,38,0.64,FALSE)	=A32*B32	=A32-B41	=D32^2*B32
31	=BINOM.DIST(31,38,0.64,FALSE)	=A33*B33	=A33-B41	=D33^2*B33
32	=BINOM.DIST(32,38,0.64,FALSE)	=A34*B34	=A34-B41	=D34^2*B34
33	=BINOM.DIST(33,38,0.64,FALSE)	=A35*B35	=A35-B41	=D35^2*B35
34	=BINOM.DIST(34,38,0.64,FALSE)	=A36*B36	=A36-B41	=D36^2*B36
35	=BINOM.DIST(35,38,0.64,FALSE)	=A37*B37	=A37-B41	=D37^2*B37
36	=BINOM.DIST(36,38,0.64,FALSE)	=A38*B38	=A38-B41	=D38^2*B38
37	=BINOM.DIST(37,38,0.64,FALSE)	=A39*B39	=A39-B41	=D39^2*B39
38	=BINOM.DIST(38,38,0.64,FALSE)	=A40*B40	=A40-B41	=D40^2*B40
Mean:	=SUM(C:C)
Variance:	=SUM(E:E)

When copying this table to Excel, you may want to highlight this note. It seems to help ensure that the code starts in cell A1.

V[X]	the variance (equivalent to σ²)
n	the number of trials
p	the success probability for each trial

V[X]	=	n × p × (1 − p)

	=	38 × 0.64 × (1 − 0.64)

	=	38 × 0.64 × (0.36)

	=	8.7552

© Ole J. Forsberg, Ph.D. 2024. All rights reserved.		.

The Variance

The Problem

Your Answer

Another Binomial Distribution

Assistance