Full course description

Course Description:

This workshop examines Excel as a research tool, and applies various functions and analysis add-ins to a sample data-set.  Specific topics include: using common research functions (mean, median, mode), truncating and rounding numbers, unit conversions, standard deviation, separating populations into tertiles and quartiles, conditionals (if), correlation coefficients and statistical significance.    

Prerequisites: Participants should have a working knowledge of Excel and be able to write basic formulas; please note that due to the short duration of this workshop, we will not be covering the concepts or mathematics, and will just be focusing on Excel functions, thus a working understanding of the topics will be helpful. (For example, we will cover methods of calculating standard deviation, but will not explain what standard deviation measures.  This knowledge will be assumed.)

Date/Time: Oct.24, 2:30-4:30 PM

Location: Information Technology Center, room ITC171

Instructor: Alec Muthig, UWIT Training

Important Information:

  • Send questions regarding this course to computer.training@uwyo.edu
  • Please make sure to arrive at least 5 minutes before the class is scheduled to begin.
  • If you are not on campus and would like to attend this course remotely via Zoom, please email a request to computer.training@uwyo.edu at least 24-hours before the listed start time.  Remote course attendance is not available for all workshops, and may have specific requirements.
  • Workshop fees are non-refundable (unless the class is cancelled by UWIT Training).