COUNTIF function in Excel The COUNTIF function in Excel calculates the number of cells that meet a particular condition. This page provides many simple COUNTIF function example for better understanding. 💎 Numeric Criteria Use the COUNTIF function in Excel to count cells that match a specific value or meet a condition, Read more
t-Test in Excel This example helps you learn how to do a t-test in Excel. The t-test is a statistical method used to determine if two sets of data have the same mean. Here is the list of study hours for 6 female students and 5 male students. H0: μ1 Read more
F-Test in Excel This example explains how to carry out an F-test in Excel. The F-test helps to compare the variability of two populations to see if they are similar. Here is the list of study hours for 6 female students and 5 male students. H0: σ12 = σ22 H1: Read more
ANOVA in Excel This example shows how to perform a one-way ANOVA in Excel. A one-way or single-factor ANOVA (Analysis of Variance) examines the null hypothesis that several population means do not differ from each other. Below is a list of salaries for people who hold degrees in economics, medicine, Read more
Descriptive Statistics in Excel You can use the Analysis ToolPak add-in to create descriptive statistics in Excel easily. For example, consider that you have the scores of 14 students from a test. Follow the steps below to produce descriptive statistics for these scores. 1. In the Data tab, find the Read more
Histogram in Excel In this tutorial, you will learn how to make a histogram in Excel. 1. First, type the bin numbers (upper limits) in the cells from C4 to C8. 2. On the Data tab, find the Analysis group and select Data Analysis. Note: can’t find the Data Analysis Read more
ROW function in Excel In Excel, the ROW function returns the number of the row for a specific cell reference. For example, =ROW(C4) returns 4. The ROW function can be quite useful. 💎 How to find row numbers in Excel 1. The ROW function below returns 8. 2. If you Read more
Move Columns in Excel You can move columns in Excel by holding Shift and dragging them, or by cutting and inserting the cells. You can change the order of every column with one action. 💎 Shift Key When moving columns in Excel, hold the Shift key to ensure that existing Read more
Split Cells in Excel To split cells in Excel, insert a new column, adjust the column widths, and then merge the necessary cells. You can split the data in one cell into multiple cells by using the Text to Columns wizard, Flash Fill, or formulas. 💎 Split a Cell Use Read more
Prevent Duplicate Entries in Excel You can prevent duplicate entries in Excel by applying data validation and the COUNTIF function. 1. Select the range A2:A20. 2. Go to the Data tab, then find Data Tools, and click Data Validation. 3. In the Allow list, click Custom. 4. Enter the formula Read more