Derive Curve From Values Then Apply Curve To Another Dataset?
Jun 5, 2014
I have a data set (Set#1) that consists of a positional rank (1-240) and a dollar value ($46-$1) for each positional rank. It's not a straight line set.
DataSet.JPG
What I need to do is take that curve and apply it to another data set (Set#2) (1-240) and assign a dollar value ($46-$1) to each positional rank.
A "corner cutting" way of doing it would be an Index/Match to simply carry over the dollar value from (for example) #45 from my Set#1 to #45 in my Set#2. This could work reasonably well with data sets of the same size, but mine aren't always the same size, so I need to apply the curve itself. I
View 1 Replies
ADVERTISEMENT
Jan 28, 2009
I'd like to apply a curve to a column of student exam grades and have the curved grades displayed in the adjacent column. Here is how I'd like to curve:
I like to make a linear function out of two coordinate pairs.
First Pair (x1,y1) = (Highest Exam Grade, 99) = (H,99)
Second Pair (x2,y2) = (Class Exam Average, Desired Exam Average) =(C,D)
Slope = (99-D)/(H-C) = m
Linear Function = Y-y = m(X-x) = Y-99=m(X-H)
Each student grade would = "Y" i.e. Y=m(X-H)+99
View 9 Replies
View Related
May 14, 2013
Is there a way to generate a normal curve from just the statistical values (mean, std dev, etc)? I used the NORMDIST function but have to manually do the x values and it generates what I would descirbe as a "sample" curve. I would like to make one based on user input.
View 5 Replies
View Related
Jul 11, 2013
Here's the spreadsheet I am talking about : [URL]
So as you can see each row = one day divided in 2 cycles of 12 hours : every 12 hours the cat gets a new injection of insulin (the columns "U" being the number of units of insulin the cat receives)
Now I want to turn this sheet into two different curves that would look like these : [URL]
As you can see the first graph shows data based on days (x) and insulin dose (y), while the second curves shows data based on days (x), and blood glucose values (y). This is basically the only way we could clearly see how the cat's disease is evolving over a long period of time.
If he had just started to take all these values from his cat I guess it would be simple to do, but since he already has a lot of data entered in his spreadsheet, I was wondering if I could use this data (and not write each number in a new document), to make things a little more simple and to avoid mistakes.
View 9 Replies
View Related
Dec 13, 2013
I have a few dates and one Total value. I need to distribute this Total Value in such a way so I can get the same shape S curve (Date vs Value).
View 4 Replies
View Related
Feb 19, 2009
I am trying to find a formula to calculate the total size from a to b with the curve being in cluded in the total.
View 14 Replies
View Related
Apr 9, 2009
I'm trying Calculate Curved Price Rate by SF. phil.freestyle@gmail.com
View 5 Replies
View Related
Sep 7, 2009
For Excel 2007 -
I am looking for a function [or method] to calculate a polynomial curve fit. I can do it on a graph with the existing graph and chart tools, but I need to calculate it myself. Does such software exist somewhere in my Excel 2007 package, or can anyone recommend a freeware program? I am hesitant to download an unknown, un-recommended add-in.
View 14 Replies
View Related
Apr 13, 2008
i am getting some data via RS 232 port and plotting it straight to excel, which comes out to be in forms of waves you can say sine waves, now i need to calculate area under the curve, say like if i highlight some area it will automatically calculate the area, or if i select two points on the curve it will calculate the area. please help me out i am really stuck at this part.
View 9 Replies
View Related
Apr 13, 2006
How I can find a max in an xy chart curve fit?
View 9 Replies
View Related
Aug 28, 2007
Does anyone know of a statistical formula that would create a normal growth curve?
For example. Let's assume that I want to forcast growth from January through December. I know that in January I will have 100 units. In December, I will have 1,000 units. Is there a formula to predict the the units in Feb-Nov (using a normal growth curve)?
View 3 Replies
View Related
May 16, 2008
I am trying to calculate the equation of a curve which best fits some data. On the x-axis is date and y-axis the readings. The curve is quadratic, so on the chart I am fitting a 2nd order polyomial and displaying the equation. To prove that the equation the trendline gives me is reasonable, I am applying the equation on the x parameter to get the y parameter estimate and looking to see the error between predicted and actual - see attached.
The equation and the output from it are clearly rubbish, even though on the graph the trendline is a reasonable fit - see attached. Has anyone any ideas why? I think it has something to do with using a date on the x-axis but no idea why. Is there a way to correct for this? I also tried using the following I to calculate the coefficients which came up with a reasonable forecast (although linest should only be used for linear data): =LINEST(C3:C15,B3:B15^{1,2,3})
View 2 Replies
View Related
Apr 4, 2014
I am working on Project Planning, I need to create the Progress curve for our Project based on Weight Factor every month.
I need to create the Plan and actual curve based on the dates defined in particular activities. Once the activity progress is calculated every month based on cut off date then it will sum product with corresponding WF to get the progress achieved every month. Presently I am calculating the values every month and pasting the values in Chart data every month. I had created the S Curve and attached here.
Now my objective is to automatically calculate the values for the entire cut off date at one time (From Project Start to End). i.e I don't want to do any manual work in the Chart. I will update only the actual Dates in the file, then the curves need to get automatically updated.
1) I don't want to calculate the progress for individual activities, I would like to calculate the overall progress directly.
2) When I change the Cut off date, then the previous values needs to become static.
View 1 Replies
View Related
Nov 19, 2008
I'm trying to find a formula that would spread out a value amongst multiple cells along a bell curve. Say I have $x,xxx. I want to spread that amount out in a certain proportion, regardless of how many cells I'm spreading it throughout.
Say I have a $10,000 project. I want to be able to spread it out like a bell curve in the cells I choose. For instance, if it was a five month project it would be distributed as
January - $1,000
February - $2,500
March - $3,000
April - $2,500
May - $1,000
If I added another month it would change to
January - $833.33
February - $1,666.66
March - $2,500.00
April - $2,500.00
May - $1,666.66
June - $833.33
I already thought of manually adding percentages to each cell, but the formula needs to be dynamic.
View 5 Replies
View Related
Mar 8, 2014
Can we draw tangent to a curve in excel graphs..? If yes if i could have some demo....** this.. I am working on finding rate ** change at an instantaneous point and average rate ** change ie: secant line
View 1 Replies
View Related
Feb 2, 2014
I need to solve about 450 excel sheets for my project.
The spreadsheet has X and Y data and curve is plotted. I need to split the curves into 3 parts based on slope change.
I can do it manually but I need an excel Macro which does this work.
A sample is attached : Excel forum-Lab data.xlsx
View 14 Replies
View Related
Feb 25, 2009
Is it possible in excel to find the equation for a curve?
I have 6 known x,y data points on a curve. I need to find the equation for the curve.
View 4 Replies
View Related
Mar 15, 2012
I would like to use excel to plot a growth curve. I would like it to plot the points that correlate to my data without connecting them by a line. I would then like to give excel a formula and have it plot that line on the graph.
View 9 Replies
View Related
Jul 14, 2014
I'm trying to graph a bell curve chart using the following data
Hotels per state
Total
AK
4
NH
5
[Code] ......
As you can see I have states and the number of hotels per state what I need not for statistical purposes but more for "pretyness" is to sort this data in a way that what you get is a somewhat of a bell shape curve graph.
View 2 Replies
View Related
Jul 29, 2014
I want to create a bell curve for my team's annual appraisal. There are 12 people in my team. The scale is 1-5, where normally rating range from 2.9 to 4.0.
View 1 Replies
View Related
Nov 26, 2013
I've managed to figure out how to normalize my data and create several bell curves. However, these charts do not display the mean, std deviation, or confidence intervals. Any way to add these into my charts?
View 7 Replies
View Related
Nov 15, 2009
What would be the best way to put together a cancel curve on an annual membership model?
View 5 Replies
View Related
Aug 28, 2002
I would like to create a histogram from experimental data with the normal distribution curve overlaying the histogram.
View 7 Replies
View Related
Apr 14, 2014
I'm trying to overlay a Gaussian distribution on some data. The data is a frequency of particle size diameters, ranging from 200-1000 um (see attached). I'm using Excel 2013.
View 1 Replies
View Related
Jan 18, 2008
I have put my values into a XY scatter graph but need to find the maximum point i.e when the gradient is zero. I am using visual basic to obtain my data and draw my graph.
View 7 Replies
View Related
Dec 3, 2013
I am recording and editing steps in order to procure unique ID's from a dataset and eliminate the manual intervention for this process. Macro works seamlessly in most of the scenarios except for the one mentioned below where it performs a step which is not really required.
Let me explain the scenario in detail:
-Sheet 1 contains the list of trades as per client's system and Sheet 2 contains the trades as per internal system
-Need to do several permutation and combination in Sheet1 in order to extract the unique ID's from Sheet 2
-Scenario 1 - lets assume I have 100 records I concatenate few common fields in both sheets and use the simple code mentioned below to fill the all rows with the lookup formula
Range(Selection, Selection.End(xlDown)).Select
Selection.FillDown
First scenario itself might populate the unique id's for all the 100 trades or might give partial result which will prompt for the next scenario. If the first scenario generates the Unique ID's for 99 records I can filter on "#N/A" and update a different formula to fetch the unique id using different combination. However in the initial stage I wouldn't know the # of unmatched records because of which I have the standard selection till end and fill down codes in the macro, which would end up filling all the blank cells till the end, which takes unnecessary time.
simple validation code which ensures that if the # of unmatched record is more than 1 only then the selection till end and fill down codes comes into picture otherwise simply update the formula and populate the result.
View 1 Replies
View Related
Jul 8, 2013
In one sheet I'd like the user to select from 3 dropdown lists certain predefined values.
On the second sheet there is a long list of unique cells (one column, that can't be split into usefull columns with text to columns or something). I want to find the cell that holds the three text choices. These can be in different order to make things more complex. How do I create a search that finds that one match.
Example
The user selects "AAA" and "DDD" and "FFF" from the dropdown lists
The formula should find that one cell that holds this value: "FFF JJJ GGG DDD CCC AAA". This is the only cell that holds all three chosen values in one text. In the end I would need to have the row number of that cell,
View 7 Replies
View Related
Mar 20, 2014
whether it is possible to derive the formula from a chart?
Right now, i have a chart and i want to know the formula, the purpose is to expand the values that the chart has.
Let say the chart has result at point 20, 30, 40, 50... Is it possible for me to know the point at 21, 22, 23, 24, 25 and so on (with increment 1)
View 14 Replies
View Related
May 11, 2014
Is it possible to find the formula of a result that is based on three other values.
Here's my example:
I give three cases, but I am sure all three use the same formula. I made the team names up but the values are 'real'.
MATCHES
TEAM NAME
TEAM RATING
OPP. RATING
POINTS DIFF.
NEW RATING
Match1
Blumps
-2.62
5.05
8
-1.28
Match2
Champs
2.8
4.08
-18
2.37
Match3
Sharps
8.26
-3.53
-16
3.68
I want to know what formula was used to calculate the New Rating in the last column. I am not 100% sure if the formula to calculate the New Ratings as shown above includes a value for home ground advantage of which I might be unaware. For what its worth, the Blumps and Sharps were home teams and the Champs was a visiting team for the three matches shown.
View 1 Replies
View Related
Dec 5, 2009
I've been working on a ss that requires me to create a function to determine a value from a exponential curve where the area of the curve is variable . The terminal points, 0,0 and 100,100 remain constant and the curve is symmetrical at the 45degree angle. How can I derive a function knowing only these things.
Here is an image to crudely illustrate what i mean [url]
The area can be 10, 20, 35% it doesn't matter, I need a way to determine the function from just the area!
View 14 Replies
View Related