Hi Jonathan, On a side note, my predicted values are consistently about $50,000 higher than the ones you got from what were using. Since I don't know what exactly your tool is doing, I can't tell you why that is).
If you want to take into account the fact that it's actually a time series, R has plenty of tools for that too. can u please tell me how u got $50,000 values,how u got that values what methods u have applied . Thanks and Regards Chinna. On Thu, Mar 11, 2010 at 11:33 PM, Jonathan Christensen [via R] < ml-node+1589394-1322271195-172...@n4.nabble.com<ml-node%2b1589394-1322271195-172...@n4.nabble.com> > wrote: > Hi, > > On Thu, Mar 11, 2010 at 3:46 AM, chinna <[hidden > email]<http://n4.nabble.com/user/SendEmail.jtp?type=node&node=1589394&i=0>> > wrote: > > > > > Hi Peter konings, > > Sorry man the forecasted values i have given wrong ........ > > once again see my question and please give me the answer. > > > > <snip> > > > > > This is the forecasted report that i get using the reporting tool > cognos(BI > > Reporting Tool). > > is this is possible with the R project. > > If possible can u please tell me the way. > > > > Certainly. Here's a really simple solution: > > Load the data into R using read.table (this may involve cleaning up the > dollar amounts). It looks linear (scatterplot of revenue and > quarter_index), > so fit a linear model (Revenue ~ quarter_index) with lm(). Use the object > created and a dataframe of what values you want to predict (probably > quarter_index=seq(1,16)) with the predict() command. > > For a bit more information, see > > http://cran.r-project.org/doc/manuals/R-intro.html#Linear-models > > and the following section. Also try ?lm, ?predict. > > (On a side note, my predicted values are consistently about $50,000 higher > than the ones you got from what were using. Since I don't know what exactly > > your tool is doing, I can't tell you why that is). > > If you want to take into account the fact that it's actually a time series, > > R has plenty of tools for that too. > > Jonathan > > > > > > > Thanks in advance > > chinna. > > -- > > View this message in context: > > http://n4.nabble.com/see-the-example-and-help-me-tp1587229p1588761.html > > Sent from the R help mailing list archive at Nabble.com. > > > > ______________________________________________ > > [hidden > > email]<http://n4.nabble.com/user/SendEmail.jtp?type=node&node=1589394&i=1>mailing > > list > > 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. > > > > [[alternative HTML version deleted]] > > ______________________________________________ > [hidden > email]<http://n4.nabble.com/user/SendEmail.jtp?type=node&node=1589394&i=2>mailing > list > 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. > > > ------------------------------ > View message @ > http://n4.nabble.com/see-the-example-and-help-me-tp1587229p1589394.html > To unsubscribe from Re: see the example and help me, click here< (link > removed) ==>. > > > -- View this message in context: http://n4.nabble.com/see-the-example-and-help-me-tp1587229p1592979.html Sent from the R help mailing list archive at Nabble.com. [[alternative HTML version deleted]] ______________________________________________ R-help@r-project.org mailing list 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.
