- Make Excel do all of the necessary calculations
- Report answers on the worksheet
- Label answers as the questions are labelled: a, b, c,…
- Use the probability notation p(A), p(Aand B),… etc
- Submit your spreadsheet in Blackboard Assignment.
2. Due to recent global economic trends, Brazilian currency haslost value compared to the US dollar. This devaluation caused anincrease in the price of products in Brazil. The following tablesummarizes results from a consumer survey that asked about thenumber of products being purchased and whether the brands purchasedhad changed (a trend towards purchasing less expensive brands wasexpected)
| Number of Products Purchased | |
Brands purchased | Fewer | Same | More | Total |
Changed to less expensive | 262 | 82 | 8 | 352 |
Did not change | 10 | 14 | 24 | 48 |
| | | | |
Total | 272 | 96 | 32 | 400 |
What is the probability that a consumer selected at random:
a. purchased fewer products than before?
b. purchased fewer products and changed brands?
c. purchased fewer products or did not change brands?
d. Constance Aguero changed the brands she purchased. What isthe probability that she purchased fewer number of products?
e. Robert Nanaim is purchasing fewer products. What is theprobability that he has changed brands?
f. Are the events Brands purchased and Number of productspurchased independent events?  Show the test.
