Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Trending News

Promoted
txgreenant
txgreenant asked in Science & MathematicsMathematics · 1 decade ago

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.

3 Answers

Relevance
  • nader h
    1 decade ago
    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
    4 years ago

    Expected Value In Excel

    Source(s): https://shrinks.im/a0K6u
  • Anonymous
    5 years ago

    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.

Still have questions? Get your answers by asking now.