The trendlines tag has no wiki summary.
5
votes
2answers
4k views
Use a Trendline Formula to Get Values for Any Given X with Excel
Is there an easy way to apply the trend line formula from a chart to any given X value in Excel?
For example, I want to get the Y value for a given X = $2,006.00. I've already taken the formula and ...
3
votes
3answers
1k views
Excel trendline accuracy
This is a problem I have every once in a while, and it annoys me tremendously, beacuse I have always to recheck every trendline I get.
An example:
r L
(mm)
30,00 97,0
60,00 103,2
...
1
vote
1answer
246 views
Office Excel Linear Approximation is Inaccurate
I am doing a physics project. I have made experiments with free-fall, and I have a time-velocity graph which I built. The slope of each point in the graph is the acceleration. The acceleration in ...
1
vote
1answer
196 views
track disk usage over time in linux
I know I can use df to get a summary of disk usage right now.
I can use du to break down into the detail of how the disk is being used.
The problem is I can only see this information for today.
...
1
vote
1answer
24 views
LINEST function in excel vba
I am trying to figure out the 2 order equation (Y = ax^2 + bx + c) for a set of data values. When I use the inbuilt function in excel
=LINEST(C2533:C2537,B2533:B2537^{1,2})
I get the following ...
1
vote
1answer
359 views
Is there a program to calculate fibonacci charts and their continuations?
I'd need a program able to take data and plot a trend graph, and it should be able to continue it to see the future trend. I've found some commercial programs but none work. Is there a free one?
I ...
1
vote
1answer
325 views
Any way to make interactive graphs in LibreOffice like Google Doc's Trend chart?
Google Docs has a nice trend viewer that can be created just like any other chart:
Is there any way to get an interactive graphic like this in OpenOffice? Manually adjusting the axes is really ...
0
votes
2answers
135 views
Apart from visually inspecting the graph, is there a way of calculating when a trend line will cross another series?
Is there a way to find the point of intersection of a trend line and another series on a chart in Excel? The other series may be another trend line or just the interpolated line drawn by Excel.
