How To Plot Normal Distribution Curve In Excel

Published in: MS Office
752 views
  • M

    Mudasir K

    • Al Ain
    • 5 Years of Experience
    • Qualification: M.Sc in Mechanical & Manufacturing Engineering
    • Teaches: Project Management, operational research, Mathemat...
  • Contact this tutor

In precision measurement, using mean and standard deviation a normal distribution is required to find out Cp and Cpk.

  • 1
    Normal Distribution Curve Engr. MUDASIR KAUSAR MOHAMMED
  • 2
    Begin by entering Mean and Standard Deviation (SD) in two columns in Excel Mean 18.0871 Standard Deviation 0.1783
  • 3
    Make Bell Curve for 3 standard deviations from mean Mean 18.0871 Standard Oeviatians Increaments -31 Standard Oeviatian 0.1783
  • 4
    Drag formula from -3 to 3 in 001 increments (more increments = more smoother) Standard 18.0871 0.1783 Standard Oeviatic•ns Increarner.ts
  • 5
    Mean 18.0871f Standard Deviation 0.17831 Standard Deviations Increaments Your Data 17.55221 -2.8 -2.7 -2.6 -2.5 -2.4 -2.3 -2.2 -2.1 -2 -1.9 -1.8 -1.7 -1.6 -1.5 -1.3 -1.2 First Point is Mean - Standard deviation X 3 Next points are + Standard Deviation / 10 Because increments
  • 6
    Mean Standard Deviation 18.0871 Standard Deviations Increaments Your Oata -3 -2.9 -2.8 -2.7 -2.6 -2.5 -2.4 -2.3 -2.2 -2.1 -2 -1.9 -1.8 -1.7 -1.6 -1.5 -1.3 -1.2 0.1783 17.5522 17.57003 17.58786 17.60569 17.62352 17.64135 17.65918 17.67701 17.69484 17.71267 17.7305 17.74833 17.76616 17.78399 17.80182 17.81965 17.83748 17.85521 17.87314 Drag formula to fill data
  • 7
    -1.3 -1.2 -1.1 -1 -0.8 -0.7 -0.6 -0.5 -0.4 -0.3 -0.2 -0.1 0.1 0.2 0.3 0.4 0.5 0.6 0.7 0.8 17,85531 17,87314 17.8BOB7 17,5088 17.B2õõ3 17 , 17.B622B 17,98012 17.BB7B5 18,01578 18,03361 18.05144 18.06927 18.0871 18.10453 18.12276 18.14055 18.15842 18.17625 18.1B408 18.211B1 18.22B74 18.24757 Check at O standard deviation, the mean is
  • 8
    Mean 'Standard Deviation 18.0굖71| Standard Deviations Increaments Your Data -2.8 -2.7 -2.6 -2.5 -2.4 -2.3 -2.2 -2.1 -2 -1.5 -1.8 -1.7 -1.6 -1.5 -1.4 -1.3 -1.2 0.17831 INormalize 17.5521= NORM.OlST(85, ,$AS2, $352, FAI 17.57003 NORM,DlST(x, mean, standard_dev, c냬『-t진]屇i혐E〕 17.58786 17.60569 17.62352 17.64135 17.65918 17.67701 17.69484 17.71267 17.7305 17.74833 17.76616 17.78399 17.80182 17.81965 17.83748 17.85531 17.87314 Lat step, normalize data WIth a function Norm. Dist (Your data point, mean, SD,
  • 9
    qean Standard Deviation 18.0871 itandard Deviations Increaments Your Data -a -2.9 -2.8 -2.7 -2.6 -2.5 -2.4 -2.3 -2.2 -2.1 -2 -1.9 -1.8 -1.7 -1.6 -1.5 -1.3 -1.2 0.1783 Normalize 17.5522 17.57003 17.58786 17.60569 17.62352 17.64135 17.65918 17.67701 17.69484 17.71267 17.7305 17.74833 17.76616 17.78399 17.80182 17.81965 17.83748 17.85531 17.87314 0.024856132 0.033384927 0.044394008 0.058446073 0.076180422 0.038307911 0.125600282 0.158872898 0.138960139 0.246683096 0.302809683 0.368007935 0.442793933 0.527476598 0.62210227 0.726402668 0.839750228 0.961125026 1.089097336 Highlight these two columns and create a scatter plot Chart Title 28 2 1.5 1 17.4 17.6 17.8 18 182 18.4 18.6 18.8
  • 10
    itandard Deviations Increaments Your Data -3 -2.9 -2.8 -2.7 -2.6 -2.5 -2.4 -2.3 -2.2 -2.1 -2 -1.9 -1.8 -1.7 -1.6 -1.5 -1.3 -1.2 -1.1 -0.9 Normalize 0.024856132 0.033384927 0.044394008 0.058446073 0.076180422 0.098307911 0.125600282 0.158872898 0.198960139 0.246683056 0.302809683 0.368007935 0.42793933 0.527476598 0.62210227 0.726402668 0.839750228 0.961125026 1.089097336 1.221829372 1.357058848 1.492345765 Chart Title 17.5522 17.57003 17.58786 17.60569 17.62352 17.64135 17.65918 17.67701 17.69484 17.71267 17.7305 17.74833 17.76616 17.78399 17.80182 17.81965 17.83748 17.85531 17.87314 17.89097 17.5088 17.92663 2.5 2 1.5 1 0.5 17.4 17.6 17.8 18 18.2 18.4 18.6 18.8

Need a Tutor or Coaching Class?

Post an enquiry and get instant responses from qualified and experienced tutors.

Post Requirement

Related PPTs