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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!