Register to reply

Excel data analysis

Share this thread:
izzy93
#1
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

thanks
Phys.Org News Partner Mathematics news on Phys.org
'Moral victories' might spare you from losing again
Fair cake cutting gets its own algorithm
Effort to model Facebook yields key to famous math problem (and a prize)
Simon Bridge
#2
Oct17-13, 09:20 AM
Homework
Sci Advisor
HW Helper
Thanks
Simon Bridge's Avatar
P: 12,463
How would you normally compare two sets of statistics?
izzy93
#3
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

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

izzy,

The typical test for this is the Student's t-test
http://en.wikipedia.org/wiki/Student...-sample_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