Plantilla Excel para elaborar distribución de frecuencias dados los datos crudos (hasta 150). Son 10 hojas de cálculo donde el estudiante indica el número de clases o, en su defecto se calcula utilizando la fórmula de Sturges. Para comenzar se deben borrar los datos del ejemplo e introducir sus...
Datos Introduce los dataos en la columna A, desde A2 (hasta 150 datos)
1.4 Valores maximo y minimo
1.8 Máximo= 5
2.5 Mínimo= 0.6
2.5
1.9 Amplitud o rango
2.8 A= 5 - 0.6 = 4.4
3.8
3.5 Número de datos
3.7 n= 130
1.7 Numero de intervalos de clase.
1.6 c= 15 Introducir dato solicitado en celdas amarillas
3
Numero de decimales en los datos crudos.
1
3.2 Ancho del Intervalo de clase
2.9 A 4.4
i= = = 0.293333
3.5 c 15
3.5
3.1 i= 0.30
0.6
1.3 Escriba la unidad minima de medida en el cuadro amarillo
2.9 1 si los datos son números enteros
1.9 0.1 si los datos tienen 1 número decimal
3.5 0.01 si los datos tienen 2 números decimales, etc
4.6
2.8 Unidad minima= 0.1
3.1
0.8 Escriba el limite inferior (li) de la primera cla< = 0.6 )
3.1 Sugerencia 0.30 ( 2 )=
2.7 li= 0.6
1.8
3.1 Nº Clases Frecuencia Frecuencia Relativa Frecuencia acumulada
1.7 1 0.60 0.80 3 0.023076923076923 3
3.6 2 0.90 1.10 4 0.030769230769231 7
3.4 3 1.20 1.40 6 0.046153846153846 13
2.2 4 1.50 1.70 8 0.061538461538462 21
4 5 1.80 2.00 9 0.069230769230769 30
3.1 6 2.10 2.30 9 0.069230769230769 39
2.8 7 2.40 2.60 10 0.076923076923077 49
2.7 8 2.70 2.90 17 0.130769230769231 66
3.2 9 3.00 3.20 16 0.123076923076923 82
3.2 10 3.30 3.50 16 0.123076923076923 98
,2.9 11 3.60 3.80 11 0.084615384615385 109
2.2 12 3.90 4.10 6 0.046153846153846 115
4.6 13 4.20 4.40 8 0.061538461538462 123
5 14 4.50 4.70 5 0.038461538461539 128
2.2 15 4.80 5.00 2 0.015384615384615 130
0.9 130 1
2.8 Si el número de intervalos es menor que 15, las filas donde la frecuencia es cero no forman pa
1.9
2.1
2.8
2.2
3.2
2.8
3.4
4.2
3.4
4
3.5
0.8
3.8
3.3
4.2
3.5
3.1
2.9
3.2
1.9
2.4
2.6
1
3.5
1.8
3.7
2.2
4.2
3.7
1.4
2.6
3.8
3.2
4
4.4
1.5
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller LinoGuer. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $4.96. You're not tied to anything after your purchase.
