calculate expected value for the following two by two tables

calculate expected value for the following two by two tables. Please show work using excel formulas.

a.

B.

C.

Solution

67

B

C

Excel Formula is

=R[x]*RC[y]/R[x]C[y]

Where x is the row number and y is the column number.

Here we obtain the estimates by multiplying the marginals of both side and then dividing it with the Total