Data Handling: Significance of Excel and Data Mining Techniques

DATA HANDLING

Table of Contents
INTRODUCTION...........................................................................................................................3
MAIN BODY..................................................................................................................................3
Part 1...........................................................................................................................................3
PART 2.......................................................................................................................................8
CONCLUSION.............................................................................................................................16
REFRENCES.................................................................................................................................17

INTRODUCTION
Data analysis is an important statement for every corporation which helps the
organisation take better decision in all departments. For making helpful and accurate decisions, it
is necessary to use suitable data analysis method with the help tools such as excel or any other
instrument. This report is divided into two parts where the first part includes elaborate content
about data of a supermarket which is analysed by using various types of features of excel such as
IF, PIVOT TABLES and others. The second part of this report includes data of a clinic which is
analysed by the usage of SPSS roles. Critical evaluation of the significance of SPSS in
comparison to excel along with analysis of various data mining techniques is provided.
MAIN BODY
Part 1
Significance of excel: In the current age of information, there is a broad spectrum of excel roles
is present which are utilised by large number of corporations and individual persons for the
purpose of effective presentation and analysis of data which helps them take better decisions
(Cotton, 2018) . Several of the major elements which highlight the significance of excel with
principle of data analysis, data processing and presentation of data are provided below:
Pre-processing data- The subject of pre-processing data is defined as showcasing the
collected data in a way which is easy to understand by any individual. Pre-processing of data is
associated transformation of raw data easily to make it comprehensible for everyone. Excel has a
crucial part in this area as due to the aid of excel, incomprehensible raw data is transformed and
the complex quality of this data is eliminated and the information is showcased in

comprehensible way which is easy to comprehend and useful results can be constructed from
such data (Farlow, 2020) . The filter function present in excel is helpful in sorting the data in
nuclear form and provides much required assistance in pre-processing of raw information.
Analysis of the data- This is one of the various highly significant functions present in
excel which are helpful in proper analysis of data. The phrase of data analysis refers to the
procedure of evaluation of data collection by the usage of various methods such as mean, mode,
median and other appropriate technical methods. This procedure is successfully accomplished by
the assistance of various instruments and tools present in excel (Filipowicz, 2019) . Different
types of procedures such as finding the mean of large data collection are easily completed by
application of =MEAN formula present in the excel sheet. With the assistance of such tools, the
procedure of data analysis becomes swift and the possibility of human errors is reduced by high
amount due to calculation being completed effectively in the excel sheet (Srivastava, 2020) .
This practice saves time as unnecessary time wastage is reduced and the results can be used to
take important decisions and improve the decision making process.
Visualising the data- Effective presentation of data also refers to showcasing data which
is not only easy to comprehend but also captivating and attention garbing. This objective of
enhancing the visual component of the data, is easily accomplished by effective usage of graphs
and tables which are present in the excel sheet. Excel sheet provides the users ability to construct
and include various charts such as pie charts, bar chart, line chart and many others. The
procedure to construct detailed accurate and attention grabbing charts is very easy as the users
are required to choose the kind of chart they wish to use and select it (Sumathi and Anitha,
2018) . This process can be completed by everyone and provides various corporations and
individuals required aid in presenting their information set in a visually appealing manner by
building charts swiftly and effectively. Excel gives the users another option of table construction
with different colours to make the visual element of the presentation highly appealing.
These are several of major benefits which are provided by excel for set of information. Aside
from the described functions, practically various type of functions which assist in the usage of
the various roles provided previously. The detailed account of each of these roles is given below:
IF function- One of the most basic chores in excel is the IF function and it helps the users make
logical differentiation between quality and attributes of the substance and the expectation of the