fdt.py

Changelog

A tool written in Python to generate Frequency Distribution Tables in .xlsx file format.

Made to make my life in Statistics class a little bit easier and just have an excuse to actually learn Python more.

Dependencies

• XlsxWriter

Installing Dependencies

In a terminal of your choice, run:

pip install -r requirements.txt

Installation

with Git

git clone https://github.com/cobbdzon/fdt.py.git

Usage

Always remember to configure the dataset in src\config.json before outputting a file.

With run.bat

Simply run the batch file src\run.bat and type in the parameters.

After inputting the parameters the program will automatically open the directory and have the .xlsx file selected for you. You can edit the code to remove the auto-open if you don't like having a new window pop up every time you generate a file.

The output name should always be a valid file name and the number of classes be a valid number at all times or else the program will not output anything.

With a Terminal

The old and original way

py "C:\...\fdt.py\src\init.py" [OUTPUT_NAME] [NUMBER_OF_CLASSES]

Replace the ... to the directory of the fdt.py repository in your machine.

If either [OUTPUT_NAME] or [NUMBER_OF_CLASSES] are specified, their default values in config.json will be used instead.

You can find the outputted .xlsx files in the out folder inside src.

Configuraton

An example of a proper config.json from src\templates is shown below

{
    "outputName": "FDT",
    "numberOfClasses": 6,
    "data": [
        69, 97, 76, 60, 35, 83, 63,
        67, 40, 85, 75, 49, 58, 55,
        59, 73, 43, 93, 38, 78, 71,
        55, 51, 70, 89, 61, 65, 65,
        72, 65, 75, 32, 64, 60, 75,
        89, 75, 65, 85, 87, 45, 75
    ]
}

Config	Type	Description
outputName	string	The default file name of the .xlsx file that will be outputted by the script.
numberOfClasses	number	The default number of classes in the Frequency Distribution Table.
data	array<number>	The data sample for the Frequency Distribution Table.

Formulas

The formulas used in the code and just for the author's reference.

Notation

Notations from statistics class.

Variable	Name
$i$	Class Width
$ci$	Class Interval
$ci$	Class Interval
$x$	Class Mark
$cb$	Class Boundary
$f$	Frequency
$N$	Total Frequency
$R_f$	Relative Frequency
$cf$	Cumulative Frequency
$\lt cf$	Less Than Cumulative Frequency
$\gt cf$	Greater Than Cumulative Frequency

Additional Notation

This is my own notation for certain unannotated values.

Variable	Name
$hv$	Dataset Lowest Value
$lv$	Dataset Highest Value
$dc$	Desired Classes
$ci_1$	Class Interval Lower Limit
$ci_2$	Class Intervl Upper Limit
$cb_1$	Class Boundary Lower Limit
$cb_2$	Class Boundary Upper Limit

Class Width

$$ i=\frac{hv-lv}{dc} $$

Class Mark

$$ x=\frac{ci_1 + ci_2}{2} $$

Relative Frequency

$$ R_f=\frac{f}{N} $$