Make the summary table with daily min max and mean tempertur

Make the summary table with daily min, max and mean temperture. (Prefer R, Matlab or Maple)

Excel File: https://www.dropbox.com/s/ts8lsu53kn24oqq/table1.xls?dl=1

Solution

Data Date/Time Min of Temperature Max of Temperature Average of Temperature 13-Jan-05 18.66 20.57 19.39 14-Jan-05 15.23 20.57 18.87 15-Jan-05 11.77 23.24 16.50 16-Jan-05 15.23 26.34 18.20 17-Jan-05 15.23 28.31 18.97 18-Jan-05 15.62 23.24 19.47 19-Jan-05 19.81 24.79 21.37 20-Jan-05 19.42 24.01 21.83 21-Jan-05 18.28 27.12 21.26 22-Jan-05 16.38 27.12 20.27 23-Jan-05 16 26.34 20.33 24-Jan-05 19.81 29.5 23.23 25-Jan-05 19.81 27.12 22.94 26-Jan-05 19.42 30.31 23.23 27-Jan-05 20.95 29.5 23.69 28-Jan-05 19.42 31.52 24.12 29-Jan-05 19.04 31.52 23.99 30-Jan-05 19.81 30.31 23.56 31-Jan-05 19.42 30.31 23.82 01-Feb-05 20.19 31.12 24.76 02-Feb-05 22.48 31.52 25.41 03-Feb-05 22.09 31.52 25.00 04-Feb-05 21.33 31.52 25.20 05-Feb-05 21.71 31.52 25.21 06-Feb-05 21.71 32.76 25.63 07-Feb-05 22.09 32.76 25.31 08-Feb-05 20.95 32.34 24.77 09-Feb-05 20.95 31.52 25.27 10-Feb-05 22.86 31.93 25.97 11-Feb-05 19.81 30.31 24.14 12-Feb-05 18.28 30.31 22.90 13-Feb-05 17.9 30.71 23.29 14-Feb-05 22.48 32.76 25.94 15-Feb-05 22.09 34.43 26.15 16-Feb-05 21.71 34.85 26.26 17-Feb-05 21.33 36.13 26.41 18-Feb-05 18.66 36.57 25.65 19-Feb-05 18.28 37 25.41 20-Feb-05 20.19 30.71 23.74 21-Feb-05 17.14 30.71 22.37 22-Feb-05 17.9 31.52 23.16 23-Feb-05 22.48 34.85 26.50 24-Feb-05 22.48 35.7 27.07 25-Feb-05 22.09 36.13 26.61 26-Feb-05 20.19 36.13 26.56 27-Feb-05 22.86 37.44 27.17 28-Feb-05 22.86 37.44 27.40 01-Mar-05 22.48 35.7 27.10 02-Mar-05 23.24 37.88 27.46 03-Mar-05 18.66 31.52 23.97 04-Mar-05 16.38 23.63 19.07 05-Mar-05 14.47 29.9 18.51 06-Mar-05 10.99 30.71 16.88 07-Mar-05 11.77 28.7 17.92 08-Mar-05 13.7 36.13 20.35 09-Mar-05 17.9 37.44 24.33 10-Mar-05 21.33 37.88 25.75 11-Mar-05 22.48 38.77 26.64 12-Mar-05 22.48 40.59 25.89 15-Mar-05 22.86 29.1 24.96 16-Mar-05 22.48 34.01 25.15 17-Mar-05 20.95 34.01 25.47 18-Mar-05 22.48 33.59 26.36 19-Mar-05 20.57 35.27 24.55 20-Mar-05 18.66 33.17 24.03 21-Mar-05 22.48 37.88 26.45 22-Mar-05 22.86 33.59 25.11 23-Mar-05 20.95 36.57 24.46 24-Mar-05 20.95 30.31 23.58 25-Mar-05 19.42 29.1 21.88 26-Mar-05 18.66 31.93 22.64 27-Mar-05 22.09 32.34 24.44 28-Mar-05 22.48 37.88 26.44 29-Mar-05 23.63 36.57 26.83 30-Mar-05 24.01 38.32 26.51 31-Mar-05 23.24 41.99 27.19 01-Apr-05 22.48 37.44 25.76 02-Apr-05 20.95 35.7 24.92 03-Apr-05 22.48 32.34 25.02 04-Apr-05 18.28 23.24 20.93 05-Apr-05 18.28 25.95 21.07 06-Apr-05 17.52 33.17 22.54 07-Apr-05 22.09 32.76 25.62 08-Apr-05 23.24 32.34 25.61 09-Apr-05 22.86 37.44 26.87 10-Apr-05 23.63 38.77 27.94 11-Apr-05 24.79 38.32 28.29 12-Apr-05 24.01 38.77 28.18 13-Apr-05 21.71 29.1 24.89 14-Apr-05 21.33 33.17 24.53 15-Apr-05 21.71 29.5 23.62 16-Apr-05 21.71 36.13 25.46 17-Apr-05 23.24 27.12 25.03 18-Apr-05 23.63 40.59 26.34 19-Apr-05 22.09 29.5 24.42 20-Apr-05 20.57 31.52 24.62 21-Apr-05 22.09 29.9 24.39 22-Apr-05 22.48 34.01 25.89 23-Apr-05 24.01 33.59 26.64 24-Apr-05 24.4 31.93 26.72 25-Apr-05 24.01 32.76 26.05 26-Apr-05 24.01 34.01 27.27 27-Apr-05 22.48 33.59 26.78 28-Apr-05 24.79 32.34 27.18 29-Apr-05 24.4 34.85 28.17 30-Apr-05 22.48 35.7 26.78 01-May-05 20.57 31.52 24.12 02-May-05 23.63 33.17 26.34 03-May-05 22.48 35.7 27.11 04-May-05 24.4 34.01 28.23 05-May-05 24.4 35.27 27.66 06-May-05 24.4 37 27.98 07-May-05 24.79 34.01 27.68 08-May-05 23.63 29.1 25.37 09-May-05 23.24 30.31 25.84 10-May-05 24.79 33.17 27.45 11-May-05 24.79 33.59 27.65 12-May-05 24.4 34.85 27.83 13-May-05 24.79 35.7 28.37 14-May-05 24.4 34.01 27.31 15-May-05 24.01 34.43 26.51 16-May-05 23.63 31.93 25.72 17-May-05 24.01 32.76 26.33 18-May-05 24.01 32.34 26.80 19-May-05 22.48 31.52 25.22 20-May-05 22.48 31.12 24.55 21-May-05 21.71 30.31 24.84 22-May-05 22.48 32.34 25.96 23-May-05 23.24 32.34 26.24 24-May-05 24.01 34.43 26.50 25-May-05 24.01 32.34 25.76 26-May-05 24.01 33.59 26.98 27-May-05 24.01 34.43 27.87 28-May-05 24.79 34.01 28.30 29-May-05 22.48 35.27 28.05 30-May-05 20.95 27.12 23.59 31-May-05 22.48 30.71 25.10 01-Jun-05 23.24 29.5 25.60 02-Jun-05 23.24 28.31 25.17 03-Jun-05 24.01 30.31 25.65 04-Jun-05 23.63 30.31 26.32 05-Jun-05 23.63 31.93 26.62 06-Jun-05 23.24 31.12 26.30 07-Jun-05 23.24 30.71 25.68 08-Jun-05 22.86 30.31 25.56 09-Jun-05 24.01 29.5 25.72 10-Jun-05 22.86 28.31 24.90 11-Jun-05 23.63 29.5 25.90 12-Jun-05 24.01 31.52 26.68 13-Jun-05 23.24 30.71 26.50 14-Jun-05 23.63 28.31 25.36 15-Jun-05 24.01 29.5 25.89 16-Jun-05 24.4 30.31 26.41 17-Jun-05 24.01 31.93 25.43 18-Jun-05 23.24 29.1 25.38 19-Jun-05 23.63 32.34 26.63 20-Jun-05 24.01 30.71 26.38 21-Jun-05 24.01 32.34 27.01 22-Jun-05 23.63 33.17 26.86 23-Jun-05 23.63 29.5 25.90 24-Jun-05 22.09 27.52 24.34 25-Jun-05 22.09 26.73 24.10 26-Jun-05 23.24 30.31 25.80 27-Jun-05 24.01 30.71 26.42 28-Jun-05 20.95 31.52 25.41 29-Jun-05 21.33 30.71 25.07 30-Jun-05 22.86 32.34 26.20 01-Jul-05 23.24 34.01 26.94 02-Jul-05 23.24 29.5 25.90 03-Jul-05 23.63 30.71 25.39 04-Jul-05 23.24 28.31 24.55 05-Jul-05 21.71 28.31 23.32 06-Jul-05 22.09 25.95 23.75 07-Jul-05 22.48 27.91 24.52 08-Jul-05 22.86 30.31 24.49 09-Jul-05 22.09 27.91 24.20 10-Jul-05 22.09 30.71 25.41 11-Jul-05 22.48 29.5 24.63 12-Jul-05 22.86 26.73 24.37 13-Jul-05 22.48 26.34 23.94 14-Jul-05 22.09 27.12 23.77 15-Jul-05 21.71 26.34 22.86 Grand Total 10.99 41.99 25.02