Data Handling And Business Intelligence (Assessment 2)

ASSESSMENT 2

Table of Contents
PART-1............................................................................................................................................3
Use of excel in pre-processing, analysing and visualizing the data............................................3
PART-2............................................................................................................................................6
Numbers of customers as male and female.................................................................................6
Number of customers eating rice.................................................................................................7
Mean and Median of the ages......................................................................................................8
Mean and Median of participants that eat rice.............................................................................8
Clustering...................................................................................................................................10
2.2 Data mining methods...........................................................................................................15
2.3 Advantages and disadvantages of SPSS over Excel............................................................15
REFERENCES................................................................................................................................1

PART-1
Use of excel in pre-processing, analysing and visualizing the data
Data refers to individual facts, statistics, information which is being collected from the
observation or the research of the specific aspects. It can be a set of qualitative and quantitative
value that may be related with respect to a person, or object (Vassakis, Petrakis and Kopanakis,
2018).
As the data are usually present in raw and unstructured mode that may need to be
integrated and combined into under-stable mode for making understanding. Excel is one of the
best tool that is being used with regard to making pre-processing and analysing the data. Pre-
processing refers to a data mining process under which a transformation of raw data into under-
stable mode is being performed (Baviskar and et.al., 2021). This will lead to have better
understanding of the data. Excel is one of the major tool with respect to this aspect. This is
because excel involves the collection of raw data and making its conversation into under-stable
mode. Under excel the data is filled in rows and columns in such a mode that it will lead to make
establishment of the relationship between them. This is being performed with the help of various
tools of excel including pivot tables, charts and graphs and various others. Excel is one of the
highly used tool with respect to data pre-processing because it will lead to make the data
conversion into under-stable mode.
Along with pre-processing, excel will also be used to make the analysis of the data. As
per this aspect excel through its tools say charts and graphs make the conversion of data into
analytical mode so that the trend and the related information and meaning of the data will be
determined. This means through the tools of the excel the data can be made analysed and its
concerned trends and meaning can be determined. It is also to be noted that as excel enable the
making of graphs and charts so it will automatically lead to visualization of data in such a mode
that with the help of prepared charts and graphs from the gathered information, visual effect in
terms of under-stable charts will be presented (Evergreen, 2019).
However, it is also to be noted that although with the help of excel, pre-processing of data
will be enabled but it also include the risk of occurrence of errors. This is because under excel
data need to be placed in the rows and the columns but while inserting the data in it there are
chances that the human error may occur and affect the extraction of the data and pre-processing
of data (Tsou, 2019). Likewise, it is also to be noted that it is also a difficult aspect to make

insert of the vast value of raw data in excel rows and columns because it will raise the chances of
occurrence of human errors in terms of escaping the data or the wrong putting of data.
But on a wider scale excel is one of the major data mining tool with regard to making
pre-processing of data and its analysis. Along with excel its associated tools including pivot
tables, bars and graphs and others also plays an important role ith respect to the data processing
and its analysis. This is because when data will be arranged in rows and columns from raw mode
and when charts and graphs will be prepared from arranged data then all the aspects including
data processing, analysing and visualization will be able to performed in an effective manner
(Hossain, 2021).
In addition, of this it is also to be noted that graphs and charts is one of the major feature
of excel under which with the help of data, graph and charts will be drawn. With respect to the
current data the graphs and charts are used for the data pre-processing and analysing. Through
the adoption of the following steps charts and graphs can be created:
 The process of integration of this technique starts with the application of filter function
which will lead to make emergence of relevant data and figures.
 After the application of filter, range will be applied and selected so that the data of the
sales will be collected.
 With the following of the rage of particular year, the sum formula is being applied so that
the sum total of sales of the specific year will come. In this way the sum total of sales of
2009, 2010, 2011 and 2012 will be gathered.
 Similar steps starting from application of filter till the selection of range and imply sum
formula are also applied with respect to determination of the trends of profits of 2009,
2010, 2011 and 2012.
 Later the range of the data will be selected followed by the selection of the graph and
chart function. This will lead to have a formation of the graph. Same practice will be
implied in both the aspects of discount and profit.
 With the preparation of graph it is being analysed that there is an existence of direct
relation between sales and profit which means that with a rise in the value of sales the
profit proportion also raises.