Saltar navegación

Cálculo de la media y la mediana. Actividades - Contenido educativo

Ajuste de pantalla

El ajuste de pantalla se aprecia al ver el vídeo en pantalla completa. Elige la presentación que más te guste:

Subido el 5 de julio de 2024 por Maria Jose M.

5 visualizaciones

Más información Transcripción

Descargar la transcripción

Formative cycle, higher degree, marketing and advertising, professional module, commercial research, work unit 7, treatment and statistical analysis of the data, associated with the learning result 7. 00:00:04
Objectives. Learn to calculate the basic measures of descriptive statistics. 00:00:24
index 1 calculation of the average 2 calculation of the median in this video we are going to learn to calculate 00:00:29
the average with simple data we see that I have a series of data and I want to calculate the average 00:00:46
excel has the average function that automatically calculates the average for me I put the same average I 00:00:51
open parentheses I select all the data I close parentheses I give it to intro and I already have the 00:00:57
average for simple data. If we remember what the average is, it is the sum of all 00:01:04
the data divided by the total number of data. We could check that this one 00:01:09
has done it correctly. If we add all the data here with self-sum, I put here, I give it 00:01:14
self-sum and automatically I get 193 and to calculate it is equal to the sum of 00:01:22
all the data 193 divided by the total number of data which is 18 and we have 00:01:29
checked that the calculated average comes out perfectly as the definition we are going to see 00:01:35
now the calculation of the average in grouped data we want to obtain information about the level 00:01:41
of daily consumption of a certain product from the response given by 730 people 00:01:48
that have been surveyed in several commercial centers the accumulated data obtained that 00:01:55
are distributed by intervals in terms of daily weight consumption has been the one that 00:02:01
is reflected in the table where we have daily consumption in interval and absolute frequency we see 00:02:07
that I do not have the data as such for that reason I have to calculate the class mark which is x 00:02:12
sub and which is the middle point of the interval how are we going to calculate it because to calculate it we have 00:02:18
to add the ends of the interval in this case it is 1 plus 5 and the sum we 00:02:24
divide by 2 and it would give us 3 and so with all the intervals in this case 6 00:02:29
plus 10 divided by 2 gives us 8 then we already have the class mark the formula 00:02:35
for the average calculation is the sum of the class mark that we already have 00:02:41
by the frequency we have made a table here with that calculation of the 00:02:45
class mark by the frequency and the add-on because we have done the self-sum gives us 10,705 divided 00:02:52
by the total number of surveyed people, which in this case is the total absolute frequency, 00:02:59
which is 730 and already the average because it gives me 15 and I would already have calculated the average for grouped data 00:03:05
we are going to calculate now the median with simple data the median is the value that the 00:03:16
central place of all the data when these are ordered to calculate it 00:03:27
excel establishes the function of the median equal to median we open parentheses 00:03:31
and select all the data that in this case are odd data I close 00:03:37
parentheses I give it to intro and I have already calculated the median value for 00:03:41
odd data we are going to calculate we are going to check that that value is correct and 00:03:46
following the definition we are going to order the data of greater and we check that the central position 00:03:52
is 10 therefore it has calculated the data of the median correctly with the function equal to 00:04:00
the median I have 9 data above and 9 data below then the median is the value that 00:04:07
occupies the central place and this is correct but what happens when the data is even when I have 00:04:12
one more data, for example, we are going to add one more data so that they are even in this case we are going to 00:04:20
calculate the median equal to the median I open parentheses and select all the even data I close 00:04:28
parentheses and give it to intro it has returned me the value of the median which is 9 we are going to check 00:04:35
if the function has done it correctly by ordering the data from minor to major the data 00:04:41
that are in the central position are the data of position 10 and 11 in this case what we have 00:04:50
to do is talk we do the average of the values ​​that are in the center in this case 00:04:58
are 8 and 10 to calculate the average we divide between 2 and the average would be 9 with which it has 00:05:04
correctly calculated the data of the median for even data and the median calculation would be done. 00:05:13
We are now going to calculate the median in grouped data. In the same previous example in which 00:05:21
we had calculated the median, we are going to calculate the median in the grouped data table. 00:05:29
We are going to calculate the median using this formula that we had already explained in the previous video. 00:05:34
When we have ungrouped data, the median is the value that is in the middle when we have 00:05:41
ordered the data from lower to higher or from higher to lower value. The problem here is that we do not have 00:05:47
the data as such, we have an absolute frequency table and we cannot calculate it that way. 00:05:53
For this, what we are going to do is build a table of accumulated frequencies. To this column 00:06:00
we call it F capital, accumulated frequency. The first value is the value of 100, the second 00:06:07
value would be the first value plus the second value and so on. The third value is the sum 00:06:15
of the three values ​​of the frequencies and so on. The final number we obtain is the 00:06:23
total number of the data of the table as we can check now well we are going to 00:06:31
calculate n between 2 in this case in between 2 is equal to 730 between 2 that 00:06:36
gives us a value of 365 we go to the column of 00:06:44
accumulated frequencies and in this case we look for the first value that is 00:06:49
greater than 365 which is 434 in 250 it is not greater than 365 so we pass this value therefore 00:06:53
once we have identified the accumulated frequency we have also identified the 00:07:04
value of the interval of the median which would be between 11 and 15 therefore l and is the first 00:07:09
number of the interval that we have just found which would be 11 the capital F we have to 00:07:17
remember that they refer to the accumulated frequencies and the f minuscule to the absolute frequency 00:07:23
it is important that we distinguish this to then substitute in the formula therefore the f 00:07:29
sub i minus 1 is the accumulated frequency of the previous interval, that is, 250 and the is the 00:07:35
amplitude of the interval in this case is calculated subtracting the limits of the interval we would have 00:07:45
have to subtract 15 minus 11 and it would be equal to 4 and now we already have all the data 00:07:51
we need what we are going to do is simply substitute them in the formula so 00:07:57
that the median would be equal to l sub 0 which would be 11 plus in between 2 which would be 365 minus 00:08:02
f sub and minus 1 which would be 250 between f minuscule sub and which would be 184 and that gives us a value 00:08:09
of the average of 13.5 and with this we would have done the calculation of the 00:08:19
average in grouped data activity defines and calculates the average and the 00:08:24
average from the following statistics table 00:08:31
activity calculates the average and the average from the 00:08:35
following statistics table daily consumption of milk and absolute frequency with 00:08:40
the following data 00:08:44
Idioma/s:
es
Idioma/s subtítulos:
en
Autor/es:
Mª José Martínez Rivas
Subido por:
Maria Jose M.
Licencia:
Reconocimiento - No comercial
Visualizaciones:
5
Fecha:
5 de julio de 2024 - 20:26
Visibilidad:
Clave
Centro:
IES PIO BAROJA
Duración:
09′ 03″
Relación de aspecto:
1.78:1
Resolución:
1920x1080 píxeles
Tamaño:
145.08 MBytes

Del mismo autor…

Ver más del mismo autor

EducaMadrid, Plataforma Educativa de la Comunidad de Madrid

Plataforma Educativa EducaMadrid