Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to use expressions in TTEST_SIG function?

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:

COUNTRYCUSTOMERPRODUCT
AC1P1
AC2P1
AC3P1
AC4P2
AC5P2
BC6P1
BC7P2
BC8P2
BC9P2
BC10P2

Thanks,

Amit

0 Replies