Excel data analysis


by izzy93
Tags: analysis, average, data, excel, gaussian, probability
izzy93
izzy93 is offline
#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
Researchers help Boston Marathon organizers plan for 2014 race
'Math detective' analyzes odds for suspicious lottery wins
Pseudo-mathematics and financial charlatanism
Simon Bridge
Simon Bridge is offline
#2
Oct17-13, 09:20 AM
Homework
Sci Advisor
HW Helper
Thanks ∞
PF Gold
Simon Bridge's Avatar
P: 10,972
How would you normally compare two sets of statistics?
izzy93
izzy93 is offline
#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
Office_Shredder is offline
#4
Oct17-13, 10:29 AM
Mentor
P: 4,499

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