[R] [FORGED] Export Forecasted output to a table (excel)

Rolf Turner r.turner at auckland.ac.nz
Wed Feb 1 23:05:15 CET 2017


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(vars)
> 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:

     http://www.stat.uiowa.edu/~jcryer/JSMTalk2001.pdf

cheers,

Rolf Turner

-- 
Technical Editor ANZJS
Department of Statistics
University of Auckland
Phone: +64-9-373-7599 ext. 88276



More information about the R-help mailing list