[FORGED] Export Forecasted output to a table (excel)
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