[FORGED] Re: [FORGED] Export Forecasted output to a table (excel)
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(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.
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. https://www.google.co.nz/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&cad=rja&uact=8&ved=0ahUKEwilxsmC_O_RAhVEmJQKHeTKDrkQFggYMAA&url=https%3A%2F%2Foit.utk.edu%2Fresearch%2Fdocumentation%2FDocuments%2FExcelStatProbs.pdf&usg=AFQjCNEocZnHA4b9_9FNxkD2lzHBA9EaNw cheers, Rolf P.S. See also: http://www.burns-stat.com/documents/tutorials/spreadsheet-addiction/ R.
Technical Editor ANZJS Department of Statistics University of Auckland Phone: +64-9-373-7599 ext. 88276