sample report data that i want to forecast quarter quarter_index Revenue 2007 Q1 1 $3,856,799 2007 Q2 2 $4,243,328 2007 Q3 3 $4,930,369 2007 Q4 4 $5,443,579 2008 Q1 5 $5,164,830 2008 Q2 6 $5,104,413 2008 Q3 7 $5,713,240 2008 Q4 8 $6,509,331 2009 Q1 9 $6,271,951 2009 Q2 10 $6,657,190 2009 Q3 11 $6,979,821 2009 Q4 12 $7,581,619 forecasted report for the year 2010 quarter Revenue Revenue Predictor 2007 Q1 $3,856,799 $4,032,525 2007 Q2 $4,243,328 $4,032,525 2007 Q3 $4,930,369 $4,032,525 2007 Q4 $5,443,579 $4,032,525 2008 Q1 $5,164,830 $4,032,525 2008 Q2 $5,104,413 $4,032,525 2008 Q3 $5,713,240 $4,032,525 2008 Q4 $6,509,331 $4,032,525 2009 Q1 $6,271,951 $4,032,525 2009 Q2 $6,657,190 $4,032,525 2009 Q3 $6,979,821 $4,032,525 2009 Q4 $7,581,619 $4,032,525 2010 Q1 $4,032,525 2010 Q2 $4,032,525 2010 Q3 $4,032,525 2010 Q4 $4,032,525 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. Thanks in advance chinna. -- View this message in context: http://n4.nabble.com/see-the-example-and-help-me-tp1587229p1587229.html Sent from the R help mailing list archive at Nabble.com.
Sure. Say your sample data is a dataframe called sampledata: sampledata$revenuePredictor <- 4032525 You might want to use a different model to predict revenue, though. On Wed, Mar 10, 2010 at 11:59 AM, chinna <durgachennu@gmail.com> wrote:> > sample report data that i want to forecast > > quarter quarter_index Revenue > 2007 Q1 1 $3,856,799 > 2007 Q2 2 $4,243,328 > 2007 Q3 3 $4,930,369 > 2007 Q4 4 $5,443,579 > 2008 Q1 5 $5,164,830 > 2008 Q2 6 $5,104,413 > 2008 Q3 7 $5,713,240 > 2008 Q4 8 $6,509,331 > 2009 Q1 9 $6,271,951 > 2009 Q2 10 $6,657,190 > 2009 Q3 11 $6,979,821 > 2009 Q4 12 $7,581,619 > > forecasted report for the year 2010 > > quarter Revenue Revenue Predictor > 2007 Q1 $3,856,799 $4,032,525 > 2007 Q2 $4,243,328 $4,032,525 > 2007 Q3 $4,930,369 $4,032,525 > 2007 Q4 $5,443,579 $4,032,525 > 2008 Q1 $5,164,830 $4,032,525 > 2008 Q2 $5,104,413 $4,032,525 > 2008 Q3 $5,713,240 $4,032,525 > 2008 Q4 $6,509,331 $4,032,525 > 2009 Q1 $6,271,951 $4,032,525 > 2009 Q2 $6,657,190 $4,032,525 > 2009 Q3 $6,979,821 $4,032,525 > 2009 Q4 $7,581,619 $4,032,525 > 2010 Q1 $4,032,525 > 2010 Q2 $4,032,525 > 2010 Q3 $4,032,525 > 2010 Q4 $4,032,525 > > 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. > > > Thanks in advance > chinna. > > -- > View this message in context: > http://n4.nabble.com/see-the-example-and-help-me-tp1587229p1587229.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > 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. >[[alternative HTML version deleted]]
Hi, can u please elaborate your answer..... using the first report i have to generate second report for the year 2010 quarterly forecasted results. Thanks in advance. -- View this message in context: http://n4.nabble.com/see-the-example-and-help-me-tp1587229p1587386.html Sent from the R help mailing list archive at Nabble.com.
Hi Peter konings, Sorry man the forecasted values i have given wrong ........ once again see my question and please give me the answer. sample report data that i want to forecast quarter quarter_index Revenue 2007 Q1 1 $3,856,799 2007 Q2 2 $4,243,328 2007 Q3 3 $4,930,369 2007 Q4 4 $5,443,579 2008 Q1 5 $5,164,830 2008 Q2 6 $5,104,413 2008 Q3 7 $5,713,240 2008 Q4 8 $6,509,331 2009 Q1 9 $6,271,951 2009 Q2 10 $6,657,190 2009 Q3 11 $6,979,821 2009 Q4 12 $7,581,619 forecasted report for the year 2010 quarter Revenue Revenue Predictor 2007 Q1 $3,856,799 $4,032,525 2007 Q2 $4,243,328 $4,335,194 2007 Q3 $4,930,369 $4,637,864 2007 Q4 $5,443,579 $4,940,533 2008 Q1 $5,164,830 $5,243,202 2008 Q2 $5,104,413 $5,545,871 2008 Q3 $5,713,240 $5,848,540 2008 Q4 $6,509,331 $6,151,210 2009 Q1 $6,271,951 $6,453,879 2009 Q2 $6,657,190 $6,756,548 2009 Q3 $6,979,821 $7,059,217 2009 Q4 $7,581,619 $7,361,886 2010 Q1 $7,664,555 2010 Q2 $7,967,225 2010 Q3 $8,269,894 2010 Q4 $8,572,563 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. 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.