You use ANOVA: Two-Factor without Replication when each cell only has 1 observation, but use Two-Factor with Replication when each cell has more than 1 observation. For instance, there are two factors, City and Chain Brand. Each has 2 levels, leading to 4 cells (see the figure below). Each cell in the left-hand data table … Read more
This tutorial explains the difference between logit and probit in statistics with formulas and examples. Formula and Example for Logit We can start with the following formula. Thus, \( \beta_0+\beta_1x_1+…+\beta_nx_n \) can be from \( -\infty \) to \(+\infty \), and \( p(y=1) \) will be always within the range of \( (0,1) \). We … Read more
The difference between population variance and sample variance is on the denominator of the formula. In particular, the denominator for population variance is N, whereas sample variance is n-1. The following uses formulas and examples to explain the difference between them. Data Example The following are 5 numbers that we are going to calculate variance. … Read more
This tutorial will first show the formulas for Two-way ANOVA and then use an example to show how you can calculate two-way ANOVA by hand. The following depicts the conceptual framework of the variance breaking down for two-way ANOVA. Typically, Two-way is used for experiment data analyses. Data example for two-way ANOVA This is the … Read more
This tutorial includes the formula and examples for Sum of Squares (SS). Sum of Squares (SS) is a measure of deviation from the mean and the following is its formula. It is to square the distance between each data point and the mean then add them together. Formula of Sum of Squares (SS) The following is … Read more
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 products in city1 and city2, each city with 2 grocery store chains (Grocery store Chain … Read more
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 price as well as by household income. Thus, consumer purchase intention is the Y, whereas price … Read more
This tutorial shows how you can do one-way ANOVA (analysis of variance) in Excel. Note that, one-way ANOVA is also called single factor ANOVA. Steps of One-Way ANOVA in Excel Step 1: Prepare the data Suppose we would like to see whether 3 cities differ in terms of household size. We sample 5 households from each city. … Read more
This tutorial shows how to solve the problem that data analysis does not show up in Excel. That is, you click the “Data” tap, but you can not see find “Data Analysis” module. Steps of fixing “Data Analysis” not show up in Excel Step 1: Click “File” and “Options” Click “File” on the top and … Read more
This tutorial shows how you can calculate two-sample t-test and its p-value in Excel. This tutorial will include detailed examples and steps. Steps of Calculating two-sample t-test and p-value in Excel Step 1: Data used for t-test The following is the data used for t-test. The data are women and men’s attitudes toward a brand … Read more