Using MS Excel for Data Analysis: A Case Study of Google

This report explores the use of MS Excel for data analysis with a case study of Google. It covers statistical tools and techniques, data manipulation, and presentation of data with charts and graphs. The report also provides interpretation of the data and its implications for business performance. The report is useful for anyone interested in learning how to use MS Excel for data analysis.

A1 MS EXCEL TASK

Contents
INTRODUCTION...........................................................................................................................2
MAIN BODY...................................................................................................................................2
Select any research-based topic..............................................................................................2
Sort the data about the related case study...............................................................................2
Statistical tool and techniques................................................................................................3
Data manipulation..................................................................................................................3
Presentation of data with the help of charts and graphs.........................................................4
Interpretation of Data.............................................................................................................5
CONCLUSION................................................................................................................................6
REFERENCES................................................................................................................................8

INTRODUCTION
The report prepared as under takes in account the roles, duties and functions which are
performed in Microsoft office and whether they are able to serve their purposes well (Liebowitz,
2019). It makes more sense of various focuses being taken under for instance, Microsoft power
point gives support in motivation towards introductions, MS word helps in providing related
assistance and building useful reports, MS excel is helpful in achieving better results even in
complex circumstances. It is adapted for loading data at a bigger level and scale and is also
helpful in solving few issues of the company. Such prepared and developed reports counts
magnificent data in Setting up of Google, it further works in web related administrations and
items as well. It also features online mechanisms for developing notices, web search techniques
and distributed calculated programming as well. Meaningful views such as market capitalisation,
income and number of users are remembered for the report being served.
MAIN BODY
Select any research-based topic.
In the research below the case study being selected is that of Google. The report is further
tied in with keeping a track record and looking for multiple methods for sorting information and
data. It covers in as an aide for income generated by the enterprise, clients which are linked with
the business and registration of market capitalisation as well.
The examination content for the search is Google. It will explain whether the method chosen
would be fruitful in development of business-related execution and results as well. There is a
different task being performed by trend setting innovation in businesses such for instance
matching the degree of stock level (Panescu and Manta, 2018). There must be situations which
would prompt assembling up of stocks and lack in accessibility of stocks. The state of stock out
will control the brand image being developed and heaped stock would be prompted ascending of
conveying expenses. For dominant supervision of assets there are some programming estimated
for instance stock administration which would be aiding description of assets in a accurate
manner.
Sort the data about the related case study.

Year Market Capitalization (in billion $) Revenue Number of users
2015 375 74.54 2759.3998
2016 530 89.98 3363.7296
2017 580 110.55 3855.9368
2018 720 136.36 3956.7462
2019 840 160.74 4070.0538
2020 745 181.69 4471.0083
2021 1425 256.74 4738.1388
Statistical tool and techniques.
Year Market Capitalization (in billion $) Revenue Number of users
2015 375 74.54 2759.3998
2016 530 89.98 3363.7296
2017 580 110.55 3855.9368
2018 720 136.36 3956.7462
2019 840 160.74 4070.0538
2020 745 181.69 4471.0083
2021 1425 256.74 4738.1388
Mean 745 144.37143 3887.859043
Median 720 136.36 3956.7462
Data manipulation.
Year Market Capitalization (in billion $) Revenue Number of users
2015 375 74.54 2759.3998
2016 530 89.98 3363.7296
2017 580 110.55 3855.9368
2018 720 136.36 3956.7462
2019 840 160.74 4070.0538
2020 745 181.69 4471.0083
2021 1425 256.74 4738.1388
Sum 5215 1010.6 27215.0133
Count 7 7 7
Maximum 1425 256.74 4738.1388
Minimum 375 74.54 2759.3998
Google

Presentation of data with the help of charts and graphs.

Interpretation of Data.
 Maximum: Such orders are useful in searching most worthy sum or quantity from the
easily accessible data collected or recorded assumptions. The greater figure represents
income segment and a value of 256.74 sum. The most prominent unequivocal quantity of
users appears at a level of 4738.1388. It further tends to be assessed by implementation of
recipe =max ().
 Minimum: The device for instance, MINIMUM would be more appreciated in impression
of least digit believable by a progression of data up till the point is being taken in account
by the enterprise. The capability performed by accomplishment of recipe which is =MIN
(). The base counts figure saw in the occurrence of Market capitalisation is recorded as
375 and in regions of income it has addressed a worth of 74.54. It also mirrored a
equilibrium of 2759.3998 in the event of clients being linked with the business.
 Count: The COUNT would work to provide assistance with registering undoubtedly the
no of perceptions and it has surveyed as a substantial apparatus in succession. The
number of attentive in setting number of users, market capitalisation and income are
being denoted as seven. The recipe is being put in use and utilised in such regions is
=count (portion of cells for which the count is demanded)
Mean: It is denoted as an instrument which is useful in computation of amount which is
being laid down by the company for a period of time. It tended to be found by isolation in
summing up of perception by all out no of perceptive. Subsequently in above jot down
case mean depicted about as 745 in segment of Market capitalisation of Google company.
It thus considered 144.371 in income related areas and in the event of numbers of users
linked with the undertaking it reflected a amount as 3887.859. Thus, one might state that
there are various vaccination seen in the event of consumers, income level. The data laid
is presented in year 2015-2021 accordingly it would be useful for assembling of data at
one single spot and deciphering the information through less complicated and
straightforward processes (Parker, 2018).
 Median: It can be characterised as sorting out Mid-point or mid-level digit by
arrangement of data worked with from lesser to higher amount. It provides useful
assistance with learning designs which are being followed and centred the worth at the
hour of data assortment which has mutilated quantity, Middle resulted to be about 720 for

a period length of 7 long years in case of Market capitalisation and in part of counting of
users it depicted as 3956.7462. It hence mirrored an equilibrium of 136.36 in income
related regions.
 Revenue: It can be explained in simpler and easy to understand ways which denotes the
advantage and benefit which is being procured by a company throughout as timeframe by
carrying out certain activities-based movements and determining normal expenditures
related to sales. It can likewise be denoted as Sales on pay proclamation or reports. It
hence, would be acting as a tool or technique which would be examining the working and
working of enterprises which would be promoting and would be dealing though reserve
related stream is measured as a sign of solvency kept up till this point (Rezaei, Jafari-
Sadeghi and Bresciani, 2020).
 Sum: The SUM work would be expected for development and development of complete
digits which are accessible in a framed series. Such sort of capabilities can be presented
with the guidance of sign, for instance “=”and selecting the column on which order must
be implemented. The summing of income would reflect as 1010.6, market capitalisation
rate is 5215 and keeping in head which if there must be arising an incident of number of
clients drew in it reflection an equilibrium of 27215.0133 in Google enterprise.
CONCLUSION
From the above prepared report, it manages to be completed up and deciphered too which
Ms would succeed gives useful assistance to performing various accomplishments doled out in a
company. It helps in readiness of survey related reports, management of data, minimizing
responsibility of analysts and limitation in assignments carried out which count confounded
chores. The complex calculations can be done in minimum time span. It takes in account tables,
graphs which gives guidance in figuring out what has been increase and decline in number of
consumers drew in and fixed with the business. It takes data for more than 7 years and
implement summation of data, its middle and normalised also. It further would be helpful in
picking best options from best accessible opportunities which would help in further development
of monetary based execution of the enterprise. The report likewise would be reflecting
presentation of tables and graphs which give a clearer picture and image which would be
valuable for consumers which need to appropriately design their activities and assets. It

additionally would be assisting with performing various order which would be helping in
arrangement of data and information in an simpler way for longer time period of business. Hence
it is necessary for companies to zero in on such methods and devices.

REFERENCES
Books and Journals
Liebowitz, J., 2019. Building organizational intelligence: A knowledge management primer.
CRC press.
Panescu, A.T. and Manta, V., 2018. Smart contracts for research data rights management over
the ethereum blockchain network. Science & Technology Libraries, 37(3), pp.235-245.
Parker, M., 2018. Shut down the business school: What's wrong with management education.
Rezaei, M., Jafari-Sadeghi, V. and Bresciani, S., 2020. What drives the process of knowledge
management in a cross-cultural setting: The impact of social capital. European Business
Review.
Schermerhorn Jr, J.R., Bachrach, D.G. and Wright, B., 2020. Management. John Wiley & Sons.
Supuran, C.T., Altamimi, A.S.A. and Carta, F., 2019. Carbonic anhydrase inhibition and the
management of glaucoma: a literature and patent review 2013-2019. Expert Opinion on
Therapeutic Patents, 29(10), pp.781-792.
Tian, H., He, J. and Ding, Y., 2019. Medical data management on blockchain with
privacy. Journal of medical systems, 43(2), pp.1-6.
Valinejad, F. and Rahmani, D., 2018. Sustainability risk management in the supply chain of
telecommunication companies: A case study. Journal of Cleaner Production, 203, pp.53-
67.