document.write( "Question 440446: If I have a 5 yr. old boy who has a BMI of 18 and the BMI is considered a normally distributed variable, whose mean for this age boy is 15.41914 and whose standard deviation is 0.075992. How can I calculate the PERCENTILE ranking for this boy. Please show me HOW you achieve the numbers--I need to see HOW to calculate the result--PLEASE DO NOT USE A TABLE. I want to write an excel program for our school nurse and I need the EQUATION to plug in and test for in excel. Thank you. \n" ); document.write( "
Algebra.Com's Answer #304251 by stanbon(75887)\"\" \"About 
You can put this solution on YOUR website!
If I have a 5 yr. old boy who has a BMI of 18 and the BMI is considered a normally distributed variable, whose mean for this age boy is 15.41914 and whose standard deviation is 0.075992. How can I calculate the PERCENTILE ranking for this boy. Please show me HOW you achieve the numbers--I need to see HOW to calculate the result.
\n" ); document.write( "--------------
\n" ); document.write( "1st: Find the z-value of 18
\n" ); document.write( "using the equation: z(x) = (x-u)/sigma
\n" ); document.write( "z(18) = (18-15.41914)/0.075992 = 2.580860/0.075992 = 33.962259
\n" ); document.write( "--------------------------
\n" ); document.write( "Note: z is a measure of the number of standard deviations the
\n" ); document.write( "score is above the mean of the distribution.
\n" ); document.write( "---------------------------
\n" ); document.write( "By the way, a z-score of 33.96.. is extremely unusual.
\n" ); document.write( "------------------------------
\n" ); document.write( "2nd: Find the percent of BMI scores that are less than 18.
\n" ); document.write( "That percent is the percent of a normally distributed population
\n" ); document.write( "that is less than z = 33.962259
\n" ); document.write( "-----
\n" ); document.write( "3rd: Use a Statistical z-chart or an EXCEL function to find
\n" ); document.write( "P(x < 18) = P(z < 33.962259) is approximately 100%ile.
\n" ); document.write( "==================================
\n" ); document.write( "Cheers,
\n" ); document.write( "Stan H.
\n" ); document.write( "
\n" );