Excel Competency Test on McDonald's Data: Statistical Techniques, Data Manipulation, and Graphical Representation

3- MS Excel task

Contents
INTRODUCTION...........................................................................................................................3
MAIN BODY..................................................................................................................................3
McDonald's is the subject of the research....................................................................................3
Collection of Raw Data...............................................................................................................3
Implementation of Statistical Techniques on the Raw Data........................................................4
Data Manipulation Techniques on Raw Data..............................................................................4
Graphical Representation of the Raw Data.................................................................................4
Interpretation and Findings on the results...................................................................................6
CONCLUSION................................................................................................................................7
REFERENCES................................................................................................................................9

INTRODUCTION
Microsoft Excel is a piece of Microsoft Office software that can be used to do many
calculations on data sets that have been imported or inputted into it. Not only does MS Office
include Microsoft Word and PowerPoint, which are the most commonly used office applications
in today's globe. Microsoft office application software includes a variety of programmes such as
Microsoft Windows, Excel, and Access (Mayes, 2020). Microsoft Excel allows a company to
perform huge and sophisticated calculations that would be impossible to do manually or with any
other programme. This paper demonstrates excel competence via the use of a case study on
McDonald's, a well-known American food behemoth with locations all over the world and a
reputation for its hamburger. McDonald's data was used in this report to run excel calculations,
and at the end of the study, various suggestions and interpretations were made utilising graphs
and charts. The information pertains to the American group's sales performance from 2015 to
2021 in order to determine its market capitalization. Statistical procedures such as mean, median,
and mode calculations have been done on the basis of such data.
MAIN BODY
McDonald's is the subject of the research.
The case study is one of the topics that McDonalds is considering, and their performance
has been analysed based on technology, the changing world, and competition. The market
capitalization, revenue, and number of workers held by the company between 2015 and 2021
were utilised in the computation, and the data was collected across all of their branches.
Collection of Raw Data
McDonalds
Year Market Capitalization (in billion $) Revenue Number of employees
202
1 200.31 22.87 195000
202
0 159.88 18.86 200000
201
9 147.47 21.07 205000
201
8 136.21 21.02 210000
201
7 137.21 22.82 235000
201 101.08 24.62 375000