College of Micronesia-FSM
MS 150 Statistics
With usage of general objectives and specific objectives
Course Description: A semester course designed as an introduction to the basic ideas of data presentation, descriptive statistics, and inferential statistics including confidence intervals and hypothesis testing. The course incorporates the use of a computer spreadsheet package, Microsoft Excel, for both data analysis and presentation. Basic concepts are studied using applications from business, social science, health science, and the natural sciences.
Hours per week: 3
Number of weeks: 16
Semester credits: 3
Prerequisite course: MS 100 College Algebra
The order of the sections is not intended to reflect the chronologic order of topics.
- General Objectives
Students will be able to:
- Calculate basic statistics
- Represent data sets using histograms
- Solve problems using normal curve and t-statistic distributions including confidence intervals for means and hypothesis testing
- Determine and interpret p-values
- Perform a linear regression and make inferences based on the results
- Specific objectives
Students will be able to:
- Calculate basic statistics
- Distinguish between a population and a sample
- Distinguish between a statistic and a parameter
- Identify different levels of measurement when presented with nominal,
ordinal, interval, and ratio data.
- Determine a sample size
- Determine a sample minimum
- Determine a sample maximum
- Calculate a sample range
- Determine a sample mode
- Determine a sample median
- Calculate a sample mean
- Calculate a sample standard deviation
- Calculate a sample coefficient of variation
- Represent data sets using histograms
- Calculate a class width given a number of desired classes
- Determine class upper limits based on the sample minimum and class width
- Calculate the frequencies
- Calculate the relative frequencies (probabilities)
- Create a frequency histogram based on calculated class widths and frequencies
- Create a relative frequency histogram based on calculated class
widths and frequencies
- Identify the shape of a distribution as being symmetrical,
uniform, bimodal, skewed right, skewed left, or normally symmetric.
- Estimate a mean from class upper limits and relative frequencies
using the formula Sx*P(x)
here the probability P(x) is the relative frequency.
- Solve problems using normal curve and t-statistic distributions including confidence intervals for means and hypothesis testing
- Discover the normal curve through a course-wide effort involving
tossing seven pennies and generating a histogram from the in-class
experiment.
- Identify by characteristics normal curves from a set of normal and
non-normal graphs of lines.
- Determine a point estimate for the population mean based on the
sample mean
- Calculate a z-critical value from a confidence level
- Calculate a t-critical value from a confidence level and the sample
size
- Calculate an error tolerance from a t-critical, a sample standard
deviation, and a sample size.
- Solve for a confidence interval based on a confidence level, the
associated z-critical, a sample standard deviation, and a sample size
where the sample size is equal or greater than 30.
- Solve for a confidence interval based on a confidence level, the
associated t-critical, a sample standard deviation, and a sample size
where the sample size is less than 30.
- Use a confidence interval to determine if the mean of a new sample places
the new data within the confidence interval or is statistically significantly
different.
- Determine and interpret p-values
- Calculate the two-tailed p-value using a sample mean,
sample standard deviation, sample size, and expected population mean to
to generate a t-statistic.
- Infer from a p-value the largest confidence interval for which a change
is not significant.
- Perform a linear regression and make inferences based on the results
- Identify the sign of a least squares line: positive, negative, or zero.
- Calculate the slope of the least squares line.
- Calculate the intercept of the least squares line.
- Solve for a y value given an x value and the slope and intercept
of a least squares line.
- Solve for a x value given an y value and the slope and intercept
of a least squares line.
- Calculate the correlation coefficient r.
- Use a correlation coefficient r to render a judgment as to whether a correlation is perfect, high, moderate, low, or none.
- Calculate the coefficient of determination r˛.
Course Intentions
- Use of Microsoft Excel and Microsoft Excel functions throughout the course as opposed to using dedicated statistics software package. Excel and other spreadsheets will be the desktop software most widely available to MS 150 students both while taking the course and, more importantly, in the workplace post-graduation.
- Use of real-world data, examples, and problems to the extent appropriate and possible.
Assessment
Assessment will be via quizzes, tests, midterm examinations and a final examination. All core outcomes will appear on the final examination.
- Textbook: Understanding Basic Statistics, Second Edition, Brase and Brase, Houghton Mifflin, 2001
- Required course materials: In-class access to a computer with Microsoft Excel.
- Reference materials
- Microsoft Excel spreadsheet mathematical software by Microsoft.
- "Data Analysis with Microsoft Excel", Berk and Carey, Duxbury Press, 1998
- "Statistics: A First Course", 6th ed. by Freund and Simon, Prentice Hall, Inc.
1995 (ISBN 0-13-083024-0),
- "Elementary Statistics." 6th ed. by Johnson, PVVS-KENT Pub., 1992 (ISBN
0-534-92980-X)
- Instructional costs: None anticipated at this time
- Methods of Instruction: The course will be taught by lecture, class discussion, and the use of Microsoft Excel for problem solving and computer simulations. This course will be taught in the Math/Science computer classroom. Also, students will be encouraged to utilize the computer labs outside of class for homework assignments.
- Evaluation: Homework, tests, quizzes, a midterm, and a final exam will be given. A standard 90%=A, 80%=B, 70%=C, 60%=D Below 60%=F grading scale is recommended pending the outcome of futher discussion on the overall meaning of grading in a student learning outcome centered environment.
- Credit by examination: None
- Attendance policy: As per the current college catalog
Appendix A
Further reading and background on the structure of this outline:
http://shark.comfsm.fm/~dleeling/department/slorevolution.html
http://shark.comfsm.fm/~dleeling/department/slorevolution_ii.html
http://shark.comfsm.fm/~dleeling/department/slorevolution_iii.html
http://shark.comfsm.fm/~dleeling/department/dnsm_program_outcomes.html
http://shark.comfsm.fm/~dleeling/department/slorevolution_v.html
http://shark.comfsm.fm/~dleeling/department/slorevolution_vi.html
http://shark.comfsm.fm/~dleeling/department/systemwidecompetencies.html