How to use expressions in TTEST_SIG function?

Mon, 01 Dec 2014 12:39:56 GMT

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

topic How to use expressions in TTEST_SIG function? in QlikView

How to use expressions in TTEST_SIG function?