Excel data analysis

  1. Not sure where to post this question, but here goes

    In excel I have calculated the average annual rain for the period 1990-2012 to be 50.2mm . How do you estimate the probability that this measured average (1990-2012) is consistent with the long term mean annual rain for the period 1948-2012 (assuming a gaussian distribution) which I calculated to be 51.6mm?

    Is there some sort of function or is this simpler than I'm imagining...

    any help much appreciated

  2. jcsd
  3. Simon Bridge

    Simon Bridge 15,474
    Science Advisor
    Homework Helper
    Gold Member

    How would you normally compare two sets of statistics?
  4. Hi, I've come up with a solution I think. Going to use the NORM.DIST function

    thanks for the reply though
  5. Office_Shredder

    Office_Shredder 4,487
    Staff Emeritus
    Science Advisor
    Gold Member

Know someone interested in this topic? Share this thead via email, Google+, Twitter, or Facebook

Have something to add?

Draft saved Draft deleted