LCBB5000 - Data Handling and BI: Excel, Data Mining, and SPSS Analysis

This report evaluates the use of Excel for data preprocessing, analysis, and visualization, highlighting its features for statistical analysis and reporting. It discusses functions like pivot tables and conditional formatting for efficient data evaluation and decision-making. The report also analyzes a sample dataset using a pivot table, identifying fluctuating growth trends. Furthermore, it describes various data mining methods, including association, classification, and clustering, and compares the advantages and disadvantages of using SPSS over Excel for data analysis. The document is available on Desklib, a platform offering AI-powered study tools and a wide array of past papers and solved assignments for students.

DATA HANDLING AND
BUSINESS INTELLIGENC
LCBB5000 ASSESSMENT 2

TABLE OF CONTENTS
PART 1............................................................................................................................................3
Evaluating use of of excel for pre processing , analysing and visualizing data........................3
PART 2............................................................................................................................................7
2.1.................................................................................................................................................7
2.2 Describing data mining methods.........................................................................................15
2.3 Describing the advantages and disadvantages of SPSS over excel....................................16
REFERENCES................................................................................................................................1

PART 1
Evaluating use of of excel for pre processing , analysing and visualizing data
Excel is one of the important tool that is utilized by various kinds of users to accomplish
certain objectives in effectual manner. It is widely taken into consideration for manipulating
rows and columns for conducting statistical analysis. This is found to be convenient as
provides features like simpler , faster and more intuitive. The particular specified tool
empowers users to get understandability by providing command for suing certain relatable
formulas which can accomplish objectives of users (Zhou, 2020.). It allows the users to get
features of providing ranks, trends, outlier, majority ,etc. This provides assistance in having
proper knowledge regarding particulars subject matter through storing, summarizing and
analysing selected range of data.
There are variety of functions available in excel that helps in proving various different abilities
to meet requirements in easy and manageable manner. In addition to this, it includes LEN,
count, net workdays, sum, average, if, error, v & h lookup, find, left and right, ranking, min,
max, sum product, etc. each function provides certain level of advantages to users that helps in
having capability of using advanced features. Concatenate aids in combing numbers, data and
test which is is helpful in obtaining excellent functions to attain the purpose in effective
manner. It becomes possible to have capability to store, analyse and summarize data in better
manner so that including complex data set of business practices can be exerted. With help of
mentioned functions user can get several distinct benefits which can help in attaining higher
efficiency in conducting complex practices in efficient manner. In order to coordinate with
changing circumstances excel upgrades and provide different new features and functions so that
modifying requirements of customers can be met. Recording, summarizing and analysing the
statical data becomes crucial in current business environment so that appropriate decision can
be taken.
In modern era, excel plays significant role in providing efficiency and accuracy by
conducting data evaluation in turn accurate decision can be taken. There are various distinct
kinds of functions available such as pivot table that provides ability to mold data as per
requirement. With help of pivot table it becomes possible to set relationship among two or
more variables so that significant result from this can be derived. Checking for miscreant data
become possible with this specified analytical tool. In order to store data excel provides higher

efficiency to drag and drop the set of information which can be easily summarized. For the
purpose of visualization, there are various types of chart, graph are present in excel that gives
larger emphasis on presenting information in understandable manner. Organizations usually
prefer to prepare reports on weekly, monthly and annually basis so that analysing data can
provide crucial factors to identifying prevailing irrelevant actions that can be eliminated in order
to have proper processing (Irafahmi and Williams, 2021). It provides users to get the proper
functioning by making reports with help of present features for deriving accurate & fair reports
in turn ascertainment of financial as well non monetary aspects can be recognised to boost
organizational performance.
The most crucial functions which are largely taken into practice are pivot table, v and h
lookup, conditional formatting, etc. Pivot table is used to summarize large data into short
manner. In addition to this, pivot table chart provides advanced patter of reflecting data set in
easily manner (Dunbar, 2020). Conditional formatting is as well one of the function utilized
analytics as it gives ability to provide information by highlighting according to set standard. In it
less or more than and equals requirement can be set to derive the data highlighted which aids
in formulating decisions in quicker manner. In addition to this, v & h look refers to vertical and
horizontal for looking information available in particular column and row respectively.
Irrespective of scale of operations conducted by companies these function largely contribute in
evaluating data in proper pattern. IF function gives ability to as well find that the particular
result or statement is true or false in turn less time need to be incurred for having accurate
assessment.
In organizational practices there are various changes occur due to different factors
which are required to focused for removing those practices that are not largely contributing in
success (Raubenheime, 2017). Excel can be used by firm to identifying prevailing trend by
setting relationship with various variables. There are distinct manner to reflect the data in
presentable manner like graphs, pie chart, etc so that visualization of complex data set can be
done in easy manner. In order to create pivot tables specified firm can take following steps:
 In order to create pivot table user is required to go to insert tab in which specific icon
will be reflected that will show a pop up will appear. Selection of table or range of data
will be done automatically as there is default feature in built in excel (Pivot Tables,2021).

In the dialogue box excel will ask location where you want to have pivot table such as
existing or new worksheet.
 The next step is concerned with appearing fields pane which will comprise row,
columns value and filters . Sorting option is as well available for filtering the data set in
turn summarized form of tabular format can be attained.
With help of these mentioned in instructions below table has been presented by filtering data
in quarters fro each years. The pivot table has been made made by dragging sales and
profitability in field pane and in values sum has been selected for getting proper knowledge
regarding the provided data set.
Column Labels
Row Labels <1/1/2009 Qtr1 Qtr2 Qtr3 Qtr4
<1/1/2009
Sum of Sales
Sum of Profit
2009
Sum of Sales 384000.468 583155.794
5
369589.
014
417315.
919
Sum of Profit 18509.72 47701.7 63265.3
6
22776.2
1
2010
Sum of Sales 338003.962
5
260170.541 337843.
7215
382849.
19
Sum of Profit 28030.26 17129.61 40106.6
4
46888.3
9
2011
Sum of Sales 366284.752 434479.037 291268.
3345
381322.
467
Sum of Profit 36982.13 61150.01 26314.7
7
36967.2
2
2012

Sum of Sales 472812.385
5
356108.784
5
363187.
272
409443.
6835
Sum of Profit 42316.3 36221.4 36743.1
2
15686.1
5
Total Sum of Sales 1561101.57 1633914.15
7
136188
8.342
1590931
.26
Total Sum of Profit 125838.41 162202.72 166429.
89
122317.
97
From the above presented table it can be concluded that entity is facing fluctuating
growth trend in which it is moving ups and down. In addition to this, it can be articulated that
profitability & sales for the year 2009 has inclined in initial three and then in fourth quarter
moved in upward direction. In four quarters of 2010 in second period it has decreased and
uplifted in both sales and profitability. 2011's quarters are presenting that in first two
mentioned set of period profitability and sales is enhancing then declined for rest two duration.
In 2012 the outcome movement is following same trend as 2011. On the basis of given
interpretation it can be articulated that organizations profits & revenue is not constant and
moving up & down which is reflecting ineffective financial performance.
This can be justified from the opinion of DaDalt and Wolf (2020)There are various types of
factors that are required to be considered as results in declining performance of company.
These factors includes all uncontrollable aspects which can largely emphasised on providing
both positive and negative impact on organizational growth (Morris, Deochand and Peterson,
2018). This includes interest, unemployment, purchasing power, political stability. GDP,
changing taste & preferences of customers, government rule, regulations, industrial legislation,
environmental practices, etc. These can not be easily controllable and required to be cope up
with changing circumstances of business environment so that sustainability can be gained. In
contrast to this, Alrousan and et.al., (2021) depicted that company largely get influenced from
its strategies of risk management, capital structuring, operational expenses, selection of
financing option, etc. These elements keeps on changing in turn its effect as well affect
organizational growth. In order to be prompt and effective it becomes crucial of the firms to pay

attention on prevailing circumstances so that better ability to assess consequences can be
become possible.
From this it can be interpreted that specified organization's performance is fluctuating
and reflecting downward sloping movement. It can be identified that there are various distinct
aspects which may influence the growth and sustainability. On the basis of given data it can
stated that entity is providing which is ultimately declining profit margin as well revenue
generating capacity. The reason behind providing discount is to motivate and spread positive
vibe among customers regarding offerings so higher revenue & profitability can be gained. In
addition to this, firm require to pay full attention on gathered data so that prevailing trend can
be taken into practice for measuring current position in industry. With help of analysed pattern
it can be interpreted that specified entity is performing ineffectively which requires to put
larger emphasis on company growth and sustainability.
PART 2
2.1
K Means

Initial Cluster Centers
Cluster
1 2
Gender 1 2
Age 13 26
Rice 1 0

Iteration Historya
Iteration Change in Cluster
Centers
1 2
1 4.450 2.659
2 .241 .420
3 .000 .000
a. Convergence achieved due to no
or small change in cluster centers.
The maximum absolute coordinate
change for any center is .000. The
current iteration is 3. The
minimum distance between initial
centers is 13.077.
Final Cluster Centers
Cluster
1 2
Gender 1 2
Age 18 24
Rice 1 1
From teh evaluation of above table it can be interpreted that rice consumption in both
cluster are equaivalent where as in gender and age categories in cluster two there is less
numbers as comapred to other.
Number of Cases in each
Cluster
Cluster 1 54.000
2 41.000
Valid 95.000
Missing .000

Descriptive