Question

Enter the missing data

Answer 1

Entering the missing data for the mean, median, and standard deviation is as follows:

John Bob Max Andy Mean Median St. Dev.

Housing 540 500 512 1,040 648 526 226.79

Auto 180 300 288 156 231 234 63.71

Food 450 240 208 364 315.5 302 97.08

Utilities 216 260 240 494 302.5 250 111.65

Miscellaneous 414 700 352 546 503 480 133.58

How the mean, median, and standard deviation is computed:

The mean, median, and standard deviation are computed as follows, with only the housing displayed as a sample.

Housing:

Count, N: 4

Sum, Σx: 2592

Mean, μ: 648

Variance, σ2: 51432

σ2 = Σ(xi - μ)^2

N =
`(540 - 648)^2` + ... +
`(1040 - 648)^2`

=
`(205728)/(4)`

= 51432

σ = √51432

= 226.786

= 226.79