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