Proficiency in Microsoft Excel: A Case Study on McDonald's Performance

MS EXCEL TASK

Contents
INTRODUCTION...........................................................................................................................3
MAIN BODY..................................................................................................................................3
1. Research Topic is McDonalds:................................................................................................3
2. Collection of Raw Data:..........................................................................................................3
3. Implementation of Statistical Techniques on the Raw Data:...................................................4
4. Data Manipulation Techniques on Raw Data: -......................................................................4
5. Graphical Representation of the Raw Data:............................................................................5
6. Interpretation and Findings on the results so obtained suing such data:.................................6
CONCLUSION................................................................................................................................8
REFERENCES................................................................................................................................9

INTRODUCTION
Microsoft excel is the software’s which is part of the MS office developed by the Microsoft
which is used to conduct multiple calculation relating to data set imported or entered on it. Not
only MS Office it consists of Microsoft word and power point too which is most frequently used
in today’s world to perform various office work. The application software of Microsoft office
consists of various applications such as Microsoft windows, excel and access. The Microsoft
Excel is helpful for an organisation to carry out large and complex calculation which is not
possible to conduct manually or by any other software. Theis’s report shows the proficiency in
the excel which the help of case study chosen that is McDonald which is a most popular
American food giant having branches around the world and famous for its Burger. The data
relating to McDonald has been taken in this report to perform excel calculation and at the end the
end some suggestion and interpretation has been carrying out using graphs and charts. The data
is related to performance of the American group from 2015 to 2021 in terms of sales figures so
that their market capitalisation can be judged. On the basis of such data statistical techniques has
been performed such as calculation of mean, median, mode etc.
MAIN BODY
1. Research Topic is McDonalds:
The case study amongst topic which is considered in McDonalds and their performance has been
evaluated on the basis of technology and changing world along with competition. The data used
to carry out the calculation is market cap, revenue and number of employees they hold during the
period starting from 2015 to 2021 and such data is collective throughout the branches they run
their outlets.
2. Collection of Raw Data:
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