This example teaches you how to perform a t-Test in Excel. The t-Test is used to test the null hypothesis that the means of two populations are equal.
Learn how to use Excel in exactly 30 minutes starting with the very basics (for the complete beginner) and then move to more intermediate features such as ch. Open Microsoft Excel. You'll find it in the Start menu (Windows) or in the Applications folder (macOS). The app will open to a screen that allows you to create or select a document. If you don't have a paid version of Microsoft Office, you can use the free online version at to create a basic spreadsheet. This example teaches you how to perform a t-Test in Excel. The t-Test is used to test the null hypothesis that the means of two populations are equal. Below you can find the study hours of 6 female students and 5 male students. H 0: μ 1 - μ 2 = 0 H 1: μ 1 - μ 2 ≠ 0.
Below you can find the study hours of 6 female students and 5 male students.
H0: μ1 - μ2 = 0
H1: μ1 - μ2 ≠ 0
To perform a t-Test, execute the following steps.
1. First, perform an F-Test to determine if the variances of the two populations are equal. This is not the case.
2. On the Data tab, in the Analysis group, click Data Analysis.
Note: can't find the Data Analysis button? Click here to load the Analysis ToolPak add-in.
3. Select t-Test: Two-Sample Assuming Unequal Variances and click OK.
4. Click in the Variable 1 Range box and select the range A2:A7.
5. Click in the Variable 2 Range box and select the range B2:B6.
6. Click in the Hypothesized Mean Difference box and type 0 (H0: μ1 - μ2 = 0).
7. Click in the Output Range box and select cell E1.
Me Excellence
8. Click OK.
Result:
Conclusion: We do a two-tail test (inequality). lf t Stat < -t Critical two-tail or t Stat > t Critical two-tail, we reject the null hypothesis. This is not the case, -2.365 < 1.473 < 2.365. Therefore, we do not reject the null hypothesis. The observed difference between the sample means (33 - 24.8) is not convincing enough to say that the average number of study hours between female and male students differ significantly.
Ms Excel Online
In this case, the formula first extracts the month as a number between 1-12, then divides this number by 3. The result is then rounded up to the nearest whole number using the ROUNDUP function.The ROUNDUP function...
Normally, the XLOOKUP function is configured to look for a value in a lookup array that exists on the worksheet. However, when the criteria used to match a value becomes more complex, you can use boolean logic to...
In this case, Excel extracts the month from the date in cell B6 as a number, and the month in the cell C6 as a number, then tests for equivalency using the equal sign. Both dates are in January, so the formula is...
This data set contains over 2900 records, and the formula above uses two named ranges:dates = B5:B2932amounts = E5:E2932Inside the SUMPRODUCT function, the MONTH function is used to extract the month number for...
The SEQUENCE function is a dynamic array function that can generate multiple results. Like other dynamic array functions, SEQUENCE outputs an array of results that 'spill' onto the worksheet in a 'spill range'....
In this example, we need to construct logic that filters data to include:account begins with 'x' AND region is 'east', and month is NOT April.The filtering logic of this formula (the include argument) is created by...
In the example, B6 is the hard-coded start date and the formula in B7 is:=DATE(YEAR(B6),MONTH(B6)+1,DAY(B6))To solve this formula, Excel first extracts the year, month, and day values from the date in B6, then...
The MONTH function takes just one argument, the date from which to extract the month. In the example shown, the formula is:=MONTH(B4)where B4 contains the dateJanuary 5, 2016. The MONTH function returns the number...
The goal of this example is to sum amounts by fiscal year, when the fiscal year begins in July. The first approach is an self-contained formula based on the SUMPRODUCT function. The second method uses SUMIF with column...
This formula relies on the FILTER function to retrieve data based on a logical test created with the MONTH function. The array argument is provided as the named range 'data', which contains the full set of data without...
In the example, the formula in cell D6 contains this formula:=MONTH(B6)&YEAR(B6)=MONTH(C6)&YEAR(C6)In this case, Excel extracts the month from the date in cell B6 as numbers, then concatenates them...
In the example, B6 is the hard-coded start date and the formula in B7 is:=DATE(YEAR(B6)+1,MONTH(B6),DAY(B6))To solve this formula, Excel first extracts the year, month, and day values from the date in B6, then...
You would think you could use the COUNTIF function to count birthdays, but the trouble is COUNTIF only works with ranges, and won't let you use something like MONTH to extract just the month number from dates. So, we...
What Is Me In Vba
Do you want to convert the date into a month name?If you want to convert the date value to a text value, you can use the TEXT function with a custom number format like 'mmmm', or 'mmm'. In the example shown, the...
Ms Excel Training
In this example, the goal is to return the fiscal year for any given date, where a fiscal year starts in July as seen in the worksheet. By convention a fiscal year is denoted by the year in which it ends. So, if a...