MA207 Midterm Skill Inventory
Technology
The midterm exam will consist of a number of multiple choice questions, some of which may require you to use either a spreadsheet or MINITAB.
You should be able to:
- Download and import a comma delimited (.csv) file to a spreadsheet or MINITAB
- Use a either spreadsheet or MINITAB to produce simple statistics including:
- the mean
- the standard deviation
- the median
- the interquartile range
Histograms
Given a histogram, you should be able to determine approximately what percent of the population falls within a given range of values on the horizontal scale.
The histogram may be:
- a frequency histogram
- a percent histogram
- a density histogram
Bell Curve Areas
Given the mean and standard deviation of a bell curve distribution, you should be able to use the NORMDIST function
to determine the proportion of the population that is:
- Less than or equal to a given value
- Greater than or equal to a given value
- Between two given values
- Either less than or equal to a given value, or greater than or equal to a second given value.
notes
Bell Curve Percentiles
Given the mean and standard deviation of a bell curve distribution and a percentile between $0$ and $100$, you should be able to use the NORMINV function to determine the value that represents the given percentile of the population.
notes
Bell Curves for Sample Means
Given the mean and standard deviation of a bell curve distribution, and the size of the sample, you should be able to
determine:
- The mean of the bell curve distribution of the sample mean
- The standard deviation of the sample mean (which is the original standard deviation divided by the square root of the sample size)
You should also be able to use the bell curve distribution of the sample mean to determine the proportion of time the sample mean will be:
- Less than or equal to a given value
- Greater than or equal to a given value
- Between two given values
- Either less than or equal to a given value, or greater than or equal to a second given value.
notes