Using MS Excel to Analyze Revenue and Market Capitalization of McDonald's

MS Excel task

INTRODUCTION
The application software of Microsoft office consists of various applications such as
Microsoft windows, excel and access. The Microsoft excel is used to perform the various
calculations which are complex(Akcam,2020.)
. This report consists the introduction of McDonald, which is an American multinational
corporation. It also includes the computation of revenue and market capitalization of McDonald
which can be analysed by using the functions of Excel such as sum, count, minimum and
maximum. There are various tools of descriptive statistics such as mean, mode and median are
also estimated by using MS-Excel.
MAIN BODY
1. Research topic for the case study of McDonalds.
The case study that has been chosen is McDonalds. The topic is of analysing the improvement in
the business performance through the utilisation of technology. The data has been collected of
the market capitalisation, revenue and the number of employees existing in the organisation all
over its branches over the years since 2015 to 2021.
2. Collect the raw data of the chosen topic.
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. By using the statistical techniques compute some of the excel functions.
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
4. Produce the relevant charts for the above statistical techniques.