Question: Based on the data wagon.xlsx create the following pivot tables and submit it as an excel file: (1 point or 0.5 point for each pivot

Based on the data wagon.xlsx create the following pivot tables and submit it as an excel file: (1 point or 0.5 point for each pivot table)
| Count of Salary | Column Labels | ||
| Row Labels | No | Yes | Grand Total |
| High | 138 | 108 | 246 |
| Large | 34 | 100 | 134 |
| Small | 104 | 8 | 112 |
| Low | 57 | 40 | 97 |
| Large | 14 | 38 | 52 |
| Small | 43 | 2 | 45 |
| Grand Total | 195 | 148 | 343 |
Now, Compute the fraction of station wagon purchasers that come from each of the following four categories: High Income Large Family, High Income Small Family, Low Income Large Family, and Low Income Small Family. The outcome of the pivot table must be as shown below.
| Count of Salary | Column Labels | ||
| Row Labels | No | Yes | Grand Total |
| High | 35/87 | 17/54 | 71/99 |
| Large | 1/10 | 7/24 | 25/64 |
| Small | 10/33 | 1/43 | 16/49 |
| Low | 1/6 | 7/60 | 28/99 |
| Large | 2/49 | 1/9 | 5/33 |
| Small | 1/8 | 0 | 8/61 |
| Grand Total | 29/51 | 22/51 | 1 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
