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

David Winsemius dwinsemius at comcast.net
Wed Feb 1 23:30:38 CET 2017


> On Feb 1, 2017, at 2:25 PM, Daniel Nordlund <djnordlund at gmail.com> 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(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
> 
> Unfortunately, that link appears to be broken / does not exist anymore.

A google-search quickly turned up this:

http://people.stat.sfu.ca/~cschwarz/Stat-650/Notes/Handouts.readings/ExcelPracticalforStat.pdf

> 
> Dan
> 
> -- 
> Daniel Nordlund
> Port Townsend, WA  USA
> 
> ______________________________________________
> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.

David Winsemius
Alameda, CA, USA



More information about the R-help mailing list