6bff_4c81

Purpose: Practice calculating Z-scores in Google Sheets using the population mean (μ, mu = 120) and population standard deviation (σ, sigma = 15).

Follow these steps:

Open the Google Sheet Template: Google Sheet Template
File → Make a copy.
Paste the table below into the sheet (two columns: Name and BP).
Use μ = 120 and σ = 15 to compute Z for each BP.
Formula hint: (B2 - μ)/σ. Here B2 means the first BP value in column B. After typing the formula in the first row, place your mouse on the small square in the bottom-right corner of the cell (the fill handle) and drag it down. The spreadsheet will automatically change B2 to B3 for the next row, then B4, and so on, so each patient's BP gets its own Z-score.
Pro Tip: Advanced users can highlight the formula cell and the rows below it, then press ⌘D (Mac) or Ctrl+D (Windows) to autofill the formula quickly.

Patient Name	Systolic BP (mmHg)
Dominique	118
Hareem	83
Isabela	124
Jamilla	116
Mit	101
Ryan	153
Shail	139
Vanessa	121

Question: Which named patient has a Z-score between -2 and -1 standard deviations?

Dominique with a BP of 118 Incorrect Hareem with a BP of 83 Incorrect Mit with a BP of 101 Correct Ryan with a BP of 153 Incorrect Vanessa with a BP of 121 Incorrect MC

e1e2_95d0

Purpose: Practice calculating Z-scores in Google Sheets using the population mean (μ, mu = 120) and population standard deviation (σ, sigma = 15).

Follow these steps:

Open the Google Sheet Template: Google Sheet Template
File → Make a copy.
Paste the table below into the sheet (two columns: Name and BP).
Use μ = 120 and σ = 15 to compute Z for each BP.
Formula hint: (B2 - μ)/σ. Here B2 means the first BP value in column B. After typing the formula in the first row, place your mouse on the small square in the bottom-right corner of the cell (the fill handle) and drag it down. The spreadsheet will automatically change B2 to B3 for the next row, then B4, and so on, so each patient's BP gets its own Z-score.
Pro Tip: Advanced users can highlight the formula cell and the rows below it, then press ⌘D (Mac) or Ctrl+D (Windows) to autofill the formula quickly.

Patient Name	Systolic BP (mmHg)
Alissa	140
Brianna	101
Isabel	155
Kayla	122
Pooja	117
Ruchita	82
Shahd	111
Vanessa	123

Question: Which named patient has a Z-score between +1 and +2 standard deviations?

Alissa with a BP of 140 Correct Brianna with a BP of 101 Incorrect Isabel with a BP of 155 Incorrect Pooja with a BP of 117 Incorrect Ruchita with a BP of 82 Incorrect MC

2f6a_d65b

Purpose: Practice calculating Z-scores in Google Sheets using the population mean (μ, mu = 120) and population standard deviation (σ, sigma = 15).

Follow these steps:

Open the Google Sheet Template: Google Sheet Template
File → Make a copy.
Paste the table below into the sheet (two columns: Name and BP).
Use μ = 120 and σ = 15 to compute Z for each BP.
Formula hint: (B2 - μ)/σ. Here B2 means the first BP value in column B. After typing the formula in the first row, place your mouse on the small square in the bottom-right corner of the cell (the fill handle) and drag it down. The spreadsheet will automatically change B2 to B3 for the next row, then B4, and so on, so each patient's BP gets its own Z-score.
Pro Tip: Advanced users can highlight the formula cell and the rows below it, then press ⌘D (Mac) or Ctrl+D (Windows) to autofill the formula quickly.

Patient Name	Systolic BP (mmHg)
Amtul	78
Dlen	112
Esmeralda	100
Krystyna	126
Lauren	154
Mounisha	140
Naba	112
Sienna	126

Question: Which named patient has a Z-score between +2 and +3 standard deviations?

Amtul with a BP of 78 Incorrect Krystyna with a BP of 126 Incorrect Lauren with a BP of 154 Correct Mounisha with a BP of 140 Incorrect Sienna with a BP of 126 Incorrect MC

fd10_62f0

Purpose: Practice calculating Z-scores in Google Sheets using the population mean (μ, mu = 120) and population standard deviation (σ, sigma = 15).

Follow these steps:

Open the Google Sheet Template: Google Sheet Template
File → Make a copy.
Paste the table below into the sheet (two columns: Name and BP).
Use μ = 120 and σ = 15 to compute Z for each BP.
Formula hint: (B2 - μ)/σ. Here B2 means the first BP value in column B. After typing the formula in the first row, place your mouse on the small square in the bottom-right corner of the cell (the fill handle) and drag it down. The spreadsheet will automatically change B2 to B3 for the next row, then B4, and so on, so each patient's BP gets its own Z-score.
Pro Tip: Advanced users can highlight the formula cell and the rows below it, then press ⌘D (Mac) or Ctrl+D (Windows) to autofill the formula quickly.

Patient Name	Systolic BP (mmHg)
Adam	81
Brittany	117
Cee	129
Dan	161
Jane	114
Karina	100
Matthew	123
Sandy	140

Question: Which named patient has a Z-score between +1 and +2 standard deviations?

Adam with a BP of 81 Incorrect Brittany with a BP of 117 Incorrect Cee with a BP of 129 Incorrect Dan with a BP of 161 Incorrect Sandy with a BP of 140 Correct MC

f782_cedf

Purpose: Practice calculating Z-scores in Google Sheets using the population mean (μ, mu = 120) and population standard deviation (σ, sigma = 15).

Follow these steps:

Open the Google Sheet Template: Google Sheet Template
File → Make a copy.
Paste the table below into the sheet (two columns: Name and BP).
Use μ = 120 and σ = 15 to compute Z for each BP.
Formula hint: (B2 - μ)/σ. Here B2 means the first BP value in column B. After typing the formula in the first row, place your mouse on the small square in the bottom-right corner of the cell (the fill handle) and drag it down. The spreadsheet will automatically change B2 to B3 for the next row, then B4, and so on, so each patient's BP gets its own Z-score.
Pro Tip: Advanced users can highlight the formula cell and the rows below it, then press ⌘D (Mac) or Ctrl+D (Windows) to autofill the formula quickly.

Patient Name	Systolic BP (mmHg)
Abbie	125
Divya	111
Edgar	127
Iram	156
Lucy	77
Monika	139
Silver	100
Zach	112

Question: Which named patient has a Z-score between -2 and -1 standard deviations?

Divya with a BP of 111 Incorrect Iram with a BP of 156 Incorrect Lucy with a BP of 77 Incorrect Monika with a BP of 139 Incorrect Silver with a BP of 100 Correct MC

db8a_aab5

Purpose: Practice calculating Z-scores in Google Sheets using the population mean (μ, mu = 120) and population standard deviation (σ, sigma = 15).

Follow these steps:

Open the Google Sheet Template: Google Sheet Template
File → Make a copy.
Paste the table below into the sheet (two columns: Name and BP).
Use μ = 120 and σ = 15 to compute Z for each BP.
Formula hint: (B2 - μ)/σ. Here B2 means the first BP value in column B. After typing the formula in the first row, place your mouse on the small square in the bottom-right corner of the cell (the fill handle) and drag it down. The spreadsheet will automatically change B2 to B3 for the next row, then B4, and so on, so each patient's BP gets its own Z-score.
Pro Tip: Advanced users can highlight the formula cell and the rows below it, then press ⌘D (Mac) or Ctrl+D (Windows) to autofill the formula quickly.

Patient Name	Systolic BP (mmHg)
Angelica	101
Boong	139
Calah	122
Hasan	127
Irum	111
Mounisha	82
Nihar	113
Rudmine	155

Question: Which named patient has a Z-score between -2 and -1 standard deviations?

Angelica with a BP of 101 Correct Calah with a BP of 122 Incorrect Hasan with a BP of 127 Incorrect Mounisha with a BP of 82 Incorrect Rudmine with a BP of 155 Incorrect MC

c5f3_699c

Purpose: Practice calculating Z-scores in Google Sheets using the population mean (μ, mu = 120) and population standard deviation (σ, sigma = 15).

Follow these steps:

Open the Google Sheet Template: Google Sheet Template
File → Make a copy.
Paste the table below into the sheet (two columns: Name and BP).
Use μ = 120 and σ = 15 to compute Z for each BP.
Formula hint: (B2 - μ)/σ. Here B2 means the first BP value in column B. After typing the formula in the first row, place your mouse on the small square in the bottom-right corner of the cell (the fill handle) and drag it down. The spreadsheet will automatically change B2 to B3 for the next row, then B4, and so on, so each patient's BP gets its own Z-score.
Pro Tip: Advanced users can highlight the formula cell and the rows below it, then press ⌘D (Mac) or Ctrl+D (Windows) to autofill the formula quickly.

Patient Name	Systolic BP (mmHg)
Alex	126
Brittni	156
Claudia	124
Dylan	100
Leonardo	112
Nairuti	140
Rutvi	117
Tyson	79

Question: Which named patient has a Z-score between +1 and +2 standard deviations?

Alex with a BP of 126 Incorrect Brittni with a BP of 156 Incorrect Dylan with a BP of 100 Incorrect Nairuti with a BP of 140 Correct Tyson with a BP of 79 Incorrect MC

f349_0bea

Purpose: Practice calculating Z-scores in Google Sheets using the population mean (μ, mu = 120) and population standard deviation (σ, sigma = 15).

Follow these steps:

Open the Google Sheet Template: Google Sheet Template
File → Make a copy.
Paste the table below into the sheet (two columns: Name and BP).
Use μ = 120 and σ = 15 to compute Z for each BP.
Formula hint: (B2 - μ)/σ. Here B2 means the first BP value in column B. After typing the formula in the first row, place your mouse on the small square in the bottom-right corner of the cell (the fill handle) and drag it down. The spreadsheet will automatically change B2 to B3 for the next row, then B4, and so on, so each patient's BP gets its own Z-score.
Pro Tip: Advanced users can highlight the formula cell and the rows below it, then press ⌘D (Mac) or Ctrl+D (Windows) to autofill the formula quickly.

Patient Name	Systolic BP (mmHg)
Alona	125
Cierra	122
Harnish	100
Ivette	157
Joslyn	139
Molly	112
Nate	112
Sienna	77

Question: Which named patient has a Z-score between -3 and -2 standard deviations?

Harnish with a BP of 100 Incorrect Ivette with a BP of 157 Incorrect Joslyn with a BP of 139 Incorrect Molly with a BP of 112 Incorrect Sienna with a BP of 77 Correct MC

6c6e_fe2a

Purpose: Practice calculating Z-scores in Google Sheets using the population mean (μ, mu = 120) and population standard deviation (σ, sigma = 15).

Follow these steps:

Open the Google Sheet Template: Google Sheet Template
File → Make a copy.
Paste the table below into the sheet (two columns: Name and BP).
Use μ = 120 and σ = 15 to compute Z for each BP.
Formula hint: (B2 - μ)/σ. Here B2 means the first BP value in column B. After typing the formula in the first row, place your mouse on the small square in the bottom-right corner of the cell (the fill handle) and drag it down. The spreadsheet will automatically change B2 to B3 for the next row, then B4, and so on, so each patient's BP gets its own Z-score.
Pro Tip: Advanced users can highlight the formula cell and the rows below it, then press ⌘D (Mac) or Ctrl+D (Windows) to autofill the formula quickly.

Patient Name	Systolic BP (mmHg)
Alissa	115
Cedric	126
Etny	126
Joel	76
Leila	101
Malcom	111
Rafiaa	158
Sonam	139

Question: Which named patient has a Z-score between +1 and +2 standard deviations?

Etny with a BP of 126 Incorrect Joel with a BP of 76 Incorrect Leila with a BP of 101 Incorrect Rafiaa with a BP of 158 Incorrect Sonam with a BP of 139 Correct MC

db51_868b

Purpose: Practice calculating Z-scores in Google Sheets using the population mean (μ, mu = 120) and population standard deviation (σ, sigma = 15).

Follow these steps:

Open the Google Sheet Template: Google Sheet Template
File → Make a copy.
Paste the table below into the sheet (two columns: Name and BP).
Use μ = 120 and σ = 15 to compute Z for each BP.
Formula hint: (B2 - μ)/σ. Here B2 means the first BP value in column B. After typing the formula in the first row, place your mouse on the small square in the bottom-right corner of the cell (the fill handle) and drag it down. The spreadsheet will automatically change B2 to B3 for the next row, then B4, and so on, so each patient's BP gets its own Z-score.
Pro Tip: Advanced users can highlight the formula cell and the rows below it, then press ⌘D (Mac) or Ctrl+D (Windows) to autofill the formula quickly.

Patient Name	Systolic BP (mmHg)
Cee	139
Danielle	159
Falak	100
Hilary	118
Irum	85
Joss	123
Ryan	126
Vrutti	115

Question: Which named patient has a Z-score between +1 and +2 standard deviations?

Cee with a BP of 139 Correct Danielle with a BP of 159 Incorrect Falak with a BP of 100 Incorrect Irum with a BP of 85 Incorrect Ryan with a BP of 126 Incorrect MC

d942_1dcc

Purpose: Practice calculating Z-scores in Google Sheets using the population mean (μ, mu = 120) and population standard deviation (σ, sigma = 15).

Follow these steps:

Open the Google Sheet Template: Google Sheet Template
File → Make a copy.
Paste the table below into the sheet (two columns: Name and BP).
Use μ = 120 and σ = 15 to compute Z for each BP.
Formula hint: (B2 - μ)/σ. Here B2 means the first BP value in column B. After typing the formula in the first row, place your mouse on the small square in the bottom-right corner of the cell (the fill handle) and drag it down. The spreadsheet will automatically change B2 to B3 for the next row, then B4, and so on, so each patient's BP gets its own Z-score.
Pro Tip: Advanced users can highlight the formula cell and the rows below it, then press ⌘D (Mac) or Ctrl+D (Windows) to autofill the formula quickly.

Patient Name	Systolic BP (mmHg)
Armela	83
Heather	119
Kareem	158
Lisa	127
Mayank	139
Roxanne	100
Tanitha	115
Zach	127

Question: Which named patient has a Z-score between +2 and +3 standard deviations?

Armela with a BP of 83 Incorrect Kareem with a BP of 158 Correct Mayank with a BP of 139 Incorrect Roxanne with a BP of 100 Incorrect Tanitha with a BP of 115 Incorrect MC

7bcb_ec7d

Purpose: Practice calculating Z-scores in Google Sheets using the population mean (μ, mu = 120) and population standard deviation (σ, sigma = 15).

Follow these steps:

Open the Google Sheet Template: Google Sheet Template
File → Make a copy.
Paste the table below into the sheet (two columns: Name and BP).
Use μ = 120 and σ = 15 to compute Z for each BP.
Formula hint: (B2 - μ)/σ. Here B2 means the first BP value in column B. After typing the formula in the first row, place your mouse on the small square in the bottom-right corner of the cell (the fill handle) and drag it down. The spreadsheet will automatically change B2 to B3 for the next row, then B4, and so on, so each patient's BP gets its own Z-score.
Pro Tip: Advanced users can highlight the formula cell and the rows below it, then press ⌘D (Mac) or Ctrl+D (Windows) to autofill the formula quickly.

Patient Name	Systolic BP (mmHg)
Alyssa	84
Clinton	101
Harin	156
Kher	124
Nicole	128
Orlando	140
Rosanna	116
Safi	113

Question: Which named patient has a Z-score between -3 and -2 standard deviations?

Alyssa with a BP of 84 Correct Clinton with a BP of 101 Incorrect Harin with a BP of 156 Incorrect Nicole with a BP of 128 Incorrect Safi with a BP of 113 Incorrect MC

6116_1c92

Purpose: Practice calculating Z-scores in Google Sheets using the population mean (μ, mu = 120) and population standard deviation (σ, sigma = 15).

Follow these steps:

Open the Google Sheet Template: Google Sheet Template
File → Make a copy.
Paste the table below into the sheet (two columns: Name and BP).
Use μ = 120 and σ = 15 to compute Z for each BP.
Formula hint: (B2 - μ)/σ. Here B2 means the first BP value in column B. After typing the formula in the first row, place your mouse on the small square in the bottom-right corner of the cell (the fill handle) and drag it down. The spreadsheet will automatically change B2 to B3 for the next row, then B4, and so on, so each patient's BP gets its own Z-score.
Pro Tip: Advanced users can highlight the formula cell and the rows below it, then press ⌘D (Mac) or Ctrl+D (Windows) to autofill the formula quickly.

Patient Name	Systolic BP (mmHg)
Alex	113
Breanne	83
Miranda	125
Omar	114
Prit	139
Reyna	121
Travis	157
Vraj	101

Question: Which named patient has a Z-score between +2 and +3 standard deviations?

Breanne with a BP of 83 Incorrect Miranda with a BP of 125 Incorrect Omar with a BP of 114 Incorrect Prit with a BP of 139 Incorrect Travis with a BP of 157 Correct MC

e81a_ee15

Purpose: Practice calculating Z-scores in Google Sheets using the population mean (μ, mu = 120) and population standard deviation (σ, sigma = 15).

Follow these steps:

Open the Google Sheet Template: Google Sheet Template
File → Make a copy.
Paste the table below into the sheet (two columns: Name and BP).
Use μ = 120 and σ = 15 to compute Z for each BP.
Formula hint: (B2 - μ)/σ. Here B2 means the first BP value in column B. After typing the formula in the first row, place your mouse on the small square in the bottom-right corner of the cell (the fill handle) and drag it down. The spreadsheet will automatically change B2 to B3 for the next row, then B4, and so on, so each patient's BP gets its own Z-score.
Pro Tip: Advanced users can highlight the formula cell and the rows below it, then press ⌘D (Mac) or Ctrl+D (Windows) to autofill the formula quickly.

Patient Name	Systolic BP (mmHg)
Avani	123
Beatrice	78
Desaray	116
Emmy	139
Phylicia	117
Roxana	101
Suchi	128
Therese	157

Question: Which named patient has a Z-score between +1 and +2 standard deviations?

Beatrice with a BP of 78 Incorrect Emmy with a BP of 139 Correct Phylicia with a BP of 117 Incorrect Suchi with a BP of 128 Incorrect Therese with a BP of 157 Incorrect MC

b8e3_915a

Purpose: Practice calculating Z-scores in Google Sheets using the population mean (μ, mu = 120) and population standard deviation (σ, sigma = 15).

Follow these steps:

Open the Google Sheet Template: Google Sheet Template
File → Make a copy.
Paste the table below into the sheet (two columns: Name and BP).
Use μ = 120 and σ = 15 to compute Z for each BP.
Formula hint: (B2 - μ)/σ. Here B2 means the first BP value in column B. After typing the formula in the first row, place your mouse on the small square in the bottom-right corner of the cell (the fill handle) and drag it down. The spreadsheet will automatically change B2 to B3 for the next row, then B4, and so on, so each patient's BP gets its own Z-score.
Pro Tip: Advanced users can highlight the formula cell and the rows below it, then press ⌘D (Mac) or Ctrl+D (Windows) to autofill the formula quickly.

Patient Name	Systolic BP (mmHg)
Anupam	79
Doha	125
Hiedy	101
Irum	126
Jasmine	119
Marianne	140
Raqib	155
Selena	118

Question: Which named patient has a Z-score between -2 and -1 standard deviations?

Anupam with a BP of 79 Incorrect Hiedy with a BP of 101 Correct Irum with a BP of 126 Incorrect Raqib with a BP of 155 Incorrect Selena with a BP of 118 Incorrect MC

0533_10fd

Purpose: Practice calculating Z-scores in Google Sheets using the population mean (μ, mu = 120) and population standard deviation (σ, sigma = 15).

Follow these steps:

Open the Google Sheet Template: Google Sheet Template
File → Make a copy.
Paste the table below into the sheet (two columns: Name and BP).
Use μ = 120 and σ = 15 to compute Z for each BP.
Formula hint: (B2 - μ)/σ. Here B2 means the first BP value in column B. After typing the formula in the first row, place your mouse on the small square in the bottom-right corner of the cell (the fill handle) and drag it down. The spreadsheet will automatically change B2 to B3 for the next row, then B4, and so on, so each patient's BP gets its own Z-score.
Pro Tip: Advanced users can highlight the formula cell and the rows below it, then press ⌘D (Mac) or Ctrl+D (Windows) to autofill the formula quickly.

Patient Name	Systolic BP (mmHg)
Allyson	114
Cory	140
Hailey	100
Miranda	119
Namrah	82
Pravalika	123
Sandy	157
Zain	129

Question: Which named patient has a Z-score between +1 and +2 standard deviations?

Cory with a BP of 140 Correct Hailey with a BP of 100 Incorrect Namrah with a BP of 82 Incorrect Sandy with a BP of 157 Incorrect Zain with a BP of 129 Incorrect MC

015b_f5a8

Purpose: Practice calculating Z-scores in Google Sheets using the population mean (μ, mu = 120) and population standard deviation (σ, sigma = 15).

Follow these steps:

Open the Google Sheet Template: Google Sheet Template
File → Make a copy.
Paste the table below into the sheet (two columns: Name and BP).
Use μ = 120 and σ = 15 to compute Z for each BP.
Formula hint: (B2 - μ)/σ. Here B2 means the first BP value in column B. After typing the formula in the first row, place your mouse on the small square in the bottom-right corner of the cell (the fill handle) and drag it down. The spreadsheet will automatically change B2 to B3 for the next row, then B4, and so on, so each patient's BP gets its own Z-score.
Pro Tip: Advanced users can highlight the formula cell and the rows below it, then press ⌘D (Mac) or Ctrl+D (Windows) to autofill the formula quickly.

Patient Name	Systolic BP (mmHg)
Alfredo	129
Daminik	121
Hilda	114
Itzel	101
Janelle	86
Mayank	115
Sabrina	140
Tricia	157

Question: Which named patient has a Z-score between -2 and -1 standard deviations?

Daminik with a BP of 121 Incorrect Hilda with a BP of 114 Incorrect Itzel with a BP of 101 Correct Janelle with a BP of 86 Incorrect Tricia with a BP of 157 Incorrect MC

d6c9_d026

Purpose: Practice calculating Z-scores in Google Sheets using the population mean (μ, mu = 120) and population standard deviation (σ, sigma = 15).

Follow these steps:

Open the Google Sheet Template: Google Sheet Template
File → Make a copy.
Paste the table below into the sheet (two columns: Name and BP).
Use μ = 120 and σ = 15 to compute Z for each BP.
Formula hint: (B2 - μ)/σ. Here B2 means the first BP value in column B. After typing the formula in the first row, place your mouse on the small square in the bottom-right corner of the cell (the fill handle) and drag it down. The spreadsheet will automatically change B2 to B3 for the next row, then B4, and so on, so each patient's BP gets its own Z-score.
Pro Tip: Advanced users can highlight the formula cell and the rows below it, then press ⌘D (Mac) or Ctrl+D (Windows) to autofill the formula quickly.

Patient Name	Systolic BP (mmHg)
Alejandra	80
Derri	124
Faryal	111
Genesis	140
Ibrahim	158
Nyah	129
Stacie	101
Vibhuti	116

Question: Which named patient has a Z-score between +2 and +3 standard deviations?

Alejandra with a BP of 80 Incorrect Faryal with a BP of 111 Incorrect Genesis with a BP of 140 Incorrect Ibrahim with a BP of 158 Correct Vibhuti with a BP of 116 Incorrect MC

9853_e5f9

Purpose: Practice calculating Z-scores in Google Sheets using the population mean (μ, mu = 120) and population standard deviation (σ, sigma = 15).

Follow these steps:

Open the Google Sheet Template: Google Sheet Template
File → Make a copy.
Paste the table below into the sheet (two columns: Name and BP).
Use μ = 120 and σ = 15 to compute Z for each BP.
Formula hint: (B2 - μ)/σ. Here B2 means the first BP value in column B. After typing the formula in the first row, place your mouse on the small square in the bottom-right corner of the cell (the fill handle) and drag it down. The spreadsheet will automatically change B2 to B3 for the next row, then B4, and so on, so each patient's BP gets its own Z-score.
Pro Tip: Advanced users can highlight the formula cell and the rows below it, then press ⌘D (Mac) or Ctrl+D (Windows) to autofill the formula quickly.

Patient Name	Systolic BP (mmHg)
Abbey	155
Brianna	114
Clifton	116
Jake	81
Melissa	121
Onyi	139
Rana	100
Wasiya	121

Question: Which named patient has a Z-score between +1 and +2 standard deviations?

Abbey with a BP of 155 Incorrect Jake with a BP of 81 Incorrect Onyi with a BP of 139 Correct Rana with a BP of 100 Incorrect Wasiya with a BP of 121 Incorrect MC

3f87_04d5

Purpose: Practice calculating Z-scores in Google Sheets using the population mean (μ, mu = 120) and population standard deviation (σ, sigma = 15).

Follow these steps:

Open the Google Sheet Template: Google Sheet Template
File → Make a copy.
Paste the table below into the sheet (two columns: Name and BP).
Use μ = 120 and σ = 15 to compute Z for each BP.
Formula hint: (B2 - μ)/σ. Here B2 means the first BP value in column B. After typing the formula in the first row, place your mouse on the small square in the bottom-right corner of the cell (the fill handle) and drag it down. The spreadsheet will automatically change B2 to B3 for the next row, then B4, and so on, so each patient's BP gets its own Z-score.
Pro Tip: Advanced users can highlight the formula cell and the rows below it, then press ⌘D (Mac) or Ctrl+D (Windows) to autofill the formula quickly.

Patient Name	Systolic BP (mmHg)
Armela	128
Brittnie	125
Cedric	114
Daminik	116
Het	101
Itzel	86
Patty	139
Sam	157

Question: Which named patient has a Z-score between +2 and +3 standard deviations?

Armela with a BP of 128 Incorrect Het with a BP of 101 Incorrect Itzel with a BP of 86 Incorrect Patty with a BP of 139 Incorrect Sam with a BP of 157 Correct MC

8c13_41aa

Purpose: Practice calculating Z-scores in Google Sheets using the population mean (μ, mu = 120) and population standard deviation (σ, sigma = 15).

Follow these steps:

Open the Google Sheet Template: Google Sheet Template
File → Make a copy.
Paste the table below into the sheet (two columns: Name and BP).
Use μ = 120 and σ = 15 to compute Z for each BP.
Formula hint: (B2 - μ)/σ. Here B2 means the first BP value in column B. After typing the formula in the first row, place your mouse on the small square in the bottom-right corner of the cell (the fill handle) and drag it down. The spreadsheet will automatically change B2 to B3 for the next row, then B4, and so on, so each patient's BP gets its own Z-score.
Pro Tip: Advanced users can highlight the formula cell and the rows below it, then press ⌘D (Mac) or Ctrl+D (Windows) to autofill the formula quickly.

Patient Name	Systolic BP (mmHg)
Ankit	125
Charonda	158
Daminik	101
Isha	113
Joslyn	125
Mariyam	140
Noel	111
Swathi	88

Question: Which named patient has a Z-score between +2 and +3 standard deviations?

Charonda with a BP of 158 Correct Daminik with a BP of 101 Incorrect Mariyam with a BP of 140 Incorrect Noel with a BP of 111 Incorrect Swathi with a BP of 88 Incorrect MC

8912_b19f

Purpose: Practice calculating Z-scores in Google Sheets using the population mean (μ, mu = 120) and population standard deviation (σ, sigma = 15).

Follow these steps:

Open the Google Sheet Template: Google Sheet Template
File → Make a copy.
Paste the table below into the sheet (two columns: Name and BP).
Use μ = 120 and σ = 15 to compute Z for each BP.
Formula hint: (B2 - μ)/σ. Here B2 means the first BP value in column B. After typing the formula in the first row, place your mouse on the small square in the bottom-right corner of the cell (the fill handle) and drag it down. The spreadsheet will automatically change B2 to B3 for the next row, then B4, and so on, so each patient's BP gets its own Z-score.
Pro Tip: Advanced users can highlight the formula cell and the rows below it, then press ⌘D (Mac) or Ctrl+D (Windows) to autofill the formula quickly.

Patient Name	Systolic BP (mmHg)
Brinda	100
Gina	112
Hailey	80
Karolina	116
Liz	127
Miriam	140
Ramon	157
Sumee	127

Question: Which named patient has a Z-score between -2 and -1 standard deviations?

Brinda with a BP of 100 Correct Hailey with a BP of 80 Incorrect Karolina with a BP of 116 Incorrect Ramon with a BP of 157 Incorrect Sumee with a BP of 127 Incorrect MC

4ce9_3ef1

Purpose: Practice calculating Z-scores in Google Sheets using the population mean (μ, mu = 120) and population standard deviation (σ, sigma = 15).

Follow these steps:

Open the Google Sheet Template: Google Sheet Template
File → Make a copy.
Paste the table below into the sheet (two columns: Name and BP).
Use μ = 120 and σ = 15 to compute Z for each BP.
Formula hint: (B2 - μ)/σ. Here B2 means the first BP value in column B. After typing the formula in the first row, place your mouse on the small square in the bottom-right corner of the cell (the fill handle) and drag it down. The spreadsheet will automatically change B2 to B3 for the next row, then B4, and so on, so each patient's BP gets its own Z-score.
Pro Tip: Advanced users can highlight the formula cell and the rows below it, then press ⌘D (Mac) or Ctrl+D (Windows) to autofill the formula quickly.

Patient Name	Systolic BP (mmHg)
Aditi	112
Cory	158
Deena	76
Ewa	122
Miraj	139
Nicole	101
Ola	126
Sage	119

Question: Which named patient has a Z-score between +1 and +2 standard deviations?

Cory with a BP of 158 Incorrect Deena with a BP of 76 Incorrect Miraj with a BP of 139 Correct Ola with a BP of 126 Incorrect Sage with a BP of 119 Incorrect MC

989a_f93b

Purpose: Practice calculating Z-scores in Google Sheets using the population mean (μ, mu = 120) and population standard deviation (σ, sigma = 15).

Follow these steps:

Open the Google Sheet Template: Google Sheet Template
File → Make a copy.
Paste the table below into the sheet (two columns: Name and BP).
Use μ = 120 and σ = 15 to compute Z for each BP.
Formula hint: (B2 - μ)/σ. Here B2 means the first BP value in column B. After typing the formula in the first row, place your mouse on the small square in the bottom-right corner of the cell (the fill handle) and drag it down. The spreadsheet will automatically change B2 to B3 for the next row, then B4, and so on, so each patient's BP gets its own Z-score.
Pro Tip: Advanced users can highlight the formula cell and the rows below it, then press ⌘D (Mac) or Ctrl+D (Windows) to autofill the formula quickly.

Patient Name	Systolic BP (mmHg)
Aisha	100
Bharat	139
Chris	129
Heydi	87
Kiara	152
Lupe	112
Mikaela	126
Orlando	112

Question: Which named patient has a Z-score between +1 and +2 standard deviations?

Bharat with a BP of 139 Correct Heydi with a BP of 87 Incorrect Kiara with a BP of 152 Incorrect Mikaela with a BP of 126 Incorrect Orlando with a BP of 112 Incorrect MC

eba3_4697

Purpose: Practice calculating Z-scores in Google Sheets using the population mean (μ, mu = 120) and population standard deviation (σ, sigma = 15).

Follow these steps:

Open the Google Sheet Template: Google Sheet Template
File → Make a copy.
Paste the table below into the sheet (two columns: Name and BP).
Use μ = 120 and σ = 15 to compute Z for each BP.
Formula hint: (B2 - μ)/σ. Here B2 means the first BP value in column B. After typing the formula in the first row, place your mouse on the small square in the bottom-right corner of the cell (the fill handle) and drag it down. The spreadsheet will automatically change B2 to B3 for the next row, then B4, and so on, so each patient's BP gets its own Z-score.
Pro Tip: Advanced users can highlight the formula cell and the rows below it, then press ⌘D (Mac) or Ctrl+D (Windows) to autofill the formula quickly.

Patient Name	Systolic BP (mmHg)
Dao	84
Errol	126
Hareem	101
Jhelam	154
Meaghan	112
Rulaa	113
Sydney	127
Tatiana	139

Question: Which named patient has a Z-score between +2 and +3 standard deviations?

Dao with a BP of 84 Incorrect Jhelam with a BP of 154 Correct Meaghan with a BP of 112 Incorrect Rulaa with a BP of 113 Incorrect Tatiana with a BP of 139 Incorrect MC

c041_411f

Purpose: Practice calculating Z-scores in Google Sheets using the population mean (μ, mu = 120) and population standard deviation (σ, sigma = 15).

Follow these steps:

Open the Google Sheet Template: Google Sheet Template
File → Make a copy.
Paste the table below into the sheet (two columns: Name and BP).
Use μ = 120 and σ = 15 to compute Z for each BP.
Formula hint: (B2 - μ)/σ. Here B2 means the first BP value in column B. After typing the formula in the first row, place your mouse on the small square in the bottom-right corner of the cell (the fill handle) and drag it down. The spreadsheet will automatically change B2 to B3 for the next row, then B4, and so on, so each patient's BP gets its own Z-score.
Pro Tip: Advanced users can highlight the formula cell and the rows below it, then press ⌘D (Mac) or Ctrl+D (Windows) to autofill the formula quickly.

Patient Name	Systolic BP (mmHg)
Cody	100
Daniella	139
Het	123
Kaushal	115
Lauren	154
Rhea	122
Salman	111
Valbhi	81

Question: Which named patient has a Z-score between -3 and -2 standard deviations?

Cody with a BP of 100 Incorrect Het with a BP of 123 Incorrect Lauren with a BP of 154 Incorrect Salman with a BP of 111 Incorrect Valbhi with a BP of 81 Correct MC

e878_f3bc

Purpose: Practice calculating Z-scores in Google Sheets using the population mean (μ, mu = 120) and population standard deviation (σ, sigma = 15).

Follow these steps:

Open the Google Sheet Template: Google Sheet Template
File → Make a copy.
Paste the table below into the sheet (two columns: Name and BP).
Use μ = 120 and σ = 15 to compute Z for each BP.
Formula hint: (B2 - μ)/σ. Here B2 means the first BP value in column B. After typing the formula in the first row, place your mouse on the small square in the bottom-right corner of the cell (the fill handle) and drag it down. The spreadsheet will automatically change B2 to B3 for the next row, then B4, and so on, so each patient's BP gets its own Z-score.
Pro Tip: Advanced users can highlight the formula cell and the rows below it, then press ⌘D (Mac) or Ctrl+D (Windows) to autofill the formula quickly.

Patient Name	Systolic BP (mmHg)
Amparo	157
Bansi	130
Hiedy	112
Katie	101
Mikhail	116
Oluwole	140
Vrutti	126
Zach	83

Question: Which named patient has a Z-score between -2 and -1 standard deviations?

Amparo with a BP of 157 Incorrect Katie with a BP of 101 Correct Mikhail with a BP of 116 Incorrect Oluwole with a BP of 140 Incorrect Zach with a BP of 83 Incorrect MC

69ca_9bb9

Purpose: Practice calculating Z-scores in Google Sheets using the population mean (μ, mu = 120) and population standard deviation (σ, sigma = 15).

Follow these steps:

Open the Google Sheet Template: Google Sheet Template
File → Make a copy.
Paste the table below into the sheet (two columns: Name and BP).
Use μ = 120 and σ = 15 to compute Z for each BP.
Formula hint: (B2 - μ)/σ. Here B2 means the first BP value in column B. After typing the formula in the first row, place your mouse on the small square in the bottom-right corner of the cell (the fill handle) and drag it down. The spreadsheet will automatically change B2 to B3 for the next row, then B4, and so on, so each patient's BP gets its own Z-score.
Pro Tip: Advanced users can highlight the formula cell and the rows below it, then press ⌘D (Mac) or Ctrl+D (Windows) to autofill the formula quickly.

Patient Name	Systolic BP (mmHg)
Abdullah	123
Bhargavi	114
Itzel	84
Madiha	139
Patrycja	100
Rubina	154
Stephanie	128
Tayo	114

Question: Which named patient has a Z-score between +1 and +2 standard deviations?

Itzel with a BP of 84 Incorrect Madiha with a BP of 139 Correct Rubina with a BP of 154 Incorrect Stephanie with a BP of 128 Incorrect Tayo with a BP of 114 Incorrect MC

8b6c_5240

Purpose: Practice calculating Z-scores in Google Sheets using the population mean (μ, mu = 120) and population standard deviation (σ, sigma = 15).

Follow these steps:

Open the Google Sheet Template: Google Sheet Template
File → Make a copy.
Paste the table below into the sheet (two columns: Name and BP).
Use μ = 120 and σ = 15 to compute Z for each BP.
Formula hint: (B2 - μ)/σ. Here B2 means the first BP value in column B. After typing the formula in the first row, place your mouse on the small square in the bottom-right corner of the cell (the fill handle) and drag it down. The spreadsheet will automatically change B2 to B3 for the next row, then B4, and so on, so each patient's BP gets its own Z-score.
Pro Tip: Advanced users can highlight the formula cell and the rows below it, then press ⌘D (Mac) or Ctrl+D (Windows) to autofill the formula quickly.

Patient Name	Systolic BP (mmHg)
Anthony	153
Dalal	123
Freny	101
Jennifer	111
Kingsley	140
Lee	83
Rudra	118
Silver	122

Question: Which named patient has a Z-score between -3 and -2 standard deviations?

Anthony with a BP of 153 Incorrect Freny with a BP of 101 Incorrect Lee with a BP of 83 Correct Rudra with a BP of 118 Incorrect Silver with a BP of 122 Incorrect MC

c7c9_07a7

Purpose: Practice calculating Z-scores in Google Sheets using the population mean (μ, mu = 120) and population standard deviation (σ, sigma = 15).

Follow these steps:

Open the Google Sheet Template: Google Sheet Template
File → Make a copy.
Paste the table below into the sheet (two columns: Name and BP).
Use μ = 120 and σ = 15 to compute Z for each BP.
Formula hint: (B2 - μ)/σ. Here B2 means the first BP value in column B. After typing the formula in the first row, place your mouse on the small square in the bottom-right corner of the cell (the fill handle) and drag it down. The spreadsheet will automatically change B2 to B3 for the next row, then B4, and so on, so each patient's BP gets its own Z-score.
Pro Tip: Advanced users can highlight the formula cell and the rows below it, then press ⌘D (Mac) or Ctrl+D (Windows) to autofill the formula quickly.

Patient Name	Systolic BP (mmHg)
Arti	155
Bianca	140
Eneo	127
Harin	101
Irene	129
Khulan	85
Namrah	114
Sejal	117

Question: Which named patient has a Z-score between +1 and +2 standard deviations?

Arti with a BP of 155 Incorrect Bianca with a BP of 140 Correct Harin with a BP of 101 Incorrect Khulan with a BP of 85 Incorrect Sejal with a BP of 117 Incorrect MC

9cf5_3029

Purpose: Practice calculating Z-scores in Google Sheets using the population mean (μ, mu = 120) and population standard deviation (σ, sigma = 15).

Follow these steps:

Open the Google Sheet Template: Google Sheet Template
File → Make a copy.
Paste the table below into the sheet (two columns: Name and BP).
Use μ = 120 and σ = 15 to compute Z for each BP.
Formula hint: (B2 - μ)/σ. Here B2 means the first BP value in column B. After typing the formula in the first row, place your mouse on the small square in the bottom-right corner of the cell (the fill handle) and drag it down. The spreadsheet will automatically change B2 to B3 for the next row, then B4, and so on, so each patient's BP gets its own Z-score.
Pro Tip: Advanced users can highlight the formula cell and the rows below it, then press ⌘D (Mac) or Ctrl+D (Windows) to autofill the formula quickly.

Patient Name	Systolic BP (mmHg)
Dima	117
Errol	140
Heather	160
Keidi	100
Nur	118
Owais	129
Silvana	78
Tania	124

Question: Which named patient has a Z-score between -3 and -2 standard deviations?

Errol with a BP of 140 Incorrect Heather with a BP of 160 Incorrect Keidi with a BP of 100 Incorrect Nur with a BP of 118 Incorrect Silvana with a BP of 78 Correct MC

1cbe_1379

Purpose: Practice calculating Z-scores in Google Sheets using the population mean (μ, mu = 120) and population standard deviation (σ, sigma = 15).

Follow these steps:

Open the Google Sheet Template: Google Sheet Template
File → Make a copy.
Paste the table below into the sheet (two columns: Name and BP).
Use μ = 120 and σ = 15 to compute Z for each BP.
Formula hint: (B2 - μ)/σ. Here B2 means the first BP value in column B. After typing the formula in the first row, place your mouse on the small square in the bottom-right corner of the cell (the fill handle) and drag it down. The spreadsheet will automatically change B2 to B3 for the next row, then B4, and so on, so each patient's BP gets its own Z-score.
Pro Tip: Advanced users can highlight the formula cell and the rows below it, then press ⌘D (Mac) or Ctrl+D (Windows) to autofill the formula quickly.

Patient Name	Systolic BP (mmHg)
Alona	124
Chrissy	140
Hamida	123
Julia	156
Lupe	77
Malcom	100
Rutuja	117
Yamini	114

Question: Which named patient has a Z-score between -2 and -1 standard deviations?

Julia with a BP of 156 Incorrect Lupe with a BP of 77 Incorrect Malcom with a BP of 100 Correct Rutuja with a BP of 117 Incorrect Yamini with a BP of 114 Incorrect MC

a3e4_ead9

Purpose: Practice calculating Z-scores in Google Sheets using the population mean (μ, mu = 120) and population standard deviation (σ, sigma = 15).

Follow these steps:

Open the Google Sheet Template: Google Sheet Template
File → Make a copy.
Paste the table below into the sheet (two columns: Name and BP).
Use μ = 120 and σ = 15 to compute Z for each BP.
Formula hint: (B2 - μ)/σ. Here B2 means the first BP value in column B. After typing the formula in the first row, place your mouse on the small square in the bottom-right corner of the cell (the fill handle) and drag it down. The spreadsheet will automatically change B2 to B3 for the next row, then B4, and so on, so each patient's BP gets its own Z-score.
Pro Tip: Advanced users can highlight the formula cell and the rows below it, then press ⌘D (Mac) or Ctrl+D (Windows) to autofill the formula quickly.

Patient Name	Systolic BP (mmHg)
Amarjeet	154
Harriet	100
Jas	112
Lupe	114
Miko	80
Pooja	122
Samantha	139
Themarr	123

Question: Which named patient has a Z-score between +2 and +3 standard deviations?

Amarjeet with a BP of 154 Correct Miko with a BP of 80 Incorrect Pooja with a BP of 122 Incorrect Samantha with a BP of 139 Incorrect Themarr with a BP of 123 Incorrect MC

bb24_1c7e

Purpose: Practice calculating Z-scores in Google Sheets using the population mean (μ, mu = 120) and population standard deviation (σ, sigma = 15).

Follow these steps:

Open the Google Sheet Template: Google Sheet Template
File → Make a copy.
Paste the table below into the sheet (two columns: Name and BP).
Use μ = 120 and σ = 15 to compute Z for each BP.
Formula hint: (B2 - μ)/σ. Here B2 means the first BP value in column B. After typing the formula in the first row, place your mouse on the small square in the bottom-right corner of the cell (the fill handle) and drag it down. The spreadsheet will automatically change B2 to B3 for the next row, then B4, and so on, so each patient's BP gets its own Z-score.
Pro Tip: Advanced users can highlight the formula cell and the rows below it, then press ⌘D (Mac) or Ctrl+D (Windows) to autofill the formula quickly.

Patient Name	Systolic BP (mmHg)
Abdullah	77
Dan	140
Isabela	117
Nina	125
Rebecca	130
Silver	101
Xavier	116
Yoana	153

Question: Which named patient has a Z-score between -3 and -2 standard deviations?

Abdullah with a BP of 77 Correct Dan with a BP of 140 Incorrect Rebecca with a BP of 130 Incorrect Silver with a BP of 101 Incorrect Yoana with a BP of 153 Incorrect MC

50ec_198b

Purpose: Practice calculating Z-scores in Google Sheets using the population mean (μ, mu = 120) and population standard deviation (σ, sigma = 15).

Follow these steps:

Open the Google Sheet Template: Google Sheet Template
File → Make a copy.
Paste the table below into the sheet (two columns: Name and BP).
Use μ = 120 and σ = 15 to compute Z for each BP.
Formula hint: (B2 - μ)/σ. Here B2 means the first BP value in column B. After typing the formula in the first row, place your mouse on the small square in the bottom-right corner of the cell (the fill handle) and drag it down. The spreadsheet will automatically change B2 to B3 for the next row, then B4, and so on, so each patient's BP gets its own Z-score.
Pro Tip: Advanced users can highlight the formula cell and the rows below it, then press ⌘D (Mac) or Ctrl+D (Windows) to autofill the formula quickly.

Patient Name	Systolic BP (mmHg)
Arturo	130
Dlen	111
Hanan	100
Jessica	140
Kaitlynn	127
Lindita	161
Nairuti	87
Srilatha	118

Question: Which named patient has a Z-score between -3 and -2 standard deviations?

Hanan with a BP of 100 Incorrect Kaitlynn with a BP of 127 Incorrect Lindita with a BP of 161 Incorrect Nairuti with a BP of 87 Correct Srilatha with a BP of 118 Incorrect MC

bba5_51e2

Purpose: Practice calculating Z-scores in Google Sheets using the population mean (μ, mu = 120) and population standard deviation (σ, sigma = 15).

Follow these steps:

Open the Google Sheet Template: Google Sheet Template
File → Make a copy.
Paste the table below into the sheet (two columns: Name and BP).
Use μ = 120 and σ = 15 to compute Z for each BP.
Formula hint: (B2 - μ)/σ. Here B2 means the first BP value in column B. After typing the formula in the first row, place your mouse on the small square in the bottom-right corner of the cell (the fill handle) and drag it down. The spreadsheet will automatically change B2 to B3 for the next row, then B4, and so on, so each patient's BP gets its own Z-score.
Pro Tip: Advanced users can highlight the formula cell and the rows below it, then press ⌘D (Mac) or Ctrl+D (Windows) to autofill the formula quickly.

Patient Name	Systolic BP (mmHg)
Alyaa	128
Dima	160
Emaad	82
Isaac	126
Leo	101
Nancy	117
Simranjit	140
Victoria	114

Question: Which named patient has a Z-score between -2 and -1 standard deviations?

Dima with a BP of 160 Incorrect Emaad with a BP of 82 Incorrect Leo with a BP of 101 Correct Simranjit with a BP of 140 Incorrect Victoria with a BP of 114 Incorrect MC

6939_503c

Purpose: Practice calculating Z-scores in Google Sheets using the population mean (μ, mu = 120) and population standard deviation (σ, sigma = 15).

Follow these steps:

Open the Google Sheet Template: Google Sheet Template
File → Make a copy.
Paste the table below into the sheet (two columns: Name and BP).
Use μ = 120 and σ = 15 to compute Z for each BP.
Formula hint: (B2 - μ)/σ. Here B2 means the first BP value in column B. After typing the formula in the first row, place your mouse on the small square in the bottom-right corner of the cell (the fill handle) and drag it down. The spreadsheet will automatically change B2 to B3 for the next row, then B4, and so on, so each patient's BP gets its own Z-score.
Pro Tip: Advanced users can highlight the formula cell and the rows below it, then press ⌘D (Mac) or Ctrl+D (Windows) to autofill the formula quickly.

Patient Name	Systolic BP (mmHg)
Anam	125
Berta	117
Christine	129
Grace	101
Kamil	85
Miraj	140
Neal	114
Rachna	156

Question: Which named patient has a Z-score between +1 and +2 standard deviations?

Anam with a BP of 125 Incorrect Berta with a BP of 117 Incorrect Kamil with a BP of 85 Incorrect Miraj with a BP of 140 Correct Rachna with a BP of 156 Incorrect MC

8bdd_fc03

Purpose: Practice calculating Z-scores in Google Sheets using the population mean (μ, mu = 120) and population standard deviation (σ, sigma = 15).

Follow these steps:

Open the Google Sheet Template: Google Sheet Template
File → Make a copy.
Paste the table below into the sheet (two columns: Name and BP).
Use μ = 120 and σ = 15 to compute Z for each BP.
Formula hint: (B2 - μ)/σ. Here B2 means the first BP value in column B. After typing the formula in the first row, place your mouse on the small square in the bottom-right corner of the cell (the fill handle) and drag it down. The spreadsheet will automatically change B2 to B3 for the next row, then B4, and so on, so each patient's BP gets its own Z-score.
Pro Tip: Advanced users can highlight the formula cell and the rows below it, then press ⌘D (Mac) or Ctrl+D (Windows) to autofill the formula quickly.

Patient Name	Systolic BP (mmHg)
Akila	127
Etny	119
Kelly	140
Milly	126
Oscar	156
Steve	101
Xavier	118
Yoana	87

Question: Which named patient has a Z-score between -2 and -1 standard deviations?

Etny with a BP of 119 Incorrect Oscar with a BP of 156 Incorrect Steve with a BP of 101 Correct Xavier with a BP of 118 Incorrect Yoana with a BP of 87 Incorrect MC

9494_2435

Purpose: Practice calculating Z-scores in Google Sheets using the population mean (μ, mu = 120) and population standard deviation (σ, sigma = 15).

Follow these steps:

Open the Google Sheet Template: Google Sheet Template
File → Make a copy.
Paste the table below into the sheet (two columns: Name and BP).
Use μ = 120 and σ = 15 to compute Z for each BP.
Formula hint: (B2 - μ)/σ. Here B2 means the first BP value in column B. After typing the formula in the first row, place your mouse on the small square in the bottom-right corner of the cell (the fill handle) and drag it down. The spreadsheet will automatically change B2 to B3 for the next row, then B4, and so on, so each patient's BP gets its own Z-score.
Pro Tip: Advanced users can highlight the formula cell and the rows below it, then press ⌘D (Mac) or Ctrl+D (Windows) to autofill the formula quickly.

Patient Name	Systolic BP (mmHg)
Abbie	77
Bhavani	111
Dwiti	152
Emmy	101
Iram	139
Kathryn	121
Neha	124
Rana	112

Question: Which named patient has a Z-score between -3 and -2 standard deviations?

Abbie with a BP of 77 Correct Bhavani with a BP of 111 Incorrect Dwiti with a BP of 152 Incorrect Emmy with a BP of 101 Incorrect Kathryn with a BP of 121 Incorrect MC

1cc5_2a86

Purpose: Practice calculating Z-scores in Google Sheets using the population mean (μ, mu = 120) and population standard deviation (σ, sigma = 15).

Follow these steps:

Open the Google Sheet Template: Google Sheet Template
File → Make a copy.
Paste the table below into the sheet (two columns: Name and BP).
Use μ = 120 and σ = 15 to compute Z for each BP.
Formula hint: (B2 - μ)/σ. Here B2 means the first BP value in column B. After typing the formula in the first row, place your mouse on the small square in the bottom-right corner of the cell (the fill handle) and drag it down. The spreadsheet will automatically change B2 to B3 for the next row, then B4, and so on, so each patient's BP gets its own Z-score.
Pro Tip: Advanced users can highlight the formula cell and the rows below it, then press ⌘D (Mac) or Ctrl+D (Windows) to autofill the formula quickly.

Patient Name	Systolic BP (mmHg)
Aditi	112
Felipe	78
Megan	128
Nur	139
Rudra	100
Shubham	126
Valbhi	160
Yash	112

Question: Which named patient has a Z-score between -2 and -1 standard deviations?

Aditi with a BP of 112 Incorrect Felipe with a BP of 78 Incorrect Megan with a BP of 128 Incorrect Rudra with a BP of 100 Correct Valbhi with a BP of 160 Incorrect MC

c09e_6b56

Purpose: Practice calculating Z-scores in Google Sheets using the population mean (μ, mu = 120) and population standard deviation (σ, sigma = 15).

Follow these steps:

Open the Google Sheet Template: Google Sheet Template
File → Make a copy.
Paste the table below into the sheet (two columns: Name and BP).
Use μ = 120 and σ = 15 to compute Z for each BP.
Formula hint: (B2 - μ)/σ. Here B2 means the first BP value in column B. After typing the formula in the first row, place your mouse on the small square in the bottom-right corner of the cell (the fill handle) and drag it down. The spreadsheet will automatically change B2 to B3 for the next row, then B4, and so on, so each patient's BP gets its own Z-score.
Pro Tip: Advanced users can highlight the formula cell and the rows below it, then press ⌘D (Mac) or Ctrl+D (Windows) to autofill the formula quickly.

Patient Name	Systolic BP (mmHg)
Adela	116
Ewa	84
Hasan	126
Jake	155
Karina	122
Nyah	139
Pegah	111
Sienna	100

Question: Which named patient has a Z-score between +2 and +3 standard deviations?

Ewa with a BP of 84 Incorrect Jake with a BP of 155 Correct Karina with a BP of 122 Incorrect Nyah with a BP of 139 Incorrect Sienna with a BP of 100 Incorrect MC

8b9d_6278

Purpose: Practice calculating Z-scores in Google Sheets using the population mean (μ, mu = 120) and population standard deviation (σ, sigma = 15).

Follow these steps:

Open the Google Sheet Template: Google Sheet Template
File → Make a copy.
Paste the table below into the sheet (two columns: Name and BP).
Use μ = 120 and σ = 15 to compute Z for each BP.
Formula hint: (B2 - μ)/σ. Here B2 means the first BP value in column B. After typing the formula in the first row, place your mouse on the small square in the bottom-right corner of the cell (the fill handle) and drag it down. The spreadsheet will automatically change B2 to B3 for the next row, then B4, and so on, so each patient's BP gets its own Z-score.
Pro Tip: Advanced users can highlight the formula cell and the rows below it, then press ⌘D (Mac) or Ctrl+D (Windows) to autofill the formula quickly.

Patient Name	Systolic BP (mmHg)
Brooke	118
Clinton	124
Dipali	155
Emaad	76
Hasena	100
KieuVi	115
Marta	122
Nirali	140

Question: Which named patient has a Z-score between -2 and -1 standard deviations?

Dipali with a BP of 155 Incorrect Emaad with a BP of 76 Incorrect Hasena with a BP of 100 Correct KieuVi with a BP of 115 Incorrect Nirali with a BP of 140 Incorrect MC

3b04_5a8f

Purpose: Practice calculating Z-scores in Google Sheets using the population mean (μ, mu = 120) and population standard deviation (σ, sigma = 15).

Follow these steps:

Open the Google Sheet Template: Google Sheet Template
File → Make a copy.
Paste the table below into the sheet (two columns: Name and BP).
Use μ = 120 and σ = 15 to compute Z for each BP.
Formula hint: (B2 - μ)/σ. Here B2 means the first BP value in column B. After typing the formula in the first row, place your mouse on the small square in the bottom-right corner of the cell (the fill handle) and drag it down. The spreadsheet will automatically change B2 to B3 for the next row, then B4, and so on, so each patient's BP gets its own Z-score.
Pro Tip: Advanced users can highlight the formula cell and the rows below it, then press ⌘D (Mac) or Ctrl+D (Windows) to autofill the formula quickly.

Patient Name	Systolic BP (mmHg)
Adam	157
Emily	101
Giovanni	118
Janet	140
Swati	117
Viral	85
Yusur	125
Zain	124

Question: Which named patient has a Z-score between +1 and +2 standard deviations?

Adam with a BP of 157 Incorrect Emily with a BP of 101 Incorrect Janet with a BP of 140 Correct Viral with a BP of 85 Incorrect Zain with a BP of 124 Incorrect MC

19d1_e75f

Purpose: Practice calculating Z-scores in Google Sheets using the population mean (μ, mu = 120) and population standard deviation (σ, sigma = 15).

Follow these steps:

Open the Google Sheet Template: Google Sheet Template
File → Make a copy.
Paste the table below into the sheet (two columns: Name and BP).
Use μ = 120 and σ = 15 to compute Z for each BP.
Formula hint: (B2 - μ)/σ. Here B2 means the first BP value in column B. After typing the formula in the first row, place your mouse on the small square in the bottom-right corner of the cell (the fill handle) and drag it down. The spreadsheet will automatically change B2 to B3 for the next row, then B4, and so on, so each patient's BP gets its own Z-score.
Pro Tip: Advanced users can highlight the formula cell and the rows below it, then press ⌘D (Mac) or Ctrl+D (Windows) to autofill the formula quickly.

Patient Name	Systolic BP (mmHg)
Adela	87
Cheryl	114
Dylan	125
Eva	139
Meleny	156
Nihar	119
Roxana	101
Serene	128

Question: Which named patient has a Z-score between -3 and -2 standard deviations?

Adela with a BP of 87 Correct Meleny with a BP of 156 Incorrect Nihar with a BP of 119 Incorrect Roxana with a BP of 101 Incorrect Serene with a BP of 128 Incorrect MC

d138_692c

Purpose: Practice calculating Z-scores in Google Sheets using the population mean (μ, mu = 120) and population standard deviation (σ, sigma = 15).

Follow these steps:

Open the Google Sheet Template: Google Sheet Template
File → Make a copy.
Paste the table below into the sheet (two columns: Name and BP).
Use μ = 120 and σ = 15 to compute Z for each BP.
Formula hint: (B2 - μ)/σ. Here B2 means the first BP value in column B. After typing the formula in the first row, place your mouse on the small square in the bottom-right corner of the cell (the fill handle) and drag it down. The spreadsheet will automatically change B2 to B3 for the next row, then B4, and so on, so each patient's BP gets its own Z-score.
Pro Tip: Advanced users can highlight the formula cell and the rows below it, then press ⌘D (Mac) or Ctrl+D (Windows) to autofill the formula quickly.

Patient Name	Systolic BP (mmHg)
Arielle	115
Braulio	128
Esmeralda	158
Jagoda	80
Kayla	117
Marylyn	139
Roshni	123
Scott	101

Question: Which named patient has a Z-score between +2 and +3 standard deviations?

Arielle with a BP of 115 Incorrect Braulio with a BP of 128 Incorrect Esmeralda with a BP of 158 Correct Jagoda with a BP of 80 Incorrect Marylyn with a BP of 139 Incorrect MC

214d_fc7b

Purpose: Practice calculating Z-scores in Google Sheets using the population mean (μ, mu = 120) and population standard deviation (σ, sigma = 15).

Follow these steps:

Open the Google Sheet Template: Google Sheet Template
File → Make a copy.
Paste the table below into the sheet (two columns: Name and BP).
Use μ = 120 and σ = 15 to compute Z for each BP.
Formula hint: (B2 - μ)/σ. Here B2 means the first BP value in column B. After typing the formula in the first row, place your mouse on the small square in the bottom-right corner of the cell (the fill handle) and drag it down. The spreadsheet will automatically change B2 to B3 for the next row, then B4, and so on, so each patient's BP gets its own Z-score.
Pro Tip: Advanced users can highlight the formula cell and the rows below it, then press ⌘D (Mac) or Ctrl+D (Windows) to autofill the formula quickly.

Patient Name	Systolic BP (mmHg)
Adam	139
Benie	119
Glenn	129
Jessica	83
Meaghan	127
Naba	160
Reham	111
Scott	100

Question: Which named patient has a Z-score between -2 and -1 standard deviations?

Jessica with a BP of 83 Incorrect Meaghan with a BP of 127 Incorrect Naba with a BP of 160 Incorrect Reham with a BP of 111 Incorrect Scott with a BP of 100 Correct MC

e1e2_00d5

Purpose: Practice calculating Z-scores in Google Sheets using the population mean (μ, mu = 120) and population standard deviation (σ, sigma = 15).

Follow these steps:

Open the Google Sheet Template: Google Sheet Template
File → Make a copy.
Paste the table below into the sheet (two columns: Name and BP).
Use μ = 120 and σ = 15 to compute Z for each BP.
Formula hint: (B2 - μ)/σ. Here B2 means the first BP value in column B. After typing the formula in the first row, place your mouse on the small square in the bottom-right corner of the cell (the fill handle) and drag it down. The spreadsheet will automatically change B2 to B3 for the next row, then B4, and so on, so each patient's BP gets its own Z-score.
Pro Tip: Advanced users can highlight the formula cell and the rows below it, then press ⌘D (Mac) or Ctrl+D (Windows) to autofill the formula quickly.

Patient Name	Systolic BP (mmHg)
Amy	112
Desaray	121
Kelly	139
Martin	77
Norhan	129
Rusul	161
Sienna	111
Tanitha	101

Question: Which named patient has a Z-score between -2 and -1 standard deviations?

Martin with a BP of 77 Incorrect Norhan with a BP of 129 Incorrect Rusul with a BP of 161 Incorrect Sienna with a BP of 111 Incorrect Tanitha with a BP of 101 Correct MC

e059_1dd0

Purpose: Practice calculating Z-scores in Google Sheets using the population mean (μ, mu = 120) and population standard deviation (σ, sigma = 15).

Follow these steps:

Open the Google Sheet Template: Google Sheet Template
File → Make a copy.
Paste the table below into the sheet (two columns: Name and BP).
Use μ = 120 and σ = 15 to compute Z for each BP.
Formula hint: (B2 - μ)/σ. Here B2 means the first BP value in column B. After typing the formula in the first row, place your mouse on the small square in the bottom-right corner of the cell (the fill handle) and drag it down. The spreadsheet will automatically change B2 to B3 for the next row, then B4, and so on, so each patient's BP gets its own Z-score.
Pro Tip: Advanced users can highlight the formula cell and the rows below it, then press ⌘D (Mac) or Ctrl+D (Windows) to autofill the formula quickly.

Patient Name	Systolic BP (mmHg)
Alissa	124
Eneo	119
Hilda	158
Jasmin	85
Liza	100
Nathi	119
Ramon	125
Stacie	139

Question: Which named patient has a Z-score between +2 and +3 standard deviations?

Hilda with a BP of 158 Correct Jasmin with a BP of 85 Incorrect Nathi with a BP of 119 Incorrect Ramon with a BP of 125 Incorrect Stacie with a BP of 139 Incorrect MC

bdd8_1a5b

Purpose: Practice calculating Z-scores in Google Sheets using the population mean (μ, mu = 120) and population standard deviation (σ, sigma = 15).

Follow these steps:

Open the Google Sheet Template: Google Sheet Template
File → Make a copy.
Paste the table below into the sheet (two columns: Name and BP).
Use μ = 120 and σ = 15 to compute Z for each BP.
Formula hint: (B2 - μ)/σ. Here B2 means the first BP value in column B. After typing the formula in the first row, place your mouse on the small square in the bottom-right corner of the cell (the fill handle) and drag it down. The spreadsheet will automatically change B2 to B3 for the next row, then B4, and so on, so each patient's BP gets its own Z-score.
Pro Tip: Advanced users can highlight the formula cell and the rows below it, then press ⌘D (Mac) or Ctrl+D (Windows) to autofill the formula quickly.

Patient Name	Systolic BP (mmHg)
Agnes	126
Claudia	115
Eleanor	100
Jocelyn	140
Krystsina	160
Liza	129
Mohammad	85
Sandy	118

Question: Which named patient has a Z-score between -2 and -1 standard deviations?

Agnes with a BP of 126 Incorrect Eleanor with a BP of 100 Correct Krystsina with a BP of 160 Incorrect Liza with a BP of 129 Incorrect Mohammad with a BP of 85 Incorrect MC

5c9a_7be9

Purpose: Practice calculating Z-scores in Google Sheets using the population mean (μ, mu = 120) and population standard deviation (σ, sigma = 15).

Follow these steps:

Open the Google Sheet Template: Google Sheet Template
File → Make a copy.
Paste the table below into the sheet (two columns: Name and BP).
Use μ = 120 and σ = 15 to compute Z for each BP.
Formula hint: (B2 - μ)/σ. Here B2 means the first BP value in column B. After typing the formula in the first row, place your mouse on the small square in the bottom-right corner of the cell (the fill handle) and drag it down. The spreadsheet will automatically change B2 to B3 for the next row, then B4, and so on, so each patient's BP gets its own Z-score.
Pro Tip: Advanced users can highlight the formula cell and the rows below it, then press ⌘D (Mac) or Ctrl+D (Windows) to autofill the formula quickly.

Patient Name	Systolic BP (mmHg)
Cory	122
Fadi	100
Isha	126
Jeffrey	84
Malcom	140
Rutvi	116
Sai	111
Tori	157

Question: Which named patient has a Z-score between +2 and +3 standard deviations?

Isha with a BP of 126 Incorrect Jeffrey with a BP of 84 Incorrect Malcom with a BP of 140 Incorrect Rutvi with a BP of 116 Incorrect Tori with a BP of 157 Correct