Calculate the answer for each question listed in column O, referencing (or calculating if it is simple) in the same row of column M.
Definitions: (All apply to a person chosen randomly from this sample.)
F = Female
H = Beyond High School Education
M = Married.
Question: Find the probability of:
F and M
F given M
F given (M or H but not both)
(Female and Beyond High School) or (Male and Married and High School or less)
The data are from 2.6 & 2.49
A) construct a pivot table showing the average of Utilities by Family Size (rows) and Location (columns).
Put the pivot table on this sheet, with the top left cell in K22
B) Construct a second pivot table showing the "proportion of households owning their own home (for that cell)" by Total Income (rows) and Family Size (columns). [Each cell in the table should give the number of households owning divided by the total number of households, both for that cell. Notice the denominator will be different for different cells. This is not the proportion of the total number of households.]
Use an appropriate grouping for the Total Income
Put this pivot table on this sheet, with the top left cell in cell S22.
C) Refer to cells T2:U9. Put a formula in each of the cells in column U that gives the statistic specified by the cell in the same row in column T. You can use built-in Excel functions in a formula.
[SEE ADDITIONAL DATA AND INFORMATION IN THE ATTACHED FILE]
The solution solves probability problems, constructs pivot tables and reports the results using excel.