Questions tagged [trendline]
270 questions
0
votes
1 answer
assign different weights to a set of trendlines in c
I have a graph with 12 different trendlines. I want to produce a single trendline by adding together the values of all 12 trendlines, like this:
for (i = 0, cumulativeTrendValue = 0; i < 12; ++i)
{
cumulativeTrendValue += trendLine[i];
}
I…
PaeneInsula
- 2,010
- 3
- 31
- 57
0
votes
2 answers
Trendline is not displaying in my chart
I am using trendlines for my line chart. But it is not visible in my browser.Can anyone tell me the reason for this. Below i am giving…
ramsai
- 121
- 1
- 7
- 22
-1
votes
0 answers
Adding a best fitting line to a series of plots
Data:
import pandas as pd
data = {'PctUrban': [1.460065484046936, 1.460065484046936, 1.460065484046936, 1.460065484046936, 1.460065484046936, 1.460065484046936, 1.460065484046936, 1.460065484046936, 1.460065484046936, 1.460065484046936],
…
ArianaMo
- 7
- 1
-1
votes
1 answer
Plugging in the trendline equation in excel gives values different than the actual line on the graph
I apologize if this question should be somewhere else but I could not find a seperate section for excel related questions.
I am recording data readings from a sensor based on the water volume in a tank. After collecting 5 data points for each volume…
DailyReader
- 43
- 1
- 8
-1
votes
1 answer
Excel using a graph trend-line formula to calculate y values from x values
I have a data set which needs to be offset by another data set.
My initial set is a sample being compressed, with the data being X = load (N), Y = Compression displacement.
My offset is the shift in the testing setup which is again measured in X =…
Chris Mason
- 13
- 3
-1
votes
1 answer
Using Polynomial Regression in Excel
Suppose I have a set of X's and Y's(both numneric data) which is dynamic i.e. changes based on certain conditions.
Using those two sets of data a scatter plot is prepared with a polynomial trendline of degree 3. I have also called for its equation…
Arijit Debroy
- 1
- 1
-1
votes
3 answers
Get trendline slope of multiple time series by group
I've got a data set containing multiple time series for different groups in long format.
I need to get the slope of a trendline for each one of the groups, so i can tell if the series is increasing or decreasing overtime.
My df looks like…
user3639100
- 336
- 1
- 11
-1
votes
1 answer
How to calculate the lifetime of the use of a database?
Can you please help me with this problem?
You have the following information:
Name Date Size_Total Size_Free Size_Used
X 20/05/2019 50MB 40MB 10MB
X 21/05/2019 50MB 35MB 15MB
X 22/05/2019 …
FixedShot
- 1
- 1
-1
votes
1 answer
How to Graph Trend Line as function of Dates?
I'm trying to plot a trend line that depends on dates (in the form Sep-14 to Dec-2018) on the same plot as my actual data values.
I've tried using Seaborn:
#dh1018['BILLDATE'] returns a pandas series of strings containing the dates from Sep-14 to…
jho
- 1
-1
votes
2 answers
Excel negative correlation of trendline
I have been getting this negative R² so many times when I add a trendline in excel as shown on the figure below.
Do I care about this negative sign?
Here is the data:
x y
0.059 0.13
0.095 0.05
0.097 0.02
0.12 0.2 …
Manser Dimor
- 21
- 2
- 8
-1
votes
1 answer
Plotting trend line with ggplot in R
I've been trying to add a trend line for my ggplot (regarding to sent data of email campaign & corresponding open rate).
I had first converted the x-axes into time series data, while y-axes is the open rate in %, then I plotted the ggplot as normal.…
Vincent Lao
- 11
- 1
- 1
-1
votes
1 answer
Find highs and lows in time series data
I've been searching high and low (no pun intended) for a formula, or more likely, a loop that can pick out the higher highs and lower lows so as to be able to draw a trend line across them. This is often used in technical analysis of stocks. At…
Andy Visser
- 95
- 1
- 11
-2
votes
1 answer
Google Sheets: Chart: Increase Moving Average Trendline Period
I've set a Trendline for a Chart Series to Moving Average, but the Period only accepts a maximum of 10 periods.
The data is provided as Weekly Stock Prices, using GOOGLEFINANCE(), for the last 10 years.
I would like to see a trendline over a longer…
maxhugen
- 1,870
- 4
- 22
- 44
-2
votes
1 answer
How can I calculate median between my changepoint locations?
I have a data frame and applied the changepoint.np package to it. Now I want to calculate the median or display a trendline between these changepoint locations (red lines) to it.
Any ideas how to do this?
My dataframe df1
date …
rayray
- 35
- 1
- 8
-2
votes
2 answers
How to create a trendline using pandas and matplotlib on financial stock data
I am trying to create a trendline on financial stock data using the following code and getting all kinds of errors. Any suggestions are most appreciated.
import pandas as pd
from pandas_datareader import data
import numpy as np
import…
Mike
- 85
- 3
- 7