day temp °C with EXCEL functions """manually"" with math formulas in EXCEL" 4/1/2008 11 4/2/2008 10 N= ´=count AVERAGE (MEAN) 4/3/2008 10 average month temperature= ´=average 4/4/2008 9 minimum= ´=min 4/5/2008 8 maximum= ´=max 4/6/2008 7 range= ´=max - =min 4/7/2008 8 modus= ´=mode 4/8/2008 9 median= ´=median 4/9/2008 4 sample variance= ´=var 4/10/2008 9 sample standard deviation= ´=stdev VARIANCE (sample) 4/11/2008 8 4/12/2008 7 4/13/2008 8 4/14/2008 9 4/15/2008 12 4/16/2008 13 4/17/2008 15 4/18/2008 11 4/19/2008 12 sample standard deviation 4/20/2008 10 4/21/2008 9 4/22/2008 8 4/23/2008 9 4/24/2008 11 4/25/2008 10 4/26/2008 9 4/27/2008 6 4/28/2008 6 4/29/2008 7 4/30/2008 12 ##### Sheet/List 2 ##### men women body weight count men women arit. average 82 57 max 87 62 min 93 58 modus 74 71 median 68 49 variance (population) 81 56 variance (sample) 80 60 stand. dev. (population) 67 53 stand. dev. (sample) 104 71 69 64 75 58 N 71 49 min 81 68 0.25 percentile 96 61 0.5 percentile 89 54 0.75 percentile 79 57 max 109 60 87 47 63 58 75 61 77 67 histogram 64 54 59 47 81 64 70 76 69 63 86 67 80 52 81 91 ##### Sheet/List 3 ##### hmotnost muži ženy muži ženy aritmet. průměr 79.6 59.5 82 57 max 109 78 87 62 min 59 47 93 58 modus 81 58 74 71 medián 80 59 68 49 rozptyl 133.3066667 56.39285714 Třídy Četnost 55 Třídy Četnost 81 56 rozptyl výběru 137.9034483 58.48148148 59 1 60 55 0 80 60 sm. odchylka 11.54585063 7.50951777 69 6 65 60 1 67 53 výběrová sm. odchylka 11.74322989 7.647318581 79 7 70 65 2 104 71 stř. chyba průměru 2.144010636 1.445207369 89 11 75 70 5 69 64 histogram 99 3 80 75 4 75 58 N 30 28 více 2 85 80 4 71 49 0.75 percentil 86.75 64 90 85 5 81 68 0.5 percentil 80 59 95 90 4 96 61 0.25 percentil 70.25 54 100 95 2 89 54 105 100 1 79 57 110 105 1 109 60 110 1 87 47 více 0 63 58 75 61 77 67 64 54 59 47 81 64 70 78 49 Třídy Četnost 69 63 56 49 4 86 67 63 56 5 80 52 70 63 11 81 77 70 5 91 77 2 více 1 ##### Sheet/List 4 ##### length in inches 2.54 frequency class conversion (cm) count 5 0.5 0.4 1.016 average 6 1 0.33 0.8382 max 2 1.5 1.37 3.4798 min 6 2 0.68 1.7272 modus 2 2.5 0.61 1.5494 median 1 3 0.06 0.1524 variance (population) 6 3.5 1.76 4.4704 variance (sample) 1 4 0.75 1.905 stand. dev. (population) 2 4.5 1.91 4.8514 stand. dev. (sample) 1 5 0.72 1.8288 0.79 2.0066 1.28 3.2512 0.9 percentile 0.6 1.524 0.5 percentile 0.14 0.3556 0.1 percentile 0.02 0.0508 1.2 3.048 1.37 3.4798 0.27 0.6858 1.27 3.2258 1.01 2.5654 0.22 0.5588 0.72 1.8288 1.37 3.4798 0.22 0.5588 0.52 1.3208 0.09 0.2286 1.7 4.318 0.83 2.1082 0.25 0.635 1.41 3.5814 0.23 0.5842 0.14 0.3556 Fagus sylvatica ##### Sheet/List 5 ##### délka v palcích 2.54 četnosti třída přepočet (centimetry) aritmet. průměr 1.92405 0.5 5 1 11 0.4 1.016 max 4.8514 1 6 2 8 0.33 0.8382 min 0.0508 1.5 2 3 3 1.37 3.4798 modus 3.4798 2 6 4 7 0.68 1.7272 medián 1.778 2.5 2 5 3 0.61 1.5494 rozptyl 1.932778393 3 1 0 0.06 0.1524 rozptyl výběru 1.995126083 3.5 6 1.76 4.4704 sm. odchylka 1.390244005 4 1 0.75 1.905 výběrová sm. odchylka 1.412489321 4.5 2 1.91 4.8514 stř. chyba průměru 0.249695194 5 1 0.72 1.8288 histogram 0 0.79 2.0066 N 32 1.28 3.2512 0.9 percentil 3.57124 0.6 1.524 0.5 percentil 1.778 0.14 0.3556 0.1 percentil 0.3556 0.02 0.0508 1.2 3.048 1.37 3.4798 0.27 0.6858 1.27 3.2258 Třídy Četnost 1.01 2.5654 1 11 0.22 0.5588 2 8 0.72 1.8288 3 3 1.37 3.4798 4 7 0.22 0.5588 5 3 0.52 1.3208 Další 0 0.09 0.2286 1.7 4.318 0.83 2.1082 0.25 0.635 1.41 3.5814 0.23 0.5842 0.14 0.3556 ##### Sheet/List 6 ##### X Y=x*x X Y=sin(x) 1 1 0 0 2 4 0.3 0.295520207 3 9 0.6 0.564642473 4 16 0.9 0.78332691 5 25 1.2 6 36 7 49 8 64 9 81 10 100 11 121 12 144 13 169 14 196 15 225 16 256 17 289 18 324 ##### Sheet/List 7 ##### Gaussian function "show normal probability distribution N(2,9)" using Excel function =norm.dist()