KINE 2049 Lecture Notes - Cohort Study, Mental Chronometry, Webct
17 Apr 2013
School
Department
Course
Professor
Document Summary
. one piece in the excel that has not been covered is the pivot tables. start with some data and what you would like to be able to do is use the. construct your pivot table by dragging the field buttons on the right to the diagram on the left. on the right hand side is the list for the field names example: id number, sec, year of st, faculty, gpa. drag any one of these icons and you put it in one of three places. points 1 & 2 indicate how you want to organize the data. location #3 is what are you going to analyze. under faculty and year of study is how you want to organize it gpa. the last thing is to decide what analysis you want to do. double click on the icon gpa and select average it changes it shows.
