| Alan B. Hale, Ph.D., Professor of Biology Office: Science Center 134 Email: abhale@cedarcrest.edu Telephone: 610-606-4666 x3510 Website: www.cedarcrest.edu/abhale Office Hours: weekly schedule or appt.; [Eastern Standard Time] Experience: Dr. Hale began teaching statistics courses in 1981 and has 38 years of research experience involving statistical analyses. A Welcome from Dr. Hale |
![]() |

| Week |
Content |
Activities/Assignments |
| 1 |
(1) Introduction of instructor and course (2) Effective use of tools within eCollege (3) Acquiring and installing XLSTAT-Pro (4) Research foci and goals of participants (5) Philosophy of science and the role of statistics (6) Clearly defining research questions, and if appropriate, statistical hypotheses and tests Week 1 Assignment |
Review the weekly assignment; ask for clarification if necessary. Watch videos, one for each of the Content topics: 1-3, 5, 6. Videos are within the Week 1 unit in the BIO 548 eCollege account. Submit sample document via eCollege to demonstrate proper access and use of eCollege. The document can be as simple as your name and your home institution. Purchase XLSTAT-Pro (annual student option or otherwise) (www.xlstat.com/en/prices.html) and install on your computer; use XLSTAT online video tutorials (www.xlstat.com/en/support/tutorials) to explain the process, if necessary. Access and familiarize yourself with the availability of XLSTAT manuals (access code is provided with XLSTAT license): www.xlstat.com/en/customers Begin contributing to the threaded discussion on the research foci and goals of the participants; the intent is to introduce participants and to promote collaboration and feedback throughout the course. Participants should feel free to ask for feedback on the research design and statistics associated with their current research, or to offer suggestions on how others might modify their approach. This discussion will continue throughout the 8-week course. Associations may develop beyond the course and continue after its completion. Begin posting questions on the FAQ threaded discussion; responses will help eliminate confusion on the part of one or more participants. Carefully read the syllabus and ask for clarification, if necessary. Please note that a Research Statement is due on the last day of class; see Grading Criteria and Percent Distribution (below) for more information. A detailed explanation can be found in the Week-8 unit within eCollege. Complete and submit Week 1 assignment by next Monday at 12:00 noon (Eastern Standard Time). |
| 2 |
Week 2 Assignment Data Management Within Microsoft Excel Tools* - XLSTAT-Pro Data Flagging Min/Max Search Removing Text Values Sheet Management Exporting to GIF/JPG/PNG/TIF Preparing Data - XLSTAT-Pro Data Sampling Distribution Sampling Variables Transformation Creating a Contingency Table Data Management Coding *Titles preceding "XLSTAT-Pro (e.g., Tools - XLSTAT-Pro) indicate the menu tab in which the subtitles (e.g., Data Flagging) reside. |
Assignment from previous week (Week 1) due Monday by 12:00 noon (EST). Review the Week 2 assignment; ask for clarification if necessary. View video illustrating the basics of data management within Excel. Recall that videos are in the appropriate units within eCollege, in this case, within Week 2. In general, each listed topic associated with XLSTAT-Pro has a separate video produced by the instructor that describes the tool/test, situations where it can be used, assumptions, if any, steps involved when employing the tool/test, and the interpretation of the output. Review these materials; request help if problems arise. On occasion, downloadable sample Excel data sets will be available for participants to use, especially when they are without appropriate data for a particular tool/test. These data sets will have informative filenames and will be available in Doc Sharing (see Tools: at top of eCollege window). Open Doc Sharing to see what is available. Continue to participate in the FAQ threaded discussion on problems faced while working with Excel, eCollege, XLSTAT-Pro or other aspects of the course. Participants should contribute questions, and also feedback to questions submitted by others if they have successfully conquered the noted hurdle. The professor will also be an active participant in this discussion. This interchange will become an ever-growing FAQ resource for current and future participants. Continue to participate in the Participant Research Foci and Goals threaded discussion. Complete and submit Week 2 assignment by next Monday at 12:00 noon (EST). |
| 3 |
Week 3 Assignment Visualizing Data - XLSTAT-Pro Scatterplots Parallel Coordinates Plots Error Bars Plotting a Function Adjusting Axes/Labels Orthonormal Plots Plotting Transformations Merging Plots Describing Data - XLSTAT-Pro Descriptive Statistics and Univariate Plots Quantiles Estimation Histograms Normality Tests Resampling Similarity/Dissimilarity Matrices Descriptive Statistics for Contingency Tables |
Assignment from previous week due Monday by 12:00 noon. (EST). Review the Week 3 assignment; ask for clarification if necessary. Review supporting materials (videos) as with Week 2, but for new topics. Again, never hesitate to ask for help if confusion arises. The FAQ threaded discussion is a good destination for your request. Otherwise, email Dr. Hale (abhale@cedarcrest.edu). Continue to contribute to the two threaded discussions: (1) FAQ and (2) Participant Research Foci and Goals. Complete and submit Week 3 assignment by next Monday at 12:00 noon (EST). |
| 4 |
Week 4 Assignment Parametric Tests - XLSTAT-Pro One-Sample t and z Tests Two-Sample t and z Tests Two-Sample Comparison of Variances k-Sample Comparison of Variances Multidimensional Tests (e.g., Mahalanobis) z-Test for One Proportion z-Test for Two Proportions Comparison of k Proportions Multinomial Goodness of Fit Test |
Assignment from previous week due Monday by 12:00 noon. (EST). Review the Week 4 assignment; ask for clarification if necessary. Review supporting materials (videos) as with previous week, but for new topics. Continue to contribute to the two threaded discussions: (1) FAQ and (2) Participant Research Foci and Goals. Complete and submit Week 4 assignment by next Monday at 12:00 noon (EST). |
| 5 |
Week 5 Assignment Nonparametric Tests - XLSTAT-Pro Comparison of Two Distributions (e.g., Kolmogorov-Smirnov) Comparison of Two Samples (e.g., Mann-Whitney) Comparison of k Samples (e.g., Kruskal-Wallis) Cochran's Q Test McNemar's Test Cochran-Mantel-Haenszel Test One-Sample Runs Test |
Assignment from previous week due Monday by 12:00 noon. (EST). Review the Week 5 assignment; ask for clarification if necessary. Review supporting materials (videos) as with previous week, but for new topics. Continue to contribute to the two threaded discussions: (1) FAQ and (2) Participant Research Foci and Goals. Complete and submit Week 5 assignment by next Monday at 12:00 noon (EST). |
| 6 |
Week 6 Assignment Modeling Data - XLSTAT-Pro Distribution Fitting and Statistical Testing Linear Regression Nonlinear Regression Logistic Regression Nonparametric Regression |
Assignment from previous week due Monday by 12:00 noon. (EST). Review the Week 6 assignment; ask for clarification if necessary. Review supporting materials (videos) as with previous week, but for new topics. Continue to contribute to the two threaded discussions: (1) FAQ and (2) Participant Research Foci and Goals. Complete and submit Week 6 assignment by next Monday at 12:00 noon (EST). |
| 7 |
Week 7 Assignment Modeling Data - XLSTAT-Pro ANOVA ANCOVA Correlation/Association Tests - XLSTAT-Pro Correlation Tests Tests on Contingency Tables Cochran-Armitage Trend Test Analyzing Data - XLSTAT-Pro Factor Analysis |
Assignment from previous week due Monday by 12:00 noon. (EST). Review the Week 7 assignment; ask for clarification if necessary. Review supporting materials (videos) as with previous week, but for new topics. Continue to contribute to the two threaded discussions: (1) FAQ and (2) Participant Research Foci and Goals. Complete and submit Week 7 assignment by next Monday at 12:00 noon (EST). |
| 8 |
Week 8 Assignment (due last day of class) Analyzing Data - XLSTAT-Pro Principal Component Analysis (PCA) Discriminant Analysis (DA) Course Wrap Up |
Assignment from previous week due Monday by 12:00 noon. (EST). Review the Week 8 assignment; ask for clarification if necessary. Review supporting materials (videos) as with previous week, but for new topics. Continue to contribute to the two threaded discussions: (1) FAQ and (2) Participant Research Foci and Goals. Complete and submit Week 8 assignment by 5:00 p.m. (EST) on the last day of class. Submit your Research Statement, i.e., the document that illustrates the design of your current/future research project, as described below in Grading Criteria. Recall that detailed guidelines for this statement are available in Week 8 within eCollege. Due: 5:00 p.m. (EST) on the last day of class. Best wishes, and never hesitate to stay in touch! |
Honor Code and Academic Standards of Integrity:
Students enrolled in BIO 548 are expected to abide by the Cedar
Crest
College Honor Code and the Academic Standards of Integrity, as
described in the
graduate catalog. Details are provided at: http://www.cedarcrest.edu/ca/catalog2011_2012/graduate/integrity_property.shtm#integrity
| ACTIVITY |
GRADING CRITERIA |
GRADING % |
| Threaded Discussions Research Foci & Goals: FAQ: |
continued participation; quality of entries (and feedback, if any) |
5% 5% |
| Statistical Tool/Test Assignments (Details of each assignment will be provided at the start of each week.) |
criteria depend upon specific assignment, but in general, they include: accurate statement of testable research question and hypotheses; proper usage/analysis of tool/test; correct interpretation of outcome; quality of written presentation |
75% [Week 1: 5%; Weeks 2-8: 10% each] |
| Research Statement |
clarity of research statement; quality of research design; choice of effective statistical tools/tests |
15% |
Grade Conversion:
| Conversion of Numerical Grades (%) to Letter Grades | ||||||||||
| A 93-100% |
A- 90-92.9% |
B+ 87-89.9% |
B 83-86.9% |
B- 80-82.9% |
C+ 77-79.9% |
C 73-76.9% |
C- 70-72.9% |
D+ 67-69.9% |
D 60-66.9% |
F < 60% |
| Pass/Fail: A grade of C or better is required for a passing grade in this graduate course. Grades will remain confidential and updated on eCollege throughout the 8-week session. |
||||||||||