+ Reply to Thread
Results 1 to 2 of 2

Bell Curve for Profit Margin

  1. #1
    Registered User
    Join Date
    01-28-2014
    Location
    dallas
    MS-Off Ver
    Excel 2013
    Posts
    2

    Bell Curve for Profit Margin

    I need help making a bell curve graph and will show us the profit (%) we made over a month. I have all the numbers listed and I'm pretty sure I found the standard deviation. I just don't know how to make the graph.

    On the graph I need the bell curve to follow the overall profit %'s values
    and the customer 1 profit's data to be on top of it to compare one customers profit with the entire company's profit.
    (if that's even possible)

    Thanks

    profit percent bell curve.xlsx

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,607

    Re: Bell Curve for Profit Margin

    Hi,
    You can draw normal distribution density curve based on built in function:
    Please Login or Register  to view this content.
    see attachment.
    Please note that I used scatter plot for the line and used more X values to have it smooth enough.

    But I dont't really understand how you want to present on it data from one customer. These are just single profits, while the curve shows density of probability.
    If you would like to show the distribution (cumulative frequency - it would be easier for me to understand) but may be the first step already will be helpfull.

    May be just points? write some Y (may be 0? or may be 0.5 would look nice) in D2:D12 and add next series to the graph (plotted with pionts, no connecting lines) with C2:C12 as X and D2:D12 as Y

    PS. in yellow row I written normal excel functions to calculate average, variance (as a matter of fact - you do not need it) and stddev (directly from data).
    Attached Files Attached Files
    Best Regards,

    Kaper

+ 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. Replies: 0
    Last Post: 01-21-2014, 12:04 PM
  2. Normal distribution curve / Bell curve
    By LAG1 in forum Excel General
    Replies: 0
    Last Post: 05-24-2012, 07:20 AM
  3. Bell Curve
    By Gre in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 11-09-2011, 04:24 AM
  4. Bell curve
    By alykins in forum Excel General
    Replies: 10
    Last Post: 05-27-2011, 12:56 PM
  5. Bell Curve
    By Girish H Tandon in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-05-2011, 11:44 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