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

[David Winsemius]

> On Feb 1, 2017, at 2:30 PM, David Winsemius <dwinsemius at comcast.net> wrote:
> 
> 
>> 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

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 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
> 
> ______________________________________________
> 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