Reading on WS Gosset - Boland (1986) (PDF) Instructor's t-test calculations - Instructor's worked t-test (one-sample, two sample, paired) (Excel) Scratch sheet from class on covariance - Scratch sheet from class on covariance (Excel)ĭata and assignment on t-test - Data for t-test (one-sample, two sample, paired) (Excel) Spreadsheet on basics of variance, covariance, and correlation Variance, covariance, correlation.xls (Excel) Spreadsheet on random number generation and data distributions - Data distributions.xlsx ( Excel 2013 - older versions cannot 'countifs') Read the primer on matrix operations at (PDF) Tutorial on basic and matrix operations in Excel - Tutorial - Basic and matrix operations in Excel.xls (Excel) Handout of formulae for the course - Handout with formulae.doc (Word) Matrix add-in for Excel, via Leonardo Volpi - Matrix.mla Kernel Density Estimation Excel Add-In: Add-in Help file User's manual Students end up with a portfolio of spreadsheets for most major methods in biometry.Įxcel Biometry Syllabus (27 August 2018) (Word) Students pick topics and serve as moderator for two or three discussions. We will construct spreadsheets and analyze a common dataset each week. The goal is to learn the rationale and mathemetics behind upper level biometrical methods. This course centers on learning biometry through weekly practice and experimentation. Department of Wildlife & Fisheries Sciencesĭepartment of Plant Pathology & MicrobiologyĢ14 WFES (Wildlife, Fisheries and Ecosystem Science Building) Overview:

Multiple regression excel 2013