{"id":3366,"date":"2018-11-10T11:15:58","date_gmt":"2018-11-10T11:15:58","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=3366"},"modified":"2024-03-29T14:12:05","modified_gmt":"2024-03-29T14:12:05","slug":"z-score-in-excel","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/formulas\/z-score-in-excel\/","title":{"rendered":"z score in Excel"},"content":{"rendered":"\n
The z-score, also known as a standard score, is used in statistics. It measures the number of standard deviations of a specific number.<\/p>\n\n\n\n
To calculate z-score you can use the following formula.<\/p>\n\n\n\n
z-score = (x – \u03bc) \/ \u03c3<\/p>\n\n\n\n
x – value<\/p>\n\n\n\n
\u03bc – mean<\/p>\n\n\n\n
\u03c3 \u2013 standard deviation<\/p>\n\n\n\n
Let\u2019s take a look at the following example. This site iqtestprep.com<\/a> shows the IQ score of famous people.<\/p>\n\n\n\n