In this course I will introduce you to the use Excel Statistical Functions and free Excel Statistical Add-ins. Excel has a huge range of statistical functions and add-ins available.
We will also cover the major statistical formulas from first principles including:
- Mean
- Standard Deviation
- Normal Distributions
- Central Limit Theorem
- t-Distribution
- Regression Analysis
- Correlation
- ANOVA Testing
I have practical Excel worked examples for each of these areas.
Among the formulas and areas cover will be:
- SumSq
- SumProduct
- Array Functions
- Average (Mean)
- Variance – Var.p entire population and var.s with N-1 for population
- Standard Deviation – stdev.p entire population
- Correlation Coefficient – CORREL
- Standard Scores – STANDARDIZE
Excel – Statistical Graphs
- Scatterplot
- Regression Analysis
- Line and Bar Charts
Excel’s Analysis Toolpak Addins Installation
- Mean
- Standard Error
- Median
- Mode
- Standard Deviation
- Sample Variance
- Kurtosis
- Skewness
- Range
- Minimum / Maximum
- Sum
- Count / Observations
We will also look the 4 Different Data Types
- Nominal
- Ordinal
- Interval
- Ratio
We will also cover Independent and dependent variables
- Probability
- Compound Events
- Factorial
- Combinations
- Permutations
- Conditional Probability
- Bayesian Probability
- Central Tendency
- Mean
- Median
- Mode – Single and multiple
- Distributions
- Normal Distributions
- Frequency
- Frequency Polygon graphs
- Sampling Distributions
- Standard Error
- Central Limit Theorem
- t-Distribution
- Estimation
- Confidence Limits
- Hypothesis testing including z-test and t-test
- Chi-Square distribution
- Independent Samples including z-test and t-test for independent samples
- Matched Samples Hypothesis Testing
- Analysis of Variance including ANOVA Testing
- Regression Analysis
- Correlation