Google Data Analysis with Excel: Applying Statistical Techniques

This assignment focuses on analyzing Google's data, including market capitalization, revenue, and user numbers, using Microsoft Excel. It covers data collection methods, both primary and secondary, and then applies statistical techniques such as calculating mean, median, sum, minimum, maxi...Read More

DHICT MODULE

Table of Contents
INTRODUCTION ..........................................................................................................................3
Main Body.......................................................................................................................................3
1. Select one of the research topic from the list provided...........................................................3
2. Collect data of Google and sample ........................................................................................4
3. By using Excel manipulate data with the help statistical techniques......................................4
4. Briefly explain and analyse the data collected........................................................................5
CONCLUSION ...............................................................................................................................6
REFERENCES................................................................................................................................7

INTRODUCTION
Microsoft office is a part of a system software which includes Microsoft power point,
Microsoft access, Microsoft excel and word. Microsoft word has a wide variety of coverage of
overall system in the globe. It performs varies functions such as editing, formatting and
modification. Power point presentation is used to create informative slides which a helps in
understand the objective of the report in brief. Excel is used as a data which can be used for
storing large amount of data which can be modified and used as the needs of research. The data
collected is related to revenue, number of users and market capitalisation. It also includes
descriptive statistics data such as median, mean and mode (Basco, Calabrò and Campopiano,
2019).
Main Body
1. Select one of the research topic from the list provided.
In the following case company selected is Google. The research is about the finding on
various aspects such as market capitalisation of google, users of google and revenue earned by
the company.
It also includes the performance of the company and google as well as the market share
captured by the organisation. There are various roles which are to be performed by the firm such
as organisation needs to have data which can help its users in findings their queries on one click.
For effective management of these resources firm needs to work on its managerial activities in
allocating proper workforce to comply the needs of the administration (Boer, Hanke and He,
2018).
Data about revenue, number of employees and capitalisation is collected from various sources
which can be used in collecting the raw data.
1. Primary data: it is collected from the direct source of information from where the
information can be derived, it is collected according to the research topic. The data
collected in this technique is all the relevant data according to the research topic.
Advantages of primary data are as below:
 Updated information: The data is collected directly from the respondents and is new to
the research.

 Authenticity: Chances of error reduces as the data is directly collected from the origin of
the information (Gupta, 2018).
Disadvantages of primary data is:
2. Secondary data: This type of data is collected from the sources which have
already collected data from various sources according to the previous collected
data. This data is readily available to be utilised for the purpose of research
(Nechushtai, 2018). This information is available in magazines, journals,
newspapers and websites.
There are various advantages of secondary form of data:
 Inexpensive: The data is collected from various sources which is already
available. That is available for free of cost or at a very lower cost.
 Easy access: This type of data is easily available to the client according to
the need of the researcher.
 Time saving: as the data is not directly collected from the respondents the
information is collected and when and where required in readily form
(Stahl and et.al., 2020).
Disadvantages of secondary data:
 Data Quality: The data available is in readily form thus it may contain
some of the data which is not relevant for the research.
2. Collect data of Google and sample
Google
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

3. By using Excel manipulate data with the help statistical techniques.

4. Briefly explain and analyse the data collected.
 Mean: it is the value which is derived after dividing the sum of all the observation to the
total number of observations. In the following case mean is calculated of 7 years starting
from 2015 to 2021. Market capitalisation has remained at 745 on an average, revenue
earned by the organisation remained at 144.371 and number of users of google is
3887.859. It states that the average number of the all of the data linked has increased
which helped in increasing the wealth of the shareholders and also of the company
(Thomas, Crosby and Vanderhaar, 2019).
 Median: it is the middle value of the data available which can be derived after applying
the formula. It helps in ascertaining the middle value of the series. Median of market
capitalisation is 720 which lies in the year 2018, revenue is 136.36 and number of median
users is 3956.47 million which means that median number of active user in google.
 Revenue: This value is generated by using different operational activities and
computation of averages. It is derived from income statement. It is used as tool of
measuring the effectiveness and efficiency (Walter and et.al., 2019).
Interpretation
From the above it can be seen that the market capitalisation of the company has icnreased
over the years. In 2015 it was $375 billion which have increased to 1425 in the year 2021. It has
increase by more than 3.8 times in last 7 years. The growth of the organisation has been doubled

from the last year. Revenue of the organisation have also increased to 256.74 in year 2021 which
was 74.54 in the year 2015.
It can be seen that the organisation revenue has increased by more than 3 times in the last
7 years. The organisation revenues have increased by $182.2 billion in previous 7 years.
Organisation has seen a tremendous growth in last 7 years in number of users of the company. In
2015 number of users of google were 2759.40 which has increased by 1979 in the last 7 years.
 Sum: This function is used when the data is available in the excel sheet, the total of the
data is required then the sum function is used to compute the total of the data available.
Sum of all the above data set is 5215, 1010.6 and 27215.0133.
 Minimum: It is used to calculate the highest value available in the data set given. It helps
in determining the value which is highest in number in the data series. In the following
case the revenue, wealth and number of users were maximum in the organisation in the
year 2021.
 Minimum: it is helpful in determining the values which is lowest in the data set available.
The minimum capitalisation value is 375, the lowest revenue was computed at 74.54 and
the least number of users recorded was 2759.40.
 Count: It is useful in calculating the total number of observations which are available in
the data set. Total number of values recorded in all the observations is 7. in all the three
raw data available the value of revenue, capitalisation and number of users of the
organisation remains same as the data is available of the last 7 years.
CONCLUSION
From the above report it can be concluded that Ms excel is an software which is used by
various researcher in order to work out on the functions of excel and tasks completed. This helps
in completing the calculations relatively very less period of time. Google is taken as the research
topic for conducting this research. The data is presented in chart and tables for making decisions
related to business. Excel functions such as min, sum, count and maximum is calculated to know
the insights of the data.

REFERENCES
Books and Journals
Basco, R., Calabrò, A. and Campopiano, G., 2019. Transgenerational entrepreneurship around
the world: Implications for family business research and practice. Journal of Family
Business Strategy, 10(4), p.100249.
Boer, D., Hanke, K. and He, J., 2018. On detecting systematic measurement error in cross-
cultural research: A review and critical reflection on equivalence and invariance
tests. Journal of Cross-Cultural Psychology, 49(5), pp.713-734.
Gupta, H., 2018. Assessing organizations performance on the basis of GHRM practices using
BWM and Fuzzy TOPSIS. Journal of environmental management, 226, pp.201-216.
Nechushtai, E., 2018. Could digital platforms capture the media through
infrastructure?. Journalism, 19(8), pp.1043-1058.
Stahl, G.K. And et.al., 2020. Enhancing the role of human resource management in corporate
sustainability and social responsibility: A multi-stakeholder, multidimensional approach
to HRM. Human Resource Management Review, 30(3), p.100708.
Thomas, M.S., Crosby, S. and Vanderhaar, J., 2019. Trauma-informed practices in schools
across two decades: An interdisciplinary review of research. Review of Research in
Education, 43(1), pp.422-452.
Walter, S.L. And et.al., 2019. A tale of two sample sources: Do results from online panel data
and conventional data converge?. Journal of Business and Psychology, 34(4), pp.425-
452.