Reply
Thu 11 Oct, 2012 08:03 am
Hello!
My name is Katerina and I would like to make a question about statistics in excel.
Is there a tool that counts if there is an increase in the variables due time (in the diagramm there is 5 values in "y" - and 18 days in "x").
Thank you in advanced!
Katerina Gerofoti
Greece
@Katerinagero,
You could
- generate a least squares fit using the LINEST function and see if the slope is positive.
- graph all the values on an scatter plot and see if the trend is positive over time by eye or put a linear fit to the points.