Forum Discussion

cousinitt13's avatar
cousinitt13
Icon for Helper I rankHelper I
3 years ago

Linear Regression (LINEST, LINESTX) possible for serial number and value?

Hallo,  I'd like to to a trend or linear regression by grouped by Variable, see example below. my problem is, that my linear regression value looks exactly the same as the values itself, how this...
DAX
Help
Linear Regression
DataNinja777's avatar
DataNinja777
Icon for Super User rankSuper User
3 years ago

Hi cousinitt13 

My visualization also comes out like yours in a zigzag manner, and not liner. BTW, are you trying to visualize the correlation between the result amount and event ID number?  As event ID is only an identifier, I guess there is no meaningful correlation between the two variables.  I am guessing that you need to do this regression analysis for variables which have correlation between each other for it to work.  Please let me know if I am misunderstanding the objective of this task.  

cousinitt13's avatar
cousinitt13
Icon for Helper I rankHelper I
3 years ago

Maybe my fault to explain correctly. I want to have a trendline, from beginning of the shown data till the end of the shown data. The data itself are like temperature data, but instead of the date, you have a serial number. so my thoughts. For my understanding, you can do a trend also with temperature and time data, so it should work also for my kind of data or?

  • DataNinja777's avatar
    DataNinja777
    Icon for Super User rankSuper User
    3 years ago

    Hi cousinitt13,

    Yes, I think so.  It sounds like a time series analysis using time as independent variable.  Instead of ID, what about using time dimension as your independent variable?