Formulas > =ZTEST()
How to Use ZTEST() in Google Sheets
Description
How To Actually Use ZTEST() in Sheets
ZTEST(data, value, [standard_deviation])
Try ZTEST yourself
In cells A1:A10, you have a set of test scores. Use the ZTEST function to determine the probability of obtaining a score greater than 85. Your formula should reference the data in A1:A10 and the value 85.
Hints (2)
-
Remember to reference the correct range for your data.
-
The second argument should be the score you want to test against.
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
More related tutorials
Transcript-matched member videos for ZTEST(). Click through to watch.
Learn Google Sheet Formulas The Hard Way
Learn more about the ZTEST() formula:
Generate a ZTEST() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses ZTEST(). 2 free AI generations, no signup. Members get unlimited use.
Generate a ZTEST() formula