College of Micronesia-FSM
MS 150 Statistics
This outline is under redevelopment. This document includes multiple presentations and comments which will eventually be removed from the final document.
Course Description: This is a semester course designed as an introduction to the basic ideas of data presentation, descriptive statistics, basic probability, and inferential statistics. 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
Strictly Mapped Format
- Program Outcomes
Students will be able to:
-
define
arithmetic, algebraic, geometric, spatial, and statistical
concepts
-
calculate
arithmetic, algebraic, geometric, spatial, and statistical
quantities
using appropriate technology.
-
estimate
arithmetic, algebraic, geometric, spatial, and statistical
solutions
-
solve
arithmetic, algebraic, geometric, spatial, and statistical
expressions, equations, functions, and problems
using appropriate technology.
-
represent
mathematical
information
numerically, symbolically, graphically, verbally, and visually
using appropriate technology.
-
develop
mathematical and statistical
models such as formulas, functions, graphs, tables, and schematics
using appropriate technology.
-
interpret
mathematical and statistical
models such as formulas, functions, graphs, tables, and schematics,
drawing conclusions and making inferences based on those models.
-
explore
mathematical
systems
utilizing rich experiences that encourage
independent, nontrivial, constructive exploration in mathematics.
-
communicate
mathematical
thoughts and ideas
clearly and concisely to others in the oral and written form.
- Course Outcomes
Students will be able to:
- define statistical concepts
- [Core] Identify the shape of a distribution as being symmetrical,
uniform, bimodal, skewed right, skewed left, or normally symmetric.
- [Peri] Distinguish between a population and a sample
- [Peri] Distinguish between a statistic and a parameter
- [Peri] Identify by characteristics normal curves from a set of normal and
non-normal graphs of lines.
- [Peri] Identify different levels of measurement when presented with nominal,
ordinal, interval, and ratio data.
- [Core] Identify the sign of a least squares line: positive, negative, or zero.
- calculate statistical quantities using appropriate technology.
Given one variable data and the use of a calculator
or spreadsheet software on a computer
- [Core] Determine a sample size
- [Core] Determine a sample minimum
- [Core] Determine a sample maximum
- [Core] Calculate a sample range
- [Core] Determine a sample mode
- [Core] Determine a sample median
- [Core] Calculate a sample mean
- [Core] Calculate a sample standard deviation
- [Core] Calculate a sample coefficient of variation
- [Core] Calculate a class width given a number of desired classes
- [Core] Determine class upper limits based on the sample minimum and class width
- [Core] Calculate the frequencies
- [Core] Calculate the relative frequencies (probabilities)
- [Core] Determine a point estimate for the population mean based on the
sample mean
- [Core] Calculate a t-critical value from a confidence level and the sample
size
- [Core] Calculate an error tolerance from a t-critical, a sample standard
deviation, and a sample size.
- [Core] 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.
Given two variable data and the use of
spreadsheet software on a computer
- [Core] Calculate the slope of the least squares line.
- [Core] Calculate the intercept of the least squares line.
- [Core] Calculate the correlation coefficient r.
- [Core] Calculate the coefficient of determination r˛.
- estimate statistical solutions
Given one variable data and the use of spreadsheet software on a computer
- [Peri] 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 statistical problems using appropriate technology.
Given one variable data and the use of spreadsheet software on a computer
- [Core] 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.
Given two variable data and the use of
spreadsheet software on a computer
- [Core] Solve for a y value given an x value and the slope and intercept
of a least squares line.
- [Core] Solve for a x value given an y value and the slope and intercept
of a least squares line.
- represent mathematical information numerically, symbolically,
graphically, verbally, and visually using appropriate technology.
Given one variable data and the use of
spreadsheet software on a computer
- [Peri] create a frequency histogram based on calculated class widths and frequencies
- [Core] create a relative frequency histogram based on calculated class widths and frequencies
- develop mathematical and statistical models such as formulas, functions, graphs, tables, and schematics using appropriate technology.
- Discover the normal curve through a course-wide effort involving tossing seven pennies and generating a histogram from the in-class experiment.
- interpret statistical models such as formulas,
functions, graphs, tables, and schematics, drawing conclusions and
making inferences based on those models.
Given one variable data and the use of spreadsheet software on a computer
- [Core] 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.
- [Peri] Infer from a p-value the largest confidence interval for which a change
is not significant.
Given two variable data and the use of
spreadsheet software on a computer
- [Core] Use a correlation coefficient r to render a judgment as to
whether a correlation is perfect, high, moderate, low, or none.
- explore mathematical systems utilizing rich experiences that encourage
independent, nontrivial, constructive exploration in mathematics.
- communicate mathematical thoughts and ideas
clearly and concisely to others in the oral and written form.
Instructor 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.
Notes
[Core] outcomes are tested on the cumulative final examination and preceding quizzes, tests, and midterm examinations. Students must successfully achieve core outcomes in order to pass the class.
[Peri] outcomes are tested during the course and may appear on the final. Their achievement is used to distinguish levels of skill above a minimal pass.
Note that the course has modified the program outcomes to those sectors
pertinent to the course in the course outcomes.
In the final outline the last two program outcomes would be deleted as no course outcome meets those program outcomes. These two program outcomes have been left in this outline for informational purposes. This is one of
the first outlines in the division to be rewritten in this format.
The complication is that the resulting outline is difficult to read: the material is not in topical order nor in any form of chronological order. One cannot at a glance see all of the outcomes related to a particular topic. The result is a choppy and disorganized document that says more about particular program skills attained than the actual coverage of the course.
Topical with reference mapping
- Program Outcomes
Students will be able to:
-
define
arithmetic, algebraic, geometric, spatial, and statistical
concepts
-
calculate
arithmetic, algebraic, geometric, spatial, and statistical
quantities
using appropriate technology.
-
estimate
arithmetic, algebraic, geometric, spatial, and statistical
solutions
-
solve
arithmetic, algebraic, geometric, spatial, and statistical
expressions, equations, functions, and problems
using appropriate technology.
-
represent
mathematical
information
numerically, symbolically, graphically, verbally, and visually
using appropriate technology.
-
develop
mathematical and statistical
models such as formulas, functions, graphs, tables, and schematics
using appropriate technology.
-
interpret
mathematical and statistical
models such as formulas, functions, graphs, tables, and schematics,
drawing conclusions and making inferences based on those models.
-
explore
mathematical
systems
utilizing rich experiences that encourage
independent, nontrivial, constructive exploration in mathematics.
-
communicate
mathematical
thoughts and ideas
clearly and concisely to others in the oral and written form.
- Course Outcomes
Students will be able to:
Given one variable data and the use of a calculator
or spreadsheet software on a computer
Basic Statistics
- [Peri] Distinguish between a population and a sample (Define)
- [Peri] Distinguish between a statistic and a parameter (Define)
- [Peri] Identify different levels of measurement when presented with nominal,
ordinal, interval, and ratio data. (Define)
- [Core] Determine a sample size (calculate)
- [Core] Determine a sample minimum (calculate)
- [Core] Determine a sample maximum (calculate)
- [Core] Calculate a sample range (calculate)
- [Core] Determine a sample mode (calculate)
- [Core] Determine a sample median (calculate)
- [Core] Calculate a sample mean (calculate)
- [Core] Calculate a sample standard deviation (calculate)
- [Core] Calculate a sample coefficient of variation (calculate)
Histograms
- [Core] Calculate a class width given a number of desired classes (calculate)
- [Core] Determine class upper limits based on the sample minimum and class width (calculate)
- [Core] Calculate the frequencies (calculate)
- [Core] Calculate the relative frequencies (probabilities) (calculate)
- [Peri] create a frequency histogram based on calculated class widths and frequencies (represent)
- [Core] create a relative frequency histogram based on calculated class
widths and frequencies (represent)
- [Core] Identify the shape of a distribution as being symmetrical,
uniform, bimodal, skewed right, skewed left, or normally symmetric. (Define)
- [Peri] 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. (estimate)
Normal Curves and Confidence Intervals
- Discover the normal curve through a course-wide effort involving
tossing seven pennies and generating a histogram from the in-class
experiment. (develop)
- [Peri] Identify by characteristics normal curves from a set of normal and
non-normal graphs of lines. (Define)
- [Core] Determine a point estimate for the population mean based on the
sample mean (calculate)
- [Core] Calculate a t-critical value from a confidence level and the sample
size (calculate)
- [Core] Calculate an error tolerance from a t-critical, a sample standard
deviation, and a sample size. (calculate)
- [Core] 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. (solve)
- [Core] 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. (interpret)
P-Values
- [Core] 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. (calculate)
- [Peri] Infer from a p-value the largest confidence interval for which a change
is not significant. (interpret)
- [Core] 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. (interpret)
- [Peri] Infer from a p-value the largest confidence interval for which a change
is not significant. (interpret)
Given two variable data and the use of
spreadsheet software on a computer
Linear Regressions
- [Core] Identify the sign of a least squares line: positive, negative, or zero. (Define)
- [Core] Calculate the slope of the least squares line. (calculate)
- [Core] Calculate the intercept of the least squares line. (calculate)
- [Core] Solve for a y value given an x value and the slope and intercept
of a least squares line. (solve)
- [Core] Solve for a x value given an y value and the slope and intercept
of a least squares line. (solve)
- [Core] Calculate the correlation coefficient r. (calculate)
- [Core] Use a correlation coefficient r to render a judgment as to
whether a correlation is perfect, high, moderate, low, or none. (interpret)
- [Core] Calculate the coefficient of determination r˛. (calculate)
Instructor 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.
Notes
[Core] outcomes are tested on the cumulative final examination and preceding quizzes, tests, and midterm examinations. Students must successfully achieve core outcomes in order to pass the class.
[Peri] outcomes are tested during the course and may appear on the final. Their achievement is used to distinguish levels of skill above a minimal pass.
In this second format the mapping is achieved by the reference in parentheses at
the end of each outcome. This format makes it easier to see the flow and run of the
course. The strictly mapped outline requires a good deal of decoding and
rearranging before an instructor would know what to teach. The topical format
says "start here" and "end here."
The topical format can also be used, at the instructor's option,
chronologically.
In the original outline, included at the end of this document, the outline
included a topic outline section under roman numeral II. One might argue that
the strictly mapped format could have this added in order to clarify the scope
and sequence of the course. I would argue strenuously against this option. This
would defeat the underlying intent of the course outcomes and be horribly
redundant.
The course outcomes are intended to be a complete list of the skills
a student must master to pass a course. The topic outline would suggest that
the topic outline has something to do with what will be taught, but that is
the fundamental reason of existence of the specific student learning outcomes.
In fact, the topic outline will simply have to repeat each and every course outcome
skill or it will be less complete than the contents in the course outcomes.
Which leads to my second objection: done properly the topic outline becomes
completely redundant.
Original and currently approved outline
- Course Objectives
- General
- Six main topics data, descriptive statistics, basic probability, probability
distributions, confidence intervals, and hypothesis testing will be covered.
- A conceptual understanding of concepts, as well as the ability to apply them toward
solving statistical problems with the aid of MS Excel
- The underlining theorems: The Law of Large Numbers and The Central Limit Theorem, will
be presented from an experimental as well as a conceptual approach.
- Specific
Note: all specific objectives are set with the following two behavioral objectives: the
student will demonstrate a proficiency level of at least 70% in
1) computer assisted homework assignments emphasizing applications and a synthesis of
various concepts given within one week following the presentation of material, and during
2) the quizzes, tests, mid-term and final exam
- the student will be able to classify data as qualitative or quantitative, and cite
examples of each
- the student will be able to select appropriate class intervals and create a frequency
distribution for a data set
- the student will be able to use MS Excel to create a histogram, a cumulative frequency
polygon, and percent pie charts for a data set, and will be able to modify these charts
- the student will be able to find information from a chart, and determine if a chart is
misleading
- the student will understand the difference between a population and a sample, and
between a parameter and a statistic
- the student will understand the various measures of central tendency, including the
mean, median, and mode, and be able to select the most useful for a given data set
- the student will be able to calculate the mean, weighted mean, median, and mode of a
data, both by hand and by using MS Excel
- the student will understand the concept behind standard deviation, and how the formula
works, as well as be able to calculate the standard deviation for a data set by hand and
using MS Excel
- the student will be familiar with other measures such as skew and kurtosis, and know how
to find them using MS Excel
- the student will be able to use the definition of simple probability to find the
probability of various events
- the student will understand the reasoning behind the Law of Large Numbers, and know how
it is applied to situation such as a casino
- the student will be able to use MS Excel to simulate simple events such as flipping a
coin or rolling a die, and will be able to verify the Law of Large Numbers
- the student will be able to apply the concepts of permutations and combination towards
solving problems that involve counting
- the student will be able to determine if events are mutually exclusive, and apply the
appropriate addition rule
- the student will be able to determine if two events are independent, both conceptually
and by using the multiplication rule
- the student will be able to find marginal and conditional probabilities, and understand
the connection with independence
- the student will understand the properties that determine a probability distribution,
it's graph and function, and its mean and standard deviation
- the student will understand the properties that determine a Binomial distribution, and
will be able to draw its graph and solve problems involving Binomial distributions using
MS Excel
- the student will understand the difference between a discrete and a continuous
distribution, and the concept of a continuity correction
- the student will be familiar with the Normal distribution as determined by its mean and
standard deviation, and be able to apply it to problems using MS Excel
- the student will understand the concepts behind a sampling distribution, and how the
Central Limit Theorem works
- the student will understand the relationship between a point estimate and a confidence
interval
- the student will be able to calculate confidence intervals for a population proportion
- the student will be able to calculate confidence intervals based on small samples using
MS Excel
- the student will be able to use a confidence interval as a one- sample hypothesis test
- the student will understand the concepts involved in hypothesis testing, including types
of error, and the relationship between hypothesis tests and confidence intervals
- the student will be able to use MS Excel to conduct one-sample Z tests both with and
without raw data.
- the student will be able to conduct paired t-test using MS Excel
- the student will be able to test equality of two sample variances using an F-test on MS
Excel
- the student will be able to chose the appropriate two sample t-test, and conduct it
using MS Excel
- the student will be able to conduct a two-sample Z test, both for means and for
population proportions
- the student, working in a small group, will be able to design, conduct, and analyze a
simple statistical research project
- Course Contents
- Data, Types of data: Qualitative versus Quantitative
- Frequency Distributions: Standard, Cumulative, and Percent Histograms
- Cumulative Frequency Polygons
- Percent Pie Charts
- Descriptive Statistics
- Population versus Sample/ Parameter versus Statistic
- Measures of Central Tendency: Mean, Median, Mode
- Measures of Variation: Standard Deviation, Percentiles
- Other Measures: Skew and Kurtosis
- Basic Probability
- Simple Probability and the Law of Large Numbers
- Counting: Permutations and Combinations
- Basic Rules: Complements
- Sample Space
- Basic Rules: Addition Rules
- Basic Rules: Multiplication and Independent Events
- Conditional Probability
- Probability Distributions
- Basic Properties
- Mean and Standard Deviation of a Probability Distribution
- Binomial Distribution
- The Normal Distribution
- Sampling Distributions and the Central Limit Theorem
- Confidence Intervals
- Point Estimates versus Confidence Intervals
- Confidence Intervals for Population Proportions
- Confidence Intervals for small sample size / t-Distributions
- Using Confidence Intervals as a One-sample Test
- Hypothesis Testing
- Basic concepts/ Types of error
- One sample Z test for means, with and without raw data
- Paired t test for means
- F test for equal variance
- 2 sample t tests for means
- 2 sample z-tests for means
- Z-test for comparison of two proportions
- Textbook "Understanding Basic Statistics", Brase and Brase, Houghton Mifflin,
1997
- Required course materials: Scientific calculator
- 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. Thus, 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 50%=F grading scale is recommended. In the last month
of the course, the students will work in groups of 1 to 3 on a project involving
collecting and analyzing data from their own research design.
- Credit by examination: None
- Attendance policy: as per the current college catalog