Lecturer: Dr. Erin M. Buchanan
Missouri State University
Summer 2018
The second in our series of Excel for Data Science series. This video covers how to calculate the mean, standard deviation, and sum using functions, as well as vlookup for combining data. Additionally, I show you how to filter data, use relative versus fixed references, and pivot tables, which are a great supplement to the data analysis pack.
Lecture materials and assignments available at statisticsofdoom.com.
https://statisticsofdoom.com/page/bas...