Spreadsheets: p-value with Excel

Tutoring stats, you deal with p-values. The tutor shows an Excel connection.

In my posts here and here I mention p-values.

Example: Using Excel, get a two-tailed p-value for z=2.4

Solution: Using symmetry, it’s best to get the cumulative z-probability for -2.4, then double it:

=2*normsdist(-2.4)

Jack of Oracle Tutoring by Jack and Diane, Campbell River, BC.

Leave a Reply