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)![]() ![]() ![]() 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( " |