Illustrating Different Statistical Methods
Goals
- Explain the importance of statistical tests.
- Break down the hypothesis test.
- Utilize tests and methods to determine relationships between variables.
Explain the Importance of Statistical Tests
- Sampling
- Simple Random Sampling
- Stratified Sampling
- Systematic Sampling
- Cluster Sampling
- Multi-Stage Sampling
- Convenience Sampling
- Snowball Sampling
- Perform sampling
- Analysis ToolPak in Excel
- Confidence Interval
- P-Value
Utilize Tests and Methods to Determine Relationships Between Variables
- Hypothesis Testing
- T-Test
- Chi-Square Test
- Linear Regression
- Correlation
- Use Excel to Apply Statistical Methods
- find functions in the Formulas tab
- some functions:
AVERAGEMEDIANMODE(single or multiple)MINMAXSTDEV(standard deviation)STANDARDIZE(z-score)CONFIDENCE
- To run statistical tests, add the Excel Add-In to the Analysis ToolPak
- Analyze Data but has more functionality