1. Limited time only! Sign up for a free 30min personal tutor trial with Chegg Tutors
    Dismiss Notice
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
    2016 Award

    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




Similar Discussions: Excel data analysis
  1. Data analysis (Replies: 2)

  2. An excellent problem (Replies: 6)

Loading...