{"id":38704,"date":"2018-11-21T09:10:58","date_gmt":"2018-11-21T03:40:58","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=38704"},"modified":"2021-12-07T11:19:57","modified_gmt":"2021-12-07T05:49:57","slug":"t-test-in-qlikview","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/t-test-in-qlikview\/","title":{"rendered":"T test in QlikView &#8211; One Sample T test &amp; Paired Sample T test"},"content":{"rendered":"<div class='__iawmlf-post-loop-links' style='display:none;' data-iawmlf-post-links='[{&quot;id&quot;:1725,&quot;href&quot;:&quot;https:\\\/\\\/help.qlik.com\\\/en-US\\\/qlikview\\\/November2017\\\/Subsystems\\\/Client\\\/Content\\\/ChartFunctions\\\/StatisticalTestFunctions\\\/ttest\\\/t_tests.htm&quot;,&quot;archived_href&quot;:&quot;http:\\\/\\\/web-wp.archive.org\\\/web\\\/20251209205153\\\/https:\\\/\\\/help.qlik.com\\\/en-US\\\/qlikview\\\/November2017\\\/Subsystems\\\/Client\\\/Content\\\/ChartFunctions\\\/StatisticalTestFunctions\\\/ttest\\\/t_tests.htm&quot;,&quot;redirect_href&quot;:&quot;&quot;,&quot;checks&quot;:[{&quot;date&quot;:&quot;2025-12-10 08:58:17&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2025-12-15 12:18:47&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2025-12-26 14:29:00&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-07 02:47:09&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-15 16:23:11&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-22 00:15:05&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-02-27 09:24:12&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-03-04 08:05:53&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-03-07 14:03:20&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-26 15:41:40&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-04-10 15:49:46&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-04-19 08:28:18&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-04-28 09:03:08&quot;,&quot;http_code&quot;:503},{&quot;date&quot;:&quot;2026-05-02 12:43:53&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-05-18 06:38:14&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-05-21 17:34:43&quot;,&quot;http_code&quot;:200}],&quot;broken&quot;:false,&quot;last_checked&quot;:{&quot;date&quot;:&quot;2026-05-21 17:34:43&quot;,&quot;http_code&quot;:200},&quot;process&quot;:&quot;done&quot;}]'><\/div>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">In our earlier lessons, we learned about <a href=\"https:\/\/data-flair.training\/blogs\/chi-square-test-in-qlikview\/\"><strong>QlikView<\/strong> <strong>chi-square\u00a0test<\/strong><\/a> of statistical chart wizard. Moving on, we are going to learn about one more such test which is T test in QlikView. In which, we will discuss One sample T test and Paired sample T test\u00a0in QlikView.\u00a0<\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">So, let&#8217;s start QlikView T test Tutorial.<\/span><\/span><\/p>\n<div id=\"attachment_38811\" style=\"width: 1210px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-T-test-01.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-38811\" class=\"size-full wp-image-38811\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-T-test-01.jpg\" alt=\"T test in QlikView - One Sample T test &amp; Paired Sample T test\" width=\"1200\" height=\"628\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-T-test-01.jpg 1200w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-T-test-01-150x79.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-T-test-01-300x157.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-T-test-01-768x402.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-T-test-01-1024x536.jpg 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-T-test-01-520x272.jpg 520w\" sizes=\"auto, (max-width: 1200px) 100vw, 1200px\" \/><\/a><p id=\"caption-attachment-38811\" class=\"wp-caption-text\">T test in QlikView &#8211; One Sample T test &amp; Paired Sample T test<\/p><\/div>\n<h3 align=\"justify\">What is QlikView T test?<\/h3>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">T test or also known as Student\u2019s T test is the test which checks the variability in a data distribution. In other words, this test helps in checking whether our data sample deviates significantly from the mean of the previous observation by comparing the mean values of two observations. <\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">T tests\u00a0in QlikView can be of several types. In the QlikView statistical chart wizard, you the second option for tests is one sample T test or paired (dependant) sample T test\u00a0in QlikView. T table use as a reference table to infer the results attained from the test.<\/span><\/span><\/p>\n<p align=\"justify\"><strong><a href=\"https:\/\/data-flair.training\/blogs\/skewness-in-qlikview-statistics\/\">Do you know What is Skewness in QlikView?<\/a><\/strong><\/p>\n<div id=\"attachment_38794\" style=\"width: 1051px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/T-table.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-38794\" class=\"size-full wp-image-38794\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/T-table.png\" alt=\"T test in QlikView - One Sample T test &amp; Paired Sample T test\" width=\"1041\" height=\"939\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/T-table.png 1041w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/T-table-150x135.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/T-table-300x271.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/T-table-768x693.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/T-table-1024x924.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/T-table-520x469.png 520w\" sizes=\"auto, (max-width: 1041px) 100vw, 1041px\" \/><\/a><p id=\"caption-attachment-38794\" class=\"wp-caption-text\">QlikView\u00a0T-test &#8211; T-Table<\/p><\/div>\n<h3 align=\"justify\">One-Sample T test in QlikView<\/h3>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">In the one sample T test\u00a0in QlikView, the mean hypotheses check for one sample of data values based on a condition. This ultimately shows whether the mean of the observed value differs from the mean we expect or not.<\/span><\/span><\/p>\n<h4 align=\"justify\">i. Example of One Sample T-test<\/h4>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">We have taken some sample data and framed two hypotheses based on a situation or assumption. <\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><b>Situation<\/b><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">: In class 12<\/span><\/span><sup><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">th<\/span><\/span><\/sup><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"> of a school, the past records state that no student has got below grade B or 70%.<\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">What the school\u2019s administration wants to know from this test using the marks of the current year is that whether the assumption stated in the situation above is true for this year\u2019s result or not?<\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">The observation i.e. marks of this year load into QlikView and display in tabular form. <\/span><\/span><\/p>\n<table dir=\"ltr\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\">\n<colgroup>\n<col width=\"124\" \/><\/colgroup>\n<tbody>\n<tr>\n<td><strong>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0Marks<\/strong><\/td>\n<\/tr>\n<tr>\n<td>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 50<\/td>\n<\/tr>\n<tr>\n<td>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 51<\/td>\n<\/tr>\n<tr>\n<td>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 55<\/td>\n<\/tr>\n<tr>\n<td>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 60<\/td>\n<\/tr>\n<tr>\n<td>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 62<\/td>\n<\/tr>\n<tr>\n<td>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 63<\/td>\n<\/tr>\n<tr>\n<td>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 65<\/td>\n<\/tr>\n<tr>\n<td>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 70<\/td>\n<\/tr>\n<tr>\n<td>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 74<\/td>\n<\/tr>\n<tr>\n<td>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 75<\/td>\n<\/tr>\n<tr>\n<td>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 80<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">To do the test, open the <\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><b>Statistics Chart Wizard<\/b><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"> from the <\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><b>Tools<\/b><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"> menu in QlikView. <\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">The Statistics Chart Wizard dialog will open. Select the <\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><b>One sample T test\/Paired T test<\/b><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"> option. Click <\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><b>Next<\/b><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"> to continue. You will also find a brief description of the three test options given in the wizard.<\/span><\/span><\/p>\n<p align=\"justify\"><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-time-chart-wizard\/\">We recommend you to learn &#8211; QlikView TIme Chart Wizard<\/a><\/strong><\/p>\n<div id=\"attachment_38796\" style=\"width: 752px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/test2.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-38796\" class=\"size-full wp-image-38796\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/test2.png\" alt=\"T test in QlikView - One Sample T test &amp; Paired Sample T test\" width=\"742\" height=\"549\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/test2.png 742w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/test2-150x111.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/test2-300x222.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/test2-520x385.png 520w\" sizes=\"auto, (max-width: 742px) 100vw, 742px\" \/><\/a><p id=\"caption-attachment-38796\" class=\"wp-caption-text\">QlikView\u00a0One Sample T-test<\/p><\/div>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">In the next step, a dialog appears where you need to enter the parameters to use in the T test\u00a0in QlikView. As you can see in the screenshot below, we have selected \u2018Marks1\u2019 field in the Value Field option as it contains the observation values. <\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Next, we have set the test value to 70 because we want to see whether the current situation is the same or gone below 70. From other options given, you can check the boxes for the values you want to include in your T test result table. Click <\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><b>Finish<\/b><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"> to see the result. <\/span><\/span><\/p>\n<dl>\n<dd>\n<table width=\"574\" cellspacing=\"0\" cellpadding=\"7\">\n<colgroup>\n<col width=\"131\" \/>\n<col width=\"412\" \/> <\/colgroup>\n<tbody>\n<tr valign=\"top\">\n<td width=\"131\" height=\"27\">\n<p align=\"justify\"><b><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Value Field\/Expression<\/span><\/span><\/span><\/b><\/p>\n<\/td>\n<td width=\"412\">\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Returns a test value series.<\/span><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr valign=\"top\">\n<td style=\"background: #f2f2f2\" bgcolor=\"#f2f2f2\" width=\"131\" height=\"14\">\n<p align=\"justify\"><b><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Test Value<\/span><\/span><\/span><\/b><\/p>\n<\/td>\n<td style=\"background: #f2f2f2\" bgcolor=\"#f2f2f2\" width=\"412\">\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Returns a test value. <\/span><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr valign=\"top\">\n<td width=\"131\" height=\"15\">\n<p align=\"justify\"><b><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">T (Show t-value)<\/span><\/span><\/span><\/b><\/p>\n<\/td>\n<td width=\"412\">\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">For including the t-value in the resultant chart.<\/span><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr valign=\"top\">\n<td style=\"background: #f2f2f2\" bgcolor=\"#f2f2f2\" width=\"131\" height=\"52\"><b><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Df (Show Degrees of Freedom)<\/span><\/span><\/span><\/b><\/td>\n<td style=\"background: #f2f2f2\" bgcolor=\"#f2f2f2\" width=\"412\">\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">For including the df or Degrees of Freedom value in the resultant chart.<\/span><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr valign=\"top\">\n<td width=\"131\" height=\"43\"><b><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">p (Show p-value \/ Significance (2-tailed))<\/span><\/span><\/span><\/b><\/td>\n<td width=\"412\">\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">For including the two-tailed p-value or significance in the resultant chart.<\/span><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr valign=\"top\">\n<td style=\"background: #f2f2f2\" bgcolor=\"#f2f2f2\" width=\"131\" height=\"15\">\n<p align=\"justify\"><b><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Mean difference<\/span><\/span><\/span><\/b><\/p>\n<\/td>\n<td style=\"background: #f2f2f2\" bgcolor=\"#f2f2f2\" width=\"412\">\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">For including the mean difference value in the resulting chart. <\/span><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr valign=\"top\">\n<td width=\"131\" height=\"14\">\n<p align=\"justify\"><b><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Lower (CL%)<\/span><\/span><\/span><\/b><\/p>\n<\/td>\n<td width=\"412\">\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">To set the lower limit of the level of confidence percentage. <\/span><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr valign=\"top\">\n<td style=\"background: #f2f2f2\" bgcolor=\"#f2f2f2\" width=\"131\" height=\"14\">\n<p align=\"justify\"><b><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Upper (CL%)<\/span><\/span><\/span><\/b><\/p>\n<\/td>\n<td style=\"background: #f2f2f2\" bgcolor=\"#f2f2f2\" width=\"412\">\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">To set the upper limit of the level of confidence percentage. <\/span><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr valign=\"top\">\n<td width=\"131\" height=\"2\">\n<p align=\"justify\"><b><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Confidence Level <\/span><\/span><\/span><\/b><\/p>\n<\/td>\n<td width=\"412\">\n<p align=\"justify\"><a name=\"_Hlk530138376\"><\/a><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Specifies or sets the percentage for the level of confidence.<\/span><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/dd>\n<\/dl>\n<div id=\"attachment_38797\" style=\"width: 752px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/test3.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-38797\" class=\"size-full wp-image-38797\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/test3.png\" alt=\"T test in QlikView - One Sample T test &amp; Paired Sample T test\" width=\"742\" height=\"549\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/test3.png 742w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/test3-150x111.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/test3-300x222.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/test3-520x385.png 520w\" sizes=\"auto, (max-width: 742px) 100vw, 742px\" \/><\/a><p id=\"caption-attachment-38797\" class=\"wp-caption-text\">T test in QlikView &#8211; QlikView\u00a0One Sample T-test<\/p><\/div>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Before we see and draw conclusions based on the values given in the table. We need to frame two hypotheses for this test too just like the chi2 test as this test is also a statistical hypothesis test. <\/span><\/span><\/p>\n<ul>\n<li>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">The <\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><i>null hypothesis<\/i><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"> is that there is no change in the mean value of the current year\u2019s marks and school\u2019s credibility is still the same.<\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">The <\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><i>alternative hypothesis<\/i><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"> is that, yes, there is a difference in the observed and expected value and the mean, as well as school\u2019s credibility, has significantly decreased.<\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Now here comes the part where knowledge of skewness would help you. One sample T-test in QlikView can be done in two ways; one-tailed test (testing for positive or negative skewing) and two-tailed test (testing for both positive and negative skewing).<\/span><\/span><\/p>\n<p align=\"justify\"><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-box-plot-wizard\/\">Do you know how to create a box plot in QlikView?<\/a><\/strong><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"> In this case, with the situation we have, we are doing a one-tailed test for negative skew because we are checking whether the mean has decreased.<\/span><\/span><\/p>\n<div id=\"attachment_42968\" style=\"width: 680px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/test5.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-42968\" class=\"size-full wp-image-42968\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/test5.jpg\" alt=\"T test in QlikView - One Sample T test &amp; Paired Sample T test\" width=\"670\" height=\"103\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/test5.jpg 670w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/test5-150x23.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/test5-300x46.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/test5-520x80.jpg 520w\" sizes=\"auto, (max-width: 670px) 100vw, 670px\" \/><\/a><p id=\"caption-attachment-42968\" class=\"wp-caption-text\">T test in QlikView &#8211; One Sample T test &amp; Paired Sample T test<\/p><\/div>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Looking at the T-test <strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-table\/\">table<\/a><\/strong> above, we can comprehend that the T-test value is -2.356 and degree of freedom (df) which is total number of test values or observations, is 11. Using these two values, we can interpret the result. We will look at the T-table, select 11 as the df (row) and t<\/span><\/span><sub><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">.95, <\/span><\/span><\/sub><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">one-tailed (column). See the value that is coming at the intersection of the selected row and column. The value is 1.796. Now, another thing to keep in mind is that we are doing the test for negative skew or negative tail. So we consider the value as -1.796. <\/span><\/span><\/p>\n<div id=\"attachment_38798\" style=\"width: 1051px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/test6.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-38798\" class=\"size-full wp-image-38798\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/test6.png\" alt=\"T test in QlikView - One Sample T test &amp; Paired Sample T test\" width=\"1041\" height=\"939\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/test6.png 1041w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/test6-150x135.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/test6-300x271.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/test6-768x693.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/test6-1024x924.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/test6-520x469.png 520w\" sizes=\"auto, (max-width: 1041px) 100vw, 1041px\" \/><\/a><p id=\"caption-attachment-38798\" class=\"wp-caption-text\">QlikView\u00a0One Sample T-test &#8211; T-table<\/p><\/div>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">In this case, any value lesser than -1.796 will reject the null hypothesis and make the alternative hypothesis correct. And if the converse is true, i.e. if the value for T-test is greater than -1.796 then null hypothesis cannot reject.<\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">In the test table, the T test value is -2.356 which is less than -1.796. Thus, the null hypothesis saying that the assumption is still true, and school\u2019s credibility is intact, will reject. Rather the truth is that the mean of student\u2019s marks or average marks has gone, taking down school\u2019s credibility as well which was our alternative hypothesis.<\/span><\/span><\/p>\n<h3 align=\"justify\">Paired Sample T test in QlikView<\/h3>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">A QlikView paired T test uses such sets of observations that are dependent on each other for the test to give a result. The two sets of observation must be about the same thing, person etc. This test is used primarily to see whether a particular factor has brought a change in data values or not. <\/span><\/span><\/p>\n<p align=\"justify\"><strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-operators\/\">Follow this link to know about QlikView Operators<\/a><\/strong><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">In other words, to see if a factor is impactful enough.<\/span><\/span><\/p>\n<h4 align=\"justify\">i. Example of Paired Sample T test<\/h4>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Let us understand this by an example. The situation we have is,<\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">A team of researchers want to find out whether studying continuously for long hours or studying with taking breaks brings any difference in the performance of the students? For this, they framed two scenarios,<\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><i>Scenario 1<\/i><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">: Students study for 6 hours straight and take the exam.<\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><i>Scenario 2<\/i><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">: Same students take a 10 minutes break after studying for 3 hours and then resume studying for another 3 hours and take the exam.<\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">We will do a paired sample T test\u00a0in QlikView to analyse the marks obtained in two scenarios. We have the list of marks obtained as \u2018Marks1\u2019 (marks obtained in scenario1) and \u2018Marks2\u2019 (marks obtained in scenario2). <\/span><\/span><\/p>\n<div id=\"attachment_42970\" style=\"width: 146px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/ptest1.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-42970\" class=\"size-full wp-image-42970\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/ptest1.jpg\" alt=\"T test in QlikView - One Sample T test &amp; Paired Sample T test\" width=\"136\" height=\"276\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/ptest1.jpg 136w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/ptest1-74x150.jpg 74w\" sizes=\"auto, (max-width: 136px) 100vw, 136px\" \/><\/a><p id=\"caption-attachment-42970\" class=\"wp-caption-text\">T test in QlikView &#8211; Sample<\/p><\/div>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">We\u2019ll open the Statistics Chart Wizard again and select the <\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><b>One sample T test\/Paired sample T test<\/b><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"> option. <\/span><\/span><\/p>\n<div id=\"attachment_38799\" style=\"width: 752px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/ptest2.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-38799\" class=\"size-full wp-image-38799\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/ptest2.png\" alt=\"T test in QlikView - One Sample T test &amp; Paired Sample T test\" width=\"742\" height=\"549\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/ptest2.png 742w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/ptest2-150x111.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/ptest2-300x222.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/ptest2-520x385.png 520w\" sizes=\"auto, (max-width: 742px) 100vw, 742px\" \/><\/a><p id=\"caption-attachment-38799\" class=\"wp-caption-text\">T test in QlikView &#8211; Paired Sample T test<\/p><\/div>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">In the next step, we will enter the values we want as parameters for the test. We\u2019ve put an expression i.e. \u2018Marks2-Marks1\u2019 because we want the difference analysed by the test. Next, we will mention no <\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><b>Test Value<\/b><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"> here because we simply want to test the difference between the two observations. Select other parameters from the list as you like and click <\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><b>Finish<\/b><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">. <\/span><\/span><\/p>\n<dl>\n<dd>\n<table width=\"574\" cellspacing=\"0\" cellpadding=\"7\">\n<colgroup>\n<col width=\"131\" \/>\n<col width=\"412\" \/> <\/colgroup>\n<tbody>\n<tr valign=\"top\">\n<td width=\"131\" height=\"27\">\n<p align=\"justify\"><b><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Value Field\/Expression<\/span><\/span><\/span><\/b><\/p>\n<\/td>\n<td width=\"412\">\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Returns a test value series.<\/span><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr valign=\"top\">\n<td style=\"background: #f2f2f2\" bgcolor=\"#f2f2f2\" width=\"131\" height=\"14\">\n<p align=\"justify\"><b><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Test Value<\/span><\/span><\/span><\/b><\/p>\n<\/td>\n<td style=\"background: #f2f2f2\" bgcolor=\"#f2f2f2\" width=\"412\">\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Returns a test value. <\/span><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr valign=\"top\">\n<td width=\"131\" height=\"15\">\n<p align=\"justify\"><b><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">T (Show t-value)<\/span><\/span><\/span><\/b><\/p>\n<\/td>\n<td width=\"412\">\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">For including the t-value in the resultant chart.<\/span><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr valign=\"top\">\n<td style=\"background: #f2f2f2\" bgcolor=\"#f2f2f2\" width=\"131\" height=\"52\"><b><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Df (Show Degrees of Freedom)<\/span><\/span><\/span><\/b><\/td>\n<td style=\"background: #f2f2f2\" bgcolor=\"#f2f2f2\" width=\"412\">\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">For including the df or Degrees of Freedom value in the resultant chart.<\/span><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr valign=\"top\">\n<td width=\"131\" height=\"43\"><b><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">p (Show p-value \/ Significance (2-tailed))<\/span><\/span><\/span><\/b><\/td>\n<td width=\"412\">\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">For including the two-tailed p-value or significance in the resultant chart.<\/span><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr valign=\"top\">\n<td style=\"background: #f2f2f2\" bgcolor=\"#f2f2f2\" width=\"131\" height=\"15\">\n<p align=\"justify\"><b><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Mean difference<\/span><\/span><\/span><\/b><\/p>\n<\/td>\n<td style=\"background: #f2f2f2\" bgcolor=\"#f2f2f2\" width=\"412\">\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">For including the mean difference value in the resulting chart. <\/span><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr valign=\"top\">\n<td width=\"131\" height=\"14\">\n<p align=\"justify\"><b><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Lower (CL%)<\/span><\/span><\/span><\/b><\/p>\n<\/td>\n<td width=\"412\">\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">To set the lower limit of the level of confidence percentage. <\/span><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr valign=\"top\">\n<td style=\"background: #f2f2f2\" bgcolor=\"#f2f2f2\" width=\"131\" height=\"14\">\n<p align=\"justify\"><b><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Upper (CL%)<\/span><\/span><\/span><\/b><\/p>\n<\/td>\n<td style=\"background: #f2f2f2\" bgcolor=\"#f2f2f2\" width=\"412\">\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">To set the upper limit of the level of confidence percentage. <\/span><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr valign=\"top\">\n<td width=\"131\" height=\"2\">\n<p align=\"justify\"><b><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Confidence Level <\/span><\/span><\/span><\/b><\/p>\n<\/td>\n<td width=\"412\">\n<p align=\"justify\"><span style=\"color: #000000\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Specifies or sets the percentage for the level of confidence.<\/span><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/dd>\n<\/dl>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-bookmarks\/\">Have you know how to create &amp; import Bookmarks in QlikView?<\/a><\/p>\n<div id=\"attachment_38800\" style=\"width: 752px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/ptest3.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-38800\" class=\"size-full wp-image-38800\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/ptest3.png\" alt=\"T test in QlikView - One Sample T test &amp; Paired Sample T test\" width=\"742\" height=\"549\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/ptest3.png 742w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/ptest3-150x111.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/ptest3-300x222.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/ptest3-520x385.png 520w\" sizes=\"auto, (max-width: 742px) 100vw, 742px\" \/><\/a><p id=\"caption-attachment-38800\" class=\"wp-caption-text\">QlikView Paired Sample T-test<\/p><\/div>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Now, let us frame our hypotheses.<\/span><\/span><\/p>\n<ul>\n<li>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">First hypothesis or the <\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><i>null hypothesis<\/i><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"> will be, that taking a break between the study hours did not bring any change (or increased) the marks and the two scenarios are same. <\/span><\/span><\/p>\n<\/li>\n<li>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">The second hypothesis or the <\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"><i>alternative hypothesis<\/i><\/span><\/span><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\"> is, taking a 10 minutes break did improve the marks of students. <\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Pay attention here, now we have a positive skewed or right tailed situation as the marks are expected to increase, as opposed to what we dealt with in the One sample T test example. Upon producing the resultant table, we get a t test value, degree of freedom (df) and a few more values. But for our case, only t test value and df are important.<\/span><\/span><\/p>\n<div id=\"attachment_42971\" style=\"width: 679px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/ptest5-1.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-42971\" class=\"size-full wp-image-42971\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/ptest5-1.jpg\" alt=\"T test in QlikView - One Sample T test &amp; Paired Sample T test\" width=\"669\" height=\"103\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/ptest5-1.jpg 669w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/ptest5-1-150x23.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/ptest5-1-300x46.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/ptest5-1-520x80.jpg 520w\" sizes=\"auto, (max-width: 669px) 100vw, 669px\" \/><\/a><p id=\"caption-attachment-42971\" class=\"wp-caption-text\">T test in QlikView &#8211; One Sample T test &amp; Paired Sample T test<\/p><\/div>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Now, to infer the result, we\u2019ll refer to the T-table. 4.167 is out T test value and 11 is the df (total number of observations). Moving to the T-table what we need to do is select 11 in the df row and t<\/span><\/span><sub><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">.95 <\/span><\/span><\/sub><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">in the column and check the value at their intersection. The value is 1.796. <\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Now, if the T test value we got is greater than 1.796 then we will reject the null hypothesis and state that the alternative hypothesis is correct. And if the T test value is lesser than 1.796 then we will not reject the null hypothesis.<\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">With our T test value being 4.167 which is greater than 1.796 we reject the null hypothesis that states that scenario 1 and scenario 2 have no difference. Rather, it goes to show that our alternative hypothesis. Which states that there is a significant difference between the two scenarios and taking a break have improved student\u2019s performance is true. <\/span><\/span><\/p>\n<div id=\"attachment_38801\" style=\"width: 1051px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/ptest6.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-38801\" class=\"size-full wp-image-38801\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/ptest6.png\" alt=\"T test in QlikView - One Sample T test &amp; Paired Sample T test\" width=\"1041\" height=\"939\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/ptest6.png 1041w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/ptest6-150x135.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/ptest6-300x271.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/ptest6-768x693.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/ptest6-1024x924.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/ptest6-520x469.png 520w\" sizes=\"auto, (max-width: 1041px) 100vw, 1041px\" \/><\/a><p id=\"caption-attachment-38801\" class=\"wp-caption-text\">QlikView Paired Sample T-test<\/p><\/div>\n<p align=\"justify\">So, this was all about T Test in QlikView. Hope you like our explanation.<\/p>\n<h3 align=\"justify\">Conclusion<\/h3>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Hence, we conclude our lesson on the two tests, which were one sample\u00a0and paired sample T test\u00a0in QlikView. The basic tests are the same which is the T test\u00a0in QlikView. It just varies according to the sample data set that can test by the tests. The one sample test takes only one set of observation whereas the paired sample T test takes two sets of observation values. <\/span><\/span><\/p>\n<p align=\"justify\"><span style=\"font-family: Arial, serif\"><span style=\"font-size: medium\">Also, an important thing to keep in mind is that you must read the values in the T table according to the skewness it has. The results will not be accurate if you do not evaluate the results properly.<\/span><\/span><\/p>\n<p align=\"justify\">Furthermore, if you have any query, feel free to ask in the comment box.<\/p>\n<p align=\"justify\">Related Topic <strong><a href=\"https:\/\/data-flair.training\/blogs\/qlikview-data-types\/\">&#8211; QlikView Data Types<\/a><\/strong><\/p>\n<p align=\"justify\"><strong><a href=\"https:\/\/help.qlik.com\/en-US\/qlikview\/November2017\/Subsystems\/Client\/Content\/ChartFunctions\/StatisticalTestFunctions\/ttest\/t_tests.htm\">Reference for QlikView<\/a><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In our earlier lessons, we learned about QlikView chi-square\u00a0test of statistical chart wizard. Moving on, we are going to learn about one more such test which is T test in QlikView. In which, we&#46;&#46;&#46;<\/p>\n","protected":false},"author":6,"featured_media":38811,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[47],"tags":[17330,17331,9216,17328,17327,17326,17329],"class_list":["post-38704","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-qlikview","tag-example-of-qlikview-one-sample-t-test","tag-example-of-qlikview-paired-sample-t-test","tag-one-sample-t-test","tag-paired-sample-t-test","tag-qlikview-t-test","tag-t-test-in-qlikview","tag-what-is-qlikview-t-test"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>T test in QlikView - One Sample T test &amp; Paired Sample T test - DataFlair<\/title>\n<meta name=\"description\" content=\"Types of T test in QlikView: One Sample T-test, Paired Sample T-test, Example of One Sample T test, Paired Sample T test in QlikView\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/t-test-in-qlikview\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"T test in QlikView - One Sample T test &amp; Paired Sample T test - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Types of T test in QlikView: One Sample T-test, Paired Sample T-test, Example of One Sample T test, Paired Sample T test in QlikView\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/t-test-in-qlikview\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-11-21T03:40:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-12-07T05:49:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-T-test-01.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"T test in QlikView - One Sample T test &amp; Paired Sample T test - DataFlair","description":"Types of T test in QlikView: One Sample T-test, Paired Sample T-test, Example of One Sample T test, Paired Sample T test in QlikView","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/data-flair.training\/blogs\/t-test-in-qlikview\/","og_locale":"en_US","og_type":"article","og_title":"T test in QlikView - One Sample T test &amp; Paired Sample T test - DataFlair","og_description":"Types of T test in QlikView: One Sample T-test, Paired Sample T-test, Example of One Sample T test, Paired Sample T test in QlikView","og_url":"https:\/\/data-flair.training\/blogs\/t-test-in-qlikview\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-11-21T03:40:58+00:00","article_modified_time":"2021-12-07T05:49:57+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-T-test-01.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/t-test-in-qlikview\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/t-test-in-qlikview\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"T test in QlikView &#8211; One Sample T test &amp; Paired Sample T test","datePublished":"2018-11-21T03:40:58+00:00","dateModified":"2021-12-07T05:49:57+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/t-test-in-qlikview\/"},"wordCount":1959,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/t-test-in-qlikview\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-T-test-01.jpg","keywords":["Example of QlikView One Sample T test","Example of QlikView Paired Sample T test","one sample t-test","Paired Sample T test","QlikView T test","T test in QlikView","What is QlikView T test"],"articleSection":["QlikView Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/t-test-in-qlikview\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/t-test-in-qlikview\/","url":"https:\/\/data-flair.training\/blogs\/t-test-in-qlikview\/","name":"T test in QlikView - One Sample T test &amp; Paired Sample T test - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/t-test-in-qlikview\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/t-test-in-qlikview\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-T-test-01.jpg","datePublished":"2018-11-21T03:40:58+00:00","dateModified":"2021-12-07T05:49:57+00:00","description":"Types of T test in QlikView: One Sample T-test, Paired Sample T-test, Example of One Sample T test, Paired Sample T test in QlikView","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/t-test-in-qlikview\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/t-test-in-qlikview\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/t-test-in-qlikview\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-T-test-01.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/QlikView-T-test-01.jpg","width":1200,"height":628,"caption":"T test in QlikView - One Sample T test &amp; Paired Sample T test"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/t-test-in-qlikview\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"QlikView Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/qlikview\/"},{"@type":"ListItem","position":3,"name":"T test in QlikView &#8211; One Sample T test &amp; Paired Sample T test"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"The DataFlair Team provides industry-driven content on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our expert educators focus on delivering value-packed, easy-to-follow resources for tech enthusiasts and professionals.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam2\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/38704","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=38704"}],"version-history":[{"count":10,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/38704\/revisions"}],"predecessor-version":[{"id":104920,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/38704\/revisions\/104920"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/38811"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=38704"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=38704"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=38704"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}