Statistical Tests
Statistical Tests
Embedded Files
Statistical Inference:
Statistical Inference:
On this page, you'll find video tutorials on how to run a T-Test, regression analysis, and ANOVA using Microsoft Excel.
T-Test
T-Test
The t-test is a statistical test that is used to compare data for two different treatments, each of which has a mean and standard deviation. In terms of variable types: a student’s t-test is used when you have two categorical, independent variables, and a continuous dependent variable.
Watch this video tutorial to learn how to run a T-Test on Microsoft Excel!
ANOVA (Analysis of Variance)
ANOVA (Analysis of Variance)
The ANOVA is a statistical test that, like the t-test, compares the means of multiple treatments to determine if they are significantly different. ANOVAs are used when you have 3 or more groups (categorical, independent variables).
Watch this video to learn how to run a one-way ANOVA on Microsoft Excel!
Link to website that allows you to do a quick Tukey Post-Hoc Test: https://astatsa.com/OneWay_Anova_with_TukeyHSD/
Linear Regression
Linear Regression
Linear regressions are used to determine if one variable significantly impacts another. Experiments with continuous independent and dependent variables can use this test. A linear regression assumes that the relationship between the variables of interest is linear. It calculates a line of best fit, and determines how well each data point fits to that line, to determine whether a significant relationship exists.
Page updated
Google Sites
Report abuse