document.write( "Question 1206567: Sketch a normal curve for each distribution. Label the x-axis at one, two, and three standard deviations from the mean.
\n" ); document.write( "1. Mean = 30; Standard deviation = 5
\n" ); document.write( "2. Mean = 95; Standard deviation = 12
\n" ); document.write( " \n" ); document.write( "

Algebra.Com's Answer #844125 by ikleyn(52878) $\"\"$ $\"About$

You can put this solution on YOUR website!
.\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "In the web-page \r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "https://www.quora.com/How-do-you-plot-a-normal-distribution-in-Excel-with-mean-and-standard-deviation\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "you will find a complete description on how to plot a normal curve in Excel
\n" ); document.write( "with the given mean and the given standard deviation.\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "

\r\n" );
document.write( "To plot a normal distribution in Excel with mean and standard deviation, you can follow these steps:\r\n" );
document.write( "\r\n" );
document.write( " 1.  Enter the mean and standard deviation values in separate cells.\r\n" );
document.write( "\r\n" );
document.write( " 2.  In another cell, enter the formula \"=NORM.DIST(x,mean,sd,0)\" where \"x\" is the value \r\n" );
document.write( "     for which you want to calculate the normal distribution probability, \"mean\" is the mean value \r\n" );
document.write( "     you entered in step 1, \"sd\" is the standard deviation value you entered in step 1, \r\n" );
document.write( "     and \"0\" indicates that you want the cumulative distribution function.\r\n" );
document.write( "\r\n" );
document.write( " 3.  Copy the formula from step 2 and paste it into the cells below to calculate the normal distribution probabilities \r\n" );
document.write( "     for different values of \"x\".\r\n" );
document.write( "\r\n" );
document.write( " 4.  Select the range of cells containing the normal distribution probabilities, including the cell \r\n" );
document.write( "     with the formula in step 2.\r\n" );
document.write( "\r\n" );
document.write( " 5.  Click on the \"Insert\" tab in the ribbon.\r\n" );
document.write( "\r\n" );
document.write( " 6.  Click on the \"Recommended Charts\" button.\r\n" );
document.write( "\r\n" );
document.write( " 7.  Select the \"All Charts\" tab.\r\n" );
document.write( "\r\n" );
document.write( " 8.  Click on the \"Statistical\" category.\r\n" );
document.write( "\r\n" );
document.write( " 9.  Select the \"Normal Distribution\" chart type.\r\n" );
document.write( "\r\n" );
document.write( "10.  Click \"OK\" to create the chart.\r\n" );
document.write( "

\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( " \n" ); document.write( "

\n" );