Read the following web resource Data Science - https://builtin.com/data-science
Qualitative data is defined as and referred to the data that approximates or characterizes but is unable to statistically measure any attributes. These may include comments, thoughts, recounts etc. These are much harder to analyse as they different for each data entry.
Quantitative data in statistics is also known as categorical data. This is much easier to analyse. Example: Colour of eyes, gender, make of car etc.
Quantitative data are measures of values or counts and are expressed as numbers. Quantitative data are data about numeric variables Example: height, shoe size,
Large slabs of data are called raw data. They are made up of rows (records) and categorised by columns better known as fields.
Raw data by itself is really hard to read and understand, however if we analyse the data using tools such as pivot tables and data visualisations we can start to make sense of data and identify patterns.
When collecting data its important to design forms so that data can be analysed more effectively. You may use drop down boxes so values are set, making it much easier to analyse later on as an example.
It is also critical when collecting data to consider data ethics, privacy and security.
We can display summaries of data into graphs. We do this by categorizing data or using mathematical arguments. These include:
Sums (add up numbers of totals)
Averages (find the mid point in the data)
Counts (find out how many records are the same of each type)
Min - find the lowest value
Max - find the highest value
Plus more
You may display data in different types of graphs including:
Column, bar, pie, linear etc.
Excel - Pivot Table Basics - https://www.excel-easy.com/data-analysis/pivot-tables.html
Excel Build Charts with Pivot Tables - https://www.youtube.com/watch?v=WoR2RhT7AF0