Spreadsheet: 158970d1338469531-stdev-from-averageifs-using-date-ranges-example
Sheet: PM25 Daily

 |  |  | PM2.5 |  |  |  | PM2.5
Date | Year | Month | Daily Data | Date | Year | Season | Seasonal Average | Standard Deviation
2007-01-06 00:00:00 |  |  | 5 | 12/1/2006 | 2007 | Winter
2007-01-12 00:00:00 |  |  | 9 | 3/1/2007 |  | Spring
2007-01-18 00:00:00 |  |  | 10 | 6/1/2007 |  | Summer
2007-01-24 00:00:00 |  |  | 8 | 9/1/2007 |  | Fall
2007-01-30 00:00:00 |  |  | 9 | 12/1/2007 | 2008 | Winter
2007-02-05 00:00:00 |  |  | 6 | 3/1/2008 |  | Spring
2007-02-11 00:00:00 |  |  | 2 | 6/1/2008 |  | Summer
2007-02-17 00:00:00 |  |  | 5 | 9/1/2008 |  | Fall
2007-02-23 00:00:00 |  |  | 2 | 12/1/2008 | 2009 | Winter
2007-03-01 00:00:00 |  |  | 6 | 3/1/2009 |  | Spring
2007-03-07 00:00:00 |  |  | 6 | 6/1/2009 |  | Summer
2007-03-13 00:00:00 |  |  | 8 | 9/1/2009 |  | Fall
2007-03-19 00:00:00 |  |  | 10 | 12/1/2009 | 2010 | Winter
2007-03-25 00:00:00 |  |  | 8 | 3/1/2010 |  | Spring
2007-03-31 00:00:00 |  |  | 7 | 6/1/2010 |  | Summer
2007-04-06 00:00:00 |  |  | 11 | 9/1/2010 |  | Fall
2007-04-12 00:00:00 |  |  | 10 | 12/1/2010 | 2011 | Winter
2007-04-18 00:00:00 |  |  | 3 | 3/1/2011 |  | Spring
2007-04-24 00:00:00 |  |  | 4 | 6/1/2011 |  | Summer
2007-05-02 00:00:00 |  |  | 8 | 9/1/2011 |  | Fall
2007-05-06 00:00:00 |  |  | 4
2007-05-12 00:00:00 |  |  | 8
2007-05-18 00:00:00 |  |  | 12
2007-05-24 00:00:00 |  |  | 7
2007-05-30 00:00:00 |  |  | 8
2007-06-05 00:00:00 |  |  | 8
2007-06-11 00:00:00 |  |  | 11
2007-06-17 00:00:00 |  |  | 7
2007-06-23 00:00:00 |  |  | 7
2007-06-29 00:00:00 |  |  | 7
2007-07-05 00:00:00 |  |  | 10
2007-07-11 00:00:00 |  |  | 8
2007-07-17 00:00:00 |  |  | 16
2007-07-23 00:00:00 |  |  | 8
2007-07-29 00:00:00 |  |  | 8
2007-08-04 00:00:00 |  |  | 8
2007-08-10 00:00:00 |  |  | 8
2007-08-16 00:00:00 |  |  | 20
2007-08-22 00:00:00 |  |  | 12
2007-08-28 00:00:00 |  |  | 6
2007-09-03 00:00:00 |  |  | 9
2007-09-09 00:00:00 |  |  | 5
2007-09-15 00:00:00 |  |  | 6
2007-09-21 00:00:00 |  |  | 5
2007-09-27 00:00:00 |  |  | 6
2007-10-03 00:00:00 |  |  | 9
2007-10-09 00:00:00 |  |  | 6
2007-10-15 00:00:00 |  |  | 1
2007-10-21 00:00:00 |  |  | 5
2007-10-27 00:00:00 |  |  | 25
2007-11-02 00:00:00 |  |  | 6
2007-11-08 00:00:00 |  |  | 10
2007-11-14 00:00:00 |  |  | 5
2007-11-20 00:00:00 |  |  | 16
2007-11-26 00:00:00 |  |  | 10
2007-12-02 00:00:00 |  |  | 8
2007-12-08 00:00:00 |  |  | 4
2007-12-14 00:00:00 |  |  | 15
2007-12-20 00:00:00 |  |  | 3
2007-12-26 00:00:00 |  |  | 7
2008-01-19 00:00:00 |  |  | 6
2008-01-25 00:00:00 |  |  | 2
2008-01-31 00:00:00 |  |  | 8
2008-02-06 00:00:00 |  |  | 5
2008-02-12 00:00:00 |  |  | 5
2008-02-20 00:00:00 |  |  | 3
2008-02-24 00:00:00 |  |  | 2
2008-03-01 00:00:00 |  |  | 11
2008-03-07 00:00:00 |  |  | 9
2008-03-13 00:00:00 |  |  | 5
2008-03-19 00:00:00 |  |  | 7
2008-03-25 00:00:00 |  |  | 4
2008-03-31 00:00:00 |  |  | 7
2008-04-06 00:00:00 |  |  | 6
2008-04-18 00:00:00 |  |  | 8
2008-04-24 00:00:00 |  |  | 6
2008-04-30 00:00:00 |  |  | 8
2008-05-06 00:00:00 |  |  | 12
2008-05-12 00:00:00 |  |  | 24
2008-05-18 00:00:00 |  |  | 6
2008-05-24 00:00:00 |  |  | 5
2008-05-30 00:00:00 |  |  | 7
2008-06-05 00:00:00 |  |  | 5
2008-06-11 00:00:00 |  |  | 7
2008-06-17 00:00:00 |  |  | 10
2008-06-23 00:00:00 |  |  | 13
2008-06-29 00:00:00 |  |  | 6
2008-07-05 00:00:00 |  |  | 13
2008-07-11 00:00:00 |  |  | 11
2008-07-17 00:00:00 |  |  | 13
2008-07-23 00:00:00 |  |  | 8
2008-07-29 00:00:00 |  |  | 11
2008-08-04 00:00:00 |  |  | 7
2008-08-10 00:00:00 |  |  | 6
2008-08-16 00:00:00 |  |  | 10
2008-08-22 00:00:00 |  |  | 6
2008-08-28 00:00:00 |  |  | 8
2008-10-15 00:00:00 |  |  | 5
2008-10-21 00:00:00 |  |  | 7
2008-10-27 00:00:00 |  |  | 8
2008-11-02 00:00:00 |  |  | 3
2008-11-14 00:00:00 |  |  | 4
2008-11-20 00:00:00 |  |  | 9
2008-11-22 00:00:00 |  |  | 4
2008-11-26 00:00:00 |  |  | 4
2008-12-02 00:00:00 |  |  | 2
2008-12-08 00:00:00 |  |  | 4
2008-12-17 00:00:00 |  |  | 2
2008-12-20 00:00:00 |  |  | 9
2008-12-26 00:00:00 |  |  | 5
2009-01-01 00:00:00 |  |  | 15
2009-01-07 00:00:00 |  |  | 12
2009-01-13 00:00:00 |  |  | 6
2009-01-19 00:00:00 |  |  | 8
2009-01-25 00:00:00 |  |  | 2
2009-01-31 00:00:00 |  |  | 5
2009-02-06 00:00:00 |  |  | 1
2009-02-12 00:00:00 |  |  | 4
2009-02-20 00:00:00 |  |  | 5
2009-02-24 00:00:00 |  |  | 4
2009-03-02 00:00:00 |  |  | 5
2009-03-08 00:00:00 |  |  | 6
2009-03-14 00:00:00 |  |  | 10
2009-03-20 00:00:00 |  |  | 9
2009-03-26 00:00:00 |  |  | 8
2009-04-01 00:00:00 |  |  | 5
2009-04-07 00:00:00 |  |  | 11
2009-04-13 00:00:00 |  |  | 7
2009-04-19 00:00:00 |  |  | 6
2009-04-25 00:00:00 |  |  | 5
2009-05-01 00:00:00 |  |  | 4
2009-05-07 00:00:00 |  |  | 6
2009-05-13 00:00:00 |  |  | 7
2009-05-19 00:00:00 |  |  | 7
2009-05-26 00:00:00 |  |  | 9
2009-05-31 00:00:00 |  |  | 9
2009-06-06 00:00:00 |  |  | 3
2009-06-12 00:00:00 |  |  | 9
2009-06-18 00:00:00 |  |  | 8
2009-06-24 00:00:00 |  |  | 11
2009-06-30 00:00:00 |  |  | 6
2009-07-06 00:00:00 |  |  | 5
2009-07-12 00:00:00 |  |  | 5
2009-07-18 00:00:00 |  |  | 8
2009-07-24 00:00:00 |  |  | 8
2009-07-30 00:00:00 |  |  | 10
2009-08-05 00:00:00 |  |  | 4
2009-08-11 00:00:00 |  |  | 12
2009-08-17 00:00:00 |  |  | 16
2009-08-23 00:00:00 |  |  | 7
2009-09-04 00:00:00 |  |  | 11
2009-09-10 00:00:00 |  |  | 7
2009-09-16 00:00:00 |  |  | 10
2009-09-22 00:00:00 |  |  | 7
2009-09-28 00:00:00 |  |  | 8
2009-10-04 00:00:00 |  |  | 7
2009-10-10 00:00:00 |  |  | 8
2009-10-16 00:00:00 |  |  | 5
2009-10-22 00:00:00 |  |  | 7
2009-10-28 00:00:00 |  |  | 5
2009-11-03 00:00:00 |  |  | 11
2009-11-09 00:00:00 |  |  | 8
2009-11-15 00:00:00 |  |  | 8
2009-11-21 00:00:00 |  |  | 4
2009-11-27 00:00:00 |  |  | 9
2009-12-03 00:00:00 |  |  | 8
2009-12-09 00:00:00 |  |  | 13
2009-12-15 00:00:00 |  |  | 11
2009-12-21 00:00:00 |  |  | 10
2009-12-27 00:00:00 |  |  | 20
2010-01-02 00:00:00 |  |  | 11
2010-01-05 00:00:00 |  |  | 10
2010-01-06 00:00:00 |  |  | 8
2010-01-08 00:00:00 |  |  | 7
2010-01-20 00:00:00 |  |  | 4
2010-01-26 00:00:00 |  |  | 15
2010-02-02 00:00:00 |  |  | 13
2010-02-07 00:00:00 |  |  | 2
2010-02-13 00:00:00 |  |  | 6
2010-02-19 00:00:00 |  |  | 7
2010-02-25 00:00:00 |  |  | 2
2010-03-03 00:00:00 |  |  | 2
2010-03-09 00:00:00 |  |  | 3
2010-03-15 00:00:00 |  |  | 4
2010-03-21 00:00:00 |  |  | 7
2010-03-27 00:00:00 |  |  | 1
2010-04-02 00:00:00 |  |  | 8
2010-04-08 00:00:00 |  |  | 1
2010-04-14 00:00:00 |  |  | 8
2010-04-20 00:00:00 |  |  | 3
2010-04-26 00:00:00 |  |  | 10
2010-05-02 00:00:00 |  |  | 6
2010-05-08 00:00:00 |  |  | 4
2010-05-14 00:00:00 |  |  | 8
2010-05-20 00:00:00 |  |  | 5
2010-05-26 00:00:00 |  |  | 4
2010-06-01 00:00:00 |  |  | 7
2010-06-08 00:00:00 |  |  | 8
2010-06-13 00:00:00 |  |  | 5
2010-06-19 00:00:00 |  |  | 7
2010-06-25 00:00:00 |  |  | 7
2010-07-01 00:00:00 |  |  | 8
2010-07-08 00:00:00 |  |  | 7
2010-07-14 00:00:00 |  |  | 6
2010-07-19 00:00:00 |  |  | 8
2010-07-25 00:00:00 |  |  | 5
2010-07-31 00:00:00 |  |  | 6
2010-08-06 00:00:00 |  |  | 1
2010-08-12 00:00:00 |  |  | 8
2010-08-18 00:00:00 |  |  | 2
2010-08-24 00:00:00 |  |  | 7
2010-08-30 00:00:00 |  |  | 6
2010-09-05 00:00:00 |  |  | 5
2010-09-11 00:00:00 |  |  | 6
2010-09-23 00:00:00 |  |  | 6
2010-10-05 00:00:00 |  |  | 4
2010-10-13 00:00:00 |  |  | 5
2010-10-19 00:00:00 |  |  | 6
2010-10-24 00:00:00 |  |  | 3
2010-10-29 00:00:00 |  |  | 9
2010-11-04 00:00:00 |  |  | 4
2010-11-10 00:00:00 |  |  | 5
2010-11-16 00:00:00 |  |  | 6
2010-11-28 00:00:00 |  |  | 2
2010-12-04 00:00:00 |  |  | 14
2010-12-22 00:00:00 |  |  | 2
2010-12-28 00:00:00 |  |  | 6
2011-01-12 00:00:00 |  |  | 8
2011-01-21 00:00:00 |  |  | 5
2011-01-27 00:00:00 |  |  | 6
2011-02-02 00:00:00 |  |  | 10
2011-02-08 00:00:00 |  |  | 2
2011-02-14 00:00:00 |  |  | 3
2011-02-26 00:00:00 |  |  | 2
2011-03-10 00:00:00 |  |  | 50
2011-03-14 00:00:00 |  |  | 5
2011-03-16 00:00:00 |  |  | 5
2011-03-22 00:00:00 |  |  | 4
2011-03-28 00:00:00 |  |  | 5
2011-04-03 00:00:00 |  |  | 4
2011-04-15 00:00:00 |  |  | 13
2011-04-21 00:00:00 |  |  | 4
2011-04-27 00:00:00 |  |  | 6
2011-05-09 00:00:00 |  |  | 4
2011-06-26 00:00:00 |  |  | 7
2011-07-02 00:00:00 |  |  | 10
2011-07-08 00:00:00 |  |  | 10
2011-07-20 00:00:00 |  |  | 6
2011-07-26 00:00:00 |  |  | 6
2011-08-01 00:00:00 |  |  | 6
2011-08-07 00:00:00 |  |  | 8
2011-10-12 00:00:00 |  |  | 5
2011-10-18 00:00:00 |  |  | 4
2011-10-24 00:00:00 |  |  | 7
2011-10-30 00:00:00 |  |  | 6
2011-11-05 00:00:00 |  |  | 3
2011-11-11 00:00:00 |  |  | 5
2011-11-17 00:00:00 |  |  | 3
2011-11-23 00:00:00 |  |  | 3
2011-11-29 00:00:00 |  |  | 7
2011-12-05 00:00:00 |  |  | 6
2011-12-11 00:00:00 |  |  | 11
2011-12-17 00:00:00 |  |  | 3
2011-12-29 00:00:00 |  |  | 8