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
GETPIVOTDATA function in Excel To add a GETPIVOTDATA formula easily, type an equal sign (=) and then click on a cell inside the PivotTable. The GETPIVOTDATA function can be quite useful. 1. First, click on cell B14 and type =D7 (do not click on cell D7 in the PivotTable) to Read more
Calculated Field and Calculated Item in Pivot Table This example shows how to add a calculated field or item in a pivot table. Below you can find a pivot table. Return to Pivot Tables to review how to create this pivot table. 💎 Using Calculated Field in Pivot Table A Read more
Update a Pivot Table in Excel The pivot table does not automatically reflect changes made to the data set. To see the changes in your pivot table, refresh it or update its data source. 💎 Refresh When you modify text or numbers in your data set, the pivot table must Read more
Slicers in Excel Slicers in Excel allow you to filter pivot tables in a simple and fast way. Use multiple slicers with multiple pivot tables to create interactive reports easily. Below you can find a pivot table. Please revisit the Pivot Tables section to understand how to create this pivot Read more
Pivot Chart in Excel A Pivot Chart is a graphical view of the summarized data found in a Pivot Table. A PivotChart and a PivotTable are linked to each other. Below you can find a two-dimensional pivot table. Please revisit the Pivot Tables tutorial to understand the steps for creating Read more