Questions tagged [trendlines]

The tag has no usage guidance.

18 questions
Filter by
Sorted by
Tagged with
28 views

How to make best fit line that is weighted according to precision of each data point

I have got a set of experimental data calledxdata and ydata that I want to approximate with a trend line. Traditionally, Libreoffice Calc calculates the optimal trend line using a method which gives ...
57 views

Excel 2010 - Creating a line graph for trend analysis of faults

I have an excel spreadsheet that currently tracks fault reporting in our building. I am looking to do some form of trend analysis ideally to track the faults on the spreadsheet and then display them (...
953 views

Highlight/Select specific data points on excel chart to draw a trend line

I hope I can get some help with the problem that I'm trying to solve. I want to be able to chart some stock data using excel. I have that part done. I have 3 columns (date, high, low, close). I am ...
35k views

Get coordinates of intersecting point of two trend lines

Given this table, chart and trend lines in Excel. I want to find the coordinates of the intersecting point. How can I do this?
19k views

Multiple Trend Lines for Different Segments of the Same Series in Excel

So I have a set of data in Excel that follows a periodic (roughly sawtooth shaped) pattern over time. That is, it increases gradually over a long period of time, and suddenly drops back down to a ...
8k views

How to find trendline without graphing

I have set of data in Excel for which I would like to find the trendline. Is there a way to find the trendline (linear and non-linear) from the raw data? Or do I have to graph the data and use the ...
5k views

Higher Dimensional Trendline

My data is in multiple dimensions, as below. Rather than a trendline, I guess I need a trendplane. Is this possible in Excel or a similar tool?
1k views

How to antialias trendline in Excel?

I have created a couple of line charts in Excel 2011 for Mac. The actual data line looks good and is antialiased in a nice way but when I then add a trendline it is jagged and ugly: I have tried "all"...
418 views

Excel - Reuse a trend line to apply to other data

I've obtained a trend line from a particular set of data. What I'd like to do now is to reuse this trend line to predict values from a given pair (x,y) of coordinates. To put it another way, I have ...
842 views

Trendline not printing

I have many pages with similar graphs and data tables to print. And there is one page that does not print the trendline in the graph. I reloaded the file and tried printing it which worked out, then i ...
6k 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 ...
1k 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 free-...
2k 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. ...
871 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 ...
22k 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 ...
5k 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 ...