Question: how calculate z score in excel?
Answer: Calculate a z-score in Excel to determine how good your score is compared to the general population of test takers. The population mean (μ) is 469 and the population standard deviation (σ) is 119. Step 1: Type the population mean into a blank cell. For this example, type “469” into cell A2.