Message-ID: <bde89d2c-0081-8e0a-c076-7c2b58c11314@auckland.ac.nz>
Date: 2017-02-01T22:05:15Z
From: Rolf Turner
Subject: [FORGED] Export Forecasted output to a table (excel)
In-Reply-To: <CACuGqa+zRfWmaNsfMvzLNbcwwcSbXxsE1RfCYp-94qAHBWHN=g@mail.gmail.com>
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