slope formula

Hello all! New User here, so bear with me I'm working on a little pet project, attempting to parse out data from a large date range using smaller date ranges. The goal is to automatically get references given a date range that can be used for math in other cells. Most of this can be done with...

Hello, Thank you for looking into my question. I have series of x_value and y_value. I am looking for excel equivalent SLOPE function in PowerBI. Can you please help me with measure to calculate SLOPE for below data points? Expected Output SLOPE (m) = 1.34556304295796 y_value x_value...

Hi all, I have done Analysis in Abaqus for Body and Mattress contact. I have imported my data into Excel sheet, I just want to see the Force vs Displacement curve. I gave Load from 1-500 N so that I get displacement --0.000,.............108 mm,,, I made a non linear Graph for my datas. I...

So I need to figure out how to get the "knee" value which in my case would be the load. I can tell its going to be about 6.2 by just hovering over it, but is there a faster way of slicing up the sample into multiple slopes and looking for a slope that's above a certain value? Thanks

I am trying to use the slope formula where my data for the y series resides in two workpapers. I don't want to combine the data into one workpaper to make the slope formula work. Instead I want to use a formula that appends the y series in one workpaper to the y series in the other. Current...