Business Performance Analysis of McDonald's Using Excel Functions

This report presents an analysis of McDonald's business performance from 2015 to 2021 using Microsoft Excel. The study focuses on market capitalization, revenue, and employee data, employing various Excel functions such as SUM, COUNT, MIN, and MAX to perform statistical computations. Data manipulation techniques are applied to derive meaningful insights, and relevant charts are generated to visually represent the findings. The analysis includes calculating mean, median, and mode to understand central tendencies in the data. The report concludes that MS Excel is a valuable tool for performing complex estimations and analyzing financial data, aiding in informed decision-making. Desklib provides access to similar solved assignments and study resources for students.

MS Excel task

Contents
INTRODUCTION...........................................................................................................................3
MAIN BODY..................................................................................................................................3
1. Research topic for the case study of McDonalds.....................................................................3
2. Collect the raw data of the chosen topic..................................................................................3
3. By using the statistical techniques compute some of the excel functions...............................3
4. Perform data manipulation......................................................................................................4
5. Produce the relevant charts for the above statistical techniques..............................................5
5. Interpret and explain the finding and analysis.........................................................................6
CONCLUSION................................................................................................................................7
REFERENCES................................................................................................................................8

INTRODUCTION
The application programming of Microsoft office comprises of different applications like
Microsoft windows, dominate and get to. The Microsoft dominate is utilized to play out the
different estimations which are complicated (Benitez, Llorens and Braojos, 2018). This report
comprises the presentation of McDonald, which is an American worldwide organization. It
additionally incorporates the calculation of income and market capitalization of McDonald
which can be examined by utilizing the elements of Excel like aggregate, count, least and
greatest. There are different devices of engaging insights, for example, mean, mode and middle
are additionally assessed by utilizing MS-Excel.
MAIN BODY
1. Research topic for the case study of McDonalds.
The case study for the research that has been picked is McDonalds. The theme is of
dissecting the improvement in the business execution through the use of innovation. The
information has been gathered of the market capitalisation, income and the quantity of
representatives existing in the association all around its branches throughout the years starting
around 2015 to 2021 (Di Vaio and et.al., 2020).
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 (in billion 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.38142857 262857.1429
Media
n 137.21 22.82 210000
4. Perform data manipulation.
McDonalds
Year
Market Capitalization (in
billion $)
Revenue (in billion
$)
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
Sum 989.28 156.67 1840000
Count 7 7 7
Maximum 200.31 25.41 420000
Minimum 101.08 18.86 195000

5. Produce the relevant charts for the above statistical techniques.

5. Interpret and explain the finding and analysis.
Microsoft Excel is a spreadsheet programme that may be used to do a variety of
computations. Data entered, information management, bookkeeping, market accounting, charts
and graphs, computing, organizational skills, and plan appropriate are all made easier using MS-
excel. It also includes pivot tables as well as choices for displaying data in the form of diagrams,
graphs, and tables. There are a multitude of functions in MS-Excel that assist in doing various
arithmetic computations.
The Sum Function assists in calculating the cumulative of all of the other values obtained. It
is possible to use it by choosing the entire row. By entering the sign (=) and dragging the row
until the sum of values is necessary, the sum formula can be implemented. In the case of
McDonald's, the total market capitalization is $989.28. McDonald's has a total income of 156.67
million dollars and 184000 employees.
The count function in Excel is used to determine the number of occurrences in a data set.
This function can also be used simply dragging the rows till the desired number of observations
is reached. According to McDonald's data, the company's market capitalization, revenue, and
staff count total seven. It is the same in each of the three variables.
The Maximum function in MS excel is used to generate higher value out from complete
number of occurrences in the series. It's activated by typing the sign (=) followed by the
function's name. If the market valuation rate is 200.31, the maximum value is 200.31, and the

highest revenue is 25.41. The total number of personnel is limited at 420000. Graphs that show
the visual representation of the data collected can also be constructed.
The minimum function returns the value that is the smallest. McDonald's has a market
capitalisation of 101.08 dollars. The lowest revenue and employee numbers are 18.86 and
195000, respectively. = min () can be used to apply this function, and the number of cells is
supplied in brackets.
The mean of a data collection is its average value. The mean is a measure of central
tendency that is calculated by multiplying all of the input values by the number of observations.
The mean for the market capitalisation rate is 141.3257143 and normal incentive for the income
is 22.3814 and mean for number of workers is 262857.1429. It is affected by the outrageous
qualities and accommodating in additional arithmetical treatment.
The median is characterized as the mid – value of the informational index. It tends to be
figured diversely in the event of odd and even perceptions. At the point when perceptions are
even, (N+1) / 2 is applied and when perceptions are odd, N / 2 equation will be applied. The
median for the market capitalisation rate is 137.21 and mid incentive for income of McDonald is
22.82. the mid incentive for number of workers is 21000.
CONCLUSION
From the above report, it tends to be inferred that Ms-Excel is an application programming
which facilitates the work by performing complex estimation in extremely less time. The
capacity of bookkeeping sheet, for example, aggregate, count, least and most extreme assists
with tracking down the aggregate and greatest qualities from the income of McDonald. The
descriptive statistics which is used in the report, for example, mean, mode and middle of the
income and market capitalisation rate can likewise be broke down which helps in taking the
different choices.

REFERENCES
Books and Journals
Benitez, J., Llorens, J. and Braojos, J., 2018. How information technology influences opportunity
exploration and exploitation firm’s capabilities. Information & Management, 55(4),
pp.508-523.
Di Vaio, A. and et.al., 2020. Artificial intelligence and business models in the sustainable
development goals perspective: A systematic literature review. Journal of Business
Research, 121, pp.283-314.
Islam, M.T. and Huda, N., 2019. Material flow analysis (MFA) as a strategic tool in E-waste
management: Applications, trends and future directions. Journal of Environmental
Management, 244, pp.344-361.
Lai, Y., Sun, H. and Ren, J., 2018. Understanding the determinants of big data analytics (BDA)
adoption in logistics and supply chain management: An empirical investigation. The
International Journal of Logistics Management.
Liao, F and et.al., 2019. Consumer preferences for business models in electric vehicle
adoption. Transport Policy, 73, pp.12-24.