Skip navigation

This discussion is archived

1 Reply Latest reply on Sep 15, 2014 10:10 AM by Cac47

Display the Simulated Sales and Sales Forecast using Least Square Regression - REGR_SLOPE

Cac47 Sep 15, 2014 9:58 AM

Hi there,

I've this table

How Can I get the Values for the 2014_Forecast and Simulated_2014 using the Least_Square_Regresion or using REGR_SLOPE function?

TRANSACTION_TYPE	MONTH	YEAR_2012	YEAR_2013	2014_Forecast	Simulated_2014
Sales	01	-18.74	-38.00
Sales	02	-19.60	-34.09
Sales	03	-20.20	-33.10
Sales	04	-19.96	-32.21
Sales	05	-23.13	-29.63
Sales	06	-23.88	-28.46
Sales	07	-30.11	-43.89
Sales	08	-33.69	-35.97
Sales	09	-32.65	-29.57
Sales	10	-37.22	-28.18
Sales	11	-37.15	-31.63
Sales	12	-41.70	-32.76

Thanks in advance fro your Help.

Rgds

Carlos

1. Re: Display the Simulated Sales and Sales Forecast using Least Square Regression - REGR_SLOPE

Cac47 Sep 15, 2014 10:10 AM (in response to Cac47)

Sorry Guys,
I'm in the wrong Discussion Group.
I'm moving to Pl/SQL
Thank you anymay
Like Show 0 Likes(0)

Actions