I am looking for a trend formula to determine if my data has a trend.
It is time series data of 300 institutions combined into 11 groups spanning 11 years. The trend analysis must be done on the indivudual institutions and each group. The data is in a pivot table by group.
I have tries th etrend function but cannot get it to work. Even the example from Excel itself I am doing wrong.
Thx fro the help, Garfield
It is time series data of 300 institutions combined into 11 groups spanning 11 years. The trend analysis must be done on the indivudual institutions and each group. The data is in a pivot table by group.
I have tries th etrend function but cannot get it to work. Even the example from Excel itself I am doing wrong.
Thx fro the help, Garfield