looking for help with parts a and b, thank you! (if you could show me how or explain how to do this in excel that would be most helpful) Thank you!
Addition Rule of Probability
It simply refers to the likelihood of an event taking place whenever the occurrence of an event is uncertain. The probability of a single event can be calculated by dividing the number of successful trials of that event by the total number of trials.
Expected Value
When a large number of trials are performed for any random variable ‘X’, the predicted result is most likely the mean of all the outcomes for the random variable and it is known as expected value also known as expectation. The expected value, also known as the expectation, is denoted by: E(X).
Probability Distributions
Understanding probability is necessary to know the probability distributions. In statistics, probability is how the uncertainty of an event is measured. This event can be anything. The most common examples include tossing a coin, rolling a die, or choosing a card. Each of these events has multiple possibilities. Every such possibility is measured with the help of probability. To be more precise, the probability is used for calculating the occurrence of events that may or may not happen. Probability does not give sure results. Unless the probability of any event is 1, the different outcomes may or may not happen in real life, regardless of how less or how more their probability is.
Basic Probability
The simple definition of probability it is a chance of the occurrence of an event. It is defined in numerical form and the probability value is between 0 to 1. The probability value 0 indicates that there is no chance of that event occurring and the probability value 1 indicates that the event will occur. Sum of the probability value must be 1. The probability value is never a negative number. If it happens, then recheck the calculation.
looking for help with parts a and b, thank you! (if you could show me how or explain how to do this in excel that would be most helpful) Thank you!
Formulae for mean & standard deviation of frequency table :
- Mean :
Add up all the numbers,
then divide by how many numbers there are.
- Standard deviation :
The standard deviation is a statistic that measures the scattering of a group of values relative to the mean. It is determined as the square root of the variance.
Given Information :
The manager of the commercial department of a large bank has collected data during the past two years concerning the number of commercial mortgages approved per week . The results from these two years (104 weeks) are shown to the right .
To obtain mean & standard deviation of the data , following table is to be obtained :
| Number Approved (x) | Frequency (f) | xf | (x- ) | (x - )2 | f*(x-)2 |
| 0 | 14 | 0 | -2.16 | 4.6656 | 65.3184 |
| 1 | 25 | 25 | -1.16 | 1.3456 | 33.64 |
| 2 | 28 | 56 | -0.16 | 0.0256 | 0.7168 |
| 3 | 18 | 54 | 0.84 | 0.7056 | 12.7008 |
| 4 | 9 | 36 | 1.84 | 3.3856 | 30.4704 |
| 5 | 7 | 35 | 2.84 | 8.0656 | 56.4592 |
| 6 | 2 | 12 | 3.84 | 14.7456 | 29.4912 |
| 7 | 1 | 7 | 4.84 | 23.4256 | 23.4256 |
| Totals : | 104 | 225 | 252.2224 |
Step by step
Solved in 3 steps
