












Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Solution to basic probability exercises in Microsoft excel
Typology: Assignments
1 / 20
This page cannot be seen from the preview
Don't miss anything!













a) b) c)
a) 0 b) 0
a) b) c) d)
a) N 225 S mean 14. S St Dev 8.
a) 42/300 = 0. b)
Claim Probability claim^2 Claim 0 0.99 0 0 500 0.008 250000 500 5000 0.002 25000000 5000 Expected claim = 14 Claims variance = Total expected claims = 560000 Claims st. Dev = Expected revenue = 600000 Net profits St dev = E(x) = Expected net profit = $ 40, Probability (profit > 0) = 0.