Message-ID: <1d107d1b-95fc-3fc7-5e72-de1df7edb7e5@auckland.ac.nz>
Date: 2017-02-01T22:49:59Z
From: Rolf Turner
Subject: [FORGED] Re: [FORGED] Export Forecasted output to a table (excel)
In-Reply-To: <d4b2066f-c521-8761-a20b-86bb046a7052@gmail.com>
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