MTH2502L                         EXCEL FOR STATISTICS                                  FALL, 2008

Professor:                            Eugen Radian,  Ph.D.

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

Office Hours:                       T 3:30-4:00 pm, W 3:00-3:30pm, 5:00-5:30pm, 9:30-10:00pm, 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:

• Facilitate concept understanding in Probability and Statistics through Excel based Stats procedures.  Provides support for MTH2502 Statistics.
• Develop familiarity with data analysis and interpretation by using Excel Stats procedures.
• Develop skills of using statistical modeling and analysis to solve real life / practical        problems.
• Develop familiarity with spreadsheets and Stats software.

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:

            Topic:                                                                          Reading (Lesson):

             Getting Started; Random Sampling                                1

             Organizing Data                                                                  2                                 

             Descriptive Measures                                                        3

             Probability Concepts                                                          4      

            The Normal Distribution                                                     6

             The Sampling Distribution of the Sample Mean                      7     

             Confidence Intervals for one Population Mean                        8

              Hypothesis Tests for one Population Mean                  9

              Inferences for two Population Means                            10

  Inferences for Population Proportions                          12       

             Chi-Square Procedures                                                    13 

              Regression and Correlation                                            14