Final Grades (posted 12/18/00):   Excel Spreadsheet.
 

Course Handouts and Graphics:
 

61.     Final Examination,    PDF version,
          Solution,                 PDF version.

60.  Final Exam Preparation:     Old Final Exam,    PDF version,
                                             Solution,            PDF version.

59. Class Example 32:  Analysis of "Student Choice of 1,2,3,4".

58. Class Example 31:  Analysis of "Pepsi Challenge".

57. Class Example 30:  Inference for Contingency tables, Text Book Problems 9.1-9.2.

56. 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 31 related stuff from Simonoff:  http://www.stern.nyu.edu/~jsimonof/classes/1305/pdf/

55. Class Example 29:  Numerical instability in Excel.

54. Class Example 28:  Inference for Regression, Text Book Problems 10.8-10.10.

53. Class Example 27:  Inference for Regression, Text Book Problem 10.6.

52.  Homework Assignment #15, due 12/7/2000  (final, posted 11/30/2000):  Microsoft Word Version      PDF Version

51. Class Example 26:  Inference using the Binomial distribution.

50.  Homework Assignment #14, due 11/30/2000  (final, posted 11/21/2000):  Microsoft Word Version      PDF Version

49. Class Example 25:  Using the t distribution for inference.

48.  Homework Assignment #13, due 11/28/2000  (final, updated 11/27/2000):  Microsoft Word Version      PDF Version

47. Class Example 24:  Simple t distribution calculations.

46.  Comparison of  t distribution to Normal, Movie.

45.  Midterm II:     Microsoft Word Version      PDF Version      Solutions:   Microsoft Word Version      PDF Version

44.  Midterm II Preparation:    Old Midterm 1, see problems 1, 2, 3, 4,
                                      Old Midterm 1 Solutions,
                                      Old Midterm 2, see problems 2, 3, 4, 5,
                                      Old Midterm 2 Solutions.

43.  Homework Assignment #12, due 11/16/2000  (final, posted 11/9/2000):  Microsoft Word Version      PDF Version

42. Class Example 23:  The 3 traps of Hypothesis Testing.

41. Class Example 22:  Simple Hypothesis Testing Examples.

40.  Solution to textbook's problem 4.85 (in HW 7)  Microsoft Word Version      PDF Version

39.  Homework Assignment #11, due 11/9/2000  (final, updated 11/3/2000):  Microsoft Word Version      PDF Version

38. Class Example 21:  Interpretation of Confidence Intervals, Applied to Male Female Data.

37. Class Example 20:  Simple Confidence Interval Calculations.

36. Class Example 19:  Central Limit Theorem.

35.  Homework Assignment #10, due 11/2/2000  (final, posted 10/26/2000):  Microsoft Word Version      PDF Version

34. Class Example 18:  Binomial Probability Histograms.

33. Class Example 17:  Calculating Binomial Probabilities.

32.  Homework Assignment #9, due 10/26/2000  (final, revised 10/23/2000):  Microsoft Word Version      PDF Version

31.  Homework Assignment #8, due 10/19/2000  (final, posted 10/12/2000):  Microsoft Word Version      PDF Version

30.  Homework Assignment #7, due 10/12/2000  (final, posted 10/3/2000):  Microsoft Word Version      PDF Version

29.  Homework Assignment #6, due 10/10/2000  (final, posted 9/28/2000):  Microsoft Word Version      PDF Version

28. Class Example 16:  Analysis of "Males at UNC" data, showing variability and bias issuses.

27.  Midterm I:     Microsoft Word Version      PDF Version      Solutions:   Microsoft Word Version      PDF Version

26.  Midterm I Practice Problem Solutions (posted 9/24/2000) Excel Worksheet

25.  Midterm I Practice Problems (posted 9/19/2000)  Microsoft Word Version      PDF Version

24.  Board Problem 7:     Microsoft Word Version      PDF Version

23.  Homework Assignment #5, due 9/28/2000  (final, posted 9/21/2000):  Microsoft Word Version      PDF Version

22. Class Example 15:  Using Excel for randomization.

21.  Homework Assignment #4, due 9/21/2000  (final, updated 9/19/2000):  Microsoft Word Version      PDF Version

20.  Class Example 14:  Toy example illustrating linear regression.

19.  Class Example 13:  Simulated example illustrating Correlation.

18.  Class Example 12:  Bralower's Fossil data, showing non-linear relationship.

17.  Class Example 11:  Excel scatterplots, exploring relation between variables, Exam and HW scores.

16.  Homework Assignment #3, due 9/14/2000  (final, updated 9/8/2000):  Microsoft Word Version      PDF Version

15.  Class Example 10:  Excel calculation of Areas under the Normal Curve.

14.  Class Example 9:  Melbourne daily maximum temperatures, Finished Example, studying Normal Curve fit to data.

13.  Class Example 8:  Hidalgo stamp thickness data (same as example 3), Movie with idealized curve.

12.  Homework Assignment #2, due 9/7/2000  (final, posted 9/1/2000):  Microsoft Word Version      PDF Version

11.  Class Example 7:  Raw Data, Buffalo Annual Snowfalls,  Finished Example, studying standardization.

10.  Class Example 6:  Raw Data, Hidalgo stamp thicknesses,  Finished Example, showing numerical summaries of populations.

9.  Homework Assignment #1, due 8/31/2000  (final, updated 8/29/2000):  Microsoft Word Version      PDF Version

8.  Class Example 5:  Raw Data, monthly airline passengers,  Finished Example, showing time plot.

7.  Class Example 4:  Finished Example, showing comparison of 2 populations with histograms.

6.  Class Example 3:  Hidalgo stamp thickness data, Movie about bin width, Movie about bin location.

5.  Class Example 2:  Raw Data, Buffalo Annual Snowfalls,  Finished Example, showing histograms and different binwidths.

4.  Class Example 1:  Raw Data, from Textbook Problem 1.14,  Finished Example, showing a bar graph.

3.  Data Set for HW B3:  EXCEL Spreadsheet.

2.  Data Set for HW B2:  ASCII file.

1.  Initial Handouts (mostly about getting to the Internet & Student Questionnaire): Microsoft Word Version      PDF Version
 

Fall Semester, 2000
 

Class Meetings:      T-Th 2:00-3:15,   Murphey 111
 

Class Waiting List:    Contact Ms. Mary Hinrichs
                                     Office:  New West 113
                                     Phone:  962-2307
                                     Email:   mhinrich@email.unc.edu

          Caution:  you must have a form on file with her, to be considered "on the waiting list".
 

Instructor: J.S. Marron, Professor
Email:  marron@stat.unc.edu    (checked regularly, preferred for most questions about HW)
Office: New West 304
Phone:
      Office:  962-2188
      Home:  493-2844
      FAX:    962-1279

Office Hours:
       "Always":  Monday 1:30-3:00, Tuesday 3:30 - 5:00
       Usually:  Monday  10:00 - 12:00
                     Tuesday 10:00 - 12:00
                     Wednesday  1:30 - 3:30
        Possibly:   other times
 

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.    Notes:   Readability is your responsibility. Highlight your numerical answer.  Never turn in more than one page per problem (or you will earn no credit for that problem).  In EXCEL, highlighting a block, and doing "Alt, File, Print, Print What: Selection", makes this straighforward.

Dates of examinations:
    Midterm I: Tuesday, September 26.
    Midterm II: Tuesday, November 14.
    Final:  Saturday, Dec. 16,  4:00PM.
 

Textbooks:

      Moore, D. S. and McCabe, G. P. (1999) Introduction to the Practice of Statistics, 3rd edition, W. H. Freeman.
                This is the main textbook.  Well written (much better than most of it's type).
                Suggested approach to course:  listen to what happens in class, do HW
                     promptly, and if you feel yourself falling behind, then catch up using text book.

      Hoppe, F. M. (2000) Excel Manual for Moore and McCabe's Introduction to the Practice of Statistics, W. H. Freeman.
                This gives useful introductory material for the use of Microsoft Excel.
 

Syllabus:     (parts of Moore and McCabe likely will be covered)

Chapter:         Sections:
    1                  1, 2, 3
    2        1, 2, 3, 4, 6, 7

End of material for Midterm I

    3        1, 2, 3, 4
    4        1, 2, 3, 4, 5
    5                  1, 2
    6                  1, 2, 3, 4
    7                  1
    8                  1
    9                  1, 2
   10                 1
 

Internet and Email access:

+  Access to this web page is essential for this course.  Many important things, such as HW assignments will be posted here.

+  Class ListServ.  This is an essential device for staying on top of course announcements (e.g. cancelled classes, discovered errors on HW problems, changes made to the web page, etc.).  It is also a forum for many useful tips on HW problems (selected answers to student's questions will be broadcast this way).
    Pre-enrolled class members have been already subscribed to the list, and don't need to take further action (unless you want to unsubscribe).
    If you are not subscribed, but want to join, go to the URL: http://listserv.unc.edu/cgi-bin/lyris.pl?join=stat31-3.
    If you want to make some changes in your subscription (e.g. to unsubscribe), go to the URL: http://listserv.unc.edu/cgi-bin/lyris.pl?enter=Stat31-3.
 

Computation:

+  "A tool, not an end in itself".  Intended to "facilitate thought, not replace it".

+  Never done in class, even for exams (so don't bring a laptop computer).

+  Done with Microsoft EXCEL.

+  You can use any computer of your choice, that has EXCEL (e.g. a CCI laptop), or use those available in the ATN Computer Labs, go to the URL: http://help.unc.edu/labs/ 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.

+  The Statistics Department has developed a good quality EXCEL "Primer" (web based introduction), that can be found at the URL: http://www.stat.unc.edu/teach/rosu/Stat31/Companion.html.  If you have never used EXCEL it is strongly recommended that you work through this (even if you have some experience it may be worth a look to be sure you are up to speed on what we are doing with it).

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

+  If you have no prior computing experience, then a careful reading of that same Chapter I, at the beginning of the Hoppe (2000) text may be useful..

+  General rules for when you encounter a problem:

        1.    "Just try something"
        2.    Ask a friend, or somebody hanging around.
        3.    Seek "more official" help.

+  Caution:  Numerical answers to HW problems will be given.  Avoid the trap of "just twiddling EXCEL until you get the right number" (because you can't do that on the exam).
 

Access to data for homework problems:

A lot of "busy work retyping", can be avoided by "importing data".  For the text book problems, almost all data sets are available on the CDrom that came with the text.  To use these in EXCEL, the following is recommended:

1.  Start Microsoft EXCEL.  For example, you can do this from Windows via:    Start  -->  Programs  -->   Microsoft Excel.

2.  Within Microsoft EXCEL, get to the "Open file" menu, e.g. by   File   -->  Open.

3.  Manipulate the buttons to move around the directory structure, until you can find the needed file.  A good first step is to change the "Files of Type" field to "All Files (*.*)".  Then manipluate the buttons so that you follow a path something like:  d:   -->  Extras   -->   Data Sets   -->    (appropriate chapter)

4.  Highlight the file that you want, and click "Open".  This starts the "Text Import Wizard".

5.  How the Text Import Wizard works varies from file to file, so you need to do some trial and error.  The first thing to try is to just hit the "Next" button at each step.  If that works, you are in business.

6.  Continually hitting "Next" fails if the data don't appear in the right place, or if you get something strange like two columns of data all apearing in single cells.  If that happens, repeat the process, but htis time try different possibilities for "Delimited" versus "Fixed Width", and for "Tab delimiters" vs. "Space delimiters".
 

Some things to avoid:  (i.e. some common mistakes).

A.  You don't need to "load the software", that is actually the main component of the disk.  You may do this if you choose, but it is not required to get at the data, which is all we will need.  If you have accidentally done this, you may want to "uninstall" it, using something like:  Start   -->  Settings   -->   Control Panel   -->   Add/Remove Programs.

B.  Do not try to access the file using only "My computer" or "Windows Explorer".  If you do this,your computer will not know that you want to use Excel on it, so it won't get piped into a spreadsheet.
 

If you don't have the CD rom:   Some students bought a used book, or for some other don't have the CD rom.  For such people, I have put a copy of the data sets here.
 

Additional Sources of Help:

1.  Open Tuturial sessions:

    Place:    New West 212
    Times:        Mon-Tue-Wed-Thu-Fri:           7:00PM - 9:00PM
                      Sat-Sun                                    2:00PM - 4:00PM  &  7:00PM - 9:00PM
                      (exceptions:  when the University is closed,
                           e.g. Labor Day, Mon, Sep. 4
                                 Fall Break, Wed, Oct. 4 - Sun, Oct. 8
                                 Thanksgiving, Wed, Nov. 22 - Sum. Nov. 26)
 

2.  Instructional Assistants:            E-mail:          Office:       Telephone:
  Mr. John Fricks                          fricks@email.unc.edu         Smith108             962-3992
  Ms. Rima Izem                           rizem@email.unc.edu         Smith 101            962-1488
  Mr. Beom Lee                           bslee@email.unc.edu          Smith 105            962-3992
  Mr. Faheem Mitha                     faheem@email.unc.edu       Smith 103-C        962-7513
  Ms. Xiaohui Wang                     xwang@email.unc.edu        Smith 105            962-3992
 

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!).
 

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

Back to Marron's Home Page