ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   how do i draw two bell curves side by side w/ some over-lap? (https://www.excelbanter.com/charts-charting-excel/142514-how-do-i-draw-two-bell-curves-side-side-w-some-over-lap.html)

ChartsNewbie

how do i draw two bell curves side by side w/ some over-lap?
 
i've got the "drawing a bell curve" part, thanks to Tushar Mehta's a
tutorial.

now, i'd like to draw two bell curves (w/ different height & width) side by
side with some over-lap. how do i go about?

Bernard Liengme

how do i draw two bell curves side by side w/ some over-lap?
 
Make a second column using the same formula as the first but with a slightly
different average (mean) and standard deviation. Unless you are using
XL2007, select the range and drag it on to the chart Or use Copy; click the
chart; use Paste Special New Series.

If you are using the formula that I think you are, then changing the width
(standard dev) will change the height since the area under both curves
should be the same.

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"ChartsNewbie" wrote in message
...
i've got the "drawing a bell curve" part, thanks to Tushar Mehta's a
tutorial.

now, i'd like to draw two bell curves (w/ different height & width) side
by
side with some over-lap. how do i go about?




ChartsNewbie

how do i draw two bell curves side by side w/ some over-lap?
 
thanks Bernard.

i was able to create different bell curves w/ different shapes.

i still have problem plotting them side-by-side. can you help me out with
that part?


All times are GMT +1. The time now is 12:06 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com