Mmmk

UN EJEMPLO
(VER HOJA EXCEL: 003 EJ. EST DESC TABLAS HISTOG)
Los 40 alumnos de una clase han obtenido las siguientes puntuaciones, sobre 50, en un examen de Física.
3, 15, 24, 28, 33, 35, 38, 42, 23, 38, 36, 34, 29, 25, 17, 7, 34, 36, 39, 44, 31, 26, 20, 11, 13, 22, 27, 47, 39, 37, 34, 32, 35, 28, 38, 41, 48, 15, 32, 13.
1. Construir la tabla de frecuencias.
2. Construir la tabla dedistribución de frecuencias.
3. Dibujar el histograma
4. Dibujar polígono de frecuencias.

Veamos los datos “ en bruto”
3, 15, 24, 28, 33, 35, 38, 42, 23, 38, 36, 34, 29, 25, 17, 7, 34, 36, 39, 44, 31, 26, 20, 11, 13, 22, 27, 47, 39, 37, 34, 32, 35, 28, 38, 41, 48, 15, 32, 13.

#orden | PUNTUACIONES | Xi-Prom | (Xi-Prom)**2 |
  |   |   |   |
1 | 3 | -26,225 | 687,750625 |
2 |15 | -14,225 | 202,350625 |
3 | 24 | -5,225 | 27,300625 |
4 | 28 | -1,225 | 1,500625 |
5 | 33 | 3,775 | 14,250625 |
6 | 35 | 5,775 | 33,350625 |
7 | 38 | 8,775 | 77,000625 |
8 | 42 | 12,775 | 163,200625 |
9 | 23 | -6,225 | 38,750625 |
10 | 38 | 8,775 | 77,000625 |
11 | 36 | 6,775 | 45,900625 |
12 | 34 | 4,775 | 22,800625 |
13 | 29 | -0,225 | 0,050625 |
14 | 25 | -4,225 |17,850625 |
15 | 17 | -12,225 | 149,450625 |
16 | 7 | -22,225 | 493,950625 |
17 | 34 | 4,775 | 22,800625 |
18 | 36 | 6,775 | 45,900625 |
19 | 39 | 9,775 | 95,550625 |
20 | 44 | 14,775 | 218,300625 |
21 | 31 | 1,775 | 3,150625 |
22 | 26 | -3,225 | 10,400625 |
23 | 20 | -9,225 | 85,100625 |
24 | 11 | -18,225 | 332,150625 |
25 | 13 | -16,225 | 263,250625 |
26 | 22 | -7,225 |52,200625 |
27 | 27 | -2,225 | 4,950625 |
28 | 47 | 17,775 | 315,950625 |
29 | 39 | 9,775 | 95,550625 |
30 | 37 | 7,775 | 60,450625 |
31 | 34 | 4,775 | 22,800625 |
32 | 32 | 2,775 | 7,700625 |
33 | 35 | 5,775 | 33,350625 |
34 | 28 | -1,225 | 1,500625 |
35 | 38 | 8,775 | 77,000625 |
36 | 41 | 11,775 | 138,650625 |
37 | 48 | 18,775 | 352,500625 |
38 | 15 | -14,225 | 202,350625 |39 | 32 | 2,775 | 7,700625 |
40 | 13 | -16,225 | 263,250625 |

n | 40 | 1169 |   | 4764,975 |
Promed |   |   |   | 29,225 |
  |   | 29,225 |   |   |
  |   |   |   |   |
VAR, INSEG | | 122,1788462 | | 122,1788462 |
  | | | |   |
VAR. Sesg |   | 119,124375 |   | 119,124375 |
  | | | |   |
Desv St Ins | | 11,05345404 | | 11,05345404 |
  | | | |   |
Desv StSesg | 10,91441134 |   | 10,91441134 |

| | | TABLA DE FRECUENCIA | |
| | | | | | | |
PUNTUAC |   |   |   |   | Xi -Prom | (Xi-Prom)**2 | fi *(Xi-Prom)**2 |
SIN DUPLIC | fi | Fi | Xi | fiXi |   |   |   |
3 | 1 | 1 | 3 | 3 | -26,225 | 687,750625 | 687,750625 |
7 | 1 | 2 | 7 | 7 | -22,225 | 493,950625 | 493,950625 |
11 | 1 | 3 | 11 | 11 | -18,225 | 332,150625 | 332,150625 |13 | 2 | 5 | 13 | 26 | -16,225 | 263,250625 | 526,50125 |
15 | 2 | 7 | 15 | 30 | -14,225 | 202,350625 | 404,70125 |
17 | 1 | 8 | 17 | 17 | -12,225 | 149,450625 | 149,450625 |
20 | 1 | 9 | 20 | 20 | -9,225 | 85,100625 | 85,100625 |
22 | 1 | 10 | 22 | 22 | -7,225 | 52,200625 | 52,200625 |
23 | 1 | 11 | 23 | 23 | -6,225 | 38,750625 | 38,750625 |
24 | 1 | 12 | 24 | 24 | -5,225 |27,300625 | 27,300625 |
25 | 1 | 13 | 25 | 25 | -4,225 | 17,850625 | 17,850625 |
26 | 1 | 14 | 26 | 26 | -3,225 | 10,400625 | 10,400625 |
27 | 1 | 15 | 27 | 27 | -2,225 | 4,950625 | 4,950625 |
28 | 2 | 17 | 28 | 56 | -1,225 | 1,500625 | 3,00125 |
29 | 1 | 18 | 29 | 29 | -0,225 | 0,050625 | 0,050625 |
31 | 1 | 19 | 31 | 31 | 1,775 | 3,150625 | 3,150625 |
32 | 2 | 21 | 32 | 64 | 2,775 |7,700625 | 15,40125 |
33 | 1 | 22 | 33 | 33 | 3,775 | 14,250625 | 14,250625 |
34 | 3 | 25 | 34 | 102 | 4,775 | 22,800625 | 68,401875 |
35 | 2 | 27 | 35 | 70 | 5,775 | 33,350625 | 66,70125 |
36 | 2 | 29 | 36 | 72 | 6,775 | 45,900625 | 91,80125 |
37 | 1 | 30 | 37 | 37 | 7,775 | 60,450625 | 60,450625 |
38 | 3 | 33 | 38 | 114 | 8,775 | 77,000625 | 231,001875 |
39 | 2 | 35 | 39 | 78 | 9,775 |...