Jump to content
  • Member Statistics

    18,376
    Total Members
    7,904
    Most Online
    Scott Koziara
    Newest Member
    Scott Koziara
    Joined

December 2025 OBS and Discussion


wdrag
 Share

Recommended Posts

1 hour ago, donsutherland1 said:

Thank you. It seems that the formula dropped "T" rather than counting it as 0 on the spreadsheet. Mean: 3.5"; median: 2.0"

I have that problem with the excel files I maintain for my climate records.  For my monthly snowfall summary ( https://www.northshorewx.com/ClimateData/SmithtownDailySnowfall.pdf ) I have a 0 for months where there were traces so that the averages don't get messed up (excluding October and May where the average is 0). 

I keep sheets with the daily data including traces, but I can't calculate an average value for a given date (e.g., December 3) because of all the years that have a trace on that date.  As a result, the difference between the actual average seasonal snowfall and the sum of the daily averages for the season in excel is significant; 36.2" vs 41.0"

 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...