Abstract

SummaryUsing the spreadsheet function SUMPRODUCT which calculates dot products, it is possible to compute the probabilities associated with the sums of independent discrete random variables. This allows the student to confirm properties of the sum of binomial and Poisson random variables. It also provides a method for computing the distribution of the sum of two (or more) arbitrary random variables. In addition, it also allows the student to compute the probabilities associated with the difference of random variables, and thus find the probability that one random variable exceeds another (or exceeds by a given amount).

Talk to us

Join us for a 30 min session where you can share your feedback and ask us any queries you have

Schedule a call

Disclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.