The Module 2b worksheet contains a crosstabulation (the data will keep changing like in Module 2 above) and blank templates for calculating row and column percentages.

Module 2b.1 In the yellow cells of the top-left table, calculate row and column totals for the source data (hint: use the =SUM formula). Remember that you need to use formulas, or else when the data recalculates, your answer will be incorrect!

Module 2b.2 In the blue cells of the top-right table, calculate the row percentages using formulas that can adapt to new data.

Module 2b.3 In the green cells, calculate the column percentages, again using formulas.

y

y

1

2

Total

1

2

Total

x

A

5

4

x

A

B

1

6

B

C

5

3

C

Total

blue

yellow

y

1

2

x

A

B

C

Total

green