MGMT2262

Worksheet #2 Solutions

 

First, we’ll make up a crosstab:

 

Bay

Not Bay

Total

Walmart

7

33

40

Not Walmart

8

52

60

Total

15

85

100

1)     P(Bay or Walmart) = P(Bay) + P(Walmart) - P(Bay and Walmart) = 15% + 40% - 7% = 48%

2)     P(Walmart | Bay) = P(Bay and Walmart)/P(Bay) = 7/15 = 46.67%

3)     P(Walmart and not Bay) = 33% from the crosstab

4)     P(not Bay | Walmart) = P(Walmart and not Bay)/P(Walmart) = 33/40 = 82.5%

5)     P(not Walmart | not Bay) = P(not Bay and not Walmart)/P(not Bay) = 52/85 = 61.18%

6)     P(neither Bay nor Walmart) = 52% from crosstab. The other solution is to use DeMorgan’s Law: P(neither Bay nor Walmart) = 100% - P(Bay or Walmart) = 100% - 48% = 52%.

7)     P(Bay | Walmart) = 7/40 = 17.5%; P(Bay | not Walmart) = 8/60 = 13.33%. So, someone who shops at Walmart is more likely to shop at The Bay than someone who doesn’t shop at Walmart.

8)     We have P(Bay and Walmart) = 7%. P(Bay)*P(Walmart) = (0.15)(0.4) = 0.06 = 6%. Since these are not equal, the events are not independent and so shopping at one store depends on shopping at the other. One other solution is to note that P(Bay | Walmart) = 17.5% from question 7. However, P(Bay) = 15%. Since P(Bay) doesn’t equal P(Bay | Walmart), we reach the same conclusion.

9)     Since P(Bay and Walmart) = 7% is not zero, the events of shopping at the 2 stores are not mutually exclusive.

10)  P(revenue ³ 500K) = (438 + 365)/1000 = 803/1000 = 80.3%

11)  P(profit ³ 100K | revenue ³ 500K) = (81 + 98 + 11 + 67)/(438 + 365) = 257/803 = 32%

12)  P(profit < 100K) = (268 + 473)/1000 = 741/1000 = 74.1%

13)  P(revenue < 500K  | profit < 100K) = (141 + 54)/(268 + 473) = 195/741 = 26.32%

14)  Revenue under $500,000 and net profit of $500,000 or more are mutually exclusive since the crosstab value is zero. These categories must be mutually exclusive since you can’t have a net profit of $500,000 or more if your revenue is less than that.

15)  P(revenue ³ 500K or profit ³ 100K) = P(revenue ³ 500K) + P(profit ³ 100K) – P(revenue ³ 500K and profit ³ 100K) = (438 + 365)/1000 + (181 + 78)/1000 – (81 + 98 + 11 + 67)/1000 = 805/1000 = 80.5%

16)  This table summarizes the results:

Profit|Revenue

< $500K

$500K - $1000K

$1000K +

$100K - $500K

2

81

98

$500K +

0

11

67

Total

197

438

365

 

1.02%

21.00%

45.21%

For example, for revenue under $500,000, the percentage of these companies with net profit of $100,000 or more is (2 + 0)/197 = 1.02%. As revenues increase, the percentage of companies with net profit of $100,000 or more increases.

17)  P(revenue ³ 500K and profit ³ 100K) = (81 + 98 + 11 + 67)/1000 = 0.257

P(revenue ³ 500K)*P(profit ³ 100K) = [(438 + 365)/1000]* [(181 + 78)/1000] = (0.803)(0.259) = 0.208. Since the two sides of the equation are not equal, having profit of $100,000 or more depends on having revenue of $500,000 or more.

18)  We first need to compute the overall market share for the under 25 age group. This Excel output summarizes the results:

Brand

% market share

% used by under 25 age group

Weighted average

Brand A

0.25

0.7

0.175

Brand B

0.15

0.55

0.0825

Brand C

0.6

0.4

0.24

 

 

Total

0.4975

We see the overall market share for the under 25 age group is 49.75%. We see that Brand C comprises the largest percentage at 24%. Therefore, the percentage of the under 25 age group that uses Brand C is 24/49.75 = 48.24%.

19)  12P4 = 11,880. The other method is 12x11x10x9 = 11,880

20)  12C3 = 220

21)  36P4 = 1,413,720. The other method is 36x35x34x33 = 1,413,720

22)  26x35x34x33 = 1,021,020. The other method is 26 x 35P3 = 26 x 39,270 = 1,021,020.