Forum Discussion
Linear regression calculation
Hello,
Is there a way to calculate with DAX the linear regression of this:
| Sites | Entity code | Result Moisture | Result aw |
| RCR | 5369 | 8,2 | 0,56 |
| RGU | 5285 | 7,4 | 0,51 |
| RGU | 5071 | 7,8 | 0,48 |
| RFT | 5459 | 6,5 | 0,5 |
| RCR | 5369 | 8 | 0,54 |
| RGU | 5071 | 7,6 | 0,46 |
| RGU | 5285 | 7,9 | 0,55 |
| RCR | 5369 | 7,7 | 0,53 |
x = Moisture results
y = aw results
And for each site/formula, I will use the linear regression calculation to estimate my aw result when moisture = 9,5 % or 10,5 %.
Thanks for your help,
Hervé
