Skip to main content

Binomial Distrubution

Let us say getting successful end product in a trial is 30% .

Let us do 100 experiments.

Now I want to know, what is the probability that I will get :
1. Only 1 product success of 100 experiments
2. Only 2 products success out of 100 experiments.
etc..
100. All 100 success products out of 100 experiments.

This is binomial distribution.

R code:

x <- seq(0,100,by=1)
y <- dbinom(x,100,0.3)
 plot(x,y)




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…