Excel data analysis

  • Thread starter izzy93
  • Start date
  • #1
35
0

Main Question or Discussion Point

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
 

Answers and Replies

  • #2
Simon Bridge
Science Advisor
Homework Helper
17,848
1,645
How would you normally compare two sets of statistics?
 
  • #3
35
0
Hi, I've come up with a solution I think. Going to use the NORM.DIST function

thanks for the reply though
 

Related Threads on Excel data analysis

  • Last Post
Replies
2
Views
3K
  • Last Post
Replies
2
Views
2K
Replies
27
Views
2K
  • Last Post
Replies
6
Views
2K
  • Last Post
Replies
2
Views
2K
  • Last Post
Replies
1
Views
1K
  • Last Post
Replies
1
Views
3K
  • Last Post
Replies
1
Views
4K
Top