Trend Analysis

garfield

New Member
Joined
Mar 2, 2004
Messages
2
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
 

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
hi - welcome to the board!

what trend - that the institutions form 3 clusters with respect to the first letter of their names? that insitutions in a group have a name length that's proportional to the size of the group?

seriously, you'll needd to provide a little more data than that to get any meaningful advice. review the 'posting tips' thread at the top of the baord (and copied below) for info on how to post in a way that maximises the chances of getting decent replies:

http://www.mrexcel.com/board2/viewtopic.php?t=49751
 

tusharm

MrExcel MVP
Joined
May 28, 2002
Messages
11,029
If you are looking for some time series regressions, you might want to consider a program better suited to the job than XL. It's been an awfully long time since I did any time series work, but you should check with your colleagues / professors / managers as to what software they'd recommend.
garfield said:
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
 

garfield

New Member
Joined
Mar 2, 2004
Messages
2
Gentlemen,

PLease excuse my ignorance of proper protocol regarding questions. I will put together a better statement of my problem and the relevant system info and restate my problem better. I am, unfortunately, working in an unknown subject matter area and my knowledge base in spreadsheet analysis is minimal.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,167,949
Messages
5,856,472
Members
431,817
Latest member
db74

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top