Not sure where to post this question, but here goes(adsbygoogle = window.adsbygoogle || []).push({});

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 Forums - The Fusion of Science and Community**

Dismiss Notice

Join Physics Forums Today!

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

# Excel data analysis

Loading...

Similar Threads - Excel data analysis | Date |
---|---|

Plot compound parabolic concentrator in Excel | Mar 7, 2018 |

B Why is the %change of the %change of a sequence so chaotic? | Oct 14, 2016 |

Excellent Calculus Practice | Sep 15, 2014 |

Calculating Harmonics following FFT on Excel | Jun 11, 2012 |

Text data in excel pivot table | Mar 2, 2011 |

**Physics Forums - The Fusion of Science and Community**