prob2

til women love chris crocker porn from leave britney alone
napalm girl slive
1300dead 12000 infected resistant flu france

sumproduct is multiply columns with corresponding rows
you can get the sum of means that way
randbetween generate random

when i say expected value is outcome value i mean value of outcome repeated so many times that it is expected

squared deviation is outcome value subtract mean. and square it
probability times square deviation with sumproduct is var
then sqrt for standard dev

or square all outcome values nd subtract mean squared for variance

binomial is boolean

50 is large batch. removing a chip doesnt really affect the outcomes that much compared to small

 

below is probabiloty of binom

https://youtu.be/eVaPNCBEXkE
n is njmber outcomes x is number times repeat p is prob

the binom.dist.range lets you select and see start and end of which outcomes you want to know likelihood. basically the range

In a hypergeometric distribution, the success in one trial affects the success in another trial. Typically, you use the HYPGEOM.DIST function when you take samples from a finite population and don’t replace the samples for subsequent trials.

mean of expected values same concept as binomial
mean is number of outcomes times probabiloty of fail
variance you also times above with  prob success
sd sqrt it

poisson is skew so good  to show how many rare evrnts happen no matter how many populations

poisson.dist x ,mean ,less or exactly as x events

0 exact 1 being less and equal

to find range in poisson subtract the start and end of range but under 1 meaning less and equal than x events

however lower boundary of range is 1 less since it is les AND EQUAL to x included 

for discrete values continuous normal its centred at 90 so choose 90.5 for guessing chance get total of less or equal 90 whats exactly total use norm dist true 

lambda means known. lambda is mean of poisson since poisson doesnt count how many events dont occur

thus mean is same as variance in poisson

norm.dist prob

set to true  means less or equsl

gives height but you cant really give exact if continuous 

norm.inv value

you can sum var but not sd

standardize function for zscores sd

dblclick drag corner in cell fill arrays to match table next to it