Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Spread Project Costs Over Months Using Bell Curve
I need help developing and understanding how to distribute project costs over time (i.e. by month). I would also like to change the distribution and skew of the costs. For example say the costs are spread over 8 months based on a normal distribution curve, I would like to:
one: change the number of months say from 8 to 12, using start and end dates/periods two: change the skewness (I think this is the right terminology!) so that the project costs are 'front' loaded (i.e. skewed to the left) or 'back' loaded (i.e. skewed to the right). Any assistance would be appreciated I have attahced a file of what I have done so far: Table 1: represents % spread of project cost over 1 to 60 periods (i.e. months) using a normal distribution NOTE due to file upload size I have deleted this section Table 2: represents $ spread of project cost over 1 to 60 periods (i.e. months) using a normal distribution NOTE due to file upload size I have deleted this section Table 3; is my attempt to 'skew' the spread of project costs by changing column A and B values and display them as barred/bell curve. NOTE I have deleted the bell curve due to file upload size. Hope I have provided enough for someone to help. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Spread Project Costs Over Months Using Bell Curve
"Gizzmo" wrote:
I have attahced a file of what I have done so far: Table 1: [....] NOTE due to file upload size I have deleted this section Table 2: [....] NOTE due to file upload size I have deleted this section Table 3; [....] NOTE I have deleted the bell curve due to file upload size. There is no reason to delete parts due to ExcelBanter file limitations. You can upload the entire Excel file to a file-sharing website. Then post the "shared", "public" or "view-only" link (aka URL; http://...) in a response here. The following is a list of some free file-sharing websites; or use your own. Box.Net: http://www.box.net/files Windows Live Skydrive: http://skydrive.live.com MediaFi http://www.mediafire.com FileFactory: http://www.filefactory.com FileSavr: http://www.filesavr.com RapidSha http://www.rapidshare.com |
#3
|
|||
|
|||
Quote:
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Spread Project Costs Over Months Using Bell Curve
Looks like this will do the trick..
http://www.excelville.com/file/1785/...eclining+Curve https://youtu.be/DPjvIIXrCEU On Friday, February 22, 2013 at 1:00:55 AM UTC-7, Gizzmo wrote: 'joeu2004[_2_ Wrote: ;1609596']"Gizzmo" wrote:- I have attahced a file of what I have done so far: Table 1: [....] NOTE due to file upload size I have deleted this section Table 2: [....] NOTE due to file upload size I have deleted this section Table 3; [....] NOTE I have deleted the bell curve due to file upload size.- There is no reason to delete parts due to ExcelBanter file limitations. You can upload the entire Excel file to a file-sharing website. Then post the "shared", "public" or "view-only" link (aka URL; http://...) in a response here. The following is a list of some free file-sharing websites; or use your own. Box.Net: http://www.box.net/files Windows Live Skydrive: http://skydrive.live.com MediaFi http://www.mediafire.com FileFactory: http://www.filefactory.com FileSavr: http://www.filesavr.com RapidSha http://www.rapidshare.com Thanks for the information, however as I am posting from work our IT Policy does not allow me to use these sites. +-------------------------------------------------------------------+ +-------------------------------------------------------------------+ -- Gizzmo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Bell Curve | Excel Worksheet Functions | |||
How do I create a bell curve? I have my z, p, std. dev., mean,etc | Charts and Charting in Excel | |||
Bell Curve | Excel Discussion (Misc queries) | |||
standard bell curve | Excel Discussion (Misc queries) | |||
Bell Curve Graph | Charts and Charting in Excel |