How to calculate Multiple Regression in Oracle [closed]
2
In Oracle there is an inbuilt function Regr_ to calculate linear regression.Can someone advice if there is any function to find multiple regression in oracle ? I want to find one dependent variable using regression with Multiple independent variables.
oracle regression linear-regression
asked Dec 30 '18 at 14:12
razaimranrazaimran
141
closed as off-topic by OldProgrammer, EdChum, zx485, TeeKea, Rob Dec 31 '18 at 3:27
This question appears to be off-topic. The users who voted to close gave this specific reason:
- "Questions asking us to recommend or find a book, tool, software library, tutorial or other off-site resource are off-topic for Stack Overflow as they tend to attract opinionated answers and spam. Instead, describe the problem and what has been done so far to solve it." – OldProgrammer, EdChum, zx485, TeeKea, Rob
If this question can be reworded to fit the rules in the help center, please edit the question.
add a comment |
2
In Oracle there is an inbuilt function Regr_ to calculate linear regression.Can someone advice if there is any function to find multiple regression in oracle ? I want to find one dependent variable using regression with Multiple independent variables.
oracle regression linear-regression
asked Dec 30 '18 at 14:12
razaimranrazaimran
141
closed as off-topic by OldProgrammer, EdChum, zx485, TeeKea, Rob Dec 31 '18 at 3:27
This question appears to be off-topic. The users who voted to close gave this specific reason:
- "Questions asking us to recommend or find a book, tool, software library, tutorial or other off-site resource are off-topic for Stack Overflow as they tend to attract opinionated answers and spam. Instead, describe the problem and what has been done so far to solve it." – OldProgrammer, EdChum, zx485, TeeKea, Rob
If this question can be reworded to fit the rules in the help center, please edit the question.
The Oracle docs at docs.oracle.com/cd/E57185_01/CBPUG/ch03s04s03.html say for step 1: "On the Predictor wizard Methods panel, select Multiple Linear Regression.", and dba-oracle.com/t_callan_using_sql_part1.htm has discussion if regr_ for multiple regression.
– James Phillips
Dec 30 '18 at 14:44
@JamesPhillips - the first link is to the documentation for Predictor, which is part of Oracle's Hyperion suite, a completely separate product from the RDBMS and so rather unhelpful as a hint. The Steve Callan article is almost fifteen years old, but at least it's about actual Oracle SQL, so that's something.
– APC
Dec 30 '18 at 16:34
Have a look at the UTL_NLA package. Oracle 12c docs here. The Datawarehousing guide has an example of implementing Linear Algebra which you may find useful. Check it out
– APC
Dec 30 '18 at 16:43
add a comment |
2
2
2
In Oracle there is an inbuilt function Regr_ to calculate linear regression.Can someone advice if there is any function to find multiple regression in oracle ? I want to find one dependent variable using regression with Multiple independent variables.
oracle regression linear-regression
asked Dec 30 '18 at 14:12
razaimranrazaimran
141
In Oracle there is an inbuilt function Regr_ to calculate linear regression.Can someone advice if there is any function to find multiple regression in oracle ? I want to find one dependent variable using regression with Multiple independent variables.
oracle regression linear-regression
oracle regression linear-regression
asked Dec 30 '18 at 14:12
razaimranrazaimran
141
asked Dec 30 '18 at 14:12
razaimranrazaimran
141
asked Dec 30 '18 at 14:12
razaimranrazaimran
141
asked Dec 30 '18 at 14:12
razaimranrazaimran
141
asked Dec 30 '18 at 14:12
razaimranrazaimran
141
141
closed as off-topic by OldProgrammer, EdChum, zx485, TeeKea, Rob Dec 31 '18 at 3:27
This question appears to be off-topic. The users who voted to close gave this specific reason:
- "Questions asking us to recommend or find a book, tool, software library, tutorial or other off-site resource are off-topic for Stack Overflow as they tend to attract opinionated answers and spam. Instead, describe the problem and what has been done so far to solve it." – OldProgrammer, EdChum, zx485, TeeKea, Rob
If this question can be reworded to fit the rules in the help center, please edit the question.
closed as off-topic by OldProgrammer, EdChum, zx485, TeeKea, Rob Dec 31 '18 at 3:27
This question appears to be off-topic. The users who voted to close gave this specific reason:
- "Questions asking us to recommend or find a book, tool, software library, tutorial or other off-site resource are off-topic for Stack Overflow as they tend to attract opinionated answers and spam. Instead, describe the problem and what has been done so far to solve it." – OldProgrammer, EdChum, zx485, TeeKea, Rob
If this question can be reworded to fit the rules in the help center, please edit the question.
The Oracle docs at docs.oracle.com/cd/E57185_01/CBPUG/ch03s04s03.html say for step 1: "On the Predictor wizard Methods panel, select Multiple Linear Regression.", and dba-oracle.com/t_callan_using_sql_part1.htm has discussion if regr_ for multiple regression.
– James Phillips
Dec 30 '18 at 14:44
@JamesPhillips - the first link is to the documentation for Predictor, which is part of Oracle's Hyperion suite, a completely separate product from the RDBMS and so rather unhelpful as a hint. The Steve Callan article is almost fifteen years old, but at least it's about actual Oracle SQL, so that's something.
– APC
Dec 30 '18 at 16:34
Have a look at the UTL_NLA package. Oracle 12c docs here. The Datawarehousing guide has an example of implementing Linear Algebra which you may find useful. Check it out
– APC
Dec 30 '18 at 16:43
add a comment |
The Oracle docs at docs.oracle.com/cd/E57185_01/CBPUG/ch03s04s03.html say for step 1: "On the Predictor wizard Methods panel, select Multiple Linear Regression.", and dba-oracle.com/t_callan_using_sql_part1.htm has discussion if regr_ for multiple regression.
– James Phillips
Dec 30 '18 at 14:44
@JamesPhillips - the first link is to the documentation for Predictor, which is part of Oracle's Hyperion suite, a completely separate product from the RDBMS and so rather unhelpful as a hint. The Steve Callan article is almost fifteen years old, but at least it's about actual Oracle SQL, so that's something.
– APC
Dec 30 '18 at 16:34
Have a look at the UTL_NLA package. Oracle 12c docs here. The Datawarehousing guide has an example of implementing Linear Algebra which you may find useful. Check it out
– APC
Dec 30 '18 at 16:43
The Oracle docs at docs.oracle.com/cd/E57185_01/CBPUG/ch03s04s03.html say for step 1: "On the Predictor wizard Methods panel, select Multiple Linear Regression.", and dba-oracle.com/t_callan_using_sql_part1.htm has discussion if regr_ for multiple regression.
– James Phillips
Dec 30 '18 at 14:44
The Oracle docs at docs.oracle.com/cd/E57185_01/CBPUG/ch03s04s03.html say for step 1: "On the Predictor wizard Methods panel, select Multiple Linear Regression.", and dba-oracle.com/t_callan_using_sql_part1.htm has discussion if regr_ for multiple regression.
– James Phillips
Dec 30 '18 at 14:44
@JamesPhillips - the first link is to the documentation for Predictor, which is part of Oracle's Hyperion suite, a completely separate product from the RDBMS and so rather unhelpful as a hint. The Steve Callan article is almost fifteen years old, but at least it's about actual Oracle SQL, so that's something.
– APC
Dec 30 '18 at 16:34
@JamesPhillips - the first link is to the documentation for Predictor, which is part of Oracle's Hyperion suite, a completely separate product from the RDBMS and so rather unhelpful as a hint. The Steve Callan article is almost fifteen years old, but at least it's about actual Oracle SQL, so that's something.
– APC
Dec 30 '18 at 16:34
Have a look at the UTL_NLA package. Oracle 12c docs here. The Datawarehousing guide has an example of implementing Linear Algebra which you may find useful. Check it out
– APC
Dec 30 '18 at 16:43
Have a look at the UTL_NLA package. Oracle 12c docs here. The Datawarehousing guide has an example of implementing Linear Algebra which you may find useful. Check it out
– APC
Dec 30 '18 at 16:43
add a comment |
0
active
oldest
votes
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
The Oracle docs at docs.oracle.com/cd/E57185_01/CBPUG/ch03s04s03.html say for step 1: "On the Predictor wizard Methods panel, select Multiple Linear Regression.", and dba-oracle.com/t_callan_using_sql_part1.htm has discussion if regr_ for multiple regression.
– James Phillips
Dec 30 '18 at 14:44
@JamesPhillips - the first link is to the documentation for Predictor, which is part of Oracle's Hyperion suite, a completely separate product from the RDBMS and so rather unhelpful as a hint. The Steve Callan article is almost fifteen years old, but at least it's about actual Oracle SQL, so that's something.
– APC
Dec 30 '18 at 16:34
Have a look at the UTL_NLA package. Oracle 12c docs here. The Datawarehousing guide has an example of implementing Linear Algebra which you may find useful. Check it out
– APC
Dec 30 '18 at 16:43