EViews.com

Im using :eviews6:

And i wish to sum up a series

Any ideas?

Thanks

Im using :eviews6:

And i wish to sum up the squares of a series

Any ideas?

Thanks

To sum up squares: To sum up just the series:

thank you!

Did you want the squares or just the levels? @sumsq will give you the sum of squared values. @sum will give you the sum.

Can @sum be used to sum cross sections, as in to sum up states to get the US total?

You have to give more context. How is your workfile structured?

I am working with bilateral travel data,I think I could structure it as a panel, but I did not explicitly do this.

I have it set up as visit_i_j (visits from country i to country j), annual data.

I have generated a pool with the list of countries. So conceptually, I think it should be visit_?_? (will this work?) and when i=j it is zero.

I would like to be able to sum up totals inbound/outbound by year, for example:

total outbound from i = visit_i_?
total inbound to i = visit_?_i.

What would be best way to calculate totals by year? Something like:

smpl 2010 2010 (then loop through years?)
totalout_? = @sum(visit_i_?)

OR another design?

I suspect wit the bilateral aspect, this may be deeper than just the @sum command...

Thanks for guidance.

Maybe a combination of @sum and @rsum, having made the appropriate groups.

Try creating a new page and use the link object with match merge:
You have to create a new alpha series in the new page with the category identifiers you are interested in summing over.