What is the formula to calculate the expected values in excel?
I am doing this for a statistics class and the professor said to google how to do it. I have been looking for almost an hour to no avail.
I am doing this for a statistics class and the professor said to google how to do it. I have been looking for almost an hour to no avail.
nader h
Favorite Answer
if the sample is nt complicated thn the simplest expectd value is the average. Anthr one is by counting the occurance of each item multiplied by the item itself divided by the total population count
everitt
Expected Value In Excel
Anonymous
1. Type 1.05 in any cell. Then click on that cell and press Ctrl+C. 2. Select the range to multiply by (let's say it's A2:A500) 3. Press Ctrl+Alt+V, then select the "Multiply" option, and click OK. 4. Repeat steps 2 and 3 for other ranges you might have. 5. Delete the cell that has the 1.05 in it.