Mike M. answered 07/15/25
Data Science & Python Tutor – Excel, SQL, Analytics, Automation
Given:
- Mean (μ) = 100
- Standard Deviation (σ) = 15
- Raw Score (X) = 120
- n = 200 (not needed to calculate percentile rank in a normal distribution)
Step 1: Calculate Ezra's Z-score
Z = (X−μ)/σ = (120−100)/15 = 1.33
Step 2: Find Percentile Rank (PR)
Look up Z = 1.33 in the standard normal distribution table.
P(Z<1.33) = ~0.9082
Ezra's PR = ~90.8
Given:
- Joshua's z score = 0.8
Step 1: Find Joshua's PR
P(Z<0.8) = ~.7881
Hence Joshua's PR ~78.8