4c26_2d32

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	159
Bhargavi	100
Chanel	129
Daniella	125
Matthew	78
Nivedha	117
Sunana	139
Vishwa	114

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

Adela with a BP of 159 Incorrect Bhargavi with a BP of 100 Incorrect Daniella with a BP of 125 Incorrect Matthew with a BP of 78 Correct Sunana with a BP of 139 Incorrect MC

0418_2ac0

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	76
Derri	139
Eleanor	160
Greg	113
Hilda	115
Phylicia	129
Rebecca	128
Vikram	100

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

Aisha with a BP of 76 Incorrect Derri with a BP of 139 Correct Eleanor with a BP of 160 Incorrect Greg with a BP of 113 Incorrect Vikram with a BP of 100 Incorrect MC

0fce_05f6

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	122
Desaray	101
Isha	158
Jasmin	139
Meaghan	78
Ruchita	112
Samantha	122
Viral	111

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

Desaray with a BP of 101 Incorrect Isha with a BP of 158 Correct Jasmin with a BP of 139 Incorrect Meaghan with a BP of 78 Incorrect Viral with a BP of 111 Incorrect MC

dc48_bb72

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	114
Dulce	128
Jeel	114
Krystsina	86
Leila	139
Nyah	101
Rudra	127
Sabrina	161

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

Krystsina with a BP of 86 Correct Leila with a BP of 139 Incorrect Nyah with a BP of 101 Incorrect Rudra with a BP of 127 Incorrect Sabrina with a BP of 161 Incorrect MC

4dcc_a05e

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)
Annie	140
Cheryl	80
Glenn	100
Iram	128
Odalys	127
Riley	157
Sabrina	118
Vincent	113

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

Cheryl with a BP of 80 Incorrect Glenn with a BP of 100 Correct Riley with a BP of 157 Incorrect Sabrina with a BP of 118 Incorrect Vincent with a BP of 113 Incorrect MC

af06_586f

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)
Amanda	154
Clinton	139
Dana	127
Kristen	113
Mengtao	85
Rafiaa	122
Selena	101
Threada	113

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

Amanda with a BP of 154 Correct Clinton with a BP of 139 Incorrect Dana with a BP of 127 Incorrect Mengtao with a BP of 85 Incorrect Rafiaa with a BP of 122 Incorrect MC

91cc_3e16

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)
Abby	140
Doha	157
Jinalben	122
Max	111
Nihar	111
Ruchita	124
Tori	100
Zach	80

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

Abby with a BP of 140 Incorrect Doha with a BP of 157 Correct Jinalben with a BP of 122 Incorrect Nihar with a BP of 111 Incorrect Zach with a BP of 80 Incorrect MC

ea51_eee9

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	117
Collin	112
Danny	79
Katya	140
Mudrika	121
Nivedha	129
Oluwole	100
Sydney	155

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

Danny with a BP of 79 Incorrect Katya with a BP of 140 Incorrect Nivedha with a BP of 129 Incorrect Oluwole with a BP of 100 Correct Sydney with a BP of 155 Incorrect MC

ec1a_6ef0

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)
Beatrice	140
Dylan	125
Edgar	115
Grace	83
Janet	122
Kirk	113
Riley	100
Sabrina	160

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

Beatrice with a BP of 140 Incorrect Grace with a BP of 83 Incorrect Kirk with a BP of 113 Incorrect Riley with a BP of 100 Incorrect Sabrina with a BP of 160 Correct MC

8b21_3596

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)
Ashley	153
Grace	140
Hasena	117
Jeanette	125
Martha	100
Naheda	86
Ola	128
Shubham	112

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

Ashley with a BP of 153 Incorrect Grace with a BP of 140 Correct Martha with a BP of 100 Incorrect Naheda with a BP of 86 Incorrect Ola with a BP of 128 Incorrect MC

3bab_87f9

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)
Afreen	155
Brenda	118
Chanel	140
Darcelle	126
Faryal	115
Meleny	78
Nicole	101
Pegah	123

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

Afreen with a BP of 155 Incorrect Darcelle with a BP of 126 Incorrect Faryal with a BP of 115 Incorrect Meleny with a BP of 78 Incorrect Nicole with a BP of 101 Correct MC

9c9d_eb73

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)
Amtur	87
Dominique	118
Hiba	118
Katie	153
Praveena	139
Ruchi	125
Sthefani	101
Zakira	122

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

Amtur with a BP of 87 Incorrect Dominique with a BP of 118 Incorrect Hiba with a BP of 118 Incorrect Katie with a BP of 153 Correct Praveena with a BP of 139 Incorrect MC

c3c3_270f

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	122
Dao	112
Jekaria	118
Leo	139
Maggie	84
Raqib	101
Sandy	125
Yash	157

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

Alissa with a BP of 122 Incorrect Jekaria with a BP of 118 Incorrect Leo with a BP of 139 Correct Maggie with a BP of 84 Incorrect Yash with a BP of 157 Incorrect MC

a2b0_b345

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	126
Bhakti	155
Etny	77
Foram	112
Meghan	139
Pooja	122
Xavier	100
Yushi	113

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

Bhakti with a BP of 155 Correct Etny with a BP of 77 Incorrect Meghan with a BP of 139 Incorrect Xavier with a BP of 100 Incorrect Yushi with a BP of 113 Incorrect MC

a451_fc7a

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)
Cassandra	100
Dongjin	127
Etny	85
Giovanni	123
Jocelyn	139
Kyle	113
Tanitha	153
Vishwa	116

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

Cassandra with a BP of 100 Incorrect Etny with a BP of 85 Incorrect Jocelyn with a BP of 139 Incorrect Tanitha with a BP of 153 Correct Vishwa with a BP of 116 Incorrect MC

ec8f_976d

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)
Derri	160
Hamida	140
Iram	118
Joel	125
Katelyn	78
Rubina	122
Stefania	100
Yushi	117

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

Derri with a BP of 160 Incorrect Hamida with a BP of 140 Incorrect Joel with a BP of 125 Incorrect Katelyn with a BP of 78 Correct Stefania with a BP of 100 Incorrect MC

9241_ea89

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	156
Cyarra	140
Dipali	84
Hilda	113
Jasveen	125
Maryam	100
Shal	123
Yash	111

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

Ankit with a BP of 156 Incorrect Cyarra with a BP of 140 Correct Dipali with a BP of 84 Incorrect Hilda with a BP of 113 Incorrect Yash with a BP of 111 Incorrect MC

5b2e_9413

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)
Firdose	82
Jeffrey	100
Khulan	113
Nicholas	126
Rikita	139
Swati	123
Threada	112
Zuby	157

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

Firdose with a BP of 82 Incorrect Jeffrey with a BP of 100 Incorrect Khulan with a BP of 113 Incorrect Rikita with a BP of 139 Correct Zuby with a BP of 157 Incorrect MC

9901_3451

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)
Francisco	123
Hammad	115
Janet	140
Kiki	161
Marianne	116
Pravalika	100
Rosanna	122
Swati	78

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

Hammad with a BP of 115 Incorrect Janet with a BP of 140 Correct Kiki with a BP of 161 Incorrect Rosanna with a BP of 122 Incorrect Swati with a BP of 78 Incorrect MC

3cd4_097b

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)
Abhishak	139
Erika	81
Jeanette	126
Kelly	101
Maria	153
Patrycja	122
Sunya	115
Tori	114

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

Erika with a BP of 81 Correct Kelly with a BP of 101 Incorrect Maria with a BP of 153 Incorrect Sunya with a BP of 115 Incorrect Tori with a BP of 114 Incorrect MC

e95b_012c

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)
Danny	113
Jasveen	140
Kenny	122
Lupe	100
Miraj	124
Sabrina	113
Toni	87
Yusur	161

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

Danny with a BP of 113 Incorrect Kenny with a BP of 122 Incorrect Lupe with a BP of 100 Correct Toni with a BP of 87 Incorrect Yusur with a BP of 161 Incorrect MC

597c_c335

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	139
Beatrice	158
Dulce	116
Erick	127
Justin	112
Liz	101
Noelle	126
Reyna	77

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

Beatrice with a BP of 158 Incorrect Dulce with a BP of 116 Incorrect Erick with a BP of 127 Incorrect Liz with a BP of 101 Incorrect Reyna with a BP of 77 Correct MC

c429_e834

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	86
Desaray	121
Elexis	117
Gina	100
Henry	126
Mihir	161
Preet	139
Sarah	118

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

Brooke with a BP of 86 Incorrect Elexis with a BP of 117 Incorrect Gina with a BP of 100 Incorrect Mihir with a BP of 161 Correct Preet with a BP of 139 Incorrect MC

9cd2_de0f

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	128
Braulio	78
Deanna	118
Lindita	122
Mary	140
Nathi	159
Shalini	101
Yomara	114

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

Abbie with a BP of 128 Incorrect Braulio with a BP of 78 Incorrect Lindita with a BP of 122 Incorrect Mary with a BP of 140 Incorrect Nathi with a BP of 159 Correct MC

2e4c_03f8

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)
Benie	115
Devarsh	123
Jhelam	139
Katie	118
Lauren	100
Milly	153
Roxana	87
Yomara	129

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

Benie with a BP of 115 Incorrect Jhelam with a BP of 139 Incorrect Katie with a BP of 118 Incorrect Milly with a BP of 153 Correct Roxana with a BP of 87 Incorrect MC

b135_bc1e

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	157
Claudia	121
Dishank	139
Hiba	114
Itzel	79
Miriam	129
Rachel	114
Sierra	100

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

Amy with a BP of 157 Incorrect Dishank with a BP of 139 Correct Hiba with a BP of 114 Incorrect Itzel with a BP of 79 Incorrect Miriam with a BP of 129 Incorrect MC

0e8b_3e37

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)
Bhakti	153
Deena	101
Helenna	129
Jaylene	117
Melissa	117
Preet	125
Rubina	86
Sunana	139

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

Bhakti with a BP of 153 Incorrect Deena with a BP of 101 Incorrect Jaylene with a BP of 117 Incorrect Preet with a BP of 125 Incorrect Rubina with a BP of 86 Correct MC

4d42_fff2

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)
Chrissy	140
Jake	154
Matt	123
Nate	121
Praveena	101
Richa	85
Shubham	115
Therese	111

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

Chrissy with a BP of 140 Incorrect Jake with a BP of 154 Incorrect Nate with a BP of 121 Incorrect Praveena with a BP of 101 Incorrect Richa with a BP of 85 Correct MC

c369_4cb8

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	84
Cynthia	161
Jennifer	139
Krystyna	118
Nur	124
Raqib	115
Shailja	123
Theresa	101

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

Ankit with a BP of 84 Incorrect Cynthia with a BP of 161 Correct Jennifer with a BP of 139 Incorrect Nur with a BP of 124 Incorrect Shailja with a BP of 123 Incorrect MC

e7a7_e5a4

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)
Abby	101
Boong	159
Emmy	79
Henry	115
Justin	140
Owais	123
Randa	117
Sthefani	127

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

Abby with a BP of 101 Incorrect Boong with a BP of 159 Correct Emmy with a BP of 79 Incorrect Justin with a BP of 140 Incorrect Sthefani with a BP of 127 Incorrect MC

5501_8d40

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)
Brittni	113
Dlen	119
Joy	122
Lauren	100
Maricarmen	122
Nirali	139
Simoni	81
Tanitha	161

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

Dlen with a BP of 119 Incorrect Lauren with a BP of 100 Incorrect Maricarmen with a BP of 122 Incorrect Simoni with a BP of 81 Correct Tanitha with a BP of 161 Incorrect MC

ffde_6ce7

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)
Amanda	140
Chris	161
Harin	116
Jayasurya	126
Mackenzye	117
Simranjit	85
Tricia	101
Urszula	129

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

Chris with a BP of 161 Incorrect Harin with a BP of 116 Incorrect Simranjit with a BP of 85 Incorrect Tricia with a BP of 101 Correct Urszula with a BP of 129 Incorrect MC

68ea_f417

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)
Aashi	125
Dwiti	139
Emmy	117
Hasan	100
Kareem	86
Nirali	157
Ramon	129
Yoana	114

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

Aashi with a BP of 125 Incorrect Hasan with a BP of 100 Correct Kareem with a BP of 86 Incorrect Nirali with a BP of 157 Incorrect Yoana with a BP of 114 Incorrect MC

a98d_dfbf

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	81
Bianca	100
Conor	117
Jasveen	126
Luis	111
Melissa	159
Norhan	139
Shifa	128

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

Arielle with a BP of 81 Incorrect Bianca with a BP of 100 Incorrect Melissa with a BP of 159 Correct Norhan with a BP of 139 Incorrect Shifa with a BP of 128 Incorrect MC

d7bf_bc44

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	83
Devarsh	100
Gina	121
Isaac	116
Justin	139
Malcom	126
Nathickshi	154
Rhea	115

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

Cory with a BP of 83 Incorrect Devarsh with a BP of 100 Incorrect Justin with a BP of 139 Incorrect Malcom with a BP of 126 Incorrect Nathickshi with a BP of 154 Correct MC

d7d8_81e2

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	123
Cody	113
Joss	79
Rutvi	100
Sabrina	117
Tatiana	127
Vibhuti	140
Yomara	161

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

Cody with a BP of 113 Incorrect Joss with a BP of 79 Incorrect Rutvi with a BP of 100 Correct Sabrina with a BP of 117 Incorrect Yomara with a BP of 161 Incorrect MC

0eb8_aba6

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	129
Dao	122
Jennifer	116
Kendrick	158
Maryam	82
Shivam	114
Vincent	101
Yash	140

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

Dao with a BP of 122 Incorrect Kendrick with a BP of 158 Correct Maryam with a BP of 82 Incorrect Vincent with a BP of 101 Incorrect Yash with a BP of 140 Incorrect MC

0ca2_123a

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	85
Claudia	129
Malcom	117
Richa	140
Suna	113
Tatiana	158
Viral	100
kushil	123

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

Allyson with a BP of 85 Incorrect Claudia with a BP of 129 Incorrect Richa with a BP of 140 Correct Tatiana with a BP of 158 Incorrect kushil with a BP of 123 Incorrect MC

7d9d_3604

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)
Ashur	122
Brittnie	81
Chanel	159
Gloria	112
Joslyn	129
Katherine	113
Orlando	101
Swathi	139

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

Ashur with a BP of 122 Incorrect Brittnie with a BP of 81 Correct Chanel with a BP of 159 Incorrect Gloria with a BP of 112 Incorrect Orlando with a BP of 101 Incorrect MC

7c8d_6c1e

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)
Bridget	115
Haneef	101
Justin	129
Miko	129
Robert	81
Salman	155
Uzma	114
Yuritzy	139

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

Bridget with a BP of 115 Incorrect Haneef with a BP of 101 Incorrect Robert with a BP of 81 Incorrect Salman with a BP of 155 Correct Yuritzy with a BP of 139 Incorrect MC

4710_6f3f

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	101
Dishank	140
Elexis	124
Fasiha	113
Jinalben	87
Meleny	160
Neal	127
Sheba	111

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

Dishank with a BP of 140 Correct Jinalben with a BP of 87 Incorrect Meleny with a BP of 160 Incorrect Neal with a BP of 127 Incorrect Sheba with a BP of 111 Incorrect MC

d389_b7bf

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	101
Bharat	81
Clinton	139
Darcelle	153
Ivette	127
Jagoda	114
Khushbu	112
Mitali	128

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

Amarjeet with a BP of 101 Incorrect Bharat with a BP of 81 Correct Clinton with a BP of 139 Incorrect Darcelle with a BP of 153 Incorrect Khushbu with a BP of 112 Incorrect MC

6039_2f71

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)
Deena	161
Falak	122
Janelle	100
Mike	126
Nathi	140
Roxanne	114
Sid	112
Vanessa	81

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

Deena with a BP of 161 Incorrect Janelle with a BP of 100 Incorrect Nathi with a BP of 140 Correct Roxanne with a BP of 114 Incorrect Vanessa with a BP of 81 Incorrect MC

d6a5_58fc

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)
Brenda	114
Conor	126
Greg	139
Hetul	161
Ivette	112
Kirk	79
Matt	101
Rulaa	129

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

Conor with a BP of 126 Incorrect Hetul with a BP of 161 Incorrect Kirk with a BP of 79 Incorrect Matt with a BP of 101 Correct Rulaa with a BP of 129 Incorrect MC

b9d2_0cc6

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	160
Danielle	139
Isabela	100
Meaghan	116
Nausheen	111
Pegah	76
Roshni	125
Tatiana	129

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

Agnes with a BP of 160 Incorrect Danielle with a BP of 139 Incorrect Isabela with a BP of 100 Correct Pegah with a BP of 76 Incorrect Roshni with a BP of 125 Incorrect MC

cae9_c634

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)
Anne	127
Gloria	159
Helenna	123
Jane	100
Myda	113
Nancy	114
Sunana	86
Veda	139

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

Gloria with a BP of 159 Correct Helenna with a BP of 123 Incorrect Jane with a BP of 100 Incorrect Sunana with a BP of 86 Incorrect Veda with a BP of 139 Incorrect MC

8ddc_fe21

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)
Berta	114
Cody	156
Giovanni	122
Lakshmidhar	100
Mudra	140
Ramon	124
Sunana	86
Valbhi	119

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

Cody with a BP of 156 Incorrect Lakshmidhar with a BP of 100 Incorrect Ramon with a BP of 124 Incorrect Sunana with a BP of 86 Correct Valbhi with a BP of 119 Incorrect MC

389f_ab0b

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	126
Dima	119
Foramben	139
Isaac	156
Jeanette	118
Kaushal	126
Mit	100
Suchi	87

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

Alyaa with a BP of 126 Incorrect Foramben with a BP of 139 Incorrect Isaac with a BP of 156 Incorrect Mit with a BP of 100 Incorrect Suchi with a BP of 87 Correct MC

6de5_d7df

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	123
Brinda	115
Claudia	128
Errol	160
Maryam	100
Neha	113
Riya	76
Tayo	140

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

Brinda with a BP of 115 Incorrect Errol with a BP of 160 Incorrect Neha with a BP of 113 Incorrect Riya with a BP of 76 Incorrect Tayo with a BP of 140 Correct MC

4400_e3ed

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)
Christine	114
Dominique	76
Krystsina	124
Luis	160
Morgan	100
Oscar	119
Shivam	122
Toni	140

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

Dominique with a BP of 76 Incorrect Luis with a BP of 160 Correct Oscar with a BP of 119 Incorrect Shivam with a BP of 122 Incorrect Toni with a BP of 140 Incorrect MC

22fd_2159

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)
Cassandra	79
Darcelle	140
Jinal	156
Kunbi	126
Noelle	116
Priya	100
Sarah	117
Yusur	124

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

Cassandra with a BP of 79 Incorrect Darcelle with a BP of 140 Incorrect Jinal with a BP of 156 Correct Priya with a BP of 100 Incorrect Yusur with a BP of 124 Incorrect MC

31a3_3a48

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)
Alexis	85
Brianna	161
Chirag	123
Danielle	100
Husna	116
Karolina	124
Lucy	139
Raseal	115

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

Alexis with a BP of 85 Incorrect Brianna with a BP of 161 Incorrect Chirag with a BP of 123 Incorrect Danielle with a BP of 100 Correct Karolina with a BP of 124 Incorrect MC

d56c_3109

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	139
Eric	101
Irum	114
Kayleigh	121
Leslie	156
Mike	117
Skylar	82
Yoana	128

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

Amtul with a BP of 139 Correct Kayleigh with a BP of 121 Incorrect Leslie with a BP of 156 Incorrect Skylar with a BP of 82 Incorrect Yoana with a BP of 128 Incorrect MC

f2fa_6f32

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	129
Chirag	139
Hasena	80
Jackie	100
Kayleigh	115
Rachel	123
Stefany	112
Uzair	160

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

Anupam with a BP of 129 Incorrect Chirag with a BP of 139 Incorrect Hasena with a BP of 80 Incorrect Jackie with a BP of 100 Correct Uzair with a BP of 160 Incorrect MC

678a_d27a

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	117
Bhargavi	128
Etny	114
Henry	140
Jhinal	81
Maryam	100
Shubham	159
Vikram	129

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

Alyssa with a BP of 117 Incorrect Bhargavi with a BP of 128 Incorrect Henry with a BP of 140 Correct Jhinal with a BP of 81 Incorrect Shubham with a BP of 159 Incorrect MC

819c_6a98

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)
Arinola	118
Brianna	122
Daminik	140
Ivette	126
Robert	100
Shaheryar	87
Tanitha	119
Veda	157

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

Arinola with a BP of 118 Incorrect Brianna with a BP of 122 Incorrect Robert with a BP of 100 Incorrect Shaheryar with a BP of 87 Correct Veda with a BP of 157 Incorrect MC

4ea0_5ead

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	81
Brittnie	129
Hamida	114
Jinalben	113
Kenny	153
Mudrika	125
Nicole	139
Suna	101

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

Abbie with a BP of 81 Incorrect Brittnie with a BP of 129 Incorrect Hamida with a BP of 114 Incorrect Kenny with a BP of 153 Correct Nicole with a BP of 139 Incorrect MC

76c1_495e

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)
Anna	158
Cee	129
Desaray	80
Francisco	140
Kirk	123
Lakshmidhar	116
Saagar	100
Threada	114

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

Anna with a BP of 158 Incorrect Cee with a BP of 129 Incorrect Desaray with a BP of 80 Incorrect Lakshmidhar with a BP of 116 Incorrect Saagar with a BP of 100 Correct MC

65fc_61be

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)
Anna	118
Bhargavi	114
Cynthia	85
Fadi	123
Jinalben	159
Kiki	101
Leslie	122
Praveena	139

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

Bhargavi with a BP of 114 Incorrect Cynthia with a BP of 85 Incorrect Jinalben with a BP of 159 Incorrect Kiki with a BP of 101 Correct Leslie with a BP of 122 Incorrect MC

5051_0373

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)
Audrey	77
Curtis	139
Ewa	119
Fadi	117
Hilary	100
Lindita	161
Olivia	125
Sarah	122

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

Audrey with a BP of 77 Incorrect Fadi with a BP of 117 Incorrect Hilary with a BP of 100 Correct Lindita with a BP of 161 Incorrect Sarah with a BP of 122 Incorrect MC

d76d_e4a1

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)
Afreen	153
Bao	115
Harika	140
Irene	76
Kaushal	128
Leila	118
Orlando	128
Shrara	100

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

Afreen with a BP of 153 Incorrect Harika with a BP of 140 Incorrect Irene with a BP of 76 Incorrect Kaushal with a BP of 128 Incorrect Shrara with a BP of 100 Correct MC

c8ed_c999

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	121
Clarke	140
Eleanor	84
Maggie	100
Priya	161
Rikita	115
Stacie	124
Vrutti	116

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

Clarke with a BP of 140 Incorrect Eleanor with a BP of 84 Incorrect Maggie with a BP of 100 Incorrect Priya with a BP of 161 Correct Vrutti with a BP of 116 Incorrect MC

e512_d115

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)
Bhavini	100
Chirag	125
Freny	123
Guangyuan	110
Jennifer	140
Samantha	152
Therese	112
Zach	76

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

Bhavini with a BP of 100 Incorrect Chirag with a BP of 125 Incorrect Guangyuan with a BP of 110 Incorrect Samantha with a BP of 152 Incorrect Zach with a BP of 76 Correct MC

222d_d912

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)
Hailey	115
Justin	122
Lakshmidhar	112
Madalyn	125
Nur	139
Rulaa	101
Theresa	154
Vincent	81

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

Justin with a BP of 122 Incorrect Madalyn with a BP of 125 Incorrect Rulaa with a BP of 101 Correct Theresa with a BP of 154 Incorrect Vincent with a BP of 81 Incorrect MC

7452_13ec

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)
Audrey	154
Cierra	124
Dhruvi	101
Eunice	125
Hailey	116
Madalyn	77
Riley	139
Suchi	112

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

Audrey with a BP of 154 Incorrect Dhruvi with a BP of 101 Incorrect Madalyn with a BP of 77 Incorrect Riley with a BP of 139 Correct Suchi with a BP of 112 Incorrect MC

1aa2_81b6

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
Bharat	139
Foramben	82
Jeanette	113
Kayleigh	128
Miranda	112
Stacy	155
Toni	125

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

Angelica with a BP of 101 Correct Bharat with a BP of 139 Incorrect Foramben with a BP of 82 Incorrect Jeanette with a BP of 113 Incorrect Stacy with a BP of 155 Incorrect MC

c271_cb6b

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	111
Chirag	81
Daisy	100
Firdose	114
Mudrika	156
Nathickshi	122
Raul	125
Sowmya	139

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

Allyson with a BP of 111 Incorrect Chirag with a BP of 81 Correct Daisy with a BP of 100 Incorrect Firdose with a BP of 114 Incorrect Mudrika with a BP of 156 Incorrect MC

5660_54aa

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	79
Danielle	155
Eleanor	111
Grace	101
Kirstin	123
Mariyam	126
Shal	139
Xavier	112

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

Akila with a BP of 79 Incorrect Danielle with a BP of 155 Incorrect Grace with a BP of 101 Correct Mariyam with a BP of 126 Incorrect Shal with a BP of 139 Incorrect MC

062a_a1b7

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)
Abhishak	101
Berta	115
Gokce	130
Jenna	123
Kiki	115
Rubina	140
Tori	160
Vanessa	87

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

Abhishak with a BP of 101 Incorrect Berta with a BP of 115 Incorrect Gokce with a BP of 130 Incorrect Tori with a BP of 160 Incorrect Vanessa with a BP of 87 Correct MC

72e8_1d28

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)
Aashi	114
Berta	123
Elizabeth	100
Jasmine	154
Leo	115
Marianne	140
Nate	86
Sandy	127

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

Berta with a BP of 123 Incorrect Elizabeth with a BP of 100 Correct Jasmine with a BP of 154 Incorrect Leo with a BP of 115 Incorrect Nate with a BP of 86 Incorrect MC

ba45_ba91

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)
Cynthia	157
Hasena	121
Jigna	126
Kayla	113
Lee	101
Mariyam	83
Raul	139
Shahaan	112

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

Cynthia with a BP of 157 Incorrect Jigna with a BP of 126 Incorrect Lee with a BP of 101 Incorrect Mariyam with a BP of 83 Incorrect Raul with a BP of 139 Correct MC

c11d_8461

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)
Awais	154
Curtis	116
Dalal	127
Joslyn	100
Monika	140
Neha	77
Sthefani	121
Yoana	118

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

Awais with a BP of 154 Incorrect Joslyn with a BP of 100 Incorrect Monika with a BP of 140 Incorrect Neha with a BP of 77 Correct Sthefani with a BP of 121 Incorrect MC

8c53_d251

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)
Bansi	115
Charonda	100
Daniella	126
Mohammed	113
Nur	155
Rudra	140
Sydney	129
Victoria	85

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

Bansi with a BP of 115 Incorrect Charonda with a BP of 100 Incorrect Nur with a BP of 155 Correct Rudra with a BP of 140 Incorrect Victoria with a BP of 85 Incorrect MC

445c_7f92

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	156
Cheryl	119
Dishank	100
Khushbu	83
Marianne	128
Noel	139
Patrycja	125
Shaheryar	118

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

Anam with a BP of 156 Correct Cheryl with a BP of 119 Incorrect Dishank with a BP of 100 Incorrect Khushbu with a BP of 83 Incorrect Noel with a BP of 139 Incorrect MC

d753_ce11

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)
Brittnie	139
Erika	111
Miko	156
Patty	125
Raseal	84
Sarah	101
Theresa	114
Vincent	122

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

Brittnie with a BP of 139 Incorrect Miko with a BP of 156 Correct Raseal with a BP of 84 Incorrect Theresa with a BP of 114 Incorrect Vincent with a BP of 122 Incorrect MC

6eb9_8ddf

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)
Brinn	80
Eric	124
Kenza	101
Madalyn	139
Pravalika	113
Radhika	158
Shal	111
Yamini	125

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

Brinn with a BP of 80 Correct Kenza with a BP of 101 Incorrect Pravalika with a BP of 113 Incorrect Radhika with a BP of 158 Incorrect Yamini with a BP of 125 Incorrect MC

febb_5930

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	115
Edgar	80
Jennifer	100
Luis	116
Omar	123
Praveena	124
Toni	139
Vikram	156

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

Edgar with a BP of 80 Correct Jennifer with a BP of 100 Incorrect Luis with a BP of 116 Incorrect Omar with a BP of 123 Incorrect Vikram with a BP of 156 Incorrect MC

779e_89d2

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	101
Dhruvi	114
Firdose	139
Harriet	112
Olivia	125
Rhea	85
Silvana	129
Tempie	153

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

Adam with a BP of 101 Incorrect Dhruvi with a BP of 114 Incorrect Olivia with a BP of 125 Incorrect Rhea with a BP of 85 Correct Tempie with a BP of 153 Incorrect MC

3c5c_be4f

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)
Bharat	77
Caleigh	127
Het	160
Katelyn	129
Mit	113
Neal	140
Swati	116
Zakira	100

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

Bharat with a BP of 77 Incorrect Het with a BP of 160 Incorrect Neal with a BP of 140 Incorrect Swati with a BP of 116 Incorrect Zakira with a BP of 100 Correct MC

38eb_b1b0

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	100
Clinton	140
Denise	118
Eunice	113
Kenza	127
Mansi	161
Oluwole	77
Saagar	123

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

Clinton with a BP of 140 Incorrect Kenza with a BP of 127 Incorrect Mansi with a BP of 161 Correct Oluwole with a BP of 77 Incorrect Saagar with a BP of 123 Incorrect MC

4338_d068

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)
Arinola	140
Daniella	160
Francisco	127
Hassan	101
Jeel	118
Mudrika	123
Oluwole	81
Sejal	117

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

Arinola with a BP of 140 Correct Daniella with a BP of 160 Incorrect Francisco with a BP of 127 Incorrect Mudrika with a BP of 123 Incorrect Oluwole with a BP of 81 Incorrect MC

0996_4b80

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	114
Deena	121
Jamilla	140
Krystsina	124
Mary	101
Rob	153
Shadi	85
Yash	117

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

Akila with a BP of 114 Incorrect Mary with a BP of 101 Incorrect Rob with a BP of 153 Incorrect Shadi with a BP of 85 Correct Yash with a BP of 117 Incorrect MC

ae8f_7376

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)
Amanda	78
Dipali	140
Itzel	123
Kayleigh	101
Mengtao	111
Noel	157
Shivam	125
Yusur	114

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

Amanda with a BP of 78 Incorrect Dipali with a BP of 140 Incorrect Mengtao with a BP of 111 Incorrect Noel with a BP of 157 Correct Yusur with a BP of 114 Incorrect MC

ac08_4b54

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)
Alexis	127
Dongjin	101
Jasmine	156
Kenza	83
Liza	129
Rob	114
Simranjit	116
Vincent	139

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

Alexis with a BP of 127 Incorrect Jasmine with a BP of 156 Incorrect Kenza with a BP of 83 Incorrect Rob with a BP of 114 Incorrect Vincent with a BP of 139 Correct MC

20ae_b21c

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)
Breanne	117
Daniella	140
Harriet	101
Jhinal	124
Mayank	157
Rikita	85
Sam	123
Vraj	115

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

Harriet with a BP of 101 Incorrect Jhinal with a BP of 124 Incorrect Mayank with a BP of 157 Incorrect Rikita with a BP of 85 Correct Vraj with a BP of 115 Incorrect MC

511e_2765

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	140
Denise	112
Eunbi	129
Gokce	100
Jeffrey	77
Misbah	113
Oluwole	127
Simoni	154

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

Alyssa with a BP of 140 Incorrect Jeffrey with a BP of 77 Incorrect Misbah with a BP of 113 Incorrect Oluwole with a BP of 127 Incorrect Simoni with a BP of 154 Correct MC

d127_300b

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)
Ashley	154
Cassandra	122
Devarsh	139
Flor	78
Liza	121
Meaghan	112
Rosanna	117
Shivam	100

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

Ashley with a BP of 154 Incorrect Cassandra with a BP of 122 Incorrect Flor with a BP of 78 Incorrect Liza with a BP of 121 Incorrect Shivam with a BP of 100 Correct MC

0319_94f1

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	127
Dan	157
Hanan	140
Jeremiah	101
Meaghan	129
Nivedha	114
Rutuja	81
Toni	110

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

Dan with a BP of 157 Incorrect Jeremiah with a BP of 101 Incorrect Meaghan with a BP of 129 Incorrect Rutuja with a BP of 81 Correct Toni with a BP of 110 Incorrect MC

7e24_36c3

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)
Anna	127
Bharat	87
Clarke	161
Jayasurya	140
Melissa	111
Noelle	116
Stephanie	100
Vishwa	128

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

Anna with a BP of 127 Incorrect Bharat with a BP of 87 Correct Clarke with a BP of 161 Incorrect Melissa with a BP of 111 Incorrect Stephanie with a BP of 100 Incorrect MC

35ad_fe9e

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	79
Grace	123
Ivanna	112
Mudrika	140
Qazi	112
Sabrina	129
Whitney	101
Yash	161

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

Amtul with a BP of 79 Incorrect Grace with a BP of 123 Incorrect Mudrika with a BP of 140 Incorrect Whitney with a BP of 101 Incorrect Yash with a BP of 161 Correct MC

0854_a188

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	123
Bharat	101
Freny	123
Hiba	80
Jagoda	115
Roshni	140
Stefany	116
Yash	154

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

Bharat with a BP of 101 Incorrect Freny with a BP of 123 Incorrect Hiba with a BP of 80 Correct Roshni with a BP of 140 Incorrect Yash with a BP of 154 Incorrect MC

2d1d_0dff

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)
Amya	124
Darcelle	117
Ivette	161
Joy	118
Manan	123
Raul	101
Threada	139
Umang	80

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

Darcelle with a BP of 117 Incorrect Ivette with a BP of 161 Incorrect Manan with a BP of 123 Incorrect Raul with a BP of 101 Incorrect Umang with a BP of 80 Correct MC

9df5_86d3

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	101
Caitlyn	76
Emaad	123
Gavin	140
Maryam	156
Roxanne	124
Uzma	113
Vishwa	111

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

Caitlyn with a BP of 76 Incorrect Emaad with a BP of 123 Incorrect Gavin with a BP of 140 Incorrect Maryam with a BP of 156 Correct Roxanne with a BP of 124 Incorrect MC

c3ef_9a87

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)
Aicha	124
Desaray	100
Jinalben	127
Kathryn	160
Nick	140
Odalys	116
Sunya	114
Therese	82

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

Desaray with a BP of 100 Incorrect Kathryn with a BP of 160 Incorrect Nick with a BP of 140 Correct Odalys with a BP of 116 Incorrect Therese with a BP of 82 Incorrect MC

687b_be3d

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
Hamida	156
Isabel	100
Jasmine	140
Meghan	87
Rita	124
Serene	121
Toni	116

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

Hamida with a BP of 156 Incorrect Isabel with a BP of 100 Incorrect Meghan with a BP of 87 Correct Serene with a BP of 121 Incorrect Toni with a BP of 116 Incorrect MC

f51b_9073

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)
Chris	140
Dao	80
Erika	113
Gloria	100
Jhelam	129
Kimberly	111
Lisa	128
Salume	154

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

Chris with a BP of 140 Incorrect Dao with a BP of 80 Correct Gloria with a BP of 100 Incorrect Lisa with a BP of 128 Incorrect Salume with a BP of 154 Incorrect MC

6410_d71b

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	100
Clinton	157
Dishank	129
Kelly	114
Rudmine	129
Shal	140
Vishal	76
Yoana	114

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

Clinton with a BP of 157 Correct Dishank with a BP of 129 Incorrect Rudmine with a BP of 129 Incorrect Shal with a BP of 140 Incorrect Vishal with a BP of 76 Incorrect MC

bc33_5b17

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)
Alishah	100
Cassandra	85
Freny	139
Kher	114
Marta	153
Nancy	123
Rana	128
Shifa	112

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

Alishah with a BP of 100 Incorrect Cassandra with a BP of 85 Correct Kher with a BP of 114 Incorrect Marta with a BP of 153 Incorrect Shifa with a BP of 112 Incorrect MC

ca2c_b388

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)
Amanda	139
Chirag	100
Joy	84
Karla	121
Myda	118
Naheda	123
Steve	112
Tayo	160

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

Amanda with a BP of 139 Incorrect Joy with a BP of 84 Incorrect Myda with a BP of 118 Incorrect Steve with a BP of 112 Incorrect Tayo with a BP of 160 Correct MC

1844_6e8a

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	117
Bianca	100
Ewa	155
Julia	118
Mehul	127
Nausheen	140
Robert	122
Simranjit	88

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

Amtul with a BP of 117 Incorrect Ewa with a BP of 155 Incorrect Nausheen with a BP of 140 Correct Robert with a BP of 122 Incorrect Simranjit with a BP of 88 Incorrect MC

6c82_a150

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	126
Braulio	115
Heather	112
Roxanne	156
Skylar	139
Tom	126
Victoria	100
Yushi	86

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

Heather with a BP of 112 Incorrect Roxanne with a BP of 156 Correct Skylar with a BP of 139 Incorrect Victoria with a BP of 100 Incorrect Yushi with a BP of 86 Incorrect MC

3175_1b1e

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	114
Cassandra	123
Falak	86
Jennifer	154
Mireya	124
Nick	118
Siobhan	101
Yoana	139

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

Cassandra with a BP of 123 Incorrect Falak with a BP of 86 Incorrect Jennifer with a BP of 154 Incorrect Mireya with a BP of 124 Incorrect Siobhan with a BP of 101 Correct MC

aee8_f9e3

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	123
Emaad	117
Glenn	140
Hilda	85
Luke	154
Matthew	100
Nate	129
Stefany	112

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

Adela with a BP of 123 Incorrect Glenn with a BP of 140 Incorrect Hilda with a BP of 85 Incorrect Luke with a BP of 154 Correct Stefany with a BP of 112 Incorrect MC

5934_d25e

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)
Ava	112
Dana	154
Foram	77
Jinalben	139
Martin	100
Pal	126
Stacy	115
Tricia	129

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

Ava with a BP of 112 Incorrect Dana with a BP of 154 Incorrect Foram with a BP of 77 Incorrect Jinalben with a BP of 139 Incorrect Martin with a BP of 100 Correct MC

f4f7_0105

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)
Atish	121
Faryal	128
Kavya	100
Marta	118
Nihar	87
Ramon	157
Sonam	139
Urszula	118

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

Kavya with a BP of 100 Incorrect Marta with a BP of 118 Incorrect Nihar with a BP of 87 Incorrect Ramon with a BP of 157 Correct Sonam with a BP of 139 Incorrect MC

1def_e5c4

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)
Daisy	117
Firdose	123
Jay	140
Kyron	100
Lakshmidhar	84
Meleny	112
Rhea	154
Shailja	124

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

Firdose with a BP of 123 Incorrect Jay with a BP of 140 Incorrect Kyron with a BP of 100 Incorrect Lakshmidhar with a BP of 84 Correct Rhea with a BP of 154 Incorrect MC

b2a7_dea0

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)
Asmita	111
Cyarra	139
Daisy	126
Krupa	157
Mengtao	101
Orlando	116
Sonali	78
Toni	127

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

Cyarra with a BP of 139 Incorrect Krupa with a BP of 157 Incorrect Mengtao with a BP of 101 Correct Orlando with a BP of 116 Incorrect Sonali with a BP of 78 Incorrect MC

80d1_68e6

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)
Ashley	126
Bhargavi	112
Dominique	154
Foram	139
Hafsa	115
Kingsley	77
Sam	100
Vishwa	128

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

Dominique with a BP of 154 Incorrect Hafsa with a BP of 115 Incorrect Kingsley with a BP of 77 Correct Sam with a BP of 100 Incorrect Vishwa with a BP of 128 Incorrect MC

5039_a02d

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	121
Bansi	83
Hailey	156
Katherine	140
Laura	112
Mayank	117
Nate	100
Roshni	121

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

Armela with a BP of 121 Incorrect Bansi with a BP of 83 Correct Hailey with a BP of 156 Incorrect Nate with a BP of 100 Incorrect Roshni with a BP of 121 Incorrect MC

66d8_0b3f

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	139
Giovanni	126
Het	100
Jayasurya	126
Kirstin	82
Rubina	114
Samiyah	112
Yuritzy	159

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

Alyaa with a BP of 139 Incorrect Kirstin with a BP of 82 Incorrect Rubina with a BP of 114 Incorrect Samiyah with a BP of 112 Incorrect Yuritzy with a BP of 159 Correct MC

40cb_28f2

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	139
Boong	100
Clifton	127
Gavin	115
Jessica	122
Kunbi	114
Najmeh	156
Rachna	77

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

Boong with a BP of 100 Incorrect Clifton with a BP of 127 Incorrect Gavin with a BP of 115 Incorrect Najmeh with a BP of 156 Incorrect Rachna with a BP of 77 Correct MC

eded_756e

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	128
Berta	112
Dulce	140
Francisco	156
Jeffrey	125
Kamil	114
Nausheen	101
Ramon	78

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

Dulce with a BP of 140 Incorrect Francisco with a BP of 156 Correct Jeffrey with a BP of 125 Incorrect Kamil with a BP of 114 Incorrect Ramon with a BP of 78 Incorrect MC

8f97_113d

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)
Alishah	116
Clarke	111
Freny	156
Jagoda	87
KieuVi	140
Molly	100
Rosanna	123
Saja	127

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

Clarke with a BP of 111 Incorrect Freny with a BP of 156 Correct Jagoda with a BP of 87 Incorrect KieuVi with a BP of 140 Incorrect Rosanna with a BP of 123 Incorrect MC

f375_086d

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)
Benie	140
Gloria	160
Jeel	111
Kyron	100
Leonardo	115
Mitali	121
Rulaa	85
Sandy	127

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

Gloria with a BP of 160 Incorrect Kyron with a BP of 100 Incorrect Leonardo with a BP of 115 Incorrect Rulaa with a BP of 85 Correct Sandy with a BP of 127 Incorrect MC

4cb1_a357

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)
Annie	100
Cynthia	160
Fasiha	128
Joslyn	129
Leonardo	115
Mehul	111
Rosanna	84
Yomara	140

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

Annie with a BP of 100 Incorrect Cynthia with a BP of 160 Incorrect Fasiha with a BP of 128 Incorrect Rosanna with a BP of 84 Incorrect Yomara with a BP of 140 Correct MC

4c2d_a8a5

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)
Audrey	113
Diamond	114
Hilda	85
Irum	121
Jeffrey	100
Mit	155
Neal	126
Vishwa	140

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

Diamond with a BP of 114 Incorrect Hilda with a BP of 85 Incorrect Irum with a BP of 121 Incorrect Mit with a BP of 155 Incorrect Vishwa with a BP of 140 Correct MC

f88a_04f5

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)
Aysun	129
Caitlyn	158
Daniella	116
Jackie	119
Myda	86
Omar	128
Prachi	139
Tanitha	100

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

Caitlyn with a BP of 158 Correct Jackie with a BP of 119 Incorrect Myda with a BP of 86 Incorrect Prachi with a BP of 139 Incorrect Tanitha with a BP of 100 Incorrect MC

2627_f620

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	100
Bilal	118
Dhruvi	115
Jeel	140
Mit	78
Robert	124
Tania	124
Vishwa	157

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

Anupam with a BP of 100 Correct Bilal with a BP of 118 Incorrect Mit with a BP of 78 Incorrect Tania with a BP of 124 Incorrect Vishwa with a BP of 157 Incorrect MC

b63e_84a3

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)
Darcelle	117
Francisco	111
Jhelam	154
Mudrika	140
Nancy	126
Sienna	81
Tempie	101
Vishal	123

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

Jhelam with a BP of 154 Incorrect Mudrika with a BP of 140 Incorrect Sienna with a BP of 81 Correct Tempie with a BP of 101 Incorrect Vishal with a BP of 123 Incorrect MC

f6d8_feed

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)
Caitlyn	127
Divya	101
Etny	83
Firdose	115
Jullisa	160
Kaushal	140
Maria	124
Rob	115

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

Divya with a BP of 101 Correct Etny with a BP of 83 Incorrect Firdose with a BP of 115 Incorrect Jullisa with a BP of 160 Incorrect Maria with a BP of 124 Incorrect MC

b1c8_e41f

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)
Arinola	118
Giovanni	116
Isha	101
Kendrick	139
Tori	127
Uzair	161
Veda	81
Yushi	125

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

Giovanni with a BP of 116 Incorrect Isha with a BP of 101 Incorrect Tori with a BP of 127 Incorrect Uzair with a BP of 161 Incorrect Veda with a BP of 81 Correct MC

8601_e8a7

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)
Einas	117
Firdose	79
Jeremiah	139
Mengtao	111
Rulaa	156
Sumee	124
Urszula	124
Yushi	101

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

Einas with a BP of 117 Incorrect Firdose with a BP of 79 Incorrect Jeremiah with a BP of 139 Incorrect Rulaa with a BP of 156 Incorrect Yushi with a BP of 101 Correct MC

41d2_b415

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)
Berta	78
Cedric	122
Isha	124
Jennifer	119
Pravalika	101
Ravikumar	140
Sthefani	160
Tanitha	111

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

Berta with a BP of 78 Incorrect Isha with a BP of 124 Incorrect Pravalika with a BP of 101 Correct Ravikumar with a BP of 140 Incorrect Sthefani with a BP of 160 Incorrect MC

622d_cdfd

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)
Ava	101
Cory	128
Dwiti	86
Eric	140
Jeffrey	160
Krupa	118
Medard	124
Nihar	116

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

Ava with a BP of 101 Incorrect Dwiti with a BP of 86 Correct Eric with a BP of 140 Incorrect Jeffrey with a BP of 160 Incorrect Nihar with a BP of 116 Incorrect MC

fd14_5e55

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)
Ahmed	86
Chenyu	100
Gloria	111
Harriet	127
Kamil	114
Leonardo	127
Matt	154
Salume	140

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

Ahmed with a BP of 86 Correct Chenyu with a BP of 100 Incorrect Gloria with a BP of 111 Incorrect Leonardo with a BP of 127 Incorrect Matt with a BP of 154 Incorrect MC

b923_d26b

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)
Charonda	100
Danny	139
Fasiha	119
Harriet	111
Molly	160
Nnenna	126
Rob	129
Sabaa	81

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

Charonda with a BP of 100 Incorrect Danny with a BP of 139 Incorrect Harriet with a BP of 111 Incorrect Molly with a BP of 160 Correct Sabaa with a BP of 81 Incorrect MC

dd8a_c099

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)
Alexis	122
Elexis	101
Hasena	125
Krystyna	113
Nathi	117
Rubina	160
Saagar	139
Tanitha	84

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

Elexis with a BP of 101 Incorrect Krystyna with a BP of 113 Incorrect Nathi with a BP of 117 Incorrect Rubina with a BP of 160 Incorrect Tanitha with a BP of 84 Correct MC

3168_4bd8

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	158
Doha	122
Firdose	84
Joel	121
Nina	140
Rubina	112
Stacie	100
Whitney	116

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

Ankit with a BP of 158 Incorrect Firdose with a BP of 84 Incorrect Nina with a BP of 140 Correct Rubina with a BP of 112 Incorrect Stacie with a BP of 100 Incorrect MC

18ff_8eae

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	154
Calah	117
Dongjin	129
Karen	85
Noelle	123
Roxanne	112
Shahd	100
Vikram	139

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

Allyson with a BP of 154 Incorrect Dongjin with a BP of 129 Incorrect Karen with a BP of 85 Incorrect Shahd with a BP of 100 Correct Vikram with a BP of 139 Incorrect MC

9c50_a110

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	127
Eunice	129
Flor	117
Ibrahim	101
Janelle	117
Marylyn	78
Raul	139
Shail	160

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

Eunice with a BP of 129 Incorrect Ibrahim with a BP of 101 Incorrect Marylyn with a BP of 78 Correct Raul with a BP of 139 Incorrect Shail with a BP of 160 Incorrect MC

d4ab_2c65

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)
Angela	140
Jaylene	80
Khushbu	119
Mohammed	156
Nina	117
Praveena	101
Rutuja	127
Vikram	127

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

Jaylene with a BP of 80 Correct Khushbu with a BP of 119 Incorrect Mohammed with a BP of 156 Incorrect Nina with a BP of 117 Incorrect Praveena with a BP of 101 Incorrect MC

9665_4f7f

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)
Collin	101
Hasena	111
Jennifer	139
Kyron	80
Meleny	129
Rikita	129
Sonia	112
Yamini	161

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

Collin with a BP of 101 Incorrect Hasena with a BP of 111 Incorrect Jennifer with a BP of 139 Incorrect Kyron with a BP of 80 Incorrect Yamini with a BP of 161 Correct MC

0faf_8599

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)
Doha	124
Erick	139
Jannela	100
KieuVi	84
Meghan	158
Nina	112
Riddhi	113
Uzair	122

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

Erick with a BP of 139 Incorrect Jannela with a BP of 100 Incorrect KieuVi with a BP of 84 Correct Meghan with a BP of 158 Incorrect Riddhi with a BP of 113 Incorrect MC

636e_ac80

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	115
Dana	139
Irum	77
Jayline	100
Krystsina	155
Ozzie	126
Pooja	113
Shubham	129

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

Akila with a BP of 115 Incorrect Dana with a BP of 139 Incorrect Irum with a BP of 77 Incorrect Jayline with a BP of 100 Incorrect Krystsina with a BP of 155 Correct MC

a395_fe1c

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)
Bhakti	140
Cody	116
Devarsh	77
Firdose	111
Guangyuan	159
Matt	126
Riya	101
Shubham	128

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

Bhakti with a BP of 140 Correct Devarsh with a BP of 77 Incorrect Firdose with a BP of 111 Incorrect Guangyuan with a BP of 159 Incorrect Shubham with a BP of 128 Incorrect MC

9b72_bc8d

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)
Braulio	157
Doha	125
Harriet	83
Kenza	100
Laura	122
Randa	140
Salman	113
Vraj	112

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

Braulio with a BP of 157 Incorrect Harriet with a BP of 83 Correct Kenza with a BP of 100 Incorrect Laura with a BP of 122 Incorrect Randa with a BP of 140 Incorrect MC

24f9_3d64

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	124
Brittnie	140
Dao	111
Hareem	154
Melissa	85
Patrycja	112
Sabrina	101
Viral	124

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

Brittnie with a BP of 140 Correct Dao with a BP of 111 Incorrect Hareem with a BP of 154 Incorrect Melissa with a BP of 85 Incorrect Patrycja with a BP of 112 Incorrect MC

c743_0dc2

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)
Atish	123
Dana	119
Erick	123
Grace	78
Katya	100
Misbah	160
Ola	112
Yusur	140

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

Erick with a BP of 123 Incorrect Grace with a BP of 78 Correct Katya with a BP of 100 Incorrect Misbah with a BP of 160 Incorrect Ola with a BP of 112 Incorrect MC

2a70_7a1f

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)
Ashley	86
Chenyu	125
Dwiti	123
Felipe	101
Hammad	115
Nirali	112
Rubina	154
Valbhi	139

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

Ashley with a BP of 86 Incorrect Chenyu with a BP of 125 Incorrect Hammad with a BP of 115 Incorrect Rubina with a BP of 154 Correct Valbhi with a BP of 139 Incorrect MC

33fb_52b9

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)
Ava	78
Curtis	125
Hareem	126
Krystsina	116
Norhan	119
Sabaa	158
Uzma	100
Vanessa	139

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

Ava with a BP of 78 Incorrect Norhan with a BP of 119 Incorrect Sabaa with a BP of 158 Incorrect Uzma with a BP of 100 Correct Vanessa with a BP of 139 Incorrect MC

3c72_b144

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)
Chanel	139
Errol	122
Hilda	101
Mit	158
Najmeh	76
Phylicia	115
Raul	111
Simranjit	123

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

Chanel with a BP of 139 Incorrect Hilda with a BP of 101 Incorrect Mit with a BP of 158 Correct Najmeh with a BP of 76 Incorrect Raul with a BP of 111 Incorrect MC

70eb_9d25

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)
April	140
Bhakti	159
Darcelle	79
Haneef	124
Jake	111
Kyle	100
Rikita	123
Sowmya	111

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

April with a BP of 140 Correct Bhakti with a BP of 159 Incorrect Darcelle with a BP of 79 Incorrect Kyle with a BP of 100 Incorrect Sowmya with a BP of 111 Incorrect MC

1732_67e4

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)
Eddie	100
Hilary	139
Jackie	111
Kelly	124
Megan	84
Odalys	159
Pooja	123
Stefania	111

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

Hilary with a BP of 139 Correct Jackie with a BP of 111 Incorrect Kelly with a BP of 124 Incorrect Megan with a BP of 84 Incorrect Odalys with a BP of 159 Incorrect MC

b654_a172

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)
Amtur	101
Calah	139
Jeffrey	158
Kiki	116
Leonardo	121
Mohammed	118
Sabrina	80
Veda	129

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

Amtur with a BP of 101 Correct Jeffrey with a BP of 158 Incorrect Kiki with a BP of 116 Incorrect Mohammed with a BP of 118 Incorrect Sabrina with a BP of 80 Incorrect MC

20b0_cf01

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)
Courtney	160
Dongjin	139
Foram	129
Janet	82
Kristen	117
Priya	100
Stefania	114
Tania	128

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

Courtney with a BP of 160 Incorrect Dongjin with a BP of 139 Correct Janet with a BP of 82 Incorrect Priya with a BP of 100 Incorrect Tania with a BP of 128 Incorrect MC

22a7_fc6a

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)
Aubrey	126
Brooke	115
Harnish	139
Jackie	158
Katelyn	127
Monika	111
Riya	100
Themarr	77

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

Aubrey with a BP of 126 Incorrect Harnish with a BP of 139 Incorrect Jackie with a BP of 158 Correct Katelyn with a BP of 127 Incorrect Themarr with a BP of 77 Incorrect MC

3e37_4d34

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)
Aye	140
Dhruvi	113
Eunbi	117
Hetul	127
Jasmin	80
Katherine	154
Richa	100
Shal	129

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

Eunbi with a BP of 117 Incorrect Jasmin with a BP of 80 Incorrect Katherine with a BP of 154 Incorrect Richa with a BP of 100 Correct Shal with a BP of 129 Incorrect MC

2528_449c

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	116
Berta	114
Jacob	100
Lupe	128
Michael	161
Stacie	129
Whitney	140
Zach	81

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

Arturo with a BP of 116 Incorrect Berta with a BP of 114 Incorrect Jacob with a BP of 100 Incorrect Michael with a BP of 161 Incorrect Zach with a BP of 81 Correct MC

d380_25e2

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)
Abdul	128
Elexis	119
Jagoda	139
Kenny	114
Magdalena	153
Ryan	122
Siobhan	101
Vikram	78

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

Elexis with a BP of 119 Incorrect Jagoda with a BP of 139 Incorrect Magdalena with a BP of 153 Incorrect Siobhan with a BP of 101 Incorrect Vikram with a BP of 78 Correct MC

7829_bced

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)
Aria	115
Brittni	121
Janelle	116
Lucy	80
Mitali	139
Nur	158
Oscar	129
Robert	101

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

Aria with a BP of 115 Incorrect Lucy with a BP of 80 Incorrect Mitali with a BP of 139 Incorrect Nur with a BP of 158 Correct Robert with a BP of 101 Incorrect MC

6269_0bcd

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)
Amaya	128
Grace	111
Helenna	160
Isabela	124
Jeremiah	140
Lana	100
Mayank	88
Selena	112

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

Amaya with a BP of 128 Incorrect Helenna with a BP of 160 Correct Jeremiah with a BP of 140 Incorrect Lana with a BP of 100 Incorrect Mayank with a BP of 88 Incorrect MC

a5f7_0925

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)
Ashur	140
Brooke	83
Christine	113
Irene	121
Lana	110
Oscar	158
Rachna	100
Sid	129

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

Ashur with a BP of 140 Incorrect Brooke with a BP of 83 Correct Lana with a BP of 110 Incorrect Oscar with a BP of 158 Incorrect Rachna with a BP of 100 Incorrect MC

3dca_3e83

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	125
Boong	86
Freny	112
Jocelyn	153
Krupa	121
Marianne	140
Omar	117
Ryan	101

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

Boong with a BP of 86 Incorrect Jocelyn with a BP of 153 Correct Krupa with a BP of 121 Incorrect Marianne with a BP of 140 Incorrect Omar with a BP of 117 Incorrect MC

ecd3_951f

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)
Bharat	100
Dominique	129
Emmy	159
Katelyn	115
Mikhail	112
Nina	129
Sunya	139
Vincent	83

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

Bharat with a BP of 100 Incorrect Dominique with a BP of 129 Incorrect Emmy with a BP of 159 Correct Sunya with a BP of 139 Incorrect Vincent with a BP of 83 Incorrect MC

22e2_1796

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	76
Brinn	126
Dalal	100
Giovanni	140
Hilda	112
Kirstin	158
Leila	126
Salman	116

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

Agnes with a BP of 76 Incorrect Brinn with a BP of 126 Incorrect Dalal with a BP of 100 Correct Giovanni with a BP of 140 Incorrect Kirstin with a BP of 158 Incorrect MC

dbc8_6193

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)
Aashi	139
Gavin	130
Harin	113
Kiara	113
Mary	86
Rutuja	100
Shraddha	152
Vamshi	124

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

Aashi with a BP of 139 Correct Kiara with a BP of 113 Incorrect Mary with a BP of 86 Incorrect Rutuja with a BP of 100 Incorrect Shraddha with a BP of 152 Incorrect MC

de07_fc2e

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	140
Bilal	100
Jayasurya	84
Kiara	129
Michael	125
Riddhi	153
Scott	113
Yoana	117

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

Bilal with a BP of 100 Correct Jayasurya with a BP of 84 Incorrect Riddhi with a BP of 153 Incorrect Scott with a BP of 113 Incorrect Yoana with a BP of 117 Incorrect MC

afe1_f516

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)
Amber	116
Dana	129
Etny	159
Haneef	84
Karina	101
Mounisha	129
Noura	139
Shaheryar	112

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

Etny with a BP of 159 Incorrect Haneef with a BP of 84 Incorrect Karina with a BP of 101 Incorrect Noura with a BP of 139 Correct Shaheryar with a BP of 112 Incorrect MC

70c4_5abe

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)
Anna	78
Felipe	115
Kyron	154
Najmeh	124
Orlando	124
Sthefani	100
Vamshi	115
Yoana	139

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

Anna with a BP of 78 Incorrect Kyron with a BP of 154 Incorrect Najmeh with a BP of 124 Incorrect Vamshi with a BP of 115 Incorrect Yoana with a BP of 139 Correct MC

54c3_bf77

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	117
Brittni	78
Ewa	128
Faryal	125
Isha	114
Jigna	140
Najmeh	154
Vanessa	100

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

Alona with a BP of 117 Incorrect Brittni with a BP of 78 Incorrect Ewa with a BP of 128 Incorrect Najmeh with a BP of 154 Incorrect Vanessa with a BP of 100 Correct MC

fcde_c069

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)
Brittany	155
Dima	111
Hiba	139
Kirstin	84
Manan	111
Olivia	101
Riddhi	121
Shaheryar	124

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

Brittany with a BP of 155 Correct Hiba with a BP of 139 Incorrect Kirstin with a BP of 84 Incorrect Manan with a BP of 111 Incorrect Olivia with a BP of 101 Incorrect MC

6852_5f28

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)
Akshay	139
Bhargavi	157
Caitlyn	112
Falak	126
Oluwole	88
Rhea	123
Silvana	100
Vraj	111

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

Akshay with a BP of 139 Correct Bhargavi with a BP of 157 Incorrect Oluwole with a BP of 88 Incorrect Rhea with a BP of 123 Incorrect Silvana with a BP of 100 Incorrect MC

8199_daa0

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)
Arinola	122
Deanna	140
Luke	116
Mansi	153
Noel	79
Phylicia	101
Randy	113
Swathi	125

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

Luke with a BP of 116 Incorrect Mansi with a BP of 153 Incorrect Noel with a BP of 79 Correct Phylicia with a BP of 101 Incorrect Randy with a BP of 113 Incorrect MC

9662_c603

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)
Aysun	159
Esmeralda	140
Jayline	118
Karina	129
Mounisha	122
Najmeh	101
Preet	116
Veronica	79

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

Aysun with a BP of 159 Incorrect Mounisha with a BP of 122 Incorrect Najmeh with a BP of 101 Correct Preet with a BP of 116 Incorrect Veronica with a BP of 79 Incorrect MC

a0be_4ab7

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	117
Caitlyn	140
Danielle	153
Irene	122
Leslie	112
Mihai	100
Sowmya	76
Yamini	129

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

Agnes with a BP of 117 Incorrect Caitlyn with a BP of 140 Incorrect Danielle with a BP of 153 Correct Sowmya with a BP of 76 Incorrect Yamini with a BP of 129 Incorrect MC

69f5_b65a

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)
Daminik	77
Emaad	113
Khulan	128
Lauren	124
Mariyam	159
Nirali	101
Perla	140
Rory	118

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

Daminik with a BP of 77 Correct Emaad with a BP of 113 Incorrect Khulan with a BP of 128 Incorrect Mariyam with a BP of 159 Incorrect Nirali with a BP of 101 Incorrect MC

fe9f_4bcf

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)
Curtis	84
Dongjin	152
Heather	127
Jamie	119
Katya	100
Medard	124
Ola	140
Stephanie	118

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

Curtis with a BP of 84 Incorrect Dongjin with a BP of 152 Incorrect Heather with a BP of 127 Incorrect Medard with a BP of 124 Incorrect Ola with a BP of 140 Correct MC

512a_55bf

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)
Anjali	121
Clarke	82
Esmeralda	127
Jocelyn	101
Krupa	161
Liza	117
Maggie	140
Norhan	112

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

Anjali with a BP of 121 Incorrect Clarke with a BP of 82 Incorrect Jocelyn with a BP of 101 Correct Krupa with a BP of 161 Incorrect Liza with a BP of 117 Incorrect MC

24a4_cecb

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)
Brittany	155
Einas	122
Falak	76
Hareem	128
Liz	100
Norhan	139
Raseal	111
Sai	115

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

Brittany with a BP of 155 Correct Einas with a BP of 122 Incorrect Falak with a BP of 76 Incorrect Liz with a BP of 100 Incorrect Norhan with a BP of 139 Incorrect MC

3d0b_939c

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)
Antonia	100
Dishank	117
Jannela	125
Luke	121
Matt	140
Rory	116
Siobhan	154
Yuritzy	84

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

Jannela with a BP of 125 Incorrect Luke with a BP of 121 Incorrect Matt with a BP of 140 Incorrect Siobhan with a BP of 154 Correct Yuritzy with a BP of 84 Incorrect MC

46ce_bf2b

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)
Abby	139
Cory	128
Freny	100
Hilda	76
Kyron	111
Patty	161
Sowmya	128
Zach	111

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

Cory with a BP of 128 Incorrect Freny with a BP of 100 Correct Hilda with a BP of 76 Incorrect Patty with a BP of 161 Incorrect Sowmya with a BP of 128 Incorrect MC

aacc_4451

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)
Bhavini	124
Clarke	85
Karolina	111
Lora	101
Meghan	128
Naheda	139
Syeda	111
Urszula	156

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

Clarke with a BP of 85 Incorrect Karolina with a BP of 111 Incorrect Naheda with a BP of 139 Correct Syeda with a BP of 111 Incorrect Urszula with a BP of 156 Incorrect MC

6d07_923f

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	139
Claudia	160
Dylan	100
Hilda	78
Itzel	117
Miguel	126
Nihar	124
Prit	114

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

Claudia with a BP of 160 Incorrect Dylan with a BP of 100 Incorrect Hilda with a BP of 78 Correct Itzel with a BP of 117 Incorrect Nihar with a BP of 124 Incorrect MC

429e_4cbb

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)
Akshay	101
Brandon	85
Heydi	124
Jay	117
Karina	156
Odalys	140
Perla	115
Sierra	124

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

Akshay with a BP of 101 Incorrect Brandon with a BP of 85 Incorrect Heydi with a BP of 124 Incorrect Karina with a BP of 156 Incorrect Odalys with a BP of 140 Correct MC

95f9_bce3

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)
Alishah	139
Dan	101
Erick	157
Glenn	84
Hamida	124
Mit	113
Owais	129
Siobhan	115

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

Alishah with a BP of 139 Incorrect Erick with a BP of 157 Correct Glenn with a BP of 84 Incorrect Mit with a BP of 113 Incorrect Siobhan with a BP of 115 Incorrect MC

8c0b_5416

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	128
Braulio	111
Chenyu	100
Grant	86
KieuVi	139
Rana	112
Tori	121
Yash	158

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

Chenyu with a BP of 100 Incorrect Grant with a BP of 86 Incorrect KieuVi with a BP of 139 Correct Rana with a BP of 112 Incorrect Yash with a BP of 158 Incorrect MC

c179_af43

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)
Amaya	128
Dwiti	86
Falak	139
Harriet	111
Irene	101
Kher	128
Odalys	159
Stefania	118

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

Dwiti with a BP of 86 Correct Falak with a BP of 139 Incorrect Harriet with a BP of 111 Incorrect Irene with a BP of 101 Incorrect Odalys with a BP of 159 Incorrect MC

24b0_12e5

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	84
Greg	100
Madalyn	125
Prachi	118
Randa	112
Tyson	125
Vanessa	153
Yuritzy	139

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

Anthony with a BP of 84 Correct Greg with a BP of 100 Incorrect Tyson with a BP of 125 Incorrect Vanessa with a BP of 153 Incorrect Yuritzy with a BP of 139 Incorrect MC

f976_637a

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)
Ashur	111
Guangyuan	124
Husna	124
Jenna	100
Kamil	111
Patrycja	160
Victoria	140
Whitney	84

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

Ashur with a BP of 111 Incorrect Jenna with a BP of 100 Correct Kamil with a BP of 111 Incorrect Patrycja with a BP of 160 Incorrect Whitney with a BP of 84 Incorrect MC

d7a9_7890

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	127
Brenda	116
Ivanna	155
Joel	140
Kher	79
Lakshmidhar	115
Prit	129
Srilatha	101

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

Ivanna with a BP of 155 Incorrect Joel with a BP of 140 Incorrect Kher with a BP of 79 Correct Prit with a BP of 129 Incorrect Srilatha with a BP of 101 Incorrect MC

8e03_fc90

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)
Anne	139
Desaray	101
Etny	153
Miriam	111
Rita	128
Sreeksha	128
Whitney	85
Yusur	119

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

Anne with a BP of 139 Incorrect Desaray with a BP of 101 Correct Etny with a BP of 153 Incorrect Rita with a BP of 128 Incorrect Whitney with a BP of 85 Incorrect MC

0cfb_96b3

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)
Brittany	128
George	125
Hammad	77
Laura	153
Nathi	113
Phylicia	116
Rebecca	140
Tori	101

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

George with a BP of 125 Incorrect Hammad with a BP of 77 Incorrect Laura with a BP of 153 Correct Nathi with a BP of 113 Incorrect Rebecca with a BP of 140 Incorrect MC

2a64_6f01

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)
Ashley	101
Chrissy	140
Dishank	123
Francisco	111
Janet	124
Mayank	153
Scott	113
Yushi	83

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

Chrissy with a BP of 140 Correct Francisco with a BP of 111 Incorrect Janet with a BP of 124 Incorrect Mayank with a BP of 153 Incorrect Yushi with a BP of 83 Incorrect MC

1a32_fcd8

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)
Ashur	139
Eunbi	100
Jocelyn	124
Krupa	118
Meghan	87
Olivia	118
Richa	124
Saagar	154

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

Eunbi with a BP of 100 Incorrect Jocelyn with a BP of 124 Incorrect Meghan with a BP of 87 Correct Richa with a BP of 124 Incorrect Saagar with a BP of 154 Incorrect MC

b80e_8ff0

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	125
Errol	76
Kingsley	156
Maricarmen	100
Norhan	125
Shail	139
Therese	116
Veronica	111

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

Errol with a BP of 76 Correct Kingsley with a BP of 156 Incorrect Maricarmen with a BP of 100 Incorrect Norhan with a BP of 125 Incorrect Shail with a BP of 139 Incorrect MC

8a57_6c07

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)
Abby	111
Clarke	122
Greg	129
Hilda	76
Ibrahim	100
Kunbi	113
Rubina	153
Saty	140

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

Greg with a BP of 129 Incorrect Hilda with a BP of 76 Correct Ibrahim with a BP of 100 Incorrect Rubina with a BP of 153 Incorrect Saty with a BP of 140 Incorrect MC

2de3_3e7b

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	140
Dlen	128
Jasveen	159
Kingsley	100
Lora	111
Praveena	113
Rutuja	124
Steve	79

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

Agnes with a BP of 140 Incorrect Dlen with a BP of 128 Incorrect Jasveen with a BP of 159 Incorrect Kingsley with a BP of 100 Incorrect Steve with a BP of 79 Correct MC

8ae3_cdc0

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	112
Etny	126
Foram	124
Grace	139
Molly	77
Rebecca	153
Tatiana	100
Vamshi	115

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

Etny with a BP of 126 Incorrect Grace with a BP of 139 Correct Molly with a BP of 77 Incorrect Rebecca with a BP of 153 Incorrect Vamshi with a BP of 115 Incorrect MC

0188_91d5

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)
Aashi	127
Curtis	117
Eric	123
Jinalben	154
Kimberly	85
Naheda	115
Ruchi	101
Silvana	140

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

Aashi with a BP of 127 Incorrect Curtis with a BP of 117 Incorrect Jinalben with a BP of 154 Incorrect Kimberly with a BP of 85 Incorrect Silvana with a BP of 140 Correct MC

47e0_11b5

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	101
Danielle	123
Giovanni	115
Hailey	83
Rob	112
Shraddha	140
Toni	156
kushil	123

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

Alex with a BP of 101 Correct Hailey with a BP of 83 Incorrect Shraddha with a BP of 140 Incorrect Toni with a BP of 156 Incorrect kushil with a BP of 123 Incorrect MC

7ffe_bb04

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)
Aatiqa	159
Devarsh	140
Jay	117
Madalyn	125
Ola	113
Sreeksha	129
Theresa	100
Yuritzy	80

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

Aatiqa with a BP of 159 Correct Devarsh with a BP of 140 Incorrect Jay with a BP of 117 Incorrect Theresa with a BP of 100 Incorrect Yuritzy with a BP of 80 Incorrect MC

891b_279b

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	156
Foramben	101
Hafsa	114
Jocelyn	79
Khushi	140
Mansi	115
Sony	128
Valbhi	121

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

Alyaa with a BP of 156 Incorrect Foramben with a BP of 101 Correct Jocelyn with a BP of 79 Incorrect Khushi with a BP of 140 Incorrect Sony with a BP of 128 Incorrect MC

6e15_6802

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	153
Elizabeth	115
Jinalben	100
Kimberly	85
Lupe	119
Meaghan	128
Nathickshi	125
Selena	140

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

Arti with a BP of 153 Incorrect Jinalben with a BP of 100 Incorrect Kimberly with a BP of 85 Incorrect Meaghan with a BP of 128 Incorrect Selena with a BP of 140 Correct MC

fe83_a65c

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	77
Braulio	111
Gokce	127
Jean	101
Mikhail	159
Nirali	111
Simoni	140
Yomara	127

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

Arti with a BP of 77 Incorrect Jean with a BP of 101 Correct Mikhail with a BP of 159 Incorrect Simoni with a BP of 140 Incorrect Yomara with a BP of 127 Incorrect MC

5dea_a77b

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	139
Calah	126
Dhruvi	125
Henry	156
Jacob	100
Mohammad	80
Suchi	116
Viral	114

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

Calah with a BP of 126 Incorrect Henry with a BP of 156 Incorrect Jacob with a BP of 100 Incorrect Mohammad with a BP of 80 Correct Suchi with a BP of 116 Incorrect MC

1823_a2f6

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)
Arinola	111
Breanne	116
Cierra	158
Eric	101
Jeremiah	140
Kathryn	123
Mayank	76
Nihar	123

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

Breanne with a BP of 116 Incorrect Cierra with a BP of 158 Incorrect Eric with a BP of 101 Correct Jeremiah with a BP of 140 Incorrect Mayank with a BP of 76 Incorrect MC

e2ca_8645

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)
Calah	118
Eric	129
Falak	140
Isaac	114
Kirstin	79
Nairuti	156
Oluwole	100
Sonali	126

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

Falak with a BP of 140 Correct Isaac with a BP of 114 Incorrect Kirstin with a BP of 79 Incorrect Nairuti with a BP of 156 Incorrect Sonali with a BP of 126 Incorrect MC

bca8_c383

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)
Dan	114
Eneo	129
Jazzmyne	116
Krystyna	86
Nicole	154
Rana	139
Sandy	100
Tania	129

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

Eneo with a BP of 129 Incorrect Jazzmyne with a BP of 116 Incorrect Krystyna with a BP of 86 Incorrect Nicole with a BP of 154 Incorrect Sandy with a BP of 100 Correct MC

26f2_2de5

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	127
Caleigh	126
Dalal	113
Freny	114
Kaushal	140
Liza	158
Nina	100
Vikram	78

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

Dalal with a BP of 113 Incorrect Kaushal with a BP of 140 Incorrect Liza with a BP of 158 Incorrect Nina with a BP of 100 Correct Vikram with a BP of 78 Incorrect