Category: Excel

You can create a contingency table in Excel using the Pivot Table. This tutorial includes steps showing how to create a contingency table for count data. Data and Resarch Question for Contingency Table The following is the sample data used...

You can use the VARP, VAR.P, or VARPA functions in Excel to calculate population variance.  Data Example The following is the data example for population variance. Example of VARP() Type =VARP(B2:B12) in a cell in Excel to calculate population variance. The population variance is 46.23. Example...

You can use the VAR, VAR.S or VARA functions to calculate sample variance.  Data Example We are going to use the following sample of 6 students with math scores. The following is how the data looks in Excel. Example of Var() Thus, you can type...

You can use the syntax of =AVERAGE() to calculate the mean in Excel. Example 1: one column You type the syntax of =AVERAGE(B2:B12) in one cell. Basically you can choose any cells to type that, and I just chose E2...

STDEV(), STDEV.S(), and STDEV.P() can be used to calculate standard deviation in Excel. It depends on if you are calculating sample or population standard deviation. Sample Standard Deviation: Use either STDEV() or STDEV.S(). Population Standard Deviation: Use STDEV.P(). Example 1 The following...

This tutorial shows detailed steps of how to do paired-sample t-test in Excel with a data example. Data Example The data table shown below has 3 columns, name, math, and English. We are going to compare if Math and English...

This tutorial shows how you can do two-way ANOVA in Excel. Different from one-way ANOVA, two-way ANOVA has two independent variables. Note that, two-way ANOVA is also called two-factor ANOVA. Prepare data and hypothesis writing Suppose Brand A sells its...

This tutorial shows how you can do linear regression in Excel with examples and detailed steps. Steps of Linear Regression in Excel Step 1: Prepare data and hypothesis We want to test how consumer purchase intention can be impacted by...