Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!
Linear regression
How to calculate linear regression in oracle plsql.
Please see the file attached.
C--Tanuja-Lake_IL-BRDs-linear-regre.docx
Please see the file attached.
C--Tanuja-Lake_IL-BRDs-linear-regre.docx
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Do you have the excel file or the raw data instead of a picture of data?
In any case, you shouldn't use PL/SQL to solve this. Instead use the built in SQL aggregate function REGR_SLOPE.
SELECT REGR_SLOPE(dependent_varia
if you're trying to do it "manually" then you can use the basic SUM and COUNT aggregate functions. This does assume every (dep,indep) pair is not null for both elements, which is true for your sample data.
select ((SUM(dep * indep) - SUM(indep) * SUM(dep) / COUNT(*)) / COUNT(*)) / ((SUM(POWER(indep, 2)) - POWER(SUM(indep), 2) / COUNT(*)) / COUNT(*)) from yourtable
In any case, you shouldn't use PL/SQL to solve this. Instead use the built in SQL aggregate function REGR_SLOPE.
SELECT REGR_SLOPE(dependent_varia
if you're trying to do it "manually" then you can use the basic SUM and COUNT aggregate functions. This does assume every (dep,indep) pair is not null for both elements, which is true for your sample data.
select ((SUM(dep * indep) - SUM(indep) * SUM(dep) / COUNT(*)) / COUNT(*)) / ((SUM(POWER(indep, 2)) - POWER(SUM(indep), 2) / COUNT(*)) / COUNT(*)) from yourtable
I also Need to calculate sales ratio. I have the details attached. Really appreciate your help and time.
C--Tanuja-Lake_IL-BRDs-sales-ratio-.docx
C--Tanuja-Lake_IL-BRDs-sales-ratio-.docx
Premium Content
You need an Expert Office subscription to comment.Start Free Trial