Register to reply

Excel data analysis

Share this thread:
Oct16-13, 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 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

Phys.Org News Partner Mathematics news on
Math journal puts Rauzy fractcal image on the cover
Heat distributions help researchers to understand curved space
Professor quantifies how 'one thing leads to another'
Simon Bridge
Oct17-13, 09:20 AM
Sci Advisor
HW Helper
Simon Bridge's Avatar
P: 13,051
How would you normally compare two sets of statistics?
Oct17-13, 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

Oct17-13, 10:29 AM
Sci Advisor
PF Gold
P: 4,500
Excel data analysis


The typical test for this is the Student's t-test

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