Has anyone ever done any linear regression for a series of points in a dataset that are being trended? Would like to create an overlay for a series of points being displayed.
It’s been a while since I’ve done any real math, but the most difficult part of linear regression should be setting up the equations. To take a dataset, do some calculations and then put the results back, you need something like the followig on a nearby button (or propertyChange script):[code]oldData = system.dataset.toPyDataSet(event.source.parent.getComponent(‘Table’).data)
newData = []
header = [“raw1”, “calc”]
for row in oldData:
#do your calculations
calc = (row[0]+row[1])/2
#append the data
newData.append([row[0], calc])
#store the new data
event.source.parent.getComponent(‘Table’).data = system.dataset.toDataSet(header, newData)[/code]
Thanks, I’ve got an equation for it, was hoping someone might have done this already and had a ‘canned ap’. Also just realized I posted this in the wrong place! Sorry 'bout that.