Hi Everyone,
I want to calculate p-value of the % of customers using each product in each of the two countries to understand if the % difference in usage of a product in each country is really significant i.e people of one country prefer a product more as compared to other country. How can I write a TTEST_SIG formula to find the % of users of each product in each country and then compare the percentages of one country with other for each product? Below is the sample data:
| COUNTRY | CUSTOMER | PRODUCT |
| A | C1 | P1 |
| A | C2 | P1 |
| A | C3 | P1 |
| A | C4 | P2 |
| A | C5 | P2 |
| B | C6 | P1 |
| B | C7 | P2 |
| B | C8 | P2 |
| B | C9 | P2 |
| B | C10 | P2 |
Thanks,
Amit
