[removed]
 
 
 
 
 
 
 
World’s Biggest Public Companies
Start with the Excel workbook (spreadsheet) World’s Biggest Public Companies
– start.xlsx.
This
data
shows
information
produced
by Forbes
in terms
of the
World’s
Largest
Public
Companies.
In column
B, the
company’s
name
is displayed;
in column
C, the
country;
in
column
D, the
company’s
2013
sales;
in column
E, the
company’s
2013
profits;
in column
F,
the
company’s
2013
assets;
in column
G, the
company’s
2013
market
value.
In the
range
I1:M5,
you
will
see
the
first
matrix
that
you
will
need
to summarize,
where
the
goal
is to determine
the
median
value
of sales,
profits,
assets
and
market
value
respective
to the
corresponding
country.
However,
to date,
Excel
does
not
feature
a MEDIANIFS
function.
Thus,
you
will
have
to use
an array
formula
similar
to our
learning
activity.
Executing
this
statement
correctly
will
produce
a median
of the
desired
values
in the
dataset
for
the
given
country
of interest.
In the
range
I7:M11,
you
will
see
the
second
matrix
that
you
will
need
to sum
marize,
where
the
goal
is to determine
the
min
value
of sales,
profits,
assets
and
market
value
respective
to the
corresponding
country.
However,
to date,
Excel
does
not
feature
a MINIFS
function.
Thus,
you
will
have
to use
an array
formula
similar
to our
learning
activity.
Executing
this
statement
correctly
will
produce
a min
of the
desired
values
in the
dataset
for
the
given
country
of interest.
In the
range
I13:M17,
you
will
see
the
third
matrix
that
you
will
need
to summarize,
where
the
goal
is to deter
mine
the
max
value
of sales,
profits,
assets
and
market
value
respective
to the
corresponding
country.
However,
to date,
Excel
does
not
feature
a MAXIFS
function.
Thus,
you
will
have
to use
an array
formula
similar
to our
learning
activity.
Executing
this
statement
correctly
will
produce
a max
of the
desired
values
in the
dataset
for
the
given
country
of interest.
In the
range
I19:M
23,
you
will
see
the
third
matrix
that
you
will
need
to summarize,
where
the
goal
is to determine
the
standard
deviation
value
of sales,
profits,
assets
and
market
value
respective
to the
corresponding
country.
However,
to date,
Excel
does
not
feature
a
STDEV.S.IFS
function.
Thus,
you
will
have
to use
an array
formula
similar
to our
learning
activity.
Executing
this
statement
correctly
will
produce
a max
of the
desired
values
in the
dataset
for
the
given
country
of interest.
Please
note
that
the
“dot
S” portion
of the
STDEV
function
indicates
that
we
are
taking
the
standard
deviation
of a sample.
This
is a sample
since
we
do not
have
information
from
all
companies
(i.e.
population).
Finally,
ensure
that
all
values
in your
summary
tables
are
formatted
with
an Accounting
style
with
two
decimals
showing
(i.e.
$52.21)
HINT:
Be
very
careful
about
what
cell
references
are
absolute
and
which
are
mixed
(the
row
or column
absolute
and
the
other
relative).
Also, remember that you must use a
Ctrl+Shift+Enter keystroke in order to implement an array formula in Excel.