Data Analysis and Business Intelligence: Excel and SPSS

This report discusses the importance of data management and visualization in data analysis and business intelligence. It includes two parts, one on the use of Excel for data handling and the other on data enquiry using SPSS. The report provides insights on ice cream flavor preferences and gender distribution among students. It also highlights the merits and demerits of using Excel and SPSS for data analysis.

Data handling and
Business intelligence

Table of Contents
PART 1............................................................................................................................................3
INTRODUCTION...........................................................................................................................3
Main Body.......................................................................................................................................3
Valuation of use of excel for advance-handling of the data...................................................3
Evaluating of the Data fixed:..................................................................................................3
Indication of the data with the assist of excel purpose:..........................................................4
Graphical Exhibition of the data consuming suitable charts:.................................................4
CONCLUSION................................................................................................................................6
REFERENCES................................................................................................................................7
PART 2............................................................................................................................................8
INTRODUCTION...........................................................................................................................8
Main Body.......................................................................................................................................8
Data enquiry...........................................................................................................................8
Outcomes and consequences................................................................................................11
Argument..............................................................................................................................11
Merits and Demerits of using SPSS.....................................................................................12
Merits and Demerits of Excel...............................................................................................12
Conclusion.....................................................................................................................................12
References......................................................................................................................................13
Appendix........................................................................................................................................14

PART 1
INTRODUCTION
The case study describes about the data management which includes the series for gathering
the data, it also confirms precision of the details, it Assimilate concurrent function collected, and
assist in protecting the complete data administration plan in stripe with the aims and goals of the
company (Alhamadi, M.S., 2020). The efficiency of data administration plays a very important
objective in the achievement of the organization. This case comprises for the misconduct data
establish for the 10 years and utilizing such data set expertise on the excel has been estimated
and after such estimation V look up, count if etc. purpose has been accomplished on that kind of
data establish so that crime level can also be measured in percentage position also for the
company. With the assist of Microsoft excel the big handling of data has been carried out by the
firm very definitely and this will secure the time duration of the enterprise on a big scale.
Main Body
Valuation of use of excel for advance-handling of the data
The Microsoft excel spreadsheet assists the company in measuring the broad formulation
in minutes as it is the better instrument in finding the results of the organization. How it is not
appropriate for all type of assessment but still the consistent instrument for data analytics. The
advance handling of the data will develop easier with the assist of excel and in the provided data
set (Dar, P., 2021). The data establish which is provided in the question concerning to the crime
level for the present year and the crime stage during 10 years and kinds of remaining
circumstance has been provide on the basis of which the crime level has been exaggerated.
Various factors can be the education stage, the expenses, the southern area etc. on the basis of
which the stage diverges:
Evaluating of the Data fixed:
In the provided data it fixed the expressive statistics has been executed which comprises of
mean, median and mode etc. which are implemented on the data so given in the excel
spreadsheet. The mean of the misconduct rate has been reached to 102.80% which normally
show that the crime is more during the present annual year and same mean for the 10 years.

Crime value has been measured which reached to be 102.07% which express that the crime value
will be managed till the duration of 10 years. It mainly Show that crime value has been
sustained. The crime level has been exaggerated by such kind of factors in the nation or field
wise knowledge, the expenses that has been occurred, the magnitude of the state etc. The
expressive statistics create the imagination of the data smaller and easier so that the results can
be arbitrated consequently over the duration of 10 years. The minority factor also distresses the
crime value proportion has been reaching by dividing the crime value with the proportion of the
population (Diderichsen, A., 2019).
Conception of Data:
Below the data imagination the demonstration of data has been prepared in graphical
procedure by path of various charts, maps and graphs etc. These tools given the reachable path in
order to form and know the developments, outlier and arrangement in data fixed or the details
that has been provided. In the creation of large data, the data imagining instrument play the
crucial character in order to find the huge value of detail so that data focused judgements can be
prepared at the earlier step. In a provided data fixed the data has been conceptualized with the
assist of excel purpose which are implemented on provided data which is pivot table and focus.
Pivot table assist the company in creating the data or details easier for the business (Ghosh, P.,
2018).
Indication of the data with the assist of excel purpose:
Affirmation has been conceded out with the assist of V look up purpose
(Concealed in Excel spreadsheet)
Graphical Exhibition of the data consuming suitable charts:
The graphical exhibition Express the relative finding of the data that has been put into the
excel spreadsheet which transmits crime value during the particular year and the data over the
duration of 10 years has been related consequently. The comparison of both the statistics has
been provide in the resulting diagrams that express that both are getting more at the equal value
over the duration of years (Virgo, J., 2021). The remaining chart that has been provided which
express that effect of crime value depends on the knowledge that has been prepared in the nation
as the proportion of education plays a crucial role in the value of crime of the nation. As if the
knowledgeable system is not setup appropriately then the level of crime goes higher

consequently and if the proportion of educated persons are less than the fluctuations of such
value will convert lesser into the nation (Singh, S. and Singh, J., 2022).

CONCLUSION
As it is concluded from the above report that the data fixing related to the crime level
over the duration of 10 Years period. It concludes that fixed data has been find in utilizing the
expressive statistics, kinds of pre instrument that has been utilized in excel spreadsheet also
being applied it involved that v look up, count if purpose etc. that assist the company in
preparing the data in the efficient manner and also create easiness for the company proprietor to
utilize only that detail which are appropriate and helpful for them. In the above case expressive
statistics has been approved out in the excel spreadsheet which express full understand the
performance of the crime value. On such kind of data, it fixed kind of purpose in the excel has
been implemented consequently so that significance of that purpose for the company can be
described therein.

REFERENCES
Books and Journals
Alhamadi, M.S., 2020. Impact of Strategic Intelligence on the sustainable competitive advantage
of Industries Qatar. Global Journal of Management and Business Research.
Dar, P., 2021. What’s the best Business Intelligence and Analytics tool in the market.
Diderichsen, A., 2019. Spreading intelligence. Intelligence and National Security. 34(3). pp.409-
420.
Ghosh, P., 2018. Business Intelligence and Analytics Trends in 2018. Retrieved February. 21.
p.2018.
Singh, S. and Singh, J., 2022. A Survey on Master Data Management Techniques for Business
Perspective. In Cyber Intelligence and Information Retrieval (pp. 609-617). Springer,
Singapore.
Virgo, J., 2021. Power BI vs QlikView–Business Intelligence Tool Comparison.

PART 2
INTRODUCTION
The given report file involves finding of data for which it supports to a resident organization
will be given through enquiry of the inspection that will contain data on 200 extraordinary school
students (Bolton and et.al., 2018). For the specified report restored terms of estimation are being
setup by accepting variables of inclinations of ice cream, puzzle game totals and video game
scores.
Main Body
Data enquiry
Ice cream flavour
Frequency Percent Valid Percent Cumulative
Percent
Valid
Vanilla 95 47.5 47.5 47.5
Chocolate 47 23.5 23.5 71.0
Strawberry 58 29.0 29.0 100.0
Total 200 100.0 100.0

From commencing the exploration of tabular exhibition of data, it can be able to understood
that avail of the total pool score of students i.e., 200 many of them choose the vanilla taste of ice-
cream ( Oraee, Sanatjoo and Ahanchian, 2020).The occurrence of students who chosen vanilla
taste totalled 47.5% which approximately 95 students out of the overall number of students. The
another preferred taste of the ice cream was conveyed as strawberry it was described below the
occurrence of 58 students.
Gender (Male or Female)
Frequency Percent Valid Percent Cumulative
Percent
Valid Male 91 45.5 45.5 45.5
Female 109 54.5 54.5 100.0

Total 200 100.0 100.0
After the understanding of upward bar chart, it can be discussing about that availability of
the overall sum of students nominated for the investigation which is totally to 200. On the other
hand, the section dimension assortment, in this there was an average total of male and female
students ( Ruth, 2019). It imitating the given figures, it can also discuss that in it the males were
91 and females were 109.
Statistics
Ice cream Flavor
N Valid 200
Missing 0
Mean 1.82

Median 2.00
After the estimation of the upward statistical tabular presentation, it could be examined
that the mean rate was attained at 1.82 which leads the average total of the variables below the
scrutiny. The data lead the conversation that’s many of the students chooses strawberry taste not
the chocolate. The above enquiry of the median it indicates the mid-value of the data. It can be
say that not various kind of middle value occurs among equally the combined variables ( Sallam
and et.al., 2019).
Outcomes and consequences
From the above outcomes of the data usually accessible, it can be believed that the many
of the students chosen the vanilla taste of ice cream. Over the estimation of the understanding
attained, it can truly believe that it was an overall of 200 students were designated for the trial
dimension. It can be said that it was nearly a same percentage of males and females in the trial
figure. It involves males 91 and females 109. Besides this, it can discover that many of the
aspirants who were the students chosen to the vanilla taste ice cream. The collection study said
about the empirical study that prominence determining the constructs into the data. The given
study is also known as the separation exploration (Sikos and Choo, eds., 2020).
Argument
By compelling appropriate detail into reflection numerous thoughts with respect to
mutual data removal and text removal techniques that can be utilize in the company. These
techniques are comprehensive of detail abstraction, gathering, briefing and much more. Various
techniques support the abstraction of good detail for the assessment and identifying productive
paths below which relevant details and data can be removed. From the given circumstance in
which 200 pool of aspirants for the inspection was being nominated who were the students of the
school. This accepted the considerations in concern to sub-dividing the variables and giving
comparative detail which is necessary by the company superiors.
Here are some various kinds of merits as well as demerits of using SPSS and excel
spreadsheet that leads appropriate practical illustrations and current negotiations in the table.
This permits superiors of the organization to transmit active exploration in the enterprise market

and identify efficiently formulate on the basis of it performance can be attained ( Wright and
Schultz, 2018).
Merits and Demerits of using SPSS
Merits Demerits
The fluctuations in inputs ability can be
attained by using SPSS.
SPSS instrument is not able to execute all
feasible statistical process.
The record of data and formulating abilities are
different benefit for the use of SPSS.
The depository defaults for the SPSS document
is software-aim therefore it’s not able to
approach those who doesn’t have the
spreadsheet software.
Merits and Demerits of Excel
Merits Demerits
The formulation of formulas and purpose is
existence structured done use of Excel.
Absence of control and safety stops at the
primary disadvantage for using Excel.
The simple testing of data and material kept by
using excel is existence permitted by using
excel.
The spreadsheet software of excel is helpless
against fraud or dishonesty which is concealed
below another demerit for using excel.
Conclusion
As it is concluded from the above report that it Analyse there was individual importance
in selecting the taste of ice cream by students of the school who take participate in the inspection
was actually analyse. This also involves in finding the appropriate data with esteem to
understanding the results.

References
Books and Journals
Bolton, C and et.,al., 2018. The power of human–machine collaboration: Artificial intelligence,
business automation, and the smart economy. Economics, Management, and
Financial Markets. 13(4). pp.51-56.
Oraee, N., Sanatjoo, A. and Ahanchian, M.R., 2020. The competitive intelligence diamond
model with the approach to standing on the shoulders of giants. Library &
Information Science Research. 42(2). p.101004.
Ruth, J.P., 2019. Examples of AI in business intelligence applications.
Sallam, R and et.al., 2019. Magic quadrant for analytics and business intelligence platforms.
Sikos, L.F. and Choo, K.K.R. eds., 2020. Data science in cybersecurity and cyberthreat
intelligence (p. 118). Cham: Springer.
Wright, S.A. and Schultz, A.E., 2018. The rising tide of artificial intelligence and business
automation: Developing an ethical framework. Business Horizons. 61(6). pp.823-832.

Appendix
Agglomeration Schedule
Stage Cluster Combined Coefficients Stage Cluster First Appears Next Stage
Cluster 1 Cluster 2 Cluster 1 Cluster 2
1 198 199 .000 0 0 2
2 2 198 .000 0 1 4
3 196 197 .000 0 0 4
4 2 196 .000 2 3 6
5 193 195 .000 0 0 6
6 2 193 .000 4 5 8
7 187 188 .000 0 0 8
8 2 187 .000 6 7 10
9 182 184 .000 0 0 10
10 2 182 .000 8 9 12
11 178 181 .000 0 0 12
12 2 178 .000 10 11 14
13 172 177 .000 0 0 14
14 2 172 .000 12 13 16
15 167 169 .000 0 0 16
16 2 167 .000 14 15 18
17 162 165 .000 0 0 18
18 2 162 .000 16 17 20
19 158 159 .000 0 0 20
20 2 158 .000 18 19 22

21 156 157 .000 0 0 22
22 2 156 .000 20 21 24
23 154 155 .000 0 0 24
24 2 154 .000 22 23 26
25 148 153 .000 0 0 26
26 2 148 .000 24 25 28
27 145 147 .000 0 0 28
28 2 145 .000 26 27 30
29 143 144 .000 0 0 30
30 2 143 .000 28 29 32
31 139 140 .000 0 0 32
32 2 139 .000 30 31 34
33 137 138 .000 0 0 34
34 2 137 .000 32 33 36
35 133 134 .000 0 0 36
36 2 133 .000 34 35 38
37 128 131 .000 0 0 38
38 2 128 .000 36 37 40
39 124 127 .000 0 0 40
40 2 124 .000 38 39 42
41 122 123 .000 0 0 42
42 2 122 .000 40 41 44
43 111 116 .000 0 0 44
44 2 111 .000 42 43 46
45 105 106 .000 0 0 46
46 2 105 .000 44 45 47
47 2 97 .000 46 0 94
48 89 91 .000 0 0 49
49 5 89 .000 0 48 51
50 83 85 .000 0 0 51
51 5 83 .000 49 50 53
52 75 79 .000 0 0 53
53 5 75 .000 51 52 55
54 73 74 .000 0 0 55
55 5 73 .000 53 54 57
56 70 71 .000 0 0 57
57 5 70 .000 55 56 59
58 66 67 .000 0 0 59
59 5 66 .000 57 58 61
60 61 64 .000 0 0 61

61 5 61 .000 59 60 63
62 59 60 .000 0 0 63
63 5 59 .000 61 62 65
64 55 58 .000 0 0 65
65 5 55 .000 63 64 67
66 53 54 .000 0 0 67
67 5 53 .000 65 66 69
68 50 51 .000 0 0 69
69 5 50 .000 67 68 71
70 48 49 .000 0 0 71
71 5 48 .000 69 70 73
72 42 43 .000 0 0 73
73 5 42 .000 71 72 75
74 40 41 .000 0 0 75
75 5 40 .000 73 74 77
76 34 37 .000 0 0 77
77 5 34 .000 75 76 79
78 28 31 .000 0 0 79
79 5 28 .000 77 78 81
80 25 26 .000 0 0 81
81 5 25 .000 79 80 83
82 22 23 .000 0 0 83
83 5 22 .000 81 82 85
84 20 21 .000 0 0 85
85 5 20 .000 83 84 87
86 12 18 .000 0 0 87
87 5 12 .000 85 86 89
88 10 11 .000 0 0 89
89 5 10 .000 87 88 91
90 8 9 .000 0 0 91
91 5 8 .000 89 90 93
92 6 7 .000 0 0 93
93 5 6 .000 91 92 94
94 2 5 1.000 47 93 0