Sorting Data Question

[n2exL]

Here is my situation:

I am recording air temperature four times a day for approx. 3 months. I want to find the average and the standard deviation by day, by week and by 14 days.

I also want all of this information to be available on the same sheet without masking cells. I want minimal input (I only want to input the temperatures and dates). Here is an example of my table:

<table x:str="" style="border-collapse: collapse; width: 101px; height: 460px;" border="0" cellpadding="0" cellspacing="0"><col style="width: 60pt;" width="80"> <col style="width: 71pt;" width="94"> <tbody><tr style="height: 44.25pt;" height="59"> <td class="xl65" style="height: 44.25pt; width: 60pt;" height="59" width="80">Date</td> <td style="width: 71pt;" width="94">Temp</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" x:num="40179" align="right" height="20">2010-01-01</td> <td x:num="-3.1" align="right">-3,1</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" x:num="40179.25" x:fmla="=A2+(6/24)" align="right" height="20">2010-01-01</td> <td x:num="-2.3" align="right">-2,3</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" x:num="40179.5" x:fmla="=A3+(6/24)" align="right" height="20">2010-01-01</td> <td x:num="-1.9" align="right">-1,9</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" x:num="40179.75" x:fmla="=A4+(6/24)" align="right" height="20">2010-01-01</td> <td x:num="" align="right">-3</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" x:num="40180" x:fmla="=A5+(6/24)" align="right" height="20">2010-01-02</td> <td x:num="-3.7" align="right">-3,7</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" x:num="40180.25" x:fmla="=A6+(6/24)" align="right" height="20">2010-01-02</td> <td x:num="-3.5" align="right">-3,5</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" x:num="40180.5" x:fmla="=A7+(6/24)" align="right" height="20">2010-01-02</td> <td x:num="-2.3" align="right">-2,3</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" x:num="40180.75" x:fmla="=A8+(6/24)" align="right" height="20">2010-01-02</td> <td x:num="-0.5" align="right">-0,5</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" x:num="40181" x:fmla="=A9+(6/24)" align="right" height="20">2010-01-03</td> <td x:num="0.4" align="right">0,4</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" x:num="40181.25" x:fmla="=A10+(6/24)" align="right" height="20">2010-01-03</td> <td x:num="" align="right">-2</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" x:num="40181.5" x:fmla="=A11+(6/24)" align="right" height="20">2010-01-03</td> <td x:num="-0.2" align="right">-0,2</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" x:num="40181.75" x:fmla="=A12+(6/24)" align="right" height="20">2010-01-03</td> <td x:num="-1.9" align="right">-1,9</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" x:num="40182" x:fmla="=A13+(6/24)" align="right" height="20">2010-01-04</td> <td x:num="-0.2" align="right">-0,2</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" x:num="40182.25" x:fmla="=A14+(6/24)" align="right" height="20">2010-01-04</td> <td x:num="0.3" align="right">0,3</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" x:num="40182.5" x:fmla="=A15+(6/24)" align="right" height="20">2010-01-04</td> <td x:num="0.6" align="right">0,6</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" x:num="40182.75" x:fmla="=A16+(6/24)" align="right" height="20">2010-01-04</td> <td x:num="-2.1" align="right">-2,1</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" x:num="40183" x:fmla="=A17+(6/24)" align="right" height="20">2010-01-05</td> <td x:num="0.1" align="right">0,1</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" x:num="40183.25" x:fmla="=A18+(6/24)" align="right" height="20">2010-01-05</td> <td x:num="2.5" align="right">2,5</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" x:num="40183.5" x:fmla="=A19+(6/24)" align="right" height="20">2010-01-05</td> <td x:num="2.2" align="right">2,2</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" x:num="40183.75" x:fmla="=A20+(6/24)" align="right" height="20">2010-01-05</td> <td x:num="1.9" align="right">1,9</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" x:num="40184" x:fmla="=A21+(6/24)" align="right" height="20">2010-01-06</td> <td x:num="1.4" align="right">1,4</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" x:num="40184.25" x:fmla="=A22+(6/24)" align="right" height="20">2010-01-06</td> <td x:num="" align="right">0</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" x:num="40184.5" x:fmla="=A23+(6/24)" align="right" height="20">2010-01-06</td> <td x:num="0.2" align="right">0,2</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" x:num="40184.75" x:fmla="=A24+(6/24)" align="right" height="20">2010-01-06</td> <td x:num="0.1" align="right">0,1</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" x:num="40185" x:fmla="=A25+(6/24)" align="right" height="20">2010-01-07</td> <td x:num="0.8" align="right">0,8</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" x:num="40185.25" x:fmla="=A26+(6/24)" align="right" height="20">2010-01-07</td> <td x:num="-0.4" align="right">-0,4</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" x:num="40185.5" x:fmla="=A27+(6/24)" align="right" height="20">2010-01-07</td> <td x:num="0.3" align="right">0,3</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" x:num="40185.75" x:fmla="=A28+(6/24)" align="right" height="20">2010-01-07</td> <td x:num="0.2" align="right">0,2</td> </tr> </tbody></table>
My problem is:

I want to end up with three tables like this:
<table x:str="" style="border-collapse: collapse; width: 163pt;" border="0" cellpadding="0" cellspacing="0" width="218"><col style="width: 59pt;" width="79"> <col style="width: 56pt;" width="75"> <col style="width: 48pt;" width="64"> <tbody><tr style="height: 44.25pt;" height="59"> <td style="height: 44.25pt; width: 59pt;" height="59" width="79">Day</td> <td style="width: 56pt;" width="75">AVE</td> <td style="width: 48pt;" width="64">SD</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" x:num="40179" align="right" height="20">2010-01-01</td> <td x:num="-2.5750000000000002" align="right">-2,575</td> <td x:num="0.5" align="right">0,5</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" x:num="40180" align="right" height="20">2010-01-02</td> <td x:num="-2.5" align="right">-2,5</td> <td x:num="1.3" align="right">1,3</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" x:num="40181" align="right" height="20">2010-01-03</td> <td x:num="-0.92500000000000004" align="right">-0,925</td> <td x:num="" align="right">1</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" x:num="40182" align="right" height="20">2010-01-04</td> <td x:num="-0.35" align="right">-0,35</td> <td x:num="1.05" align="right">1,05</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" x:num="40183" align="right" height="20">2010-01-05</td> <td x:num="1.675" align="right">1,675</td> <td x:num="0.9" align="right">0,9</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" x:num="40184" align="right" height="20">2010-01-06</td> <td x:num="0.42499999999999999" align="right">0,425</td> <td x:num="0.6" align="right">0,6</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" x:num="40185" align="right" height="20">2010-01-07</td> <td x:num="0.22500000000000001" align="right">0,225</td> <td x:num="0.4" align="right">0,4</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" x:num="40186" align="right" height="20">2010-01-08</td> <td x:num="-1.2749999999999999" align="right">-1,275</td> <td x:num="0.6" align="right">0,6</td> </tr> </tbody></table>
The first one (as shown) would be the average and stdevp by day, the next table would be by week and the next table would be by 14 days

Please help me find the functions to make the three tables out of the input data! Ask questions if you do not understand my situation!

 

[n2exL]

 

[JoeMo]

Here's a start - you can pull down the formulas in D2:F2 (below the raw data shown here) to cover as much of your raw data as you wish. You can then adapt these formulas for your 14-day and monthly calculated values.

Excel Workbook
	A	B
1	Date	Temp
2	1/1/2010	-3.1
3	1/1/2010	-2.3
4	1/1/2010	-1.9
5	1/1/2010	-3
6	1/2/2010	-3.7
7	1/2/2010	-3.5
8	1/2/2010	-2.3
9	1/2/2010	-0.5
10	1/3/2010	0.4
11	1/3/2010	-2
12	1/3/2010	-0.2
13	1/3/2010	-1.9
14	1/4/2010	-0.2
15	1/4/2010	0.3
16	1/4/2010	0.6
17	1/4/2010	-2.1
18	1/5/2010	0.1
19	1/5/2010	2.5
20	1/5/2010	2.2
21	1/5/2010	1.9
22	1/6/2010	1.4
23	1/6/2010	0
24	1/6/2010	0.2
25	1/6/2010	0.1
26	1/7/2010	0.8
27	1/7/2010	-0.4
28	1/7/2010	0.3
29	1/7/2010	0.2
Sheet2

Excel Workbook
	D	E	F
1	Day	Avg	SD
2	1/1/2010	-2.58	0.79
3	1/2/2010	-2.50	1.76
Sheet2

 

[JoeMo]

Sorry. my first reply had a formula error for Column F: replace with the following (this assumes your raw data 'Date' header is in cell A1).

Excel Workbook
	F
1	SD
2	0.57
3	1.47
Sheet2