Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 12
Default Bell Curve

Hello -
I have a project that will cost $10MM to build over 12 months. I would like
to spread the costs out in a bell curve shape. For example, I would like
something similar to the following costs...
Month 1 - $100,000
Month 2 - $150,000
Month 3 - $225,000
.....
Month 7 - $2,000,000
Month 8 - $3,000,000
....
Month 11 - $150,000
Month 12 - $100,000

Is there a formula I can use where I can input the total costs and the time
period to allocate so that it will spread my costs out over that time period
in a Bell Curve fashion?

Thanks for your help!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating bell curve in excel Lukedug Charts and Charting in Excel 2 April 22nd 23 08:08 AM
Bell Curve Todd Nelson Excel Discussion (Misc queries) 3 December 7th 07 01:36 PM
Trend Line - Bell Curve David Excel Discussion (Misc queries) 1 July 23rd 06 03:34 AM
Creating Bell Curve Chart MikeR-Oz Charts and Charting in Excel 3 February 2nd 06 12:19 PM
Fit bell curve to histogram cwinters Charts and Charting in Excel 1 June 14th 05 02:03 AM


All times are GMT +1. The time now is 12:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"