Frequency Distribution Table Shortcuts // Frequency Function MS Excel

Functions Used: COUNT, MAX, MIN, SQRT, ROUNDUP, FREQUENCY, SUM, $$
0:00 Introduction
1:01 With Lecture
9:15 Without Lecture
#FrequencyFunction #FrequencyDistribution #FrequencyDistributionTable

[@kamalranatunga]

What a great tutorial... Keep the good work.

[@uchechukwuamua3037]

thank you so much for this lesson

[@glentox1563]

Welcome,

[@marjhonsartagoda568]

How to know the numbers of the class intervals, sir, there are 7 rows for the class intervals.

[@glentox1563]

Thanks for asking. In some cases, the number of class interval is already provided or by simply choosing between 5 to 15. But in the case that it is not provided, one way to get the IDEAL number of class interval is to get the square root of the number of raw data. In the example on the video, 50 is the number of raw data. The square root of 50 is 7.07 or equal to 7.
You can check out my other video, ruclips.net/video/3YX_1DLwJEI/видео.html. In this video, I got a raw data of 162. In the presentation of numerical data particularly construction of FDT, we don't strictly focus on the idea of the number of class interval. Because the number of class interval can change at any time. What is important is that as long as the lowest score from the raw data is contained in the lowest class interval and similarly, the highest score from the raw data is contained in the highest class interval. Thanks!

[@marjhonsartagoda568]

@@glentox1563 I appreciate your reply, Sir, I can now peacefully create an FDT without thinking too much.