Page 1 of 2
rescale between 0 and 1 using eviews
Posted: Mon Oct 09, 2017 9:48 am
by hend elgamiel
hi, i want rank firms into deciles based on cash balance and leverage and then ,i want rescale The two groups of ranked
to range between zero and one, respectively. how can do it step by step using eviews (how can rank firms into deciles based on cash and leverage and rescale between 0 and 1). my data in panel form.
Re: rescale between 0 and 1 using eviews
Posted: Mon Oct 09, 2017 10:15 am
by EViews Gareth
Need a lot more information on the structure of your data and exactly how you want to do the ranking.
Re: rescale between 0 and 1 using eviews
Posted: Mon Oct 09, 2017 11:42 am
by hend elgamiel
1) my data is panel data, time seies from 2000 to 2016 for firms 90 firms. unbalanced data number of observation almost 1200 .
2) first , i want rank firms into deciles based on their cash balance and their leverage .and re-scale them to range
between zero and one.then create a composite score measure, OverFirm, which is computed as the average of ranked values of the two partitions variables.
3) i want perform it using eviews . can help me step by step.
4) any information you need it ask me. thank you
Re: rescale between 0 and 1 using eviews
Posted: Mon Oct 09, 2017 11:51 am
by EViews Gareth
How does time fit in to 2)?
Re: rescale between 0 and 1 using eviews
Posted: Mon Oct 09, 2017 12:01 pm
by hend elgamiel
plz explain more what did you mean How does time fit in to 2)?
Re: rescale between 0 and 1 using eviews
Posted: Mon Oct 09, 2017 12:14 pm
by EViews Gareth
To create a rank for a firm, you need 1 observation for that firm. You have 17 observations per firm. So you need to reduce those 17 years to a single observation, or you create 17 ranks for each firm.
Re: rescale between 0 and 1 using eviews
Posted: Mon Oct 09, 2017 12:18 pm
by hend elgamiel
i want create 17 ranks for each firm.
Re: rescale between 0 and 1 using eviews
Posted: Mon Oct 09, 2017 12:35 pm
by EViews Gareth
In a program:
Code: Select all
for !i=0 to 16
smpl @first+!i @first+!i
series ranks = @ranks(x)
next
Re: rescale between 0 and 1 using eviews
Posted: Mon Oct 09, 2017 1:13 pm
by hend elgamiel
i tried many times and syntex error . this my data plz learn me how rank into deciles and rescale between 0 and 1
Re: rescale between 0 and 1 using eviews
Posted: Mon Oct 09, 2017 2:57 pm
by EViews Gareth
Post your EViews file.
Re: rescale between 0 and 1 using eviews
Posted: Tue Oct 10, 2017 11:57 am
by hend elgamiel
my workfile and data
Re: rescale between 0 and 1 using eviews
Posted: Tue Oct 10, 2017 12:58 pm
by EViews Gareth
Code: Select all
for !i=0 to 15
smpl @first+!i @first+!i
series ranks = @ranks(CASH_IN_FUTURE)
next
Re: rescale between 0 and 1 using eviews
Posted: Wed Oct 11, 2017 7:17 am
by hend elgamiel
plz explain step by step how to perform these commands
smpl @first+!i @first+!i
series ranks = @ranks(CASH_IN_FUTURE)
Re: rescale between 0 and 1 using eviews
Posted: Wed Oct 11, 2017 7:40 am
by EViews Gareth
File->New Program.
Copy and paste the code.
Click Run.
Re: rescale between 0 and 1 using eviews
Posted: Wed Oct 11, 2017 10:22 am
by hend elgamiel
i tried many time and the programe say " Error in Sample: !I is not defined in "SMPL @FIRST+!I
@FIRST+!I".
plz give me steps with more explanations