I need a pivot table with (with proportions/probabilities/percent, not frequencies/counts). Pivot tables need at least one qualitative variable to compare to another variable.Here is the link with the data. https://docs.google.com/spreadsheets/d/11EPQzT4HtSnDVoSF1FXYs8qJf7D595a7lJaoZH1JpsI/edit?usp=sharing

Qualitative Variables in the survey

• What type of residence do you occupy
• What is your most thrown away item
• Do you have access to recycling
• Do you have access to composting

Part 2

Once your pivot table has been created, you will now get to find some probabilities. Since we are all choosing different variables to study, please define your events A and B.

• Define event A as a single event from your first variable chosen.
• Define event B as a single event from your second variable chosen.

Then, compute AND INTERPRET the following probabilities:

P(A')

P(A U B)

P(A' U B)

P(A B)

P(A | B)

Determine if events A and B are dependent or independent. Give your justification with your conclusion.