1. D

    Recovery Curve VBA Code help to reduce repetitive Parts

    HI Everyone, I have some vba code that I’ve been using for years that I use to project the recoveries of an asset over some period of time according to a vector. So if I have cash outlay in period 1, I have a curve that recovers that cash amount over some period time (let’s say 24 months)...
  2. T

    How to calculate the area under a Weibull curve

    Hi all, I'm practising my survival analysis skills and I'm trying to conduct a partitioned survival model by means of a Weibull distribution. I can easily manage to do so for exponential distributions, where the survival function is denoted as s(t)=EXP(-(EXP(-intercept)*t)). The area under the...
  3. M

    input construction costs into a development appraisal

    I want to be able to automatically enter the value of monthly construction costs following an s curve spend profile. I want the ability to simply enter the contract value and monthly term to create a spend profile that follows the s curve principle. Anybody cracked this?
  4. T

    Index function complications

    Ok, so I've gotten a lot of use from this forum and now I have a question I haven't been able to find an answer to, I'm totally shocked by that fact...I'll probably learn I wasn't using the right search terms lol. Lots of detail here, possibly too much but hopefully better than not-enough :rofl...
  5. H

    Forecasting Curve Distribution

    Hello, I am working on a forecasting model and have run into some trouble when trying to extend the X-Axis of a 12-month Curve Distribution to a longer time frame. Given a distribution of 12 percentages (one for each month), how can I spread the 12 months or periods to say 18 months while...
  6. D

    Find greater x value of a curve that corresponds to a y value

    I want to find the x value which corresponds which half the maximum of the y value, and i want the x value to be greater than the x value which corresponds to the maximum y value So if you had a curve, and you looked at where the y corresponds to the x there would be 2 values. I want to find...
  7. P

    Normal Distribution not working properly Bell Curve

    Hi everyone, I'm trying to do a normal distribution bell curve on a range of salaries. The x-axis seems not to be reading the salaries and hence I am not getting the right bell curve shape even though my data is normally distributed. I've done this before and it worked so I'm confused why its...
  8. M

    Defining Points Along Exponential Trendline

    I let Excel provide an Exponential Curve for a set of data points (in blue). Is there a way to know the value of the points along the curve at each X axis value? I tried using exponential decay and a few other methods. No luck getting the table set up correctly.
  9. J

    Formula / equation help

    Hello,<o:p></o:p> I am trying to replicate the formula below in excel, but can't quite get it right. The aim is to use the formula to help drive data that I can graph into an s-shaped sales curve. The formula I have is:<o:p></o:p>...
  10. J

    Apex of a bell curve

    I have a scatter chart with smooth lines that creates a bell curve. Is there a formula i can make based off of the data to calculate the apex of the bell curve or is there an excel function to show the apex number and label it?
  11. M

    fitting excel data with normal curve

    Hi, I have a graph of data, and when I put this into a chart there is the option to fit the data to a curve. The options are Linear Exponential Polynomial These are OK, but the problem is that I have a curve that is most closely resembling a "Beta" distribution. Is there any way to fit the...
  12. W

    Plotted graph from a table. Read value from the curve?

    Hi I wonder if you can help. I have a table which has been used to create graph curve in excel. Is there a way of reading a value from the curve? Many thanks in advance
  13. T

    how to get the curve maxima?!

    How can I get the value of the point that I have circled on the attached graph? i have the data, I will plot the curve, then how can I get the value?
  14. U

    How Do I create a (Pretty) Bell Curve in Excel 2010

    Hey guys. I have been having the worse time figuring this out. I am trying to create an attractive bell curve in Excel. My boss has put a lot of pressure on me but I just can't seem to do this. I am trying to create a bell curve based on total sqft of a store. Here is an example the data...
  15. M

    Why my data does not give a bell curve graph? normal distribution formulas used

    Hi Guys, I have been trying to create a bell curve / normal distribution chart but my data does not give a belle curve. What do I do wrong ? Given X values, I use formula z= STANDARDIZE Fx = NORM.DIST <colgroup><col span="3"></colgroup><tbody> X z f(x) 490 0.9 0.029 490 0.9 0.029...
  16. K

    Force Vs Displacement Curve

    Hi all, I have done Analysis in Abaqus for Body and Mattress contact. I have imported my data into Excel sheet, I just want to see the Force vs Displacement curve. I gave Load from 1-500 N so that I get displacement --0.000,.............108 mm,,, I made a non linear Graph for my datas. I...
  17. T

    how to build a bell curve with infinite degrees of freedom?!

    Hi Guys, i'm trying to create a bell curve for returns given a level of volatility. I need to calculate the infinite degrees of freedom for every point on the bell curve. I've search all over and found various methods for calculating the various deviations but cant find out how to work out...
  18. H

    Really need help generating cash flow values.

    Good afternoon, I am in a very tight pickle in which I am hoping someone can help me, or point me in the right direction. I am given total contract values of for say maybe 30 contractors, as well as the duration they are on the job. The job has begun so there are actual values for roughly 5...
  19. D

    Calculating Area Under a Curve

    Hi guys, I am trying to calculate the area under the curve on my Power-Time graph so that I can determine the energy. Would anyone have an idea of how I can calculate the area under the curve? The solution would also have to ignore cells with #N/A. Would I also be able to choose a specific...
  20. C

    % Distribution

    Hi I have a distribution question, I have this split over 10 qtrs, 100% total, which creates a bell curve <tbody> Quarter % Split Q1 4% Q2 10% Q3 11 Q4 12% Q5 13% Q6 13% Q7 12% Q8 11% Q9 10% Q10 4% </tbody> What I would like to do is evenly distribute the % for the 10...

Some videos you may like

This Week's Hot Topics