Basic Biostatistics with Basic Steps in Microsoft Excel

*Hypothesis
*Frequency
*Type I Error and Type II Error, and Sample and Population
*Measuring the central tendencies (mean, median, and mode), and Range
*Types of data in statistics
*Population mean and sample mean
*Histogram, frequency distribution Description, and Bar Graph
*Variance, Standard deviation, and Outliers
*Level of Significance and confidence level
*Correlation, Types of Distribution, Standardization, and Standard Error of the Mean
*Tests for Non-normally distributed data
*Chi-square test
*One-tailed test, two-tailed test, and Wilcoxon Rank Sum Test / Mann Whitney U Test
*The Sign Test
*Wilcoxon Signed Rank Test
*The Kruskal-Wallis Test
*The Friedman Test
*Tests for Normally distributed data
*Unpaired "t" test
*Paired "t" test
*One way ANOVA
*Two way ANOVA
*Odds Ratio and Mantel-Haenszel Odds Ratio
*Correlation Coefficient
*Regression Analysis
*Important Statistical Techniques/Procedures used in Medical Research