Importance of Excel and SPSS for Data Analysis

Report SPSS

Contents
INTRODUCTION...........................................................................................................................3
MAIN BODY..................................................................................................................................3
Part 1............................................................................................................................................3
Part 2............................................................................................................................................6
CONCLUSION..............................................................................................................................17
REFERENCES................................................................................................................................1

INTRODUCTION
Data analysis is a useful term for each type of business entity for better decision-making. In
order to take corrective decision, it is essential to apply suitable technique of data analysis by
help of excel or any other tool (Alpar and Schulz, 2016). The report is based on two parts in
which first part contains detailed information about data of a superstore and this data set is
analysed through different kinds of functions of excel like IF, PIVOT TABLES etc. On the other
hands, in second part of report data of a clinic is included which is analysed through SPSS
functions. In the further section, different kinds of data mining methods are analysed and critical
evaluation of importance of SPSS over excel is done.
MAIN BODY
Part 1
Importance of excel: In modern time period, there is a wide range of excel functions which are
used by business entities and individuals to present and analyse the data in a manner which can
be used for better decision-making. Below some key importance of excel is explained with
rationale of processing of data, analysis of data and presentation of data:
Pre-processing the data-The term pre-processing of data can be understood as presenting the data
in a form which can be understandable of everyone (Wazurkar, Bhadoria and Bajpai, 2017). In
other words, pre-processing of data is a way of transforming raw data in an easy way. In this
aspect, excel plays a key role because by help of excel complexity of data set is removed and
data is presented in a manner by which users can read and can find out a suitable outcome. For
instance, in the excel filter function can be used for preprocessing of data set and such function
helps in sorting the data in set in a small form.
Analysing the data- This is also another important function of excel which is used to analyse the
data set. The term data analysis can be defined as a process of assessing the data set by help of
different kinds of techniques like mean, mode, median etc. This process can be completed
successfully by help of excel functions and tools. There are various kinds of formulas like if user
need to compute mean of a huge data set than it can be accomplished by applying =MEAN
formula in excel sheet. This way of data analysis reduce the effort and time of analyst as well as

there is a surety that produced outcomes are correct and can be used for decision making in an
effective manner.
Visualising the data- It is essential to present the data in a way which is attractive and
understandable. In order to do so graphs and tables play a key role which are offered under excel
sheet. As we can see that in the excel, users have variety of options of charts like bar chart, pie
chart, column chart and many more (Martínez-Rojas, Marín and Vila, 2016). In order to produce
such chart there is no complex process, users just need to select the data for which they want
chart and have to select type of chart. This process becomes too easier and helpful for many
companies and businesses to prepare an attractive way to present the data set. Apart from these
charts, there is another option by which data can be presented effectively like tables under which
users can fill the colour to make presentation more attractive.
So these are some key importance of excel for data set. Apart from this, in practical manner there
are different kinds of functions which can be used for above mentioned roles. Below description
of each function is done:
IF function- The IF feature is one of the most basic tasks in Excel and it helps you to make
rational distinctions between such a quality and what you anticipate (Nagar, Atriwal and Tayal,
2016). So an IF claim can have two outcomes. If your correlation is valid, the first outcome is the
double if your correlation is incorrect.
In Excel, a four - part period clause is included in the IF feature or IF argument. It is easy to see
in this case what revenue and benefit sums are decreased or even what period the buyer's charge
is, as well as how the IF feature is implemented point by point.
 Cut/paste the taxable date, revenue and benefit again on separate pages for the first time.
 Reorganize old data into quality assurance claim's main framework.
 Use the type 'IF Element.' Shape a code of sort = if (virus type: B2>C3),
 If the recipient satisfies the specifications, continue adding a cell key to be checked as
well.
 Semi-colon Productive: Pick "Rise"
 Delete the multipack; and press Continue if the requirement is not met.
If a feature stresses the value of B3, the function of B1 would mean that the criteria may be much
more critical than B3 if the output of B3 is better than those of segment B3. As this alternative