Rebasing a dataset
Moderators: EViews Gareth, EViews Moderator, EViews Jason, EViews Matt
Rebasing a dataset
Hello, I would like to rebase a graph to a certain data point. I ran a regression model and I got a beta coefficient (which in this case is 5.2). I would like to rebase my graph with my beta coefficient that 0 becomes my beta coefficient (5.2). I would like to replicate this process. Thanks in advance.
- Attachments
-
- data.PNG (16.04 KiB) Viewed 5649 times
-
EViews Gareth
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13603
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Rebasing a dataset
You'll have to explain in more detail.
Re: Rebasing a dataset
Each plot is a component to growth. I want to see how each component contributes to the growth level. This model is based on regression, which I also ran using EViews, and each component is multiplied by its corresponding beta to better reflect their weights. However, because beta constant coefficient is too large(5.2), my component to growth model had a huge discrepancy compared to the real growth. To solve the issue, I allocated my beta coefficient equally to each component. Now my components to growth model has the right number, but it does not truly reflect each component's contribution to growth as I have allocated my beta coefficient.
To put more easily,
I ran a regression model: growth = b0 +b1*c1 + b2*c2+b3*c3+b4*c4+b5*c5
where as c=component, b=beta.
My original model did not reflect the growth level as it did not contain (and I did not want to contain) b0. But now that I know I need to include b0, rather than allocating b0 into other components, I want to rebase my graph with my beta constant coefficient. Below is an attachment for your reference. Thanks.
To put more easily,
I ran a regression model: growth = b0 +b1*c1 + b2*c2+b3*c3+b4*c4+b5*c5
where as c=component, b=beta.
My original model did not reflect the growth level as it did not contain (and I did not want to contain) b0. But now that I know I need to include b0, rather than allocating b0 into other components, I want to rebase my graph with my beta constant coefficient. Below is an attachment for your reference. Thanks.
- Attachments
-
- Baseline: my beta(5.2) I would want that to be my new 0 (base point), so that I can see the true increase and decrease value of my components (as depicted with yellow bars)
- data.PNG (7.29 KiB) Viewed 5645 times
-
EViews Gareth
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13603
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Rebasing a dataset
You haven't explained what you mean by rebase.
You also haven't explained what the graph is - how it was created etc...
You also haven't explained what the graph is - how it was created etc...
Re: Rebasing a dataset
If I was not clear, the attached image file should explain what I mean by rebase.
I allocated beta constant (bhat(1)) into the components, which I am trying to fix. The first image file attached is the result of the allocation. The allocated beta makes it difficult to see how each component is contributing to the growth level.
caihat is the blue line. Notice how I did not add the beta here and this is making difference between the blue line in the upper graph and the composite value of the lower graph (they should be same). To remove the difference, I want to add back the beta, but not the way I did before. I want to make the BASE (which is 0 now, to 5.2, which is my beta in this case). The attached image file will explain in more detail. It might be simple if I simply want to change those numbers by hand, but I am running this model with tens of country in regular basis, so I want to know how I will be able to change the base into a datapoint (Beta) I want. Thank you.
I allocated beta constant (bhat(1)) into the components, which I am trying to fix. The first image file attached is the result of the allocation. The allocated beta makes it difficult to see how each component is contributing to the growth level.
caihat is the blue line. Notice how I did not add the beta here and this is making difference between the blue line in the upper graph and the composite value of the lower graph (they should be same). To remove the difference, I want to add back the beta, but not the way I did before. I want to make the BASE (which is 0 now, to 5.2, which is my beta in this case). The attached image file will explain in more detail. It might be simple if I simply want to change those numbers by hand, but I am running this model with tens of country in regular basis, so I want to know how I will be able to change the base into a datapoint (Beta) I want. Thank you.
- Attachments
-
- data.PNG (36.45 KiB) Viewed 5633 times
Last edited by dean.hong on Fri Jun 24, 2016 7:01 am, edited 1 time in total.
-
EViews Gareth
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13603
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Rebasing a dataset
I guess I'm just not seeing the issue. Why can't you just add 5.2 to the numbers?
Re: Rebasing a dataset
Because if I just add the number (5.2) without rebasing as you suggested, I get the graph I am attaching now. Because the beta is too high, it is difficult to look how each component is contributing to the growth. The goal of this graph is to see how each component is contributing to the "exact" growth level. I decided to divide 5.2 by 6 (the number of components) and allocate equally to each component, but I ended up getting the graph that I posted first, and it does not reflect the growth level, as each component data contain beta/n. I would love to know if there is a way to rebase 0 to the beta coefficient that I have if I can just change the label of the tick mark. Thanks.
- Attachments
-
- beta add.PNG (12.46 KiB) Viewed 5623 times
-
EViews Gareth
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13603
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Rebasing a dataset
Then I'm afraid my understanding of your issue is not good enough to help. I still have no idea what you're doing.
Re: Rebasing a dataset
Thanks for the response and I appreciate your help. Let me put this way. Is there any way I can re-label tick marks? Even if you cannot understand the logic behind it and why I'm doing it, I hope you understood what I am trying to do. I just want another label and that's it. Please see the attached image. I tried my best to be clear as possible. If there is any function, code or anything that can do anything like that, please let me know. Very much appreciate it.
- Attachments
-
- data.PNG (13.94 KiB) Viewed 5620 times
-
EViews Gareth
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13603
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Rebasing a dataset
No you cannot, but that's because it is generally trivial to change the numbers in the graph, rather than change the labels.
Re: Rebasing a dataset
Then I guess I'll have to stick with what I have. Thank you for the answer.
Who is online
Users browsing this forum: No registered users and 2 guests
