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
______________________________________________
R-help@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.
