Ticket Price x | Number of tickets f | P(x) | xP(x) | |
---|---|---|---|---|
Games | 1.00 | 100 | __________ | __________ |
Rides | 2.00 | 75 | __________ | __________ |
General Admission: Child | 5.00 | 40 | __________ | __________ |
General Admission: Adult | 8.00 | 60 | __________ | __________ |
Ring Side: Child | 8.00 | 85 | __________ | __________ |
Ring Side: Adult | 10.00 | 115 | __________ | __________ |
Headless woman from Thailand | 1.00 | 25 | __________ | __________ |
__________ | __________ | __________ |
Calculate a z value from an x | z | = | =STANDARDIZE(x, m, s) |
Calculate an x value from a z | x | = s z + m | = s*z+m |
Find a probability p from a z value | =NORMSDIST(z) | ||
Find a z value from a probability p | =NORMSINV(p) |