rescale between 0 and 1 using eviews
Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator
-
- Posts: 8
- Joined: Sun Oct 08, 2017 9:38 am
rescale between 0 and 1 using eviews
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.
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.
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13319
- Joined: Tue Sep 16, 2008 5:38 pm
Re: rescale between 0 and 1 using eviews
Need a lot more information on the structure of your data and exactly how you want to do the ranking.
Follow us on Twitter @IHSEViews
-
- Posts: 8
- Joined: Sun Oct 08, 2017 9:38 am
Re: rescale between 0 and 1 using eviews
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
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
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13319
- Joined: Tue Sep 16, 2008 5:38 pm
Re: rescale between 0 and 1 using eviews
How does time fit in to 2)?
Follow us on Twitter @IHSEViews
-
- Posts: 8
- Joined: Sun Oct 08, 2017 9:38 am
Re: rescale between 0 and 1 using eviews
plz explain more what did you mean How does time fit in to 2)?
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13319
- Joined: Tue Sep 16, 2008 5:38 pm
Re: rescale between 0 and 1 using eviews
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.
Follow us on Twitter @IHSEViews
-
- Posts: 8
- Joined: Sun Oct 08, 2017 9:38 am
Re: rescale between 0 and 1 using eviews
i want create 17 ranks for each firm.
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13319
- Joined: Tue Sep 16, 2008 5:38 pm
Re: rescale between 0 and 1 using eviews
In a program:
Code: Select all
for !i=0 to 16
smpl @first+!i @first+!i
series ranks = @ranks(x)
next
Follow us on Twitter @IHSEViews
-
- Posts: 8
- Joined: Sun Oct 08, 2017 9:38 am
Re: rescale between 0 and 1 using eviews
i tried many times and syntex error . this my data plz learn me how rank into deciles and rescale between 0 and 1
- Attachments
-
- data.xls
- (87 KiB) Downloaded 249 times
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13319
- Joined: Tue Sep 16, 2008 5:38 pm
-
- Posts: 8
- Joined: Sun Oct 08, 2017 9:38 am
Re: rescale between 0 and 1 using eviews
my workfile and data
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13319
- Joined: Tue Sep 16, 2008 5:38 pm
Re: rescale between 0 and 1 using eviews
Code: Select all
for !i=0 to 15
smpl @first+!i @first+!i
series ranks = @ranks(CASH_IN_FUTURE)
next
Follow us on Twitter @IHSEViews
-
- Posts: 8
- Joined: Sun Oct 08, 2017 9:38 am
Re: rescale between 0 and 1 using eviews
plz explain step by step how to perform these commands
smpl @first+!i @first+!i
series ranks = @ranks(CASH_IN_FUTURE)
smpl @first+!i @first+!i
series ranks = @ranks(CASH_IN_FUTURE)
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13319
- Joined: Tue Sep 16, 2008 5:38 pm
Re: rescale between 0 and 1 using eviews
File->New Program.
Copy and paste the code.
Click Run.
Copy and paste the code.
Click Run.
Follow us on Twitter @IHSEViews
-
- Posts: 8
- Joined: Sun Oct 08, 2017 9:38 am
Re: rescale between 0 and 1 using eviews
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
@FIRST+!I".
plz give me steps with more explanations
Who is online
Users browsing this forum: No registered users and 28 guests