Excel — Spring 22

Lesson 5 — Boxplots & Quartiles

By


Learning Objectives

  • Create a boxplot by creating a Box and Whisker plot in Excel
  • Calculate Q1, Q2 (median) and Q3 by using the Excel function (command) QUANTILE.EXC
  • Calculate upper and lower fence by using arithmetic functions in Excel such as +, – and *, etc.

 

Instruction

Watch the following video and then do assignment Excel #5:

Excel Lesson 5

-END-



Content is copyright the author. Layout is copyright Mark Ciotola. See Corsbook.com for further notices.