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 5Number Summary.notebook

1

February 18, 2018

Feb 89:03 AM

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


2

February 18, 2018

Aug 1312: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)

https://docs.google.com/spreadsheets/d/1e0IVR4NUyESg5ZZjaIJkCaYMIRG6jSO3IPEFhE3vCh4/edit?usp=sharing


3

February 18, 2018

Aug 1312:24 PM


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



4

February 18, 2018

Aug 1312:24 PM


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



5

February 18, 2018

Feb 1011:47 PM

Using Google Sheets to determine the 5 number summary

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


6

February 18, 2018

Feb 1011:51 PM

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


7

February 18, 2018

Feb 1011:55 PM

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


8

February 18, 2018

Feb 1011:55 PM

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


9

February 18, 2018

Feb 1011: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


10

February 18, 2018

Feb 1811: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


11

February 18, 2018

Feb 1011: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


12

February 18, 2018

Feb 1011: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


13

February 18, 2018

Feb 1011:55 PM

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


14

February 18, 2018

Feb 1112:15 AM

Class Survey Results


15

February 18, 2018

Feb 1112: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


16

February 18, 2018

Feb 1112:15 AM

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

week.

Use same colors for 5number summary.


17

February 18, 2018

Feb 1811:21 AM

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

Documents