Syllabus

MTH2502L                            EXCEL FOR STATISTICS                                    SPRING, 2009

Professor:                            Eugen Radian,  Ph.D.

Office:                                    SM 124,  (650) 508-3539, eradian@ndnu.edu

Office Hours

(Tentative Schedule):        T 3:30-4:30 pm, W 5:00-6:00, R 4:30-5:30 pm and by appointment

Required textbooks:         Ian Walters – Excel for Introductory Statistics, 8th Edition, by Neil Weiss.  Addison Wesley, 2008.

Prerequisites:                      Math Competency Level 2.

                                                MTH1214 or Math Competency Level 3 recommended

Corequisite:                         Concurrent enrollment In MTH2502 Statistics

Module Description:

Data analysis with Excel procedures for typical Statistics topics:

Descriptive statistics, measures of central tendency and dispersion, probability, random variables, sampling distributions, normal distribution, confidence intervals, hypothesis testing for simple and multiple samples, goodness-of-fit and independence tests, correlation and regression.

Topics are compatible with the MTH2502 Statistics list of subjects.

Course Objectives / Learning Outcomes:

• Students will demonstrate concept understanding in Probability and Statistics through Excel based Stats procedures.  This module provides support for MTH2502 Statistics.
• Students will demonstrate familiarity with data analysis and interpretation by using Excel Stats procedures.
• Students will gain skills of using statistical modeling and analysis to solve real life / practical and will demonstrate their skills by solving practical problems in Statistics.
• Students will develop familiarity with spreadsheets and Stats software and will demonstrate their familiarity through class work and homework for the Statistics course (MTH2502).

Assessment Methods:

Class Work, Practical Homework for Statistics MTH2502.

Procedures:

Class work is based on a hands-on self paced approach to Stats data analysis with Excel.

I will provide explanations and assistance as needed.  You will also use the text for guidance.

Technology/Software:    

You will use EXCEL in the PC Lab for statistical data analysis.  You should be enrolled in MTH2502 STATISTICS concurrently with taking this module.

NOTE:                      

Attendance is mandatory.  Missed classes may cause severe problems to your progress.

Grading:

Final grade is based on the average point grades for class work.

Letter grades will be assigned on the following basis:

A = 93-100,  A- = 89-92

B+ = 85-88,  B = 80-84, B- = 76-79

C+ = 72-75,  C = 67-71, C- = 63-66

D+ = 59-62,  D = 54-58, D- = 50-53

F = 0-49.

List of Topics: