Resolved: Excel formula to find number in the Z-table
I'm struggling to find an automated way to lookup the number in th Z-table. Refer to 5:10, I finally managed to do this by formula, but this doesn't work for CI 90% or 95% (refer to 6:30)
Here's what I've done so far:
- F38 is number to lookup (0.9750 in this case)
- ZTABLE is the the named range of the z-table in a separated sheet
Get Z-Table column ---> Result: 0.06
Get Z-Table row ---> Result: 1.90
Zα /2 = Z-Table column + Z-Table row (1.96)
Is there any simpler way finding Zα /2 that can be solved by formula instead of manually find the number in the table?
You can try the NORMSINV function in excel.