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

    thanks
     
  2. jcsd
  3. Simon Bridge

    Simon Bridge 14,658
    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,500
    Staff Emeritus
    Science Advisor
    Gold Member

Know someone interested in this topic? Share a link to this question via email, Google+, Twitter, or Facebook

Have something to add?

0
Draft saved Draft deleted