Questions tagged [trendline]

270 questions
0
votes
0 answers

Is there a function that will take an existing series of values in oracle SQL for Apex and will make a trendline based on those values?

I would like to create a trendline based on the values returned from a query. The logic needs to be applicable for other cases of placing a trendlines on series in Oracle PLSQL with Apex. My series has X values that are dates and Y values that are…
Philab
  • 13
  • 1
  • 1
  • 6
0
votes
1 answer

Spotfire: Multiple Average Lines on Bar Chart

How do I add an average line for each of the columns in my bar chart in Spotfire seperately? The image below shows a green, blue, and red column that I would like to obtain the average of individually and then plot each on the chart.
RJW
  • 19
  • 2
  • 12
0
votes
1 answer

Change basic assumptions of "add trendline" in excel

I'm plotting some interaction effects that stem from a regression in stata. I'm using excel for convenience. The data are curvilinear and I'm adding a polynomial trendline to maximize the fit. The problem I have is that the trendline function…
SJDS
  • 1,239
  • 1
  • 16
  • 31
0
votes
0 answers

Trendline error in Access

I am getting a trendline error message in some Pivot Chart forms I created in Access. When testing these a week ago they worked perfectly but now I continually get an error. Any ideas on why the error is occurring?
Bethany Minor
  • 57
  • 1
  • 8
0
votes
0 answers

Insert confidence interval in a quasi-poisson regression plot

I ran a quasipoisson regression using the following code: plot(ori_brk ~ year_imd,pch=16,col="darkgreen",cex.lab=1.2,cex.axis=1.2,xlab="Year",ylab="No. of break days",ylim=c(0,30),cex=1.2) and inserted a trend line using the following code: …
user53020
  • 889
  • 2
  • 10
  • 33
0
votes
1 answer

I do not see a trendline section in Google Charts

I want to add a trendline to a Google line chart. When I scroll to the bottom of the customize section there is no trendline section visible.
0
votes
2 answers

Predict future values using highcharts/Highstock

I need to predict the future values based on given set of data. I found in the following link a method of obtaining trend line moving average. http://www.highcharts.com/plugin-registry/single/16/technical-indicators jsfiddle is here…
Madweer
  • 11
  • 1
  • 2
0
votes
1 answer

Using VBA to copy cells and removing blanks, then use Linest ()

So here is my situation: I've a large amount of data, with x values of 1-18, but y values that vary.. some of which are blanks because the equation is /0 - arranged in rows. I am trying to get the m^3, m^2, m, c coefficients of the polynomial trend…
Lozano
  • 163
  • 12
0
votes
2 answers

chart width changes when a trendline is added in highcharts

I'm facing a serious problem. Whenever I try to add any trendline starting from a bit below to the top of the chart (near about 70-85 degree angle), it changes its width. But in case of vertical and horizental line I'm not facing the problem. Is…
Poles
  • 3,585
  • 9
  • 43
  • 91
0
votes
1 answer

Google Sheets Scripts and Trendlines

This question is first about scripts, because I am obviously missing something. I am looking for help actually just implementing them. When I go to the "script editor" I always have to create a new "project" and save it as something. Should the…
Catu
  • 715
  • 1
  • 6
  • 13
0
votes
1 answer

teechart trend possible in standard version?

I have Teechart v7.10 that shipped with Delphi 2007, which is the standard version. Is it possible to add a trend line to my charts or do I have to use the Pro version? Thanks
0
votes
1 answer

Python CGI script to show Google scatter chart with known trendline

I am trying to make a Python CGI script show a Google ScatterChart with a linear trendline whose equation I can use elsewhere. The ScatterChart trendline option draws a trendline and I can find out the equation of the line by putting my pointer over…
user1476044
  • 281
  • 1
  • 4
  • 13
0
votes
1 answer

Is there a way to change the data by adjusting a trend line

I have a set of data charted and a trend line for the data (in Excel). Is there a way to change the slope of the trend line and it will adjust the data to match the new slope?
David Thielen
  • 28,723
  • 34
  • 119
  • 193
0
votes
1 answer

how to plot power trendline showing equation and regression coefficient (like in the image below) in gnuplot?

I am trying to recreate the plot that I created in MS Excel using gnuplot. Can this be done in gnuplot which shows the power trendline Equation with corresponding Regression Coefficient? The data has to be plotted is from file:'data.txt' and the…
maxm
  • 113
  • 2
  • 14
0
votes
3 answers

VBA: How to update a trendline label in excel

sometimes it happens that the trendline label in excel isn't updated when I changed the graph-data. Therefore I want to update via VBA. I want to do it for all existing trendlines in all sheets and charts. My code until now doesn't work. You will…
kame
  • 20,848
  • 33
  • 104
  • 159
1 2 3
17
18