EViews.com

many thanks, it looks fine, i will try.
thanks for your patience. have a good weekend.

group y y*
y.drop y100

many thanks for your patience, this works very well,

but i still want to know if we can make a parameter setting,

for example, i have the y1 to y100 series, but i just wanna group (y1 to y50), what should i do? many thanks.

group y y*

this group y1 to y100,

can i ask another question, if i have y1 to y100 series, but i just want to group y1 to y99, is there any parameter setting?

sorry for the silly question:(

thanks, group is good

group y y1, y2, y3, ..., y100

i just feel it is too complicated to write from y 1 to y100, is there an easy way to do this? like y1:y100?

y1, y2, y3, ... y100, each of them is a series with 50 obs. i want to get a new series y with 50 obs, each ob. is the average of the (y1, y2, y3, ... y100) of course we can write y = (y1 +y2 + y3 +... +y100)/100, but this is too complicated, is there any way like y1:y100 in excel? hope this is clear...

Thanks for your reply:

I have 100 series y1, y2, y3, y4, ..., y99, y100

and now i need to create a new series y, which is the average of the 100 series,

y = (y1 +y2 +y3+... + y100)/100

i am wondering if there is a simple syntax for this, thanks.

I have 100 series

y1 y2 y3 .... y100

and i need to produce a new series y = average of (y1 + y2 + y3 +... + y100),

Could you please help write a syntax, many thanks.

Many thanks for your help. will try later.

Yes, EViews 8.

Great, could you let me know how to write the syntax, I will update my Eviews later, many thanks.

Because EViews 7 doesn't have that functionality.

thanks for your patience. final question, does any other version have this function?

You'll have to calculate it. !pval = @tdist(!tstat, !df) thanks for your reply. But the prob values are already in the last column of the regression results, why cannot export directly as we did for coefficeint, t-stat, and std. error? using sth to replace @stderrs : setcell(results, 4,2, @stderrs(...

Eviews 7

Hi I am a new user of Eviews programming I run a regression model and got the following results: Variable Coefficient Std. Error t-Statistic Prob. C 0.000672 0.000807 0.831947 0.4055 FTALLSH 0.678808 0.050166 13.53123 0.0000 IR 0.147604 0.052164 2.829590 0.0047 I am exporting the results of coeffice...