Homework 3xlsx 0 Tell me what you want to do Draw Page Layou

Homework 3.xlsx 0 Tell me what you want to do Draw Page Layout Data View Trace precedents Show Formulas Define Name Calculate Now Trace Dependents Error checking Use in Format Sum Recently Financi Text Date & Lookup & Math & More Name Watch Calculation EH Calculate sheet Evaluate Formula Create from Selection Remove Arrows Functi Time Reference Function Manager Window options Function Library Defined Nam Formula Auditing Calculation The block of data below contains records of water eleva at different location nu for specific dates For example, for th e data n columns L-N, the date 1/5/2010 exists 3 times at site 25 and twice at site 3 2 Some of the data records contain one than 1 date. The corrected shoul SP-R ook like that in c For all of the records that have duplicated dates, average th e values to create one rec Location Date value Location Date Value 4 Create a new set of data that has u nique dates for each There should be no gaps 0ca on 5 On pproach is to create a value that for each site and date 25 1/3/2010 25 113/2010 que 25 1 4/2010 6.19 25 1/4/2010 6.19 7 Location Date value 25 1/5/2010 9l 178 1/2/2010 22.790 25 15/2010 629 25 1re/2010 6.28 101 178 1 3/2010 22.81 25 1/6/2010 6.3 25 1/9/2010 6.31 11 178 1/4/2010 22.82 25 1/8/2010 28 25 1/10/2010 64 178 1/s/2010 22.82 31 113/2010 178 1/6/2010 22.71 25 1/10/2010 178 1/7/2010 22.645 3/20 1/5/20 7.95 7.685 178 1/8/2010 22.645 /4/2010 7.61 1/6/20 178 /9/2010 22.675 31 1/5/2010 178 1/10/2010 22.64 31 1/9/2010 178 1/11/2010 22.58 1/6/2010 775 178 /13/2010 22.595 178 1/14/2010 22.62 178 1/15/2010 22.615 22 178 1/17/2010 22.635 178 1/18/2010 22.635 178 1/19/2010 22.595 178 1/20/2010 22.525 178 1/21/2010 22.58 28 178 1/22/2010 22.605 29 178 1/23/2010 22.575 178 1/24/2010 22.565 178 1/25/2010 22.555 178 1/27/2010 22.53 178 28/2010 22.585 178 1/29/2010 22.62 178 1/30/2010 22.66 178 1/31/2010 22.595 178 2/1/2010 22.675

Solution

so there is no changes in that given table as for your requirement.

Location	Date	value
178	1/1/2010	22.79
178	1/2/2010	22.79
178	1/3/2010	22.81
178	1/4/2010	22.82
178	1/5/2010	22.82
178	1/6/2010	22.71
178	1/7/2010	22.645
178	1/8/2010	22.645
178	1/9/2010	22.675
178	1/10/2010	22.64
178	1/11/2010	22.58
178	1/12/2010	22.56
178	1/13/2010	22.595
178	1/14/2010	22.62
178	1/15/2010	22.615
178	1/16/2010	22.63
178	1/17/2010	22.635
178	1/18/2010	22.635
178	1/19/2010	22.595
178	1/20/2010	22.525
178	1/21/2010	22.58
178	1/22/2010	22.605
178	1/23/2010	22.575
178	1/24/2010	22.565
178	1/25/2010	22.555
178	1/26/2010	22.5
178	1/27/2010	22.53
178	1/28/2010	22.585
178	1/29/2010	22.62
178	1/30/2010	22.66
178	1/31/2010	22.595
178	2/1/2010	22.675