https://community.qlik.com/t5/Member-Articles/Comparing-Qlik-Analytics-and-R-Software-for-Accurate-Two-Sample/ta-p/2456241 <P>A while ago, I conducted an internal research project with my colleagues&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/231823">@AlaneMiguelis</a>, and Dr. <a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/172757">@priscilarubim</a>, aiming to validate the accuracy of a <STRONG>Two-Sample T-Test</STRONG> in Qlik by comparing it with the medical research gold standard: <STRONG>R</STRONG>. While we explored various hypothesis testing methods, we prioritized formalizing our findings on the T-Test. Recently, we decided to make this document available to the whole community.</P> <P>The focus of our project was to assess whether the statistical results produced by Qlik matched those generated by R, particularly for the Two-Sample T-Test. Our methodology involved rigorous data analysis and repeated testing to ensure the reliability and consistency of our results. Through our detailed comparative analysis, we aimed to provide insights into the robustness of Qlik’s statistical capabilities. The code and dataset is available in a Git repository for those who want to reproduce the study.</P> <P>Here is the abstract of our study. The full document can be accessed through the link at the end of this post.</P> <P><STRONG><SPAN>ABSTRACT</SPAN></STRONG></P> <P><STRONG>Objective</STRONG></P> <P>The statistical determination of a large or small difference between two groups is not based on an absolute standard, but is rather an evaluation of the probability of an event.1,2 In the field of medical research, it is common to use statistical software for descriptive statistics as well as to perform statistical tests.3 However, most software provides ready-to-use functions, and the researchers have almost no information as to how those statistical tests are calculated inside those functions. This article evaluates the accuracy of two-sample Student’s t-test using Qlik analytics software. The gold standard used for this evaluation is the set of standard t-test functions available in R software, a widely used, robust, and reliable statistical software.5–7</P> <P><BR /><STRONG>Materials and Methods</STRONG></P> <P>The tests performed in this evaluation used a subset of Framingham heart study data. The dataset contains data on 4,434 anonymous participants, collected in three periods apart from each other by 6 years from 1956 to 1968. Five t-tests with 2 scenarios each were performed in Qlik analytics and in R and the results compared.</P> <P><BR /><STRONG>Results</STRONG></P> <P>In general, the results for multiple statistics obtained in Qlik analytics match the ones found in R for multiple scenarios: small and large sample sizes, small and large p-values, assuming and not assuming equal variance.</P> <P><BR /><STRONG>Discussion</STRONG></P> <P>Although Qlik analytics matches all statistics for t-test found in R, the p-value only matches up to four decimal points, which is concluded to be enough for testing hypothesis since the conventional levels of significance do not go lower than 0.1.</P> <P><BR /><STRONG>Conclusion</STRONG></P> <P>This research concluded that Qlik analytics can be used for two-sample t-tests in multiple scenarios.</P> <P><BR /><STRONG>Keywords</STRONG>: Qlik, t-test, r language, Framingham.<BR /><BR /><STRONG>Link for the full article:&nbsp;</STRONG><A href="https://www.ipc-global.com/post/comparing-qlik-analytics-and-r-software-for-accurate-two-sample-t-tests-research-paper" target="_blank">Comparing Qlik Analytics and R Software for Accurate Two-Sample T-Tests Research Paper (ipc-global.com)</A></P> Fri, 24 May 2024 18:46:29 GMT igoralcantara 2024-05-24T18:46:29Z https://community.qlik.com/t5/Member-Articles/Comparing-Qlik-Analytics-and-R-Software-for-Accurate-Two-Sample/ta-p/2456241 <P><SPAN>In this study, we evaluated the accuracy of two-sample Student’s t-tests using Qlik analytics software compared to the gold standard R software. Utilizing data from the Framingham Heart Study, we performed multiple t-tests in both Qlik and R across different scenarios, including variations in sample sizes and p-values. Our findings revealed that Qlik analytics closely match the statistical results of R, making it a reliable tool for performing t-tests.</SPAN></P> Fri, 24 May 2024 18:46:29 GMT https://community.qlik.com/t5/Member-Articles/Comparing-Qlik-Analytics-and-R-Software-for-Accurate-Two-Sample/ta-p/2456241 igoralcantara 2024-05-24T18:46:29Z