[R] [FORGED] Re: [FORGED] Export Forecasted output to a table (excel)
r.turner at auckland.ac.nz
Wed Feb 1 23:49:59 CET 2017
On 02/02/17 11:25, Daniel Nordlund wrote:
> On 2/1/2017 2:05 PM, Rolf Turner wrote:
>> On 02/02/17 08:03, Lal Prasad wrote:
>>> Hi All,
>>> Is there any way to
>>> 1) Convert the below forecast to a datafram
>>> 2) Any way to write it to an excel table?
>>> library(fpp)VARselect(usconsumption, lag.max = 3,
>>> type="const")$selectionvar <- VAR(usconsumption, p=1,type =
>>> "both",lag.max = 3)
>>> serial.test(var, lags.pt = 3,type = "PT.asymptotic")
>>> fcst <- forecast(var)
>> (1) Read the posting guide.
>> (2) In particular don't post in HTML.
>> (3) As it appears, your code makes no sense to me.
>> (4) DON'T use Excel. Ever. See:
>> Rolf Turner
> Unfortunately, that link appears to be broken / does not exist anymore.
Thanks for pointing that out Dan. The following rather messy link does
seem to work. The line gets wrapped (at least it does in my mailer) so
you may need to mess around copying and pasting.
P.S. See also:
Technical Editor ANZJS
Department of Statistics
University of Auckland
Phone: +64-9-373-7599 ext. 88276
More information about the R-help