Skip to main content

R Tutorials for beginers

Here are some exceptional R tutorials for beginers

http://www.cyclismo.org/tutorial/R/probability.html
http://stattrek.com/chi-square-test/independence.aspx
http://www.r-tutor.com/elementary-statistics/probability-distributions/binomial-distribution
http://www.practicalsurveys.com/reporting/chisquare.php

--
HP

Comments

Popular posts from this blog

ORE-OBIEE Integration

Let us say I want to have prediction and linear model plots of data table in Oracle having data of height and weight using ORE, to use server memory execution rather than client memory execution and show the result in OBIEE reporting tool.

Prerequisite:

1. I have ORE in 12c pdb configured with a user, say RUSER2 with RQROLE and RQADMIN roles.
2. OBIEE 11.1.1.7.0 is configured.
3. Table PRED_TBL is created with height, weight and ID columns.
4. I know R,ORE and OBIEE

Let us start with scripts:

#olm is a ORE script which returns predicted table.
begin
sys.rqScriptDrop('olm');
sys.rqScriptCreate('olm', 'function(dat) {
raw<-dat
library(ORE)
lmdl<-lm(WEIGHT~.,raw)
lpred<-predict(lmdl,raw)
pred_tbl<-cbind(raw,lpred)
pred_tbl
}');
end;

#Creating view which calls olm script with PRED_TBL as input
create or replace view R_PREDICT as
select HEIGHT, WEIGHT, ID,LPRED from table( rqTableEval(
        cursor(select * from PRED_TBL),cursor(select 1 as "ore.con…