Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Excel data analysis

  1. Oct 16, 2013 #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. Oct 17, 2013 #2

    Simon Bridge

    User Avatar
    Science Advisor
    Homework Helper
    Gold Member

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

    thanks for the reply though
     
  5. Oct 17, 2013 #4

    Office_Shredder

    User Avatar
    Staff Emeritus
    Science Advisor
    Gold Member

Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook

Have something to add?
Draft saved Draft deleted
Similar Discussions: Excel data analysis
  1. Data analysis (Replies: 2)

  2. An excellent problem (Replies: 6)

Loading...