Histogram

[marcounam]

I have information on an excel page of the same variable. Problem is that i have in matrix form i.e. the information is not in series form. I want to do a histogram of this information but when i load the info, eviews reads it as various series and so i cant do histogram. what do i do?

Thanks so much in advance.

[EViews Gareth]

I'm afraid I don't understand what you're describing. Could you give a more concrete example?

[marcounam]

I have information on some mutual fund returns on an excel page. It contains the returns of various mutual funds per date. So for each date the is a row of the return on that date for each mutual fund. It is a 1173x56 table. I want to do a histogram of the returns of all mutual funds of all dates. The problem is when i load the excel page to excel it reads each column as a series which is ok, but when i open all series as a group and plot the histogram it plots the histogram for each series. What i want is a histogram from all the returns of all dates, so i would like the histogram of the data in all my series treated as one big series containg all the information in my table. I hope i explained myself this time.

Thanks alot for your time.

[EViews Gareth]

Ah, gotcha. You want to stack all the data into one long series, and then have a histogram of that long series. The only way to do that is by stacking the data in a new workfile page. This is only possible if the series names follow some pattern. Assuming that they are something like return1, return2, return3 etc..., then it is easy:

• From your workfile page, click on Proc->Reshape Current Page->Stack in New Page
• In the first box enter the naming pattern, with a "?" for the ID. In my example above I would enter "return?", since the numbers 1,2,3 are the individual ids
• Hit ok, and you're done.

[marcounam]

Dear eviewsgareth:

Thanks so much for your answer. Followed your steps. When i hit ok it says "Two or more IDS are required for procedure". I dont see the problem. Could you please help me out?

Many Thanks!

[EViews Gareth]

Could you post your workfile?

[marcounam]

Here you go. I appreciate your time. Meanwhile i will check out ReShape Page on the help function.

Thanks.

[EViews Gareth]

Seems to work perfectly for me:

[marcounam]

ooooohhhhh! It seems i followed your instructions a little to much, i was entering "return?" instead of return?.
I thank you for your time you have helped me alot.