Search found 2673 matches
- Thu May 14, 2009 11:02 am
- Forum: Data Manipulation
- Topic: importing multiple spreedsheet tabs
- Replies: 12
- Views: 13441
Re: importing multiple spreedsheet tabs
You do need to know the names of the sheets, but the formats need not be the same since they will be read into different pages.
- Thu May 14, 2009 10:54 am
- Forum: Data Manipulation
- Topic: Problem with merged graph
- Replies: 1
- Views: 3184
Re: Problem with merged graph
No. The closest thing to this is to put the graphs in a spool object...
- Thu May 14, 2009 10:50 am
- Forum: Data Manipulation
- Topic: importing multiple spreedsheet tabs
- Replies: 12
- Views: 13441
Re: importing multiple spreedsheet tabs
Gareth is correct as far as dragging-and-dropping, but this can be automated via a simple program. Suppose we have have a workbook BOOK1.XLS that has three sheets SHEET1, SHEET2, and SHEET3. Then the following code fragment will create a new EViews workfile named BOOK1, with three pages correspondin...
- Thu May 14, 2009 10:37 am
- Forum: Estimation
- Topic: One tail t-statistics
- Replies: 2
- Views: 14244
Re: One tail t-statistics
I'll add to Startz's comment by noting that you can use the @qtdist function to get the appropriate critical value (without having to look things up in a table). For example, the (upper) one-tailed .05 critical value may be obtained by @qtdist(.95, df), where df is the degrees-of-freedom. I'll also ...
- Thu May 14, 2009 10:32 am
- Forum: Bug Reports
- Topic: Time Series Functions - Year to Date (YTD) Variations
- Replies: 12
- Views: 17600
Re: Time Series Functions - Year to Date (YTD) Variations
Unless you really are worried about memory use, wouldn't just replacing the original series and deleting the temp be easier?
Code: Select all
series sum = @recode(@month=1 or @trend=0,x,x+sum(-1))
x=sum
delete sum
- Tue May 12, 2009 10:14 am
- Forum: Suggestions and Requests
- Topic: Frequency Conversion - Help
- Replies: 5
- Views: 8103
Re: Frequency Conversion - Help
If you're doing it a lot, I'd wrap it in a subroutine then you should be good to go.
- Tue May 12, 2009 6:58 am
- Forum: Suggestions and Requests
- Topic: Frequency Conversion - Help
- Replies: 5
- Views: 8103
Re: Frequency Conversion - Help
This is one of those conversions that I've wanted to make one of our automatic ones, but it's never advanced beyond a request. Having said that, it's not too hard to do semi-manually. What you can do is to use the built-in repeated value conversion (by value), then to set the sample to exclude all b...
- Mon May 11, 2009 1:24 pm
- Forum: Bug Reports
- Topic: Hausman test in Eviews 6, error?
- Replies: 3
- Views: 10051
Re: Hausman test in Eviews 6, error?
Gareth is correct about the Var(diff) column, which reports the variance of the different not the difference. I've taken a look at the results for these data, and there are differences in the overall test statistic between EViews and Stata (which the original poster didn't elaborate on, EViews has a...
- Mon May 11, 2009 6:39 am
- Forum: Estimation
- Topic: forecasts with LOGL object
- Replies: 1
- Views: 2836
Re: forecasts with LOGL object
Make a model object from your LOGL using Proc/Make Model.
- Mon May 11, 2009 6:28 am
- Forum: Estimation
- Topic: Sorting groups after quantiles
- Replies: 8
- Views: 7920
Re: Sorting groups after quantiles
If you want the firm specific, you should look at using @quantilesby instead of @quantiles...
- Thu May 07, 2009 1:24 pm
- Forum: Estimation
- Topic: Sorting groups after quantiles
- Replies: 8
- Views: 7920
Re: Sorting groups after quantiles
Do you want the quantiles within the asset group, or the firm specific quantiles within the asset group?
- Thu May 07, 2009 7:04 am
- Forum: Estimation
- Topic: Partial Sum of Squares
- Replies: 6
- Views: 6436
Re: Partial Sum of Squares
It's not a built-in feature, but can be calculated with only a bit of work. Can you tell me a bit more about your base equation (how many variables, etc.) and what you want the final output to look like? And lastly, how exactly do you want to use the results? As a table of output for presentation, o...
- Wed May 06, 2009 10:07 am
- Forum: Estimation
- Topic: Poisson Regression: Z-Statistic, LR Test, and Overdispersion
- Replies: 5
- Views: 12156
Re: Poisson Regression: Z-Statistic, LR Test, and Overdispersion
The S.E. of the regression is simply the standard estimator of the root of the variance of the residuals. I'm not certain what you mean by correct here. For the scaling of the test statistic, you do need an estimate of the variance factor that relates the variance of the data to the restricted ML va...
- Tue May 05, 2009 1:24 pm
- Forum: Estimation
- Topic: Poisson Regression: Z-Statistic, LR Test, and Overdispersion
- Replies: 5
- Views: 12156
Re: Poisson Regression: Z-Statistic, LR Test, and Overdispersion
The LR statistic does maintain the mean-variance assumption. As you note, the Wald does. But all is not lost. EViews doesn't adjust the LR statistics for overdispersion automatically (it's on our lengthy list of things to look at). Part of the reason it hasn't been done is that it's not difficult to...
- Tue May 05, 2009 6:38 am
- Forum: Estimation
- Topic: help for unit root test
- Replies: 1
- Views: 3686
Re: help for unit root test
Your instructor is correct. You could run the test on the residuals and then look up the critical values in the Engle-Granger paper or in one of the other sources for simulated values. There was a recent set of threads on this issue. http://forums.eviews.com/viewtopic.php?f=5&t=715&p=2364&am...