MA207 Final Exam Skill Inventory
Technology
The final 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
Regression
Given pairs of x and y values, you sould be able to:
- Find the slope of the regression line using the SLOPE function
- Find the intercept of the regression line using the INTERCEPT function
- Find the correlation coefficient using the CORREL function
- Provide an interpretation of the slope and intercept in the context of the problem.
- Be able to compute the RMS error (see class notes)
notes
Confidence Intervals
You should be able to compute confidence intervals for a given alpha level for:
- A proportion
- The mean of a population with known standard deviation
- The mean of a population with unknown standard deviation
Significance Testing
You should be :
- A proportion
- The mean of a population with known population standard deviation
- The mean of a population with unknown population standard deviation
Significance Testing: Comparing Two Means or Proportions
You should be able to test for equality given:
- A paired or dependent sample
- Two proportions
- Two means with known standard population deviation
- Two means with unknown population standard deviation