Probability exercises review, Assignments of Mathematics

Solution to basic probability exercises in Microsoft excel

Typology: Assignments

2022/2023

Uploaded on 09/22/2023

juank-z-bk
juank-z-bk 🇬🇧

2 documents

1 / 20

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
a)
b)
c)
pf3
pf4
pf5
pf8
pf9
pfa
pfd
pfe
pff
pf12
pf13
pf14

Partial preview of the text

Download Probability exercises review and more Assignments Mathematics in PDF only on Docsity!

a) b) c)

P(B)

a) 0 b) 0

a) b) c) d)

BINOM.DIST(3,20,0.1, TRUE) – BINOM.DIST(0,20,0.1, TRUE)

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.