Fall Semester, 1999
 

Class Meetings:      T-Th 9:30-10:45,   Phillips 265
 

Class Waiting List:    Contact Ms. Lois M. Douglass
                                     Office:  New West 112
                                     Phone:  962-2307
                                     Email:   lmd@stat.unc.edu
 

Instructor: J.S. Marron, Professor
Email:  marron@stat.unc.edu
Office: New West 304
Phone:
      Office:  962-2188
      Home:  493-2844
      FAX:    962-1279

Office Hours:
       Always:  Thursday 11:00 - 12:30, 1:30-3:30
       Usually:  Monday  10:00 - 12:00, 1:30 - 3:30
                     Tuesday 1:30 - 3:00
        Possibly:   other times
 

Teaching Assistant:  Ms. Xiaohui Wang
Email:   xwang@email.unc.edu
Office:  Smith 105
Phone:  962-3992

Office Hours:
       Wednesday   1:00-5:00
 

Grading:    Based on:
    1.  Homework     10%
    2.   Midterm I      20%
    3.   Midterm II      20%
    4.  Final Exam (cumulative)  50%

Homework:  Assigned daily, collection for each week is due Thursday of the following week, at the beginning of class.  No late homework accepted, lowest two scores dropped.

Dates of examinations:
    Midterm I: Tuesday, September 21.
    Midterm II: Tuesday, November 9.
    Final:  Tuesday, Dec. 14,  8:00AM.
 

Textbooks:

      McClave, J. T., Benson, P. G. and Sincich, T. (1998) Statistics for Business and Economics, 7th edition, Prentice Hall.
            This is the main textbook.  It will be referred to as a source
            for Homework Exercises, and additional reading.

      Dummeldinger, M. (1998)  The Microsoft EXCEL Supplement for Statistics for Business and Economics, Prentice Hall.
            This provides help with the computational side of the course.
 

Approximate Ordering of Material

Chapter and Section Numbers from McClave, Benson and Sincich (1998) Statistics for Business and Economics, 7th Edition.
 

In the format:   Chapter.Section

1.1,   1.2,   1.3,   1.5,   1.6,   1.7

3.1,   3.2,   3.7,   3.3,   3.4,   3.5,   18.9,   3.6

4.1,   4.2,   4.4

2.2,   4.3,   2.4,   2.5,   2.6,   2.8

5.1,   5.3,   2.7,   5.4

6.1,   6.3

7.1,   7.2,   7.3,   7.4,   7.5

8.1,   8.2,   8.3,   8.4,   8.5

9.1,   9.2,   9.3,   18.6
 
 

Internet and Email access:

+  These are essential for this course.

+  Class ListServ:
      Name of the list:   Stat23-1
                   (caution:  you need to remember this when you get to the
                    ListServ page.  You must enter it on the third line of their
                    menu to get added to our list.  Note that there are 8 characters,
                    with no spaces, and the symbol after 3 is a "dash")
      To subscribe go here.
                  (class announcements and updates, such as canceled classes
                    and discovered errors on homework problems, will come
                    to you by email when you subscribe to this).
      To check that you are on, go here for a text file with the full list (last updated 9/2/99)

+  The data sets used in the text book are internet available:
      From the publisher:   http://www.prenhall.com/mcclave/statsbe/html/tsdata_index.html
      Locally at UNC (in Excel spreadsheet form):    http://www.unc.edu/depts/statistics/postscript/papers/marron/stat23/TextBookData
 

Computation:

+  Done with Microsoft EXCEL97.

+  You can use any computer of your choice, that has EXCEL, or use those available in the ATN Computer Labs, go here for lab locations and schedules.

+  EXCEL is "user friendly", so if you have experience using computers, you may be able to just start using EXCEL.

+  If there are some specifics about which you are wondering "how do I do that?", the first section of the Dummeldinger (1998) text above provides well organized access to a number of important topics.

+  If you don't have prior computing experience, then a careful reading of Section P, at the beginning of the Dummeldinger (1998) text is recommended.
 

Additional Tips on using Microsoft EXCEL97:

+  On many machines, including those in the ATN Labs, many of the statistical analysis tools we will use require loading the "Analysis ToolPak".

+  You can see if this available, by starting EXCEL, then clicking on "Tools" on the toolbar at the top.  If the Analysis ToolPak is loaded, your screen should look like:

If the last option, called "Data Analysis..." is there, then the Analysis ToolPak is loaded, and you can follow instructions as in the Dummeldinger textbook.

+  If the Analysis ToolPak is not loaded, you should be able to load it by going to the "Add-Ins..." Option on the above menu.  This will pull up a window that looks something like:

Click in the box for "Analysis ToolPak", so the screen looks like the above, and choose "OK".  Then "Data Analysis..." will show on the "Tools" menu as shown above.

+  If you always use the same machine, then you should only need to load the Analysis ToolPak once.  However, when you go to a different machine at the ATN Labs, it is likely that you will need to load it on that machine (at least at the beginning of the semester!).
 

Course Handouts and Graphics:

1.  Initial Handout (mostly about getting to the Internet): Microsoft Word Version      PDF Version

2.  Homework Assignment #1, due 8/26/99  (final):    Microsoft Word Version      PDF Version
          (Hint:  for suggestions on using EXCEL to generate "random" numbers, go here)

3.  Class Example 1, work out textbook problem 3.11, using Excel: Web version of example shown in class,     Excel spreadsheet itself.

4.  Homework Assignment #2, due 9/2/99  (final):    Microsoft Word Version      PDF Version

5.  Class Example 2, work out textbook problem 3.24, using Excel: Excel Spreadsheet.

6.  Homework Assignment #3, due 9/9/99  (final):    Microsoft Word Version      PDF Version

7.  Class Example 3, Binomial probabilities, using Excel: Web version of example shown in class,    Excel spreadsheet itself.

8.  Homework Assignment #4, due 9/16/99  (final):    Microsoft Word Version      PDF Version

9.  Correct data spreadsheet, for textbooks problem 3.42  The table published in the book had the row and column totals wrong.  For the Homework, please use the number in the body of the table, and compute row and column totals yourself.   Excel Spreadsheet

10.  Class Example 4, Bar graphs of counts, using Excel: Web version of example shown in class,     Excel spreadsheet itself.

11.  Class Example 5, Plots of Binomial Probabilities, using Excel: Excel Spreadsheet.

13.  Class Example 6, Histogram analysis of incomes data, using Excel: Web version of example shown in class, Excel spreadsheet itself.

14.  Solutions to even numbers (since odd numbers are in the Solution Book) forHomework Assignment #4:    Microsoft Word Version      PDF Version

15.  Practice Excel Problems, for the midterm.  These show you how I will formulate this type of problem.   Microsoft Word Version      PDF Version     Excel spreadsheet with answers.

16.  Midterm I:   Microsoft Word Version      PDF Version

17.  Solution to Midterm I (updated 9/23/99):   Microsoft Word Version      PDF Version

18.  Class Example 7, solution to text book problem 4.29a, expected value of a discrete distribution, using Excel: Excel Spreadsheet.

19.  Scores on Midterm I  Excel Spreadsheet.

20.  Homework Assignment #5, due 9/30/99  (final):    Microsoft Word Version      PDF Version

21.  Class Example 8, Example of median of Binomial Distribution, using Excel: Web version of example shown in class, Excel spreadsheet itself.

22.  Homework Assignment #6, due 10/7/99  (final):    Microsoft Word Version      PDF Version

23.  Notes for Excel Computer Demo, by TA, 10/1/99, 4:00, Room 212 New West.

24.  Class Example 9, Analysis of Male-Female data, from HW 1, using Excel: Excel Spreadsheet.

25.  Class Example 10, Numerical instability of Excel: Excel Spreadsheet.

26.  Web page with Jeff Simonoff's example about numerical instabilities of Excel:   http://www.stern.nyu.edu/~jsimonof/classes/1305/pdf/excelreg.pdf     Some additional nice Stat 23 related stuff from Simonoff:   http://www.stern.nyu.edu/~jsimonof/classes/1305/pdf/

27.  Homework Assignment #7, due 10/21/99  (final):    Microsoft Word Version      PDF Version

28.  Class Example 11, Calculation of Normal probabilities, using Excel: Web version of example shown in class, Excel spreadsheet itself.

29.  Class Example 12, Normal Approximation to Binomial: Excel Spreadsheet.

30.  Homework Assignment #8, due 10/28/99  (final):    Microsoft Word Version      PDF Version

31.  Class Example 13, Central Limit Theorem: Excel Spreadsheet.

32.  Homework Assignment #9, due 11/4/99  (final):    Microsoft Word Version      PDF Version

33.  Class Example 14, t distribution, and calculation of probabilities, using Excel: Web version of example shown in class, Excel spreadsheet itself.

34.  Class Example 15, solution to text book problem 7.26, expected value of a discrete distribution, using Excel: Excel Spreadsheet.

35.  Class Example 16, solution to text book problem 7.40, expected value of a discrete distribution, using Excel: Excel Spreadsheet.

36.  Practice Excel Problems, for the second midterm.  These show you how I will formulate this type of problem.   Microsoft Word Version      PDF Version     Excel spreadsheet with answers.

37.  Homework Assignment #10, due 11/11/99  (final):    Microsoft Word Version      PDF Version

38.  Class Example 17, Further analysis of Male-Female data, from HW 1, using Excel: Excel Spreadsheet.

39.  Class Example 18, solution to text book problem 7.62, expected value of a discrete distribution, using Excel: Excel Spreadsheet.

40.  Midterm II:   Microsoft Word Version      PDF Version

41.  Solution to Midterm II:   Microsoft Word Version      PDF Version

42.  Homework Assignment #11, due 11/18/99  (final):    Microsoft Word Version      PDF Version

43.  Example of bad normal random number generation by Excel: Excel Spreadsheet

44.  Class Example 19, solution to text book problem 7.62,  using Excel: Excel Spreadsheet.

45.  Homework Assignment #12, due 11/30/99  (final):    Microsoft Word Version      PDF Version

46.  Class Example 20, solution to text book problem 8.19,  using Excel: Excel Spreadsheet.

47.  Class Example 21, solution to text book problem 8.46,  using Excel: Excel Spreadsheet.

48.  Class Example 22: Excel Spreadsheet.

49.  Homework Assignment #13, due 12/2/99  (final):    Microsoft Word Version      PDF Version

50.  Class Example 23: Excel Spreadsheet.

51.  Homework Assignment #14, due 12/7/99  (optional):    Microsoft Word Version      PDF Version

52.  Analysis of Pepsi Challenge: Excel Spreadsheet.

53.  Final Exam:   Microsoft Word Version      PDF Version

54.  Solution to Final Exam:   Microsoft Word Version      PDF Version
 
 
 

Posting of Recorded Grades (final version, postted 12/15/99): Excel Spreadsheet
 
 

If you have suggestions for improving this page, please send email to marron@stat.unc.edu.
 
 

Back to Marron's Home Page