Use a PivotTable to construct a cross-tabulation for Marital Status and Housing Type for the data provided.

Part 1

Complete the cross-tabulation for Marital Status vs. Housing Type.

Marital Status Housing Type Years

Married Own 1

Single Other 4

Single Own 3

Divorced Own 4

Single Own 4

Divorced Own 1

Divorced Own 2

Divorced Own 4

Single Rent 3

Married Own 1

Divorced Own 1

Married Own 1

Divorced Own 2

Single Rent 4

Single Other 4

Divorced Own 3

Single Own 2

Single Own 2

Married Own 3

Divorced Own 2

Single Own 3

Divorced Own 3

Divorced Own 4

Single Own 2

Divorced Own 1

Divorced Own 1

Single Rent 2

Divorced Rent 2

Married Own 2

Single Own 4

Single Own 2

Divorced Rent 4

Single Rent 2

Single Own 3

Divorced Own 4

Single Own 2

Single Other 4

Married Own 1

Single Own 4

Divorced Rent 4