moon miner
New Member
- Joined
- May 11, 2021
- Messages
- 1
- Office Version
- 2019
- Platform
- MacOS
Hello everyone,
I am trying to use LINEST function in order to estimate a linear regression. However, I can't make the function work when the Y variable has BOTH positive and negative values.
Say I have the following data:
View attachment 38604
LINEST works fine when all Y values are positive or when they are all negative, but it returns an error when I select both positive and negative data.
Does anyone know why this is and if there is any way I can work around it?
Thanks!
I am trying to use LINEST function in order to estimate a linear regression. However, I can't make the function work when the Y variable has BOTH positive and negative values.
Say I have the following data:
View attachment 38604
LINEST works fine when all Y values are positive or when they are all negative, but it returns an error when I select both positive and negative data.
Does anyone know why this is and if there is any way I can work around it?
Thanks!