Hi - I want to be able to describe the trend (+, - or flat) of a series of %'s over time, but the =slope function returns very large numbers (e.g. 72,932) - what is the best way to interpret?
Dataset:
Known Ys: Jan 18 - Apr 19 dates
Example Known Xs:
[TABLE="width: 1232"]
<tbody>[TR]
[TD="class: xl63, width: 106, align: right"]8.17%[/TD]
[TD="class: xl63, width: 101, align: right"]8.26%[/TD]
[TD="class: xl63, width: 97, align: right"]8.33%[/TD]
[TD="class: xl63, width: 104, align: right"]8.45%[/TD]
[TD="class: xl63, width: 103, align: right"]8.51%[/TD]
[TD="class: xl63, width: 102, align: right"]8.53%[/TD]
[TD="class: xl63, width: 105, align: right"]8.51%[/TD]
[TD="class: xl63, width: 103, align: right"]8.48%[/TD]
[TD="class: xl63, width: 100, align: right"]8.48%[/TD]
[TD="class: xl63, width: 103, align: right"]8.47%[/TD]
[TD="class: xl63, width: 105, align: right"]8.54%[/TD]
[TD="class: xl63, width: 103, align: right"]8.59%[/TD]
[/TR]
</tbody>[/TABLE]
=Slope on this give me 72,932 - am I doing something wrong? As I'd describe this as a roughly flat trend...
Dataset:
Known Ys: Jan 18 - Apr 19 dates
Example Known Xs:
[TABLE="width: 1232"]
<tbody>[TR]
[TD="class: xl63, width: 106, align: right"]8.17%[/TD]
[TD="class: xl63, width: 101, align: right"]8.26%[/TD]
[TD="class: xl63, width: 97, align: right"]8.33%[/TD]
[TD="class: xl63, width: 104, align: right"]8.45%[/TD]
[TD="class: xl63, width: 103, align: right"]8.51%[/TD]
[TD="class: xl63, width: 102, align: right"]8.53%[/TD]
[TD="class: xl63, width: 105, align: right"]8.51%[/TD]
[TD="class: xl63, width: 103, align: right"]8.48%[/TD]
[TD="class: xl63, width: 100, align: right"]8.48%[/TD]
[TD="class: xl63, width: 103, align: right"]8.47%[/TD]
[TD="class: xl63, width: 105, align: right"]8.54%[/TD]
[TD="class: xl63, width: 103, align: right"]8.59%[/TD]
[/TR]
</tbody>[/TABLE]
=Slope on this give me 72,932 - am I doing something wrong? As I'd describe this as a roughly flat trend...