Skip to content
Sem 5 Prep
← BI & Data ScienceWhat business intelligence and data science are

Formulas for this chapter

Mean of a column

mean = SUM(values) / n Excel: =AVERAGE(range)

Turning raw data into information, the second rung of the DIKW ladder. Always check the answer lies between the smallest and largest values.

SUM(values)
Total of every observation
n
Number of observations

Growth and uplift percentage

growth % = (later - earlier) / earlier x 100

Comparing two periods or two groups. The denominator is always the figure you are comparing against; swapping it changes the answer.

later
Value of the newer period or the group being described
earlier
Value of the base period or the reference group
Step 5 of 25
Quick checkTheory

A manager asks for a dashboard showing last quarter's sales by region. Which is that, mostly?

← Back