One Problem

a) Create a pivot table. Insert Water in the column and insert Soda in row then move the categories so NW & NS are in the top left. Then HW AND HS in the bottom right.

b) using the same table repeat part a and show the percentages by row/column. Create a pivot table

HW: Heavy Water Consumer

HS: Heavy Soda Conusmer

NW: No Water consumer

NS: No Soda consumer

Please write down step by step how you created this! :)

Person	Soda	Water
1	HS	HW
2	NS	NW
3	NS	NW
4	HS	HW
5	HS	HW
6	NS	HW