Tools:
    Web site for PopTools Excel Add-In
    Kernel Density Estimation Excel Add-In: Add-in     Help file     User's manual
    Matrix add-in for Excel, via Leonardo Volpi -- Matrix.mla

Week 1
    Handout of formulae for the course - Handout with formulae.doc (Word)
    Tutorial on basic and matrix operations in Excel - Tutorial - Basic and matrix operations in Excel.xls (Excel)
    Read the primer on matrix operations at http://www.unc.edu/~swlt/metricsmatrix.pdf (PDF)
    Spreadsheet on random number generation and data distributions - Data distributions.xlsx (Excel 2013 - older versions cannot 'countifs')
    Spreadsheet on basics of variance, covariance, and correlation Variance, covariance, correlation.xls (Excel)
    Scratch sheet from class on covariance - Scratch sheet from class on covariance (Excel)
    Data and assignment on t-test - Data for t-test (one-sample, two sample, paired) (Excel)
    Instructor's t-test calculations - Instructor's worked t-test (one-sample, two sample, paired) (Excel)

Week 2
    Reading on WS Gosset - Boland (1986) (PDF)
    Scratch sheet from class on t-test - Scratch sheet from class on t-test.xlsx (Excel 2013 - older versions cannot 'countifs')
    Review questions - Week 2 Review questions (Word)
    Data for ANOVA homework/practice - Data for ANOVA (snake behavior, drosophila sex & lifespan) (Excel)
    Instructor's ANOVA assignment - Instructor's worked ANOVA (snake behavior, drosophila sex & lifespan) (Excel)
    Reading on RA Fisher - Rao (1992) (PDF)

Week 3
    Notes on items to know - Handout - Stats expectations.doc (Word)
    Mantras as of this week - Mantras handout (Word)
    Regression - Regression.xls (Excel)
    Permutation - Regression - with permutation.xls (Excel)

Week 4
    t-test by regression & multiple regression - t-test by regression & multiple regression (Excel)
    Multiple regression with confidence (intervals) - Multiple regression - with confidence intervals (Excel)
    Reading on assumptions in stat - Stat assumptions paper (PDF)
    Spreadsheet on data rotation - Data rotation (Excel)
    Example design matrix (Phylogenetic contrast) - Phylogenetic design matrix (Excel)

Week 5
    Tight MANOVA spreadsheet with permutation - Mosquitofish MANOVA with permutation (Excel)
    Data for hominin MANOVA - Hominin data for MANOVA assignment (Excel)

Week 6
    Multivariate GLM worksheet - Multivariate GLM with E, H, L and design matrices.xlsx (Excel 2013)
    Hominins worked as GLM & MANOVA. Replaces 'Week 6. MANOVA - Hominins.xls' - Instructor's hominin analysis worked as both MANOVA and GLM (Excel)
    Updated formulae - Formulae with multivariate equations (Word)
    10 steps handout Handout - 10 Step program for biometers(Word)

Week 7
    Schedule your practicum with the instructor
    Eigendecomposition tool for PCA and CA analyses - Eigenvalue&vector spreadsheet (Excel)
    Eigenvalue calculation (FYI) - Eigenvalue calculation spreadsheet (FYI only) (Excel)
    Otter analysis example - Canonical analysis of otter morphometrics (Excel 2013)

Week 8
    Hominins updated with analysis using Matrix.xla, not PopTools - Hominins - with CA analysis - DeWitt worked version.xls Hominins - with CA analysis - DeWitt worked version (Excel)
    PCA updated for Matrix.xla with additions of orthogonal decomp routine for nonsymmetric matrices, a PCA assignment, etc. - PCA with Caley-Hamilton decomposition - Papadopoulos & DeWitt (Excel)
    Wrath of Grapes statistical and analytical assignment - Wrath of Grapes exercise (Excel)
    Link to update "Week 6. Multivariate GLM - E, H, L and design matrices - DeWitt worked version.xlsx" (but not this update is in Excel 2003 format, so extension is now '.xls' not '.xlxs' - Update with Matrix.xla functionality (Excel)

Week 9
    Path analysis example - Path analysis - tadpoles - with permutation (Excel)
    Link options to tadpole path analysis publication: doi: 10.1111/j.1558-5646.2008.00343.x or PDF
    DFA and it's inverse - Multiple regression vs. DFA (Excel)
    Liberated DFA - DFA including quadratic exploration with otters.jmp (JMP)
    Liberated DFA borrowed lecture - DFA - quadratic v. linear great lecture file (PDF)

Week 10
    Worked 'Wrath of Grapes' - Wrath of Grapes - Instructor worked (Excel - change extension to .xls for Excel 2003)
    Worked PCA assignment - PCA with worked example (Excel - change extension to .xls for Excel 2003)
    lecture file (PDF)
    Community analysis - Community data by PCA, CoA, RDA/CCA (Excel - change extension to .xls for Excel 2003)

Week 11
    Instructor worked CCA - Update of CCA with homework worked (Excel - change extension to .xls for Excel 2003)
    2-block PLS - 2BPLS with cichlid data (Excel - change extension to .xls for Excel 2003)
    3-block PLS - 3BPLS algorithm (Excel)
    SVD demo - SVD as illustrated in class today (Excel)
        Nov 6 Lecture - Nov 6 Excel Biometry lecture part 1 (MP4)
        Nov 6 Lecture - Nov 6 Excel Biometry lecture part 2 (MP4)
        Nov 8 Lecture - Nov 8 Excel Biometry lecture part 1 (MP4)
        Nov 8 Lecture - Nov 8 Excel Biometry lecture part 2 (MP4)

Week 12
    Tuesday, 13 November
        3B-PLS, Markov Chain Monte Carlo -3B-PLS MCMC algorithm (Excel - change extension to .xls for Excel 2003)
    Thursday, 15 November
        Review and lab day - Review questions to examine individually before and collectively on Thursday (Word)

Week 13
    Tuesday, 20 November
        Kaylee -- "Sampling and population estimates"
        Bridget -- "Cluster analyses, esp. K-means"
    Thursday, 22 November
        Thanksgiving break -- class does not meet

Week 14
    Tuesday, 27 November
        Roy -- "Model selection and Aikaike's and Bayesian information criteria"
        Amanda -- "Phylogenetically independent contrasts"
    Thurday, 29 November
        Simon -- "Geospatial statistics"
        Capstone: Five approaches to statistics - Five approaches to analytics.xlsx (Excel)
    Worked versions of past homework assignments:
        Week 7. PCA with Caley-Hamilton decomposition - with worked microarray data.xlsx (Excel)
        Week 12. 3B-PLS MCMC algorithm - with SA2 extraction.xlsx (Excel)

Week 15
    Tuesday, 4 December
        Jasmine -- "Robust regression methods"
        Review of biplot ray interpretation (in PCA, multivariate regression, and CCA) - Week 15. CCA practice (Excel)
    Note: Now is the time to schedule your final practicum
    Thursday, 6 December
        Reading day -- class does not meet