Search found 45 matches

by Lol38
Thu Aug 28, 2014 8:25 pm
Forum: Programming
Topic: MULTICOLINEARITY
Replies: 7
Views: 5386

Re: MULTICOLINEARITY

Ok, the equation looks like this.
equation.png
equation.png (104.68 KiB) Viewed 5367 times
by Lol38
Thu Aug 28, 2014 7:00 pm
Forum: Programming
Topic: MULTICOLINEARITY
Replies: 7
Views: 5386

Re: MULTICOLINEARITY

It is very difficult to post the workfile because it is a mix from different data sources but here i share my programme.
tesis.prg
(28.72 KiB) Downloaded 315 times
by Lol38
Thu Aug 28, 2014 6:54 pm
Forum: Programming
Topic: MULTICOLINEARITY
Replies: 7
Views: 5386

Re: MULTICOLINEARITY

I mean that the multicolinearity is very high.

I have tried with Variance Inflation Factors but even deleting the serie that have the highest VIF, the problem persist.
by Lol38
Thu Aug 28, 2014 5:27 pm
Forum: Programming
Topic: MULTICOLINEARITY
Replies: 7
Views: 5386

MULTICOLINEARITY

Hello,

Im trying to run a programme but it shows the message "near singular matrix. Regressors may be perfect collinear". I have calculated the level of multicolinearity and it is more than 210.

Is there any way to solve the multicolinearuty problem?
by Lol38
Fri Aug 01, 2014 8:28 am
Forum: Programming
Topic: Matrix
Replies: 3
Views: 3288

Re: Matrix

Thank you.

Can i fill each cell of a matrix with an equation?
by Lol38
Fri Aug 01, 2014 7:35 am
Forum: Programming
Topic: Matrix
Replies: 3
Views: 3288

Matrix

Hello,

I have a matrix (4, 188) B
I want to fill it in with a equation, is it possible?

Another thing, how can i change the names in the rows and the columns? What i want is put the name of a series on each row and each column.
by Lol38
Wed Jul 16, 2014 3:01 am
Forum: Programming
Topic: @mid
Replies: 5
Views: 3819

Re: @mid

I don't know. I thought the command "@mid" was wrong but then you tell me that it is ok. =(

I don't know what to do.
by Lol38
Tue Jul 15, 2014 7:14 pm
Forum: Programming
Topic: @mid
Replies: 5
Views: 3819

Re: @mid

Because i want to sort the series taking into account the third number but this number must be "2", i mean, all the groups of numbers in the serie that have the third number as a "2". Then, i need the same condition but with the third number ="3" and another group with ...
by Lol38
Tue Jul 15, 2014 3:51 am
Forum: Programming
Topic: @mid
Replies: 5
Views: 3819

@mid

Hello, I'm trying to use this combination of commands: smpl if @mid(@str(ocup), 3, 1) = "2" but the programme doesn't read it, what am i doing wrong? The sample is something like this and i want to extract the third number which can be 0, 1 or 3: 10313 10313 99997 20311 80311 20312 30314 5...
by Lol38
Thu Jul 10, 2014 3:28 pm
Forum: Data Manipulation
Topic: Merging
Replies: 15
Views: 9339

Re: Merging

Hello, I have tried to do what you told me about creating a link in two different pagues in the same file but the problem is still there in the merge. Is there any way of "undone" de merge and start over? I have tried many ways but its impossible for me to solve de missings that appear in ...
by Lol38
Mon Jul 07, 2014 12:18 pm
Forum: Data Manipulation
Topic: Merging
Replies: 15
Views: 9339

Re: Merging

Thank you!
by Lol38
Mon Jul 07, 2014 11:38 am
Forum: Data Manipulation
Topic: Merging
Replies: 15
Views: 9339

Re: Merging

From a workfile to another. But the workfile which represents the source data comes from excel.
by Lol38
Mon Jul 07, 2014 3:08 am
Forum: Data Manipulation
Topic: Merging
Replies: 15
Views: 9339

Re: Merging

Hello, I have done a Merge by "pasting special" but the box with the options that appears when when you try to merge don't allowd me to "Link", it just let me "Paste as a serie (by value)". What can i do to paste my source data as a link? or why the "link" opt...
by Lol38
Mon Jun 30, 2014 4:21 pm
Forum: Data Manipulation
Topic: Merging
Replies: 15
Views: 9339

Re: Merging

Thank you for all but after trying by myself i could do it!

The answer was just copy and paste special and then select the option general match merge criteria.
by Lol38
Mon Jun 30, 2014 3:55 pm
Forum: Data Manipulation
Topic: Merging
Replies: 15
Views: 9339

Re: Merging

Ok, sorry. I have a source series which contains 80 observations in a workfile (in workfile1), each observation correspond to one country, i mean Countries Taxes A 80 b 90 c 70 d 50 ... On the other hand, i have another workfile (workfile2) that have 40.000 observations about countries but it doesn'...

Go to advanced search