Elsmar Cove Forum Header Graphic The Elsmar Cove Wiki Sitemap More Free Files The Elsmar Cove Forums Discussion Thread Index Post Attachments Listing Failure Modes Services and Solutions to Problems Elsmar Cove Forums Main Page Elsmar Cove Home Page
NQA-USA
NQA-USA
Miner's MSA (Measurement Systems Analysis) Blog 
Go Back   The Elsmar Cove Forum > Common Quality Assurance Processes and Tools > Quality Tools, Improvement and Analysis > Quality Assurance and Compliance Software Tools / Solutions > Excel .xls Spreadsheet Templates and Tools
Forum Username

Wooden Line

How Can I Create a Bell curve in Excel 2007

Search the Elsmar Cove
Search Elsmar
Monitor the Elsmar Forum
Follow Marc & Elsmar
Elsmar Cove Forum RSS Feed  Marc Smith's Google+ Page  Marc Smith's Linked In Page   Marc Smith's Elsmar Cove YouTube Page  Marc Smith's Facebook Page  Elsmar Cove Twitter Feed
Elsmar Cove Groups
Elsmar Cove Google+ Group  Elsmar Cove LinkedIn Group  Elsmar Cove Facebook Group
Donate and $ Contributor Forum Access
Courtesy Quick Links

Links that Elsmar Cove visitors will find useful in your quest for knowledge:

Howard's
International Quality Services
Marcelo Antunes'
SQR Consulting
Bob Doering's
Correct SPC - Precision Machining

NIST's Engineering Statistics Handbook
IRCA - International Register of Certified Auditors
SAE - Society of Automotive Engineers
Quality Digest Portal
IEST - Institute of Environmental Sciences and Technology
ASQ - American Society for Quality

Related Topic Tags
2007, bell curve, microsoft excel .xls .xlsx spreadsheet
Reply
 
Thread Tools Search this Thread Rate Thread Content Display Modes
  Post Number #1  
Old 21st August 2008, 06:44 PM
bbrandon's Avatar
bbrandon

 
 
Total Posts: 4
Please Help! How Can I Create a Bell curve in Excel 2007

I need some help can someone show me how to create a Bell curve that contains the following information in the attachment that I have posted, I have not done this before. I have attached my data to the post. I have excell 2007 and I can not figure out how to create a bell curve with this data or how to set it up. Very confusing. Can someone help me or show me how to do it.

Thank you

Brian
Attached Files: 1. Scan for viruses before using, 2. Please report any 'bad' files by Reporting this post, 3. Use at your Own Risk.
File Type: xls Data.xls (18.5 KB, 742 views)

Sponsored Links
  Post Number #2  
Old 21st August 2008, 06:54 PM
Stijloor's Avatar
Stijloor

 
 
Total Posts: 14,703
Re: How Can I Create a Bell curve in Excell 2007

Quote:
In Reply to Parent Post by bbrandon View Post

I need some help can someone show me how to create a Bell curve that contains the following information in the attachment that I have posted, I have not done this before. I have attached my data to the post. I have excell 2007 and I can not figure out how to create a bell curve with this data or how to set it up. Very confusing. Can someone help me or show me how to do it.

Thank you

Brian
Brian,

I did an advanced search on: "Normal distribution in Excel."

Look and see if there's some info you can use.

Stijloor.
Sponsored Links

  Post Number #3  
Old 21st August 2008, 10:17 PM
Tim Folkerts's Avatar
Tim Folkerts

 
 
Total Posts: 975
Re: How Can I Create a Bell curve in Excell 2007

Brian,

There are two challenges before even getting started with fitting a bell curve to the data.

* The data does not seem to follow a bell curve to begin with. There is perhaps some slight rise in the middle, but there are larger variations from one bin to the next.

* The bins are different widths. The narrowest bins are about 1/3 the width of the widest bins. This would naturally put more items into the wide bins (although that does not necessarily be the case in the actual data). Figuring out how to properly fit a bell curve in that case will be CONSIDERABLY more difficult than if the bins are the same width.

Tim F



P.S. I am assuming that the "OD Size" is the way you are sorting the items (the 'bins') and the "Footage" is how much you got of that category.
  Post Number #4  
Old 22nd August 2008, 05:57 AM
mclaubee

 
 
Total Posts: 8
Re: How Can I Create a Bell curve in Excell 2007

If you just want to "draw" a bell curve, you may try to add a 4th or 5th order polynomial trendline to you data.
  Post Number #5  
Old 22nd August 2008, 10:22 AM
bbrandon's Avatar
bbrandon

 
 
Total Posts: 4
Re: How Can I Create a Bell curve in Excel 2007

Thank you for quick responses, it did shine some light on the issue. Does any body know where I can locate the Analysis Tool pack to be loaded.
  Post Number #6  
Old 22nd August 2008, 09:00 PM
S Johnson

 
 
Total Posts: 35
Re: How Can I Create a Bell curve in Excel 2007

Try "Tools", "Add Ins" and select it from the list. I think it is built into all Excel Programs, but it must be added using the Add In menu.
  Post Number #7  
Old 26th August 2008, 04:12 AM
sathis's Avatar
sathis

 
 
Total Posts: 107
Thumbs up Re: How Can I Create a Bell curve in Excel 2007

Hi

Attaching a write up on " Excel For Statistical Data Analysis"


Hope this helps

Sathish
Attached Files: 1. Scan for viruses before using, 2. Please report any 'bad' files by Reporting this post, 3. Use at your Own Risk.
File Type: pdf Excel for Statistical Analysis.pdf (1.18 MB, 1402 views)
Thank You to sathis for your informative Post and/or Attachment!
  Post Number #8  
Old 15th February 2009, 08:00 PM
bobdoering's Avatar
bobdoering

 
 
Total Posts: 3,943
Re: How Can I Create a Bell curve in Excel 2007

Quote:
In Reply to Parent Post by bbrandon View Post

I need some help can someone show me how to create a Bell curve that contains the following information in the attachment that I have posted, I have not done this before. I have attached my data to the post. I have excell 2007 and I can not figure out how to create a bell curve with this data or how to set it up. Very confusing. Can someone help me or show me how to do it.
I guess my question is what is the process? Maybe it should not fall into a normal distribution. Just seeing the term "O.D." makes me suspicious....

Sawtooth curve in a bell shaped hole? Doesn't fit...
Reply

Lower Navigation Bar
Go Back   The Elsmar Cove Forum > Common Quality Assurance Processes and Tools > Quality Tools, Improvement and Analysis > Quality Assurance and Compliance Software Tools / Solutions > Excel .xls Spreadsheet Templates and Tools

Do you find this discussion thread helpful and informational?


Bookmarks


Visitors Currently Viewing this Thread: 1 (0 Registered Visitors (Members) and 1 Unregistered Guest Visitors)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Forum Search
Display Modes Rate Thread Content
Rate Thread Content:

Forum Posting Settings
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Discussion Threads
Discussion Thread Title Thread Starter Forum Replies Last Post or Poll Vote
How can I add a Normal Distribution Bell Curve to an Excel Histogram? Manix Excel .xls Spreadsheet Templates and Tools 20 14th August 2014 01:36 PM
How to create Drop Down Box in Excel 2007 amariepsu Excel .xls Spreadsheet Templates and Tools 2 11th July 2011 09:12 PM
William A. Levinson speaks on When the Bell Curve Doesn’t Fit, Part 2: Non-Normality bobdoering Statistical Analysis Tools, Techniques and SPC 0 21st April 2011 02:51 PM
Process capability worksheet - how to create the Bell Curve? Mezzaluna Capability, Accuracy and Stability - Processes, Machines, etc. 6 5th November 2007 12:53 AM
Help me make a normal bell curve on my histogram Indul Statistical Analysis Tools, Techniques and SPC 1 26th July 2005 02:28 PM



The time now is 04:59 PM. All times are GMT -4.
Your time zone can be changed in your UserCP --> Options.


   


Marc Timothy Smith - Elsmar.com
8466 LeSourdsville-West Chester Road, Olde West Chester, Ohio 45069-1929
513 341-6272
NOTE: This forum uses "cookies".