Importance of Excel for Data Analysis and Interpretation

2 Coursework

Table of Contents
INTRODUCTION...........................................................................................................................2
MAIN BODY...................................................................................................................................2
PART 1............................................................................................................................................2
PART 2:...........................................................................................................................................7
CONCLUSION..............................................................................................................................13
REFERENCES..............................................................................................................................15
1

INTRODUCTION
Data is a form of raw facts and figures which is useful in every type of organisation. The
information is extracted from the raw data. This report is divided into two parts. In part one, it
includes the importance of excel for the purpose of analysing and interpreting the data set. Excel
is a part of Microsoft windows which is useful for the complex calculations. It is represented in
the form of spreadsheet (Adinugroho, and Sari, 2018). There are various techniques of the
Microsoft excel such as pre-processing, analysing and visualising the data is also explained in
this report. The use of pivot table, look up and if function by using the given crime data is also
included in this report. In task two, it encompasses the use of descriptive statistics such as mean,
median is taken into consideration. The concept of data mining and text mining methods is
included in the report. The SPSS is a software which helps in performing complex calculations
and interpreting the information for taking various decisions. SPSS and excel both are helpful
tools to take operational, financial and strategical decisions of nay organisation.
MAIN BODY
PART 1
Evaluating the use of excel for pre-processing, analysing and visualising the data.
a) Data pre-processing: It involves various steps which convert the raw data into structured
form of data. The raw data is not useful for the analysis. Hence, there are various phases
of the data pre-processing There are various steps which are included in the data pre-
processing can be described as given below:
 Data cleaning – it consists missing data, noise, outliers and make a copy of the wrong
records (Chen, Lee, and Chen, 2020).
 Data integration – The data is available in the heterogeneous form which means data is
not sorted according to the required category. In this step, it filters the data into the same
class or group which helps in reaching to the conclusions.
 Data transformation – There are variety of scales available in the data. The different
scales are nominal, ordinal, interval and ratio. The nominal and ordinal deals with the
qualitative aspects of the data whereas interval and ratio includes quantitative aspects. It
eases by transforming one scale to another.
2

 Data reduction – In this step, the unnecessary data is removed and the data is presented in
a tidy format. It organises the data in an effective manner.
Uses of data pre-processing:
There are several advantages of the data pre-processing which can be described as given
below:
Inaccurate data (missing data): There are numerous reasons for which data is missing. The data
missing can be due to the mistake in the data entry, technical problems with biometrics and many
other issues. The application of data pre-processing helps in solving the issue of the missing data
(Datta, Rokade, and Rajput, 2022)
Presence of noisy data- There are several issues which can occur in the gadget it can be
existence of noise and ambiguity in the data. There can be occurrence of human mistake while
making data entry and many more things.
Inconsistent data – Inconsistencies are the errors or issues which can occur in the data. There
can be various reasons for the inconsistencies such as mistakes in the codes or names, human
error in data entry.
Data analysing:
Excel provides various functions such as organising, analysing and interpreting the data. The
data analysis is a feature which helps in taking decisions related to operational and strategical
options in the enterprise. The different techniques available for data analysis can be elaborated as
given below:
Sorting: The process of sorting includes the arrangement of data in ascending or descending
order. It is a vital part of the data analysis. It can be done either name wise, date wise or year
wise (Fong, Li, and Dey, 2018)
The foremost step in the data sorting is to click the cell which the user wants to sort. Then go to
the Data tab in the sort and filter group.
Filtering: It is the process which helps to match the specific conditions depending upon the
criteria given. The steps for filtering of data includes clicking on the single cell and select data
tab, then sort& filter and again click on the filter.
Count if – It is another excel function which is used for computing cells in a range that helps in
satisfaction of a particular condition
3