Find the best survey software for you!
(Along with a checklist to compare platforms)
Take a peek at our powerful survey features to design surveys that scale discoveries.
Explore Voxco
Need to map Voxco’s features & offerings? We can help!
Find the best customer experience platform
Uncover customer pain points, analyze feedback and run successful CX programs with the best CX platform for your team.
We’ve been avid users of the Voxco platform now for over 20 years. It gives us the flexibility to routinely enhance our survey toolkit and provides our clients with a more robust dataset and story to tell their clients.
Steve Male
VP Innovation & Strategic Partnerships, The Logit Group
Explore Regional Offices
Find the best survey software for you!
(Along with a checklist to compare platforms)
Take a peek at our powerful survey features to design surveys that scale discoveries.
Explore Voxco
Need to map Voxco’s features & offerings? We can help!
Find the best customer experience platform
Uncover customer pain points, analyze feedback and run successful CX programs with the best CX platform for your team.
We’ve been avid users of the Voxco platform now for over 20 years. It gives us the flexibility to routinely enhance our survey toolkit and provides our clients with a more robust dataset and story to tell their clients.
Steve Male
VP Innovation & Strategic Partnerships, The Logit Group
Explore Regional Offices
SHARE THE ARTICLE ON
We there are various methods to calculate the t-test, like calculating it manually, using a statistical programming language and so on.
In this article we will be looking at step-by-step process of how you can perform the t-test in excel. Let’s start:
Make sure you have the Data analysis add-in installed in your excel.
Go to excel and click on “Data” menu. You should be able to see the data analysis tool in the end like below:
If you don’t already have the Data analysis tool, follow the below steps to get in installed:
File > Options > Add-ins > Select the “Analysis ToolPak” > Go > Tick the “Analysis ToolPak” checkbox > Ok
You can follow the step 1 and see, you will have the Data analysis tool installed.
Create an actionable feedback collection process.
You will see an option box where there are various tests you can perform in excel. From the options, select the t-test option and click “ok”
Note that the Alpha value is set to 0.05 by default and it needs not be changed.
After doing the changes, click on “Ok”
See Voxco survey software in action with a Free demo.
Depending on your experiment, the most important p value is highlighted in pink.
Since you set your alpha value at 0.05, if the p-value is less than 0.05, you can say that there is a statistically significant difference between the means of your two trials. In our example
p = 2.07 x 10-13 is less than 0.05 hence, the difference is significant.
Get market research trends guide, Online Surveys guide, Agile Market Research Guide & 5 Market research Template
There is a way to calculate the t-test in just one step, provided you are interested in just the p value.
Select any cell and enter this syntax in the cell formula: T.TEST(array1, array2,tails,type)
The array A2:A11 refers the sample 1 and B2:B11 refers the sample 2.
The first 2 is for two-tails and the other 2 is for the type referring:
1 = paired test
2 = two sample equal variance test
3 = two sample unequal variance test
We will get the same p value as we calculated before.
Net Promoter®, NPS®, NPS Prism®, and the NPS-related emoticons are registered trademarks of Bain & Company, Inc., Satmetrix Systems, Inc., and Fred Reichheld. Net Promoter Score℠ and Net Promoter System℠ are service marks of Bain & Company, Inc., Satmetrix Systems, Inc., and Fred Reichheld.
Read more
We use cookies in our website to give you the best browsing experience and to tailor advertising. By continuing to use our website, you give us consent to the use of cookies. Read More
Name | Domain | Purpose | Expiry | Type |
---|---|---|---|---|
hubspotutk | www.voxco.com | HubSpot functional cookie. | 1 year | HTTP |
lhc_dir_locale | amplifyreach.com | --- | 52 years | --- |
lhc_dirclass | amplifyreach.com | --- | 52 years | --- |
Name | Domain | Purpose | Expiry | Type |
---|---|---|---|---|
_fbp | www.voxco.com | Facebook Pixel advertising first-party cookie | 3 months | HTTP |
__hstc | www.voxco.com | Hubspot marketing platform cookie. | 1 year | HTTP |
__hssrc | www.voxco.com | Hubspot marketing platform cookie. | 52 years | HTTP |
__hssc | www.voxco.com | Hubspot marketing platform cookie. | Session | HTTP |
Name | Domain | Purpose | Expiry | Type |
---|---|---|---|---|
_gid | www.voxco.com | Google Universal Analytics short-time unique user tracking identifier. | 1 days | HTTP |
MUID | bing.com | Microsoft User Identifier tracking cookie used by Bing Ads. | 1 year | HTTP |
MR | bat.bing.com | Microsoft User Identifier tracking cookie used by Bing Ads. | 7 days | HTTP |
IDE | doubleclick.net | Google advertising cookie used for user tracking and ad targeting purposes. | 2 years | HTTP |
_vwo_uuid_v2 | www.voxco.com | Generic Visual Website Optimizer (VWO) user tracking cookie. | 1 year | HTTP |
_vis_opt_s | www.voxco.com | Generic Visual Website Optimizer (VWO) user tracking cookie that detects if the user is new or returning to a particular campaign. | 3 months | HTTP |
_vis_opt_test_cookie | www.voxco.com | A session (temporary) cookie used by Generic Visual Website Optimizer (VWO) to detect if the cookies are enabled on the browser of the user or not. | 52 years | HTTP |
_ga | www.voxco.com | Google Universal Analytics long-time unique user tracking identifier. | 2 years | HTTP |
_uetsid | www.voxco.com | Microsoft Bing Ads Universal Event Tracking (UET) tracking cookie. | 1 days | HTTP |
vuid | vimeo.com | Vimeo tracking cookie | 2 years | HTTP |
Name | Domain | Purpose | Expiry | Type |
---|---|---|---|---|
__cf_bm | hubspot.com | Generic CloudFlare functional cookie. | Session | HTTP |
Name | Domain | Purpose | Expiry | Type |
---|---|---|---|---|
_gcl_au | www.voxco.com | --- | 3 months | --- |
_gat_gtag_UA_3262734_1 | www.voxco.com | --- | Session | --- |
_clck | www.voxco.com | --- | 1 year | --- |
_ga_HNFQQ528PZ | www.voxco.com | --- | 2 years | --- |
_clsk | www.voxco.com | --- | 1 days | --- |
visitor_id18452 | pardot.com | --- | 10 years | --- |
visitor_id18452-hash | pardot.com | --- | 10 years | --- |
lpv18452 | pi.pardot.com | --- | Session | --- |
lhc_per | www.voxco.com | --- | 6 months | --- |
_uetvid | www.voxco.com | --- | 1 year | --- |