The Cove Business Standards Discussion Forums More Free Files Forum Discussion Thread Post Attachments Listing Cove Discussion Forums Main Page
UL - Underwriters Laboratories - Health Sciences
Go Back   The Elsmar Cove Business Systems and Standards Discussion Forums > 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

Elsmar Cove Forum Visitor Notice(s)

Wooden Line

How Can I Create a Bell curve in Excel 2007


Elsmar XML RSS Feed
Elsmar Cove Forum RSS Feed

Monitor the Elsmar Forum
Sponsor Links



Courtesy Quick Links

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


ASQ - American Society for Quality

International Standards Organization - ISO Standards and Information

Atul's
Quality Forum Online

Howard's
International Quality Services

Marcelo Antunes'
SQR Consulting, and
Medical Devices Expert Forum

Bob Doering
Bob Doering's Blogs and,
Correct SPC - Precision Machining

NIST's Engineering Statistics Handbook

IRCA - International Register of Certified Auditors

SAE - Society of Automotive Engineers

Quality Digest

IEST - Institute of Environmental Sciences and Technology


Related LinkedIn Groups

ISO 9001 for Small Businesses

ISO 9001:2015 Revision Discussions

Information Security Community

Medical Devices Group

Quality and Regulatory Network

FDA (Food and Drugs)

AS91XX Series - Tips and Advice


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, 05: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, 747 views)

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

 
 
Total Posts: 15,044
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, 09:17 PM
Tim Folkerts's Avatar
Tim Folkerts

 
 
Total Posts: 972
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, 04: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, 09: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, 08: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, 03: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, 1420 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: 4,006
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 Business Systems and Standards Discussion Forums > Common Quality Assurance Processes and Tools > Quality Tools, Improvement and Analysis > Quality Assurance and Compliance Software Tools / Solutions > Excel .xls Spreadsheet Templates and Tools

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 12:36 PM
What is the formula to create a bell curve? mi06rasja Excel .xls Spreadsheet Templates and Tools 8 26th July 2013 06:47 PM
How to create Drop Down Box in Excel 2007 amariepsu Excel .xls Spreadsheet Templates and Tools 2 11th July 2011 08:12 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 01:28 PM



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


 


NOTE: This forum uses "Cookies" -- The Elsmar Cove is *Copyright Free*.
A Peachfarm LLC Internet Property