> On Feb 1, 2017, at 2:30 PM, David Winsemius <dwinsem...@comcast.net> wrote: > > >> On Feb 1, 2017, at 2:25 PM, Daniel Nordlund <djnordl...@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
That did seem somewhat dated after I read it (being 15 years old) and I think other resources might be more current: https://web.stanford.edu/group/ssds/cgi-bin/drupal/files/Guides/Using%20Excel%20for%20Data%20Manipulation%20and%20Statistical%20Analysis_1.pdf http://people.umass.edu/evagold/excel.html http://www.burns-stat.com/documents/tutorials/spreadsheet-addiction http://www.phusewiki.org/docs/2009%20PAPERS/SP06.pdf http://homepages.ulb.ac.be/~gmelard/rech/gmelard_csda23.pdf -- David. > >> >> Dan >> >> -- >> Daniel Nordlund >> Port Townsend, WA USA >> >> ______________________________________________ >> 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. > > David Winsemius > Alameda, CA, USA > > ______________________________________________ > 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. David Winsemius Alameda, CA, USA ______________________________________________ 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.
