+ Reply to Thread
Results 1 to 2 of 2

Create a bell curve trendline

  1. #1
    Registered User
    Join Date
    04-26-2014
    Location
    Leuven, België
    MS-Off Ver
    Excel for Mac 2011
    Posts
    44

    Create a bell curve trendline

    Hi,

    i have some data and I would like to add a trendline according to a "bell curve" distribution. Note that the data is not normally distributed, the data is assymmetrical, or as we say, we have a distribution with non-zero skewness.

    With the several trendline options excel provides, I can pick between linear, exponential, logarithmic, ... and so forth but none of these give me a normal distribution for example. To show you better what I mean I added an image and in this image I've plotted a polynomial trendline but of course this isn't what I'm looking for either as it's a polynomial and not a distribution with positive skewness.

    Thanks in advance for the help,

    Denis

    Schermafbeelding 2022-01-27 om 20.53.11.png

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,343

    Re: Create a bell curve trendline

    Are you trying to create a true trendline, or are you trying to connect the ends of the bars with a smooth curve?

    What I see in your picture is a bar + xy scatter combination chart. If you are not already familiar with creating combination charts in Excel, I will recommend this tutorial on dot plots (one kind of chart created as a combination bar + scatter combination chart) https://peltiertech.com/dot-plots-microsoft-excel/ If I understand what you are showing in your picture, that should get you real close.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to create bell curve chart
    By Arpita_Excel in forum Excel General
    Replies: 2
    Last Post: 07-17-2015, 01:45 AM
  2. Replies: 2
    Last Post: 02-19-2015, 02:00 PM
  3. [SOLVED] Create bell curve
    By Starkey in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 08-22-2013, 08:13 PM
  4. [SOLVED] Create a Skew bell curve chart
    By jeffreybrown in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 06-30-2013, 09:10 PM
  5. How to create Bell Curve
    By Madan in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-30-2009, 09:09 AM
  6. [SOLVED] How do I create a Bell Curve Graph in Excel
    By fratton in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-17-2005, 03:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1