Register to reply 
Excel data analysis 
Share this thread: 
#1
Oct1613, 10:20 AM

P: 30

Not sure where to post this question, but here goes
In excel I have calculated the average annual rain for the period 19902012 to be 50.2mm . How do you estimate the probability that this measured average (19902012) is consistent with the long term mean annual rain for the period 19482012 (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
Oct1713, 09:20 AM

Homework
Sci Advisor
HW Helper
Thanks
P: 13,051

How would you normally compare two sets of statistics?



#3
Oct1713, 09:31 AM

P: 30

Hi, I've come up with a solution I think. Going to use the NORM.DIST function
thanks for the reply though 


#4
Oct1713, 10:29 AM

Emeritus
Sci Advisor
PF Gold
P: 4,500

Excel data analysis
izzy,
The typical test for this is the Student's ttest http://en.wikipedia.org/wiki/Student...sample_ttest which determines whether the difference in means between two samples is statistically significant. 


Register to reply 
Related Discussions  
Reading WAV as data/numbers into Excel  Programming & Computer Science  8  
Exporting data from matlab to excel  Math & Science Software  3  
Interpolation of data on Excel for analysis of Load Displacement  General Engineering  5  
Eliminating noise from Excel Data  General Physics  14  
Reading WAV as data/numbers into Excel  Calculus  0 