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˛.

- 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 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

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