Utilization of Microsoft Excel for Statistical Analysis of McDonald's Market Capitalization, Revenue, and Employee Data

This report discusses the use of Microsoft Excel for statistical analysis of McDonald's market capitalization, revenue, and employee data. It covers the functions of Excel, such as sum, count, maximum, and minimum, and how to represent data using charts. The report also explores the topic of improving business performance through the utilization of technology.

Assessment A1 And A2

Table of Contents
INTRODUCTION...........................................................................................................................1
MAIN BODY...................................................................................................................................1
1.Discussing the research topic of McDonald's..........................................................................1
2.Collecting the raw data of market capitalisation, revenue and number of employees. ...........1
3.Computation of statistical techniques using excel function.....................................................2
4.Representing the appropriate charts for the statistical techniques. ........................................3
. ...................................................................................................................................................4
5. Interpretation of various functions of excel and its analysis. ................................................4
CONCLUSION................................................................................................................................6
REFERENCES ...............................................................................................................................7

INTRODUCTION
Microsoft office is a package of various tools such as Microsoft windows, excel, access
and power point. There are various tasks which can be performed such as create, edit text and
images. The presentation of data can also be done in posters and charts. This report includes the
introduction of McDonald's and data related to its market capitalisation, revenue and number of
employees is also discussed. There are various functions of Microsoft excel such as minimum,
maximum, sum and count(Liang and et.al., 2018). These functions perform different task and
assists in finding the total of all the data. There are several tools of descriptive statistics such as
mean, median and mode. It is also calculated by using Microsoft excel.
MAIN BODY
1.Discussing the research topic of McDonald's.
The case study of McDonald's, it is an American multinational fast food corporation. It
has been started in the year 1940. It is founded by Richard and Maurice. It is popularly known
for its hamburgers, cheeseburgers and French fries. It also has a good brand valuation. It also has
various subsidiaries such as Mc drive, Mc cafe, and create your taste restaurants. The topic
discussed in the report is improvement of business performance through the utilisation of
technology(Gorbatikov and et.al.,2019). The data collected is about market capitalisation,
revenue and number of employees in the organisation. It is collected of all the branches since
2015 to 2021.
2.Collecting the raw data of market capitalisation, revenue and number of employees.
The data is the collection of raw facts and figures which are integrated to
 Market capitalisation : It is the sum total of all the shares of company's stock. It helps the
investors to know about the financial health of the enterprise. It can be calculated by
current market price per share and multiplied by the total outstanding shares.
 Revenue : It is the addition of income generated by the sale of goods and services. It is
related with the operations which are of primary nature(White and Yang, 2020)
 Number of employees : In every organisation, there are various employees which helps in
the production of goods and rendering various services.
1

McDonalds
Year Market capitalization (in billion $) Revenue Number of employees
2021 200.31 22.87 195000
2020 159.88 18.86 200000
2019 147.47 21.07 205000
2018 136.21 21.02 210000
2017 137.21 22.82 235000
2016 101.08 24.62 375000
2015 107.12 25.41 420000
3.Computation of statistical techniques using excel function.
McDonalds
Year Market Capitalization (in billion $) Revenue
Number of
employees
2021 200.31 22.87 195000
2020 159.88 18.86 200000
2019 147.47 21.07 205000
2018 136.21 21.02 210000
2017 137.21 22.82 235000
2016 101.08 24.62 375000
2015 107.12 25.41 420000
Mean 141.3257143 22.3814 262857.1429
Median 137.21 22.82 210000
2

4.Representing the appropriate charts for the statistical techniques.
3

.
5. Interpretation of various functions of excel and its analysis.
The Microsoft excel is a spreadsheet tool which is developed by Microsoft for windows,
macos, android and ios. It has various other functions such as graphing tools, pivot tables and
macro programming language which is known as visual basic for applications(VBA). There are
various applications of ms-excel such as :
 Data entry and storage : The excel is a superior software which helps in storing the
large volume of data.
 Data analysing and interpretation: The process of data analysing is done with the help
of excel which helps in taking various decisions(Warren and et.al., 2020). . There are
4

several formula and pivot table which helps in communicate the results to various
stakeholders.
 Forecasting : There is also a function in excel which helps in forecasting the data. The
feature of goal seek analysis helps in identification of targets and set standards
accordingly.
The functions performed using excel can be described as given below:
 SUM : The function of SUM helps in adding the total values of the data. This function
can be performed by prefixing the sign of = and selecting the rows for which the sum is
required. The sum of the market capitalisation rate is 989.28 and revenue sum is 156.67.
The total of number of employees is 1840000 in the McDonald.
 COUNT : The function of COUNT helps in calculating the total observations and it is
important function of excel(Bisello, Antoniucci and Marella, 2020). The total number of
observations in case of market capitalisation rate, revenue and number of employees is
seven. The formula for the count can be applied by =count ( number of cells for which
the count is required to know).
 MAXIMUM : The function of maximum is used to find the highest value from the total
observations. The maximum value of capitalisation rate is 200.31 and revenue highest
value is 25.41. The maximum number in case of employees is 420000. It can be
interpreted by =max().
 MINIMUM : The excel function of minimum helps in returning the smallest value from
the total data set. The function of minimum is applied as =MIN(). The minimum value
for market capitalisation rate is 101.08 and revenue lowest value is 18.86. In case of total
number of employees, the minimum value is 195000.
 Mean : It is a part of descriptive statistics which is a measure of central tendency. The
mean is the average of all values given in the data set. It can be computed by adding all
the numbers and divide by the number of observations. It is the most powerful tool of
descriptive statistics which is helpful in arithmetic calculations. The mean is affected by
the extreme value and it is possible that the computed average value may not be present
in the series. The mean for the market capitalisation rate is 141.3257143 and mean for
revenue is 22.3814. The average value of number of employees is 262857.1429. The data
is collected is for seven years.
5

 Median : The median is the mid value for the given data set. It can be calculated
differently in case of even and odd observations(Wang and Xing, 2020). In case of even
observations, it is calculated by using n+1/2 formula and in case of odd observations n/2
formula is applied.
The median for the market capitalisation rate is 137.21 and mid value of revenue is 22.82. the
central value of the number of employees is 210000.
 Improvement in business through utilisation of technology
There are various technology introduced in the modern times which helps in improving the
business performance. The technology is helpful in improving the level of productivity and
satisfaction level of customers can also be increased. There are various competitors in the
market, the technology helps to identify the needs of the customers. When the customers are
satisfied, it will improve the level of profitability in the enterprise(Li and Wu, 2022). The
retention of employees can also be enhanced when technology is used in the business. There are
various issues related to setting adequate inventory level. There can be issue related to stock out
and stock piling. The issue related to stock out will decline the goodwill of the enterprise. On the
other hand, stock piling will increase the carrying cost of the enterprise. There is a tool named
scheduled inventory scanning. It is a flexible tool which helps to meet the real time needs of the
organisation. The IT inventory management helps in preparing out of the box reports. It helps in
reducing the wastage of assets(Ahmed and Huo, 2019).
CONCLUSION
From the above report, it can be concluded that Ms-excel is a tool of Microsoft office
which eases the work of various departments, agencies and institutions by reducing the complex
calculations. There are numerous functions of Ms-excel such as sum, count, maximum and
minimum. The data regarding market capitalisation, revenue and number of employees of
McDonald's helps to take various decisions by the organisations. These decisions impact the
level of profitability and revenue of the organisation. The descriptive statistical techniques such
as mean, median and mode helps in knowing the average, mid and most occurred value in the
data. Therefore, excel is a tools which reduces the time and efforts of the employees.
6

REFERENCES
Books and Journals
Liang, J., and et.al., 2018, November. Correlation-based dynamics and systemic risk measures in
the cryptocurrency market. In 2018 IEEE International Conference on Intelligence and
Security Informatics (ISI) (pp. 43-48). IEEE.
Gorbatikov, E., and et.al.,2019. Is firm-level political exposure priced?.
White, L.J. and Yang, J., 2020. What Has Been Happening To Aggregate Concentration In The
US Economy In The Twenty‐First Century?. Contemporary Economic Policy, 38(3),
pp.483-495.
Warren, A.M., and et.al., 2020. Taxonomy of Seniors’ needs for food and food assistance in the
United States. Qualitative health research, 30(7), pp.988-1003.
Bisello, A., Antoniucci, V. and Marella, G., 2020. Measuring the price premium of energy
efficiency: A two-step analysis in the Italian housing market. Energy and
Buildings, 208, p.109670.
Wang, V.X. and Xing, B.B., 2020. Battling uncertainty: Corporate disclosures of COVID-19 in
earnings conference calls and annual reports. Available at SSRN 3586085.
Li, X. and Wu, P., 2022. Stock price prediction incorporating market style clustering. Cognitive
Computation, 14(1), pp.149-166.
Ahmed, A.D. and Huo, R., 2019. Impacts of China's crash on Asia-Pacific financial integration:
Volatility interdependence, information transmission and market co-
movement. Economic Modelling.79. pp.28-46.
7