background top icon
background center wave icon
background filled rhombus icon
background two lines icon
background stroke rhombus icon
header logo icon

Download "Tabla de Frecuencias para Datos Agrupados en Excel - Tutorial paso a paso"

input logo icon
"videoThumbnail Tabla de Frecuencias para Datos Agrupados en Excel - Tutorial paso a paso
Similar videos from our catalog
|

Similar videos from our catalog

Video tags
|

Video tags

tabla
frecuencia
excel
frecuencias
gratis
video
tutorial
ejercicios
problemas
sumar
contar
acumulada
relativa
porcentual
absoluta
agrupados
no agrupados
tabla de frecuencias
agrupada
intervalos
REGLA DE STURGES
sturges
estadistica
matematicas
variable
cualitativa
cuantitativa
marca de clase
frecuencia acumulada
frecuencia relativa
frecuencia absoluta
funny math
jesus artunduaga
Jesús Artunduaga
UNAD
unad
intervalo
Latin
lofi hip hop
lofi
Subtitles
|

Subtitles

subtitles menu arrow
  • ruRussian
Download
00:00:06
Hello, welcome to this new video,
00:00:09
today we will learn how to build
00:00:11
a frequency distribution table
00:00:13
for grouped data when the value of
00:00:15
our variable is made up
00:00:17
mostly of decimal numbers. For this,
00:00:20
the first thing we have to do is
00:00:21
determine how much data we have. In
00:00:24
total, for this we are going to use the function
00:00:26
or command count, so here we are going to
00:00:29
write the same
00:00:31
count, we open parentheses and
00:00:34
select all our data. A
00:00:37
very optimized way to do this is
00:00:39
to place ourselves on the first value, using
00:00:41
the key combination control chis
00:00:43
down arrow. enter what
00:00:46
we just did is to select
00:00:48
each of the values ​​of the variable
00:00:49
we realize that in total we have
00:00:52
350 data,
00:00:54
now what are we going to do because we are going to
00:00:57
determine what is the maximum value of
00:00:59
those 350 data, for this we are going to
00:01:02
use the max command then
00:01:04
we write equal
00:01:06
mats parentheses and again we are going to
00:01:09
select all the data as
00:01:11
by doing the key combination
00:01:13
control shift down arrow and press
00:01:16
enter after this we are going to determine
00:01:19
what is the smallest value of our
00:01:22
base then we write equal
00:01:26
min parentheses and again
00:01:28
we select all the values ​​with the
00:01:30
key combination control shift
00:01:32
down arrow and enter
00:01:35
then we are going to proceed to determine
00:01:37
what our range is going to be so
00:01:40
how do we do it by
00:01:42
simply subtracting the largest value x mats we
00:01:45
are going to subtract the smallest value
00:02:07
22 asterisk to understand that it is
00:02:11
a
00:02:13
logarithmic multiplication we write the parentheses
00:02:16
we select the total of the data which
00:02:18
is 350 we close parentheses and this gives us
00:02:22
9.45
00:02:23
we have to take into account that since it is
00:02:26
a frequency distribution table
00:02:28
we cannot count on 9 like 45
00:02:32
intervals then we are going
00:02:35
to bring this value closer to the nearest odd integer
00:02:38
which in this case would be 9 then we
00:02:41
are going to proceed to calculate the amplitude
00:02:43
so we are going to write equal
00:02:47
and the range which is 4.4 we are going to divide it
00:02:51
by 9 which is the number of intervals and
00:02:54
this gives us 05 amplitude
00:02:58
and then after filling out the
00:03:00
initial information we are going to proceed to construct
00:03:02
each of the nine intervals for
00:03:05
this when we are going to make the first
00:03:07
interval we have to take into account
00:03:08
that the lower limit of this first
00:03:11
interval It will be the smallest number
00:03:13
of all the data. If we realize
00:03:16
that value we already know it, sx1000,
00:03:18
then we simply write equal and
00:03:21
select the value of x min.
00:03:24
Now to calculate the upper limit,
00:03:26
which is what we are going to do to the
00:03:28
lower limit. to add the amplitude
00:03:30
like this then we are going to write the same
00:03:34
we select the lower limit that
00:03:36
we already have press more and here
00:03:40
we select the amplitude before hitting
00:03:43
enter we are going to leave this amplitude fixed
00:03:45
as like this then here the electric that
00:03:49
you appear here whatever they are
00:03:51
simply They are going to put it between the
00:03:54
dollar symbol in the following way. Don't
00:03:57
forget, whatever the letter is, put it
00:03:59
between the dollar symbol
00:04:01
and press enter
00:04:02
and then this and this little number are going to
00:04:06
drag down here. Don't be scared
00:04:10
by the number that appears there.
00:04:12
It is normal now they are going to put the same here and they are going to
00:04:16
select this upper limit,
00:04:18
they press enter and then simply what
00:04:21
they do is just by selecting this cell
00:04:24
we drag
00:04:27
and we are going to build each
00:04:29
of the intervals
00:04:32
now we are going to proceed to build
00:04:34
our next column that It is the
00:04:35
class mark, this is the
00:04:37
simplest procedure of all, simply what
00:04:40
we do, we write the same, we
00:04:42
open parentheses, we select the
00:04:45
lower limit of the interval plus the
00:04:49
upper limit of the interval,
00:04:51
we close parentheses, slice divided 2 and
00:04:55
we press enter,
00:04:57
now we are going to put it here in the little box,
00:04:59
we click and we drag and in this
00:05:02
way
00:05:04
all the class marks will be constructed.
00:05:06
Now we are going to proceed to construct the
00:05:08
absolute frequency column. Be
00:05:10
very careful since this
00:05:12
procedure can be a bit
00:05:13
complicated, so for this we are going to use
00:05:16
the frequency command for So
00:05:18
we write equal frequency
00:05:22
we open parentheses and we are going to select
00:05:25
all the data we already know how we
00:05:27
do it we stop here in the first
00:05:29
control chis down arrow here you
00:05:32
have to be careful not to
00:05:34
press enter we simply
00:05:36
return
00:05:38
here in the cell we write period and comma
00:05:41
and now we are going to select the column
00:05:44
of upper limits remember that we
00:05:46
simply select the numbers
00:05:48
so we select from here to
00:05:50
here to the bottom we close
00:05:53
parentheses we enter enter
00:05:55
at this moment depending on the
00:05:57
version of office that we have it may
00:06:00
appear as follows all
00:06:01
the values ​​but if it doesn't
00:06:04
appear don't be scared what we have to
00:06:06
do is the following we simply
00:06:08
select the entire column
00:06:11
press efe 2 if we are on a
00:06:14
desktop computer simply efe
00:06:16
2 if we are on a laptop
00:06:19
we write fn efe 2 ready and then
00:06:23
we do the following key combination
00:06:26
control shift enter and in this way
00:06:29
all the values ​​should have appeared
00:06:31
to confirm that these numbers are
00:06:34
correct then we are going to do the sum
00:06:37
we write equal we write the addition command
00:06:40
we open parentheses we select
00:06:43
all the values ​​we close parentheses and
00:06:46
we give integer we realize that
00:06:48
we actually have 350 values
00:06:51
which corresponds to the total of the data.
00:06:54
The next thing we are going to do is
00:06:56
build the relative frequency column.
00:06:58
Remember that this
00:06:59
relative frequency is a quotient between the
00:07:01
absolute frequency and the total of the
00:07:03
data.
00:07:04
So for this, what we are going to do
00:07:06
is write here, we take the
00:07:09
first absolute frequency
00:07:10
slash and we come and select
00:07:13
the total data here. We are going to do something
00:07:15
here to not do the procedure
00:07:16
so many times, simply what we are going to
00:07:19
do is here in This letter, whatever
00:07:21
appears to you, is to put it
00:07:24
between the peso symbol.
00:07:26
If you suddenly don't want to do it
00:07:28
this way manually, then what do you do?
00:07:30
Where is your calling? Select this cell
00:07:32
and press if you are on a laptop, efe nf
00:07:35
4, and these will immediately appear.
00:07:38
symbols, if you don't want to do it that
00:07:40
way, you already know, write it
00:07:42
manually and enter, now what are we going to
00:07:45
do? We are going to select the
00:07:47
cell and scroll down. At this
00:07:50
moment, all the relative frequencies will appear.
00:07:53
We are going to corroborate that these
00:07:56
values ​​are true, as
00:07:58
below we simply write equal
00:08:00
sum, open parentheses and select
00:08:03
all the relative frequencies in the
00:08:06
parentheses. The teacher, if the final value
00:08:09
is equal to 1, means that this entire
00:08:12
procedure was carried out correctly
00:08:15
to construct the
00:08:17
accumulated absolute frequency column. so we are going to
00:08:19
do the following we are going to write
00:08:21
the same and remember that the first
00:08:22
accumulated absolute frequency
00:08:25
refers to the first
00:08:27
absolute frequency so we select here
00:08:29
and absent then the next
00:08:32
accumulated absolute frequency is going to be the
00:08:34
absolute frequency of the interval and we are
00:08:37
going to add the
00:08:40
previous accumulated absolute frequency again we
00:08:43
press enter and now in order not to do this
00:08:46
procedure repetitively we
00:08:47
simply select this
00:08:50
last cell here and scroll down.
00:08:54
If here at the end we again
00:08:56
realize that we have the total data
00:08:58
for our example 350 then
00:09:01
we can say that The procedure is
00:09:03
done correctly
00:09:06
for the last column of
00:09:08
accumulated relative frequency. We are going to do a
00:09:10
procedure similar to the previous one.
00:09:12
So let's remember that the first
00:09:14
accumulated relative frequency
00:09:16
refers to the first
00:09:18
relative frequency. So we write the same.
00:09:20
We select the first
00:09:22
relative frequency and give integer now. for the
00:09:25
next accumulated relative frequency
00:09:27
we write equal select the
00:09:30
relative frequency of the interval and to
00:09:33
it we are going to add the
00:09:36
previous accumulated relative frequency we
00:09:38
select we enter enter at this
00:09:42
moment to optimize the time we
00:09:44
simply select this cell and
00:09:47
scroll down
00:09:50
again if we realize that here
00:09:52
the last value is equivalent to 1 so
00:09:55
we can say that the result or the
00:09:58
column is solved
00:09:59
correctly if you wish you can
00:10:01
eliminate a couple of decimal figures here
00:10:03
simply by clicking on this symbol
00:10:06
here so that the number appears like
00:10:09
this We have built
00:10:11
our frequency distribution table
00:10:13
for grouped data. If you
00:10:15
liked the video, I invite you to
00:10:17
click like and subscribe to my
00:10:19
channel. I also invited us to join
00:10:21
each of my social networks until the
00:10:24
next time. Be very well.

Description:

¿Necesitas crear una tabla de distribución de frecuencias en Excel para datos agrupados en intervalos con valores decimales? En este tutorial de matemáticas, te mostraré paso a paso cómo crear una tabla de frecuencias completa en Excel para tus datos agrupados. Cubriré todos los aspectos importantes, incluyendo cómo calcular el número de datos, el valor máximo y mínimo, el rango, el número de intervalos utilizando la regla de Sturges, y la amplitud. Luego, te guiaré a través de cómo crear las columnas de intervalos, límite inferior y superior, marca de clase, frecuencia absoluta, frecuencia relativa, frecuencia absoluta acumulada y frecuencia relativa acumulada. ¡Sigue conmigo y en poco tiempo podrás crear una tabla de frecuencias de manera rápida y sencilla en Excel! Palabras clave: matemáticas, tabla de frecuencias, datos agrupados, intervalos, Excel, cálculos, distribución, regla de Sturges, amplitud, límite inferior, límite superior, marca de clase, frecuencia absoluta, frecuencia relativa, frecuencia acumulada, tutorial.

Preparing download options

popular icon
Popular
hd icon
HD video
audio icon
Only sound
total icon
All
* — If the video is playing in a new tab, go to it, then right-click on the video and select "Save video as..."
** — Link intended for online playback in specialized players

Questions about downloading video

mobile menu iconHow can I download "Tabla de Frecuencias para Datos Agrupados en Excel - Tutorial paso a paso" video?mobile menu icon

  • http://unidownloader.com/ website is the best way to download a video or a separate audio track if you want to do without installing programs and extensions.

  • The UDL Helper extension is a convenient button that is seamlessly integrated into YouTube, Instagram and OK.ru sites for fast content download.

  • UDL Client program (for Windows) is the most powerful solution that supports more than 900 websites, social networks and video hosting sites, as well as any video quality that is available in the source.

  • UDL Lite is a really convenient way to access a website from your mobile device. With its help, you can easily download videos directly to your smartphone.

mobile menu iconWhich format of "Tabla de Frecuencias para Datos Agrupados en Excel - Tutorial paso a paso" video should I choose?mobile menu icon

  • The best quality formats are FullHD (1080p), 2K (1440p), 4K (2160p) and 8K (4320p). The higher the resolution of your screen, the higher the video quality should be. However, there are other factors to consider: download speed, amount of free space, and device performance during playback.

mobile menu iconWhy does my computer freeze when loading a "Tabla de Frecuencias para Datos Agrupados en Excel - Tutorial paso a paso" video?mobile menu icon

  • The browser/computer should not freeze completely! If this happens, please report it with a link to the video. Sometimes videos cannot be downloaded directly in a suitable format, so we have added the ability to convert the file to the desired format. In some cases, this process may actively use computer resources.

mobile menu iconHow can I download "Tabla de Frecuencias para Datos Agrupados en Excel - Tutorial paso a paso" video to my phone?mobile menu icon

  • You can download a video to your smartphone using the website or the PWA application UDL Lite. It is also possible to send a download link via QR code using the UDL Helper extension.

mobile menu iconHow can I download an audio track (music) to MP3 "Tabla de Frecuencias para Datos Agrupados en Excel - Tutorial paso a paso"?mobile menu icon

  • The most convenient way is to use the UDL Client program, which supports converting video to MP3 format. In some cases, MP3 can also be downloaded through the UDL Helper extension.

mobile menu iconHow can I save a frame from a video "Tabla de Frecuencias para Datos Agrupados en Excel - Tutorial paso a paso"?mobile menu icon

  • This feature is available in the UDL Helper extension. Make sure that "Show the video snapshot button" is checked in the settings. A camera icon should appear in the lower right corner of the player to the left of the "Settings" icon. When you click on it, the current frame from the video will be saved to your computer in JPEG format.

mobile menu iconWhat's the price of all this stuff?mobile menu icon

  • It costs nothing. Our services are absolutely free for all users. There are no PRO subscriptions, no restrictions on the number or maximum length of downloaded videos.