Unit 2 Template
Unit 3 Template
Excel Templates as a Statistical Tool
Overview
As mentioned in the syllabus, we are using MS Excel for statistical analysis in our OER stats course. We have, therefore, created three templates, one for each of the three units that the course is divided into, in order to help students make necessary calculations. Creating templates was a necessary steps since students are not expected to know how to use Excel functions for statistics and these templates are to guide students into getting relevant stats for their data, such as average, median, histograms, etc. Each template is divided into separate spreadsheets according to the topics. These templates help cut down the tedious work of evaluating statics and help students focus more on the concepts and analyse the results.
Excel Templates
As mentioned in the syllabus, we are using MS Excel for statistical analysis in our OER stats course. We have, therefore, created three templates, one for each of the three units that the course is divided into, in order to help students make necessary calculations. Creating templates was a necessary steps since students are not expected to know how to use Excel functions for statistics and these templates are to guide students into getting relevant stats for their data, such as average, median, histograms, etc. Each template is divided into separate spreadsheets according to the topics. These templates help cut down the tedious work of evaluating statics and help students focus more on the concepts and analyse the results.
Following is the description of the three templates.
Unit 1 Template
- Frequency Distribution - this spreadsheet evaluates frequencies for variable values, provided the data and the values.
- Class Frequency Distribution - this spreadsheet evaluates frequencies for a range of variable values, provided the data and the ranges.
- Measures of Center and Spread - this spreadsheet is for evaluating statistics such as the average, median, standard deviation, variance, etc.
- Measures of Position - this spreadsheet is for evaluating statistics such as percentiles, quartiles, and z-scores, provided the data.
- 5-Number Summary - this spreadsheet if for evaliating the five-number summary, i.e. the minimum data value, the three quartiles, and the maximum data value.
- Linear Regression - to obtain scatter plots, correlation coefficient, and regression equation for bivariate data.
Unit 2 Template
- Probability Table - to evaluate probabilities from given information in tabular format.
- Contingency Table - to evaluate conditional probabilities from given contingency tables.
- Counting - to evaluate factorials, permutations, and combinations.
- Expected Value - to evaluate the expected value and standard deviation of a discrete random variable.
- Binomial Probability - to evaluate the binomial probability for exact, at least, or at most value of a given random variable.
- Normal - to evaluate the probabilities of a random variable using a normal distribution, given the mean and standard deviation.
- CLT - to evaluate the probabilities of a random variable using a normal distribution and the Central Limit Theorem, given the sample size (or data), mean and standard deviation.
Unit 3 Template
- CI for Proportion - evaluates the confidence interval for a population proportion with the given information.
- CI for Mean - evaluates the confidence interval for a population with the given information (or data).
- HT for Proportion - evaluates the critical value, test-statistic, and P-value for testing hypotheses for population proportion.
- HT for Mean - evaluates the critical value, test-statistic, and P-value for testing hypotheses for population mean.