google sheets- how to use to find the 5-number …...google sheets how to use to find the 5 number...

Google Sheets­ How to Use to Find the 5­Number Summary.notebook

1

February 18, 2018

Feb 8­9:03 AM

How to use Google Sheets to find the 5­Number Summary.

Google Sheets­ How to Use to Find the 5­Number Summary.notebook

2

February 18, 2018

Aug 13­12:24 PM

14.4 Using Google Sheets to find 5-Number Summary

2//2018 #

Examples: Notes:5- Number Summary:• Put the numbers in chronological order• Lower Extreme

> Highlight the Lowest Number• Upper Extreme

> Highlight the Greatest Number• Median- type formula into the B cell

> Type in =median(a1:a5)> = starts out formula> median tells what you want to do> a1 cell & number

– always in parenthesis> : means through> So, you want to find the median of a1

through a5• Lower Quartile• Upper Quartile

Survey Results

CellNumber

=median(a1:a5)

Google Sheets­ How to Use to Find the 5­Number Summary.notebook

3

February 18, 2018

Aug 13­12:24 PM

14.4 Using Google Sheets to find 5-Number Summary

2//2018 #

Examples: Notes:5- Number Summary:• Lower Quartile- type formula into the B

cell> Type in =median(a1:a2)> ENTER> Remember, you always take the median

out before finding the lower or upper quartile median

Survey Results

CellNumber

=median(a1:a2)

4.5

Google Sheets­ How to Use to Find the 5­Number Summary.notebook

4

February 18, 2018

Aug 13­12:24 PM

14.4 Using Google Sheets to find 5-Number Summary

2//2018 #

Examples: Notes:5- Number Summary:• Upper Quartile- type formula into the B

cell> Type in =median(a4:a5)> ENTER> Remember, you always take the median

out before finding the lower or upper quartile median

Survey Results

CellNumber

=median(a1:a2)

4.5

8.5

Google Sheets­ How to Use to Find the 5­Number Summary.notebook

5

February 18, 2018

Feb 10­11:47 PM

Using Google Sheets to determine the 5 number summary

Step 1: Type in the data, vertically in the first cell

Google Sheets­ How to Use to Find the 5­Number Summary.notebook

6

February 18, 2018

Feb 10­11:51 PM

Step 2: Find Minimum & Maximum• Highlight list• Click on Data: Sort range by column A, A - Z

Google Sheets­ How to Use to Find the 5­Number Summary.notebook

7

February 18, 2018

Feb 10­11:55 PM

Step 3: Low & High Extremes• Highlight Lower Extreme in ice blue• Highlight High Extreme in bright green

Google Sheets­ How to Use to Find the 5­Number Summary.notebook

8

February 18, 2018

Feb 10­11:55 PM

Step 4: Median• Type into any cell in column B• =median(a1:a8)• Enter• Highlight median in yellow

Google Sheets­ How to Use to Find the 5­Number Summary.notebook

9

February 18, 2018

Feb 10­11:55 PM

Step 4: Median• Type into any cell in column B• =median(a1:a8)• Enter• Because the median is in between 2 numbers, click on INSERT,

DRAWING

Google Sheets­ How to Use to Find the 5­Number Summary.notebook

10

February 18, 2018

Feb 18­11:47 AM

Step 4: Median• Because the median is in between 2 numbers, click on INSERT,

DRAWING• Click on LINE• Draw Line• Click on PENCIL & select YELLOW & thickness• Click SAVE & CLOSE

Google Sheets­ How to Use to Find the 5­Number Summary.notebook

11

February 18, 2018

Feb 10­11:55 PM

Step 5: Lower Quartile• Type into any cell in column B• =median(a1:a4)• Enter• Because the median is in between 2 numbers, click on INSERT,

DRAWING• Draw a Orange line

Google Sheets­ How to Use to Find the 5­Number Summary.notebook

12

February 18, 2018

Feb 10­11:55 PM

Step 5: Upper Quartile• Type into any cell in column B• =median(a5:a8)• Enter• Because the median is in between 2 numbers, click on INSERT,

DRAWING• Draw a Hot Pink line

Google Sheets­ How to Use to Find the 5­Number Summary.notebook

13

February 18, 2018

Feb 10­11:55 PM

Step 6: List the 5-Number Summary in Column C & highlight the columns

Google Sheets­ How to Use to Find the 5­Number Summary.notebook

14

February 18, 2018

Feb 11­12:15 AM

Class Survey Results

Google Sheets­ How to Use to Find the 5­Number Summary.notebook

15

February 18, 2018

Feb 11­12:15 AM

Go to your Google Drive & find results to class survey.

Click + to make new sheet

Click on Sheet2 black arrow 

Click on Rename...   IQR

Copy & paste HW minutes into IQR document

Google Sheets­ How to Use to Find the 5­Number Summary.notebook

16

February 18, 2018

Feb 11­12:15 AM

Find the 5­ number summary for the amount of time students spend on homework each 

week.

Use same colors for 5­number summary.

Google Sheets­ How to Use to Find the 5­Number Summary.notebook

17

February 18, 2018

Feb 18­11:21 AM