Data Handling 2: Effectiveness of Excel Functions in Analyzing Data

Data Handling 2

TABLE OF CONTENTS
INTRODUCTION...........................................................................................................................3
PART 1............................................................................................................................................3
Effectiveness of excel functions in analysing data......................................................................3
Use of excel.....................................................................................................................................3
PART 2............................................................................................................................................7
Number of male and female customers of Smile Clinic..............................................................7
Mean, mode, median of the ages.................................................................................................8
Numbers of people who eat rice along with mean, median and mode......................................11
Examples of clustering..............................................................................................................13
Most common data mining methods used in businesses...........................................................14
Advantages and disadvantages of SPSS over excel..................................................................14
REFERENCES................................................................................................................................1

INTRODUCTION
The following report focuses on data handling. Data handling is the procedure of making
sure the research data which is stored, archived or disposed of in the safe and secure manner
during the conclusion of research project (Lee and et.al 2018). Proper planning of data handling
can provide economic storage and disposal of data to business. This report focuses on evaluating
the use of excel.
PART 1
Effectiveness of excel functions in analysing data
Use of excel
Excel is one of the important and top tool which is frequently used for data analysis and
built- in pivot table are one of the most popular analytic tool. Excel plays various functions in
data analysis. Various data mining technique has been used to transform raw data into such
format which can be understood by anyone. The main motive of using Excel is to make the data
easy and understandable for all. Excel also helps in removing the errors and mistakes. Raw data
always remain incomplete and this data can't be sent through any model. In the set of data,
generally lacking attribute values, inconstancy also being found out from excel. Therefore, it is
one of the powerful tool of excel which is quite popular.
Excel is also getting used in analysing the data, because the range of statistical function
which calculates the accurate figure and provide appropriate data. One of the biggest use of excel
in data analysis is that it makes the complex data easier and convenient for use. Analysed data
provides high level of visual summarization and different trends and patterns which make the
data more convenient (Xiao, 2020). Excel sheet organize the data into raw and also make it
readable, and also it becomes easier to extract the insights. Excel also gives customized fields
which is helpful for complex data. It also assists in solving difficult calculations. It is also used
to analyse the larger set of data and segments and all these segments can be read effectively.
Better analysis of data provides better products hence the excel becomes more important. It is
used to explore the data and all the insights.

Excel also provides various chart types so that anyone can choose any chart which suits
their data, and they may use them for the visualization of their data. Excel also provides
different editing options in the charts so that user can make certain changes in the visuals of their
data and make the data more useful and effective in looking. In the spread sheet various tools
available such as bar charts, line chart etc. which make the data creative. Apart from this various
combination of charts can be used to represent the data. Visualization of data also helps in
conducting the comparison between different sets of data. Therefore, excel is one of the
important program for every business. Therefore, it is used for indicator, which is used for
numeric values.
Chart
Chart is one of the important tool, which is provided by excel which communicate data
graphically. Chart is helpful for indicating the data which has been displayed in one or two
numeric values. Chart also provides various offers to provide titles and headings. Chart is also
being defined in various forms such as line chart, bar chart etc. This is used by those people
who have to deal with the complex issues. Line chart is one of the popular chart for complex
problem. Chart is also known as graph which is one of the powerful tool and used to produce
accurate results. Chart is also come classified in different types such as: Bar, column, pie, scatter
etc. Column chart is typically used to display different categories and it also provides horizontal
axis and vertical value. Pie chart also use to show the value of big size items and data. All the
data point in the chart is being shown as the percentage of whole. It is used to maintain all the
data in one column.
Bar chart is also used to demonstrate comparison among different team. As it is easy to
understand and is has used on wide level and also it represents all the change which is done in
the data. Bar chart is also important because it can create a clear picture of data set. Therefore, it
is getting used in data handling and used in future planning and forecasting. One of the biggest
benefit is that it helps the management to incorporate their understanding for analysing and
future forecasting. Bar chart also use for presentation and it quickly states about the trend.
Year Sales
2009 14915601