curve

Hi everyone, I'm trying to create a worksheet that will allow me to dynamically forecast resource requirements for projects. The idea is that the sheet requires data relating to project start and end dates, as well as the estimated resource effort at the project's maximum. Using a 'standard'...

Hi all. Firstly im new here and English isnt my native tongue so I would like to apologize beforehand if my explanations aren't very clear. Truly appreciate if anyone can help me with the following: I generally have two sets of data: 1.First one is an inventory list of clothes with their...

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)...

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...

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?

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...

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...

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...

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...

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.

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>...

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?

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...

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

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?

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...

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...

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...

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...

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...