Estimate Probability of Excel Data Analysis Results

Click For Summary
SUMMARY

This discussion focuses on estimating the probability that the average annual rainfall calculated for 1990-2012 (50.2mm) is consistent with the long-term mean annual rainfall from 1948-2012 (51.6mm) under the assumption of a Gaussian distribution. The recommended approach is to utilize the NORM.DIST function in Excel for probability calculations, while the Student's t-test is suggested as a method to determine the statistical significance of the difference between the two means. Both methods provide a structured way to analyze the rainfall data effectively.

PREREQUISITES
  • Understanding of Gaussian distribution principles
  • Familiarity with Excel functions, specifically NORM.DIST
  • Knowledge of statistical significance testing
  • Experience with the Student's t-test methodology
NEXT STEPS
  • Research how to implement the NORM.DIST function in Excel for probability analysis
  • Study the application of the Student's t-test for comparing means
  • Explore the implications of Gaussian distribution in statistical analysis
  • Learn about alternative statistical tests for comparing datasets
USEFUL FOR

Data analysts, statisticians, and researchers involved in statistical data analysis and comparison of datasets, particularly those using Excel for their calculations.

izzy93
Messages
34
Reaction score
0
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
 
Physics news on Phys.org
How would you normally compare two sets of statistics?
 
Hi, I've come up with a solution I think. Going to use the NORM.DIST function

thanks for the reply though
 

Similar threads

Undergrad Error bars in Excel (standard deviation, standard error, percentage)
  • · Replies 4 ·
Replies
4
Views
3K
Undergrad Desirable estimator properties...
  • · Replies 7 ·
Replies
7
Views
3K
High School It works but why? (Matching experimental data to a random equation)
  • · Replies 3 ·
Replies
3
Views
1K
Undergrad How to implement proper error estimation using MC
  • · Replies 3 ·
Replies
3
Views
3K
Undergrad Adding random numbers: Tolerance analysis
  • · Replies 11 ·
Replies
11
Views
3K
Undergrad Is there a way to calculate expected value from probabilistic data?
  • · Replies 76 ·
3
Replies
76
Views
6K
Graduate PDF of multimodal circular data
  • · Replies 1 ·
Replies
1
Views
2K
Data analysis by guessing, checking and fixing
  • · Replies 5 ·
Replies
5
Views
4K
Graduate The Blessings of Dimensionality and Hilbert's 6th Problem
  • · Replies 4 ·
Replies
4
Views
2K
Undergrad Data Analysis: Automating Distribution Comparisons from Daily Stats
  • · Replies 1 ·
Replies
1
Views
2K