I have the following data:
| date | count |
|---|---|
| 1 | 2 |
| 2 | 5 |
| 3 | 6 |
| 4 | 1 |
I want to be able to calculate the trendline in a verbose manner, as in, "Positive" or "Negative."
How would I go about achieving that in Google Sheets?
Assuming I'd use y=mx+b, I used the SLOPE formula to find M, and then INTERCEPT to find Y. I don;t know where to go from here.