Funciones De Crystal Ball
I'r"obnbilit1, CB.xxx (distribution parameters) llistrihutions
CB.GetFore StatFN (ForeReferencg, Index)Simulation Results
l.tttrcliotts|trreachol.t|teptoltnlrilityttiitrffi Iist in Table 3.1 (page88) of Evans& Olson book. Returnsdescriptivestatistic ForeReference must point to a defined forecastcell (ifnot, #VALUE is displayed). Indexis a nunrber betweenI ancl13.Beforst sirnulation ru', or afterresettingthe results shown0s zeroes. is are The valuesof Indexretumthe following values: l: nurnber trialsof 2: mean 3: median 4: mode 5: standard deviation 6; varianco 7: skewness 8: kurtosis 9: cocflicientof variability l0: minimum Il:maximum 12: ronge(nax-min) 13: standard error
I\lodel InformutlonC'tJ.fielForel)erceut l-orel{el'ere FN( nce,Percent) Cti.GelCerlilint.v l or.el(c l-'N1 l'erenc e, Value) ('lJ.llerirliousFN( I (AssutrrRcl. ClJ.CetAssunrlrN lndcx) CB.GcJAs umPcrcen (A ssumR s tFNel'erence, Perccnt) Llj.ueruec v&r.N ( Decv0rRel; lndex)
Retums vulue a fbrecast of roro sp@ probability). percentile a number The is llom 0 to 100, Returns cutaintylevel(curnulative theprobobilir), a giv6Talue for ofa forecast.
lh unrber ireffi ot' llglttttrserr
Returnsinformationaboutassumption cells. Rctums pcrcentileof an assurnption@ cell's dlstrlbutlon.-slfirilar G€tForepercentFN a...
Regístrate para leer el documento completo.