Lab 2 - Frequency Distribution and Histograms

Comic of the Day

Tip: Always label your axes.

Warmup
Fill in the blanks with the words FUNCTION or FORMULA
A __________ uses mathematical operators to calculate a value
A __________ is built in and has a specific syntax for its inputs
An example of a __________ is "=SUM(A1:A5)"
An example of a __________ is "=A1+A2+A3+A4+A5"
Avoid "=SUM(A1+A2+A3+A4+A5)"

Deadlines & Announcements
Lab 1 Mobius questions due Fri Jan 24
Production Assignment 1 due Sun Feb 2 (will need to submit draft to WriteOn several days in advance)
Chapter 1&2 assignments (Moodle) due Mon Feb 3
Watch your rounding for the assignments.  Keep extra decimals for intermediate answers, then round your final answer only.
Theory Exam (Chapter 1&2) in class Mon Feb 3
Drop-in tutorials will run every Tue 12-12:50 in CAT286 (computer lab)

Today - Lab 2 - Frequency Distribution and Histograms
Video tutorial and Mobius questions on Moodle
Check your email for other data files from me

Tips:

• Formulas or functions always start with =
• Press Enter to accept a formula, or Esc to exit without saving changes
• Start typing =COU in the formula bar in Excel and it will give you a choice of which function to use (e.g. COUNT, COUNTA, COUNTIF...) then the syntax for that function

Next Lecture - 2.5-2.6 Measures of Central Tendency

Pre-read §2.5-2.6
Watch this 3:54 primer video on mean, median and mode

https://www.khanacademy.org/math/probability/data-distributions-a1/summarizing-center-distributions/v/mean-median-and-mode