4UIQM Studyguide
4UIQM Studyguide
4UIQM Studyguide
LEVEL 4
INTRODUCTION
TO QUANTITATIVE
METHODS
BE •
• A
OF
IDE
FICI
GU
L
STUDY
abeuk.com
A
© ABE 2017
Every attempt has been made to ensure the accuracy of this study guide;
however, no liability can be accepted for any loss incurred in any way
whatsoever by any person relying solely on the information contained within
it. The study guide has been produced solely for the purpose of professional
qualification study and should not be taken as definitive of the legal position.
Specific advice should always be obtained before undertaking any investment.
ABE cannot be held responsible for the content of any website mentioned in
this book.
ISBN: 978-1-911550-13-6
Reviewer: Colin Linton MRes MBA PGCHE DipM DipFS FCIB FCIM FCIPS
FCIEA FHEA FInstLM
Every effort has been made to trace all copyright holders, but if any have
been inadvertently overlooked, the Publishers will be pleased to make the
necessary arrangements at the first opportunity.
The rights of Rajesh Raheja BSc MBA to be identified as the author of this
work have been asserted by her in accordance with the Copyright, Design and
Patents Act 1998.
Acknowledgements
The publishers gratefully acknowledge permission to reproduce the following
copyright material:
P23 Jat306/Shutterstock; p23 SFIO CRACHO/ Shutterstock; p24 Casper1774
Studio/Shutterstock; p27 kurhan/Shutterstock; p28 SARAVOOT LENG-IAM/
Shutterstock; p29 kurhan/Shutterstock; p30 kurhan/Shutterstock; p41 gabczi/
Shutterstock; p45 ChristianChan/Shutterstock; p47 Andrey_Popov/Shutterstock;
p49 wutzkohphoto/Shutterstock; p50 Thanakit Jitkasem/Shutterstock; p54
Elena Shashkina/Shutterstock; p58 varuna/Shutterstock; p59 Artazum/
Shutterstock; p63 attaphong/Shutterstock; p64 sheff/Shutterstock; p65 como/
Shutterstock; p72 Olesia Bilkei/Shutterstock; p79 hxdbzxy/Shutterstock;
p82 GLF Media/Shutterstock; p103 Anna-Mari West/Shutterstock; p108
Foxys Forest Manufacture/Shutterstock; p122 Viktor1/Shutterstock; p147
ndoeljindoel/Shutterstock; p151 Lamai Prasitsuwan/Shutterstock;
ii © ABE
Contents
Using your study guide iv
Glossary 158
© ABE iii
Using your study guide
Welcome to the study guide for the Level 4 Introduction to Quantitative Methods.
Below is an overview of the elements of learning and related key capabilities (taken from
the published syllabus), designed to support learners to assess their own skillset in terms
of employability and to develop their own personal development plans.
This study guide follows the order of the syllabus, which is the basis for your studies.
Each chapter starts by listing the overarching syllabus learning outcomes covered and
the assessment criteria.
iv © ABE
L4 descriptor
Knowledge descriptor (the holder…) Skills descriptor (the holder can…)
• Has practical, theoretical or technical • Identify, adapt and use appropriate
knowledge and understanding of a cognitive and practical skills to inform
subject or field of work to address actions, and address problems that
problems that are well defined but are complex and non-routine while
complex and non-routine. normally fairly well-defined.
• Can analyse, interpret and evaluate • Review the effectiveness and
relevant information and ideas. appropriateness of methods, actions
and results.
• Is aware of the nature and approximate
scope of the area of study or work.
• Has an informed awareness of
different perspectives or approaches
within the area of study or work
‘Over to you’: activities for you to complete, using the space provided.
Case studies: realistic business scenarios to reinforce and test your
understanding of what you have read.
REVISION
on the go
‘Revision on the go’: use your phone camera to capture these key pieces of
learning, then save them on your phone to use as revision notes.
Examples: illustrating points made in the text to show how it works in practice.
Tables, graphs and charts: to bring data to life.
Reading list: identifying resources for further study, including Emerald articles
(which will be available in your online student resources).
Source/quotation information to cast further light on the subject from
industry sources.
Highlighted words throughout and glossary terms at the end of the book.
Note
Website addresses current as at June 2017.
© ABE v
Chapter 1
Numeracy for Business
Introduction
Numbers are an integral part of business management theory and practice. There is no economic
activity that can take place without the use of numbers. Therefore, learning to communicate with
the language of numbers is as important as learning to communicate with words. A simple example,
that is relevant for almost everyone in today’s world, is the ability to understand how banks
calculate interest on savings and loans.
Learning outcome
On completing the chapter, you will be able to:
1 Apply numeracy and quantitative techniques for use in day-to-day business activities.
(Weighting 25%)
Assessment criteria
1.1 Perform calculations on different types of numbers
1.2 Express numbers in various forms for making comparisons
1.3 Perform simple financial calculations to obtain values for taking business decisions
© ABE
Level 4
Introduction to
Quantitative Methods
Natural Natural numbers are all positive numbers starting from 1. Zero is not a
numbers natural number. The letter “n” denotes a natural number in arithmetic
expressions.
Example: 1,2,3,4…
Whole Whole numbers include all natural numbers and also zero. These are
numbers numbers with no decimal or fractional parts. These numbers never take
negative values.
Example: 0,1,2,3…
Integers Integers include whole numbers and also negative numbers. These
numbers do not have decimal or fractional parts and only represent whole
units of positive and negative numbers.
Fractions Fractions are parts of whole numbers. These indicate that an integer is
being divided by another integer.
Example: 1 , 3 , 9 …
2 4 11
Decimals Decimals are numbers based on the decimal system or the 10s system.
Decimals use a dot or a point to separate the ones place from the tenths
place in a number. There are one or more digits to the right-hand side of
the dot or point called the decimal point.
Just like a traditional language is built on certain grammatical principles, there are certain rules in
application of numbers. It is important to follow these rules for correct numerical expression. When
these rules are not followed, it results in meaningless and incorrect numerical communication.
BEDMAS rule
Numeric expressions can be both, simple and complex. Simple numerical expressions have just
one arithmetic operation that may be addition, subtraction, multiplication or division. However,
a complex numeric expression typically has a combination of different arithmetic operations.
Therefore, to understand a complex numerical expression you need to apply BEDMAS, a rule that
defines the order in which the arithmetic expression is simplified. BEDMAS is an acronym:
This order of operations in the acronym simply implies that, according to the rules of numeracy,
you would perform the operations division and multiplication only after opening brackets and
simplifying exponents. However, both division and multiplication precede addition and subtraction.
You should understand that while division appears before multiplication, and addition appears
before subtraction in the acronym BEDMAS, division and multiplication are considered higher
level operations, and therefore, are applied before addition and subtraction. However, both
multiplication and division are given equal importance, implying that you can apply either of
these two operations before the other. Once you have completed these operations, only then can
you apply addition and subtraction in any order because both these operations are given equal
importance. If there are brackets within brackets then the innermost brackets need to be simplified
and opened first.
Example
16 ÷ 22 + 6 + (4 × 3 − [6 + 2 − 3])
= 16 ÷ 22 + 6 + (4 × 3 − 5)
= 16 ÷ 22 + 6 + 7
= 16 ÷ 4 + 6 + 7
16
= +6+7
4
=4+6+7
= 17
Note the order of operations: innermost brackets were simplified before other brackets, exponent,
multiplication and division, and in the end, addition and subtraction.
4 © ABE
Numeracy for Business Chapter 1
Rules of numeracy
Innermost brackets
Outer brackets
Multiplication or division
Addition or subtraction
Revision
on the go
Over to you
Activity 1
1 (60 × 3 − 5) + 25 ÷ 5
2 15 ÷ 3 × (18 + 2 − [3 + 32])
3 88 + 88 ÷ (2 × 11) × 2
© ABE 5
Chapter 1 Numeracy for Business
Rule Examples
Over to you
Activity 2
When you multiply a positive number by another positive number, is the result positive
or negative?
An equivalent fraction May look different but have the same value. 1= 8
2 16
6 © ABE
Numeracy for Business Chapter 1
Over to you
Activity 3
1 13
4
2 21
5
3 3
4
4 11
3
Certain rules must be followed for solving expressions that contain fractions. These rules are
explained with examples in Table 4.
75 75 15 5
15 3
the numerator and denominator. Continue to
cancel till the point when no more division is
possible. Every cancelling step must include
both numerator and denominator. Similarly,
However, 1 + 1 ≠ 1 + 1
4 2 2 1
2 1
© ABE 7
Chapter 1 Numeracy for Business
8 © ABE
Numeracy for Business Chapter 1
Over to you
Activity 4
1 8 1 4
1 2 + ×2−1 −
2 9 2 5
9 3 2 3
2 ÷ × 1− +
4 6 4 5 2
2
+1−4÷2− 4+2 ×1
2
3
3 9 3 9 3 2
© ABE 9
Chapter 1 Numeracy for Business
Types of fraction
Proper Improper
fraction fraction
Equivalent Mixed
fraction fraction
Types of
fraction
Revision
on the go
In general, if the recurring decimal has 5 or a higher number recurring, you need to round up the
last digit to the next number
2
Example: = 0.6666666....... can be rounded off as 0.667 if the answer is expressed up to three
3
decimal places.
If the recurring decimal has less than 5 as the number recurring, you need to leave the number as is.
1
Example: = 0.33333..... = 0.33 to two decimal places
3
A decimal can be converted into a fraction by removing the decimal and dividing the number by a
multiple of 10 equal to the number of digits after the decimal place.
5
125 5 1
Example: 1.25 = = =1
100 4 4 4
Or
3
0.03 =
100
10 © ABE
Numeracy for Business Chapter 1
Over to you
Activity 5
1 Equivalent fractions
2 Recurring decimals
Over to you
Activity 6
4
1 1
5
7
2
11
16
3
3
3
4 3
5
78
5
13
Over to you
Activity 7
Solve and express your answers as a fraction and a decimal to two decimal places.
1 6 2 8 1
1 +2 − ÷ ×
4 11 5 10 4
3 6 1
2 4 + 1.2 − 3.5 − × 14.7 + 3
4 7 2
© ABE 11
Chapter 1 Numeracy for Business
• An exponent can also be negative. In such cases, you would express the number as the
reciprocal of the number to the positive power of the exponent.
1
Therefore, 4−3 = 3 = 0.156
4
• When we have very small or very large numbers, you can express these in a more manageable
form called standard form A × 10n, where n is an integer and A is a number less than 10.
For example:
87,038,993,020,000 can be expressed in standard form by multiplying it by 10s raised to the
required power to make it manageable.
Therefore, 87,038,993,020,000 can be simplified to 87,038×109 as
87,038,000,000,000 = 87038 × 10 × 10 × 10 × 10 × 10 × 10 × 10 × 10 × 10
The number can be expressed in decimal terms in standard form by adding a decimal point and
each time the decimal is moved left the power of 10 is increased by 1.
Therefore, the number can also be expressed as:
870.38 × 1011
or
87.038 × 1012
or
8.7038 × 1013
This final form is the number in standard form as 8.703 is less than 10.
This makes the number more manageable for applying arithmetic operations and also for comparing
with other numbers. Of the two numbers, the number that is raised to a higher power is larger.
A number × 10–n (a negative exponent) implies that the number is being multiplied by 1 n where n
10
is the value of the exponent.
Therefore,
0.956 = 956 × 10–3 = 956 × 1 3
10
8703.8 × 10 n
or
870.38 × 10 n + 1
or
87.038 × 10 n + 2
D ec i m a l m ov es l ef t
by one p os i ti on,
power g oes up b y 1
Revision
on the go
12 © ABE
Numeracy for Business Chapter 1
Over to you
Activity 8
1 4562.3 where n = 5
2 2,893,000,000 where n = 7
3 623.54 where n = −3
4 875.23 where n = −1
Over to you
Activity 9
1 505.05 × 10−2
2 8.01 × 103
3 635.25 × 107
4 8745 × 10−3
You can express quantities in percentages when these need to be compared by bringing them to a
common base. This base is 100. For example, 30% is smaller than 32%.
You can express per cent as a whole number or convert it into a fraction or a decimal.
• Y
ou can convert it into a fraction by dividing it by 100 and removing the % sign. Removing the %
sign simply implies dividing the number by 100.
30 = 3
Example: 30% =
100 10
• Y
ou can convert it into a decimal by removing the decimal point and moving the decimal point
two places to the left.
ou can convert a whole number or a decimal or a fraction into percentage by simply multiplying
Y
it by 100 and putting a % sign.
© ABE 13
Chapter 1 Numeracy for Business
Over to you
Activity 10
1 3
5
2 8
15
3 1
30
4 36
7
Over to you
Activity 11
1 34.62%
2 84.1%
3 103.20%
4 55.5%
14 © ABE
Numeracy for Business Chapter 1
David’s friend Salim saves 12% of his annual earnings of $35,000. Who saves more money every
year – David or Salim?
Example 3
If you want to express 5000 grams as a percentage of 200 kilograms, then either grams should
be converted into kilograms or kilograms as grams.
Example 4
Madhu sold 3000 units in 2015. In 2016, units sold increased by 20%. How many units did he sell
in 2016?
Example 5
The cost of manufacturing one unit of product increased from $5 to $8. What was the
percentage increase in cost?
© ABE 15
Chapter 1 Numeracy for Business
6 The total value or part of the total value can be determined from a percentage as follows:
Example 7
60% of students in Rehman’s class play some sport regularly. There are 120 students in his class.
How many students do not play any sport?
Therefore, 40% of total students in Rehman’s class do not play any sport.
40% × 120
40
= × 120 = 48
100
Example 8
Lisa pays $1500 every month as rent. This is 25% of her monthly income. What is Lisa’s total
monthly salary?
Over to you
Activity 12
In a class of 150 students, 70% have opted for business statistics, 50% students study
economics. Work out how many students study both the subjects.
Over to you
Activity 13
16 © ABE
Numeracy for Business Chapter 1
Over to you
Activity 14
Carole pays a rent of $2000 per month. The landlord decides to increase her rent to $2300
per month from August. Calculate the percentage increase in the rent that Carole will pay
from August.
When expressed as a ratio, the resulting fraction 23 is written as 2 : 3. This ratio indicates that for
every 2 minutes of tennis played by John, Susan has played 3 minutes. In other words, Susan has
spent one and a half times more time on playing tennis than John.
© ABE 17
Chapter 1 Numeracy for Business
Ratios are used in many business situations. With the use of ratios, various related quantities can
be quickly compared. For example, the ratio of sales done by a business in the years 2015 and 2016
can instantly tell us whether there is a positive improvement or decline in sales.
Step 1: Add the two terms of the ratio and use this as the denominator of the two fractions you
will use.
Step 2: Take the first term of the ratio as the numerator in the first fraction.
Step 3: Multiply the number to be divided by the first fraction to get the first part of the division.
Step 4: Take the second term of the ratio as the numerator in the second fraction and multiply this
second fraction by the number to get the second part.
The same approach can be used in the case of ratio of more than three values or quantities. This is
illustrated in the following example.
Example
You enter into a partnership with Khalid and Maureen and decide to share profits and losses in the
ratio 3 : 2 : 1. The partnership made a profit of $48,000 in the year. What will be the share of each
partner in the profit?
Solution: There are three terms in the ratio that should be used for dividing $48,000. Therefore,
there will be three fractions, and these will be used to divide the profit.
18 © ABE
Numeracy for Business Chapter 1
Over to you
Activity 15
1 20 is to 60
2 55 is to 220
3 90 is to 75
Over to you
Activity 16
Over to you
Activity 17
Chao and Min enter into partnership sharing profits and losses in the ratio 2 : 3. Lynn
joins the partnership and the partners decide to share the profit equally.
The partnership makes a profit of $30,000. What will be difference in the shares of
Chao’s profit before and after Lynn’s admission to the partnership?
© ABE 19
Chapter 1 Numeracy for Business
Over to you
Activity 18
Aamir had $32,000 in cash. He invested 8.5% in stocks and shares and gave 25% to his
parents. How much did he invest in stocks and shares? How much did he give to his
parents? What is the amount left with him?
Proportions
Ratios and proportions are inter-related. Two quantities are in direct proportion if they increase or
decrease in the same ratio.
A proportion is a mathematical statement with two equal ratios. It is written a “::” and is read
as “as”
For example: 5 : 10 :: 1 : 2 is an expression of a proportion. Stated in words, it reads:
“5 is to 10 as 1 is to 2”
The fractions that this expression represents are:
5 =1
10 2
In a proportion, 5 : 10 :: 1 : 2 the first and the last terms, that is, 5 and 2 are called “extremes” and
the two middle terms, that is, 10, and 1 are called “means”.
In a proportion, the product of the extremes = the product of the means. This is a very important
principle that is used for calculating the missing values in a given expression of proportion.
Example: Udoka spends $6 to buy 12 pens. How much will 18 pens cost?
This problem can be expressed as: 6 : 12 :: ? : 18
The value of “?” can be determined as follows:
6 : 12 :: ? : 18
6 = ?
12 18
? × 12 = 6 × 18
6×18
?= =9
12
Therefore, 18 pens will cost $9.
20 © ABE
Numeracy for Business Chapter 1
Over to you
Activity 19
1 2 : 3 :: 5 : ?
2 3.5 : 7.0 :: ? : 5.4
3 6 : ? :: 12 : 18
4 ? : 4 :: 4 : 8
r+s t+u
3 If sr = ut then s = u
r–s t–u
4 If sr = ut then s = u
r+s t+u
5 If sr = ut then r – s = r – s
Over to you
Activity 20
1 0.60 = 0.48
0.75 x
2 5= x
2 1200
= x
16
3
x 49
© ABE 21
Chapter 1 Numeracy for Business
We will understand these topics by performing calculations for given business situations.
Simple interest
Simple interest is the interest that applies only to the amount borrowed or invested. It is calculated
as a percentage of the principal amount only for a number of years. It stays the same for the
duration of the loan (or investment). Normally, short duration loans charge a simple interest and
short-term investments earn a simple interest. An interest of 10% per annum on $100 means that
$10 is charged as interest on $100 at the end of the year. Therefore, the total amount due to the
lender at the end of one year will be $110.
The duration of the loan (or investment) is the time that the principal amount is either borrowed or
invested. The duration is generally given in years but can also be stated in months or days.
Simple interest can be calculated with the formula:
P×R×T
S.I. =
100
Where,
S.I. = Simple interest
P = Principal amount
R = Rate of interest per annum
T = duration of the loan or investment
22 © ABE
Numeracy for Business Chapter 1
CASE STUDY 1
Monica’s loan
Monica wants to renovate her office. She wants to
finance the renovation partly with her own money and
the remaining by borrowing a reasonable amount from
her friend.
She is considering taking a loan of $8000 from her
friend for 5 years at a simple interest of 12% per
annum. What amount will Monica pay back to her
friend at the end of 5 years if she takes the loan?
To calculate the amount of money that Monica will have to repay, we should calculate the simple
interest using the formula:
P×R×T
S.I. =
100
This is a straightforward calculation:
8000 × 12 × 5
S.I. =
100
= $4800
Since $4800 is the simple interest, Monica needs to pay back $8000 + $4800 = $12,800 to her
friend at the end of 5 years.
This time Monica knows that S.I. = $3000, R = 12% and T = 5 years. She needs to find P.
P×R×T
We will adapt the formula S.I. = and state it in terms of P to find our answer.
100
The terms of this formula can be transposed as:
100 × S.I.
=P
R×T
or
100 × S.I.
P=
R×T
© ABE 23
Chapter 1 Numeracy for Business
Over to you
Activity 21
Salman takes a loan for $4500 for 3 years at a rate of 7% rate of simple interest. Work
out the amount of interest Salman will need to pay after three years.
In this instance, S.I. = $3000, R = 8% and P = $8000. Monica would like to know the value of T.
P×R×T
Just like earlier, the formula terms of the formula S.I. = are transposed as:
100
100 × S.I.
=T
R×P
or
100 × S.I.
T=
R×P
Substituting the values:
T = 100 × 3200
8 × 8000
= 5 years
24 © ABE
Numeracy for Business Chapter 1
Therefore, the best duration of loan for Monica is 5 years. Using this, she can avoid paying interest
of more than $3200.
Over to you
Activity 22
Calculate the rate of simple interest Monica should pay if she borrows $8000 for 5 years
and only $2800 interest.
Over to you
Activity 23
Noel invests $5000 in a high interest paying bank account. The bank will pay a simple
interest at 10% per annum on a six-month basis into this account. After how many years
will the total amount in the account double?
Compound interest
Unlike simple interest, compound interest is the interest calculated not only on the principal
amount but also on the accumulated interest. At the end of year 1 there is no difference between
the simple interest and compound interest as there is no accumulated interest. However, in year
2, the principal for compound interest will be equal to the sum of the principal and the interest
accumulated for year 1. Therefore, interest will be calculated on a higher base. This happens with
every passing year till the end of the term.
Example: Jiao takes a loan of $1000 for 3 years on 10% compound interest.
© ABE 25
Chapter 1 Numeracy for Business
These year-on-year calculations for compound interest can be done with the formula:
T
R
C.I. = P 1 + −P
100
Where,
C.I. = Amount
P = Principal amount
C.I. = P 1 + Revision
100 on the go
26 © ABE
Numeracy for Business Chapter 1
Let’s understand how to make a decision on borrowing with simple and compound interest with the
following case study.
Monica should compare the total amount repayable after 5 years at 7% compound interest against
the amount payable at 8% per annum simple interest.
We know that the amount payable after 5 years with simple interest is:
Now let’s calculate the amount payable when interest is compounded annually with the formula:
T
R
A=P1+
100
We know:
P = $8000
R = 7%
T = 5 years
A = 8000
100
107 5
A = 8000
100
= $11,220.41
We know that the amount payable after 5 years with compound interest is: $11,220.41
Note that even though the rate of interest is 1% lower, the total amount payable at the end of 5 years
with compound interest (7%) is $20.41 more than the amount payable with simple interest (8%).
© ABE 27
Chapter 1 Numeracy for Business
CASE STUDY 2
Akilah deposits $5000 in a bank account for two
and a half years. The bank pays an interest at 10%
per annum. The interest is calculated after every
6 months and is automatically deposited into
Akilah’s account.
Therefore, R = 5%
2 The total period of the deposit is two and a half years. This implies that Akilah’s bank account
will receive the interest 5 times.
Therefore T = 5
T
R
Use the formula P 1 + to determine the amount due on maturity.
100
5 5
5000 1 +
100
105 5
= 5000 ×
100
= $6381.41
Therefore, Akilah should have $6381.41 in her bank account at the end of two and a half years.
Over to you
Activity 24
Which is greater?
a A sum of money accumulating 3% compound interest for 12 years; or
b The same sum of money accumulating 6% compound interest for 6 years.
28 © ABE
Numeracy for Business Chapter 1
The concept of present value is one of the fundamental concepts in finance. It is widely used in financial
modelling for taking long-term investment decisions. Present value accounts for the time value of
money. In other words, it accounts for the return that one can get on the money invested today.
PV = CF
(1 + R%)T
Where,
PV = Present value
CF = Cash flow
T = Number of periods
CASE STUDY 3
rian is evaluating investing in a project today.
B
The project will result in a one-time cash inflow of
$90,000 at the end of three years. He estimates the
discount rate to be 12% and wants you to help him find
the present value of this cash flow.
It is NOT necessary that investment is always made into a project with the aim of getting
consolidated cash inflow at the end of the project. Often investments are made for getting periodic
cash inflows, typically on an annual basis. In many cases, a project may give the investor the same
© ABE 29
Chapter 1 Numeracy for Business
amount of cash inflow every year. The present value in such cases can be determined by using the
following formula:
1– 1 T
1 + R%
PVA = CFA ×
R%
Where:
T = Number of periods
1– 1 3
1 + 0.12
PVA = 30,000 ×
0.12
1– 1 3
1.12
= 30,000 ×
0.12
= 30,000 × (1 – 0.712)
0.12
= 30,000 × 0.288
0.12
= $72,000
It is evident that the present value of the project with annual returns is higher than the one-time
cash inflow at the end of three years. Therefore, Brian should decide on getting annual returns.
PV = CF
(1 + R%)T Revision
on the go
30 © ABE
Numeracy for Business Chapter 1
Over to you
Activity 25
Calculate the present value of receiving $1500 every year if you receive the amount for
the next:
a 6 years and the discount rate is 12%
b 5 years and discount rate is 10%
c 6 years and the discount rate is 10%
d 5 years and the discount rate is 12%
There are various methods of calculating depreciation. Two commonly used methods of
depreciation are:
• Straight-line method;
• Reducing balance method.
This section will discuss these two methods.
Straight-line method
Straight-line method of depreciation spreads the cost of the asset evenly throughout the useful life
of the asset. It assumes that there will be a uniform use of the asset over its life. It is calculated as:
Example 1
Ajit purchases a machine on 1 January 2015 for $11,000. The machine has a useful life of 5 years.
At the end of its useful life, the machine can be sold off for $1000. Depreciation on the machine by
applying the straight-line method is calculated as:
Example 2
Emma purchased office equipment at a cost of $5400. This office equipment will have no residual
value at the end of its life. She charges depreciation of $540 every year. After how many years will
her office equipment have no value?
Note that since the office equipment will have zero value when it is completely depreciated.
Over to you
Activity 26
A factory purchases a machine for $40,000 in January. The machinery is estimated to have a
useful life of 5 years after which it will be sold for $2000. Calculate the rate of depreciation
the business should charge every year.
The method charges a higher depreciation in the earlier years of the useful life of the asset.
Net book value is the value of the asset at the start of the year. It is calculated by deducting the
total depreciation charged on the asset till that point from the cost of the asset.
32 © ABE
Numeracy for Business Chapter 1
Example 4
Aadil purchases a motor vehicle on 1 January 2015 for $12,000. He charges a depreciation of 15%
using the reducing balance method. What will be the value of the motor vehicle on 1 January 2018?
2015
2016
2017
2018
DV = C(1–R)T
Where,
R = Rate of depreciation
In Example 4, value at the beginning of 2018 is the same as value at the end of 2017 (31 December 2017).
As the asset was purchased on 1 January 2015, the depreciation for three years would have been charged
on 31 December 2017. Therefore, depreciated value on 31 December 2017 will be:
DV = 12,000(1 – 0.15)3
= $7369.50
Annual depreciaton = (Net Book Value – Scrap or salvage value) × Rate% Revision
on the go
© ABE 33
Chapter 1 Numeracy for Business
Over to you
Activity 27
Malcolm depreciates his computer at a rate of 35% each year. At the end of 2016 the
value of the computer was $5740. Work out the value of the computer at the end of
2014 based on reducing balance method.
Over to you
Activity 28
Jesse bought a new car. She depreciates the car at 10% using the reducing balance method.
After how many years will the value of her car be less than 50% of the original value?
There are other employees who work under different contractual agreements such as:
• receive a fixed monthly salary + commission;
• receive wages based on the number of hours worked;
• receive wages based on units produced, etc.
In many countries, deductions are made from the salaries and wages for pension contributions or
taxation. In many organisations, employees who work more than the required number of hours are
paid overtime wages.
Overtime wage rate is generally higher than the normal wage rate and may be indicated as time
and a half or time and a quarter, etc. The various terms involved in these calculations are:
• Time and a half: this means normal hourly rate + 0.5 of normal hourly rate = hourly rate × 1.5
• Time and a quarter: this means normal hourly rate + 0.25 of normal hourly rate = hourly rate × 1.25
34 © ABE
Numeracy for Business Chapter 1
• Gross wages or gross salary: this is the total amount due to an employee before any deductions.
• Net wages or net salary: this is the total amount due to the employee after deductions.
Example 1
For the month of October, Jian was paid for 136 hours at $8 per hour and 28 hours at time and a
half. The employer deducted $275 towards taxation and $60 for pension contributions from the
gross amount. What did Jian’s receive in the month of October?
Out of this, deduction towards taxation and pension is subtracted to get the net amount received
by Jian in October.
Example 2
Eve is in the sales team in her organisation. She receives a salary of $24,000 per annum. She also
receives a commission of 10% on the amount of sales exceeding $7500. In August, she had sales of
$10,000. There were no deductions from her salary. What was her salary in August?
Over to you
Activity 29
© ABE 35
Chapter 1 Numeracy for Business
Discounts
Discounts are common in businesses all over the world. A discount is the amount of money
deducted from the cost or the face value or the selling price of an item. A business may offer trade
discount to attract more customers or encourage them to buy larger quantities. A business may
also offer cash discount to encourage its credit customers to make prompt payments.
Example
Anwar bought office furniture that carried the list price of $4800. He got a discount of 8%. What is
the amount Anwar paid for the furniture?
Over to you
Activity 30
Atul gives a cash discount of 3% to his credit customers who pay within 15 days of
purchase. Shahana bought goods for $1500 from Atul on 3 April and settled her account on
10 April. Calculate how much discount she received.
36 © ABE
Numeracy for Business Chapter 1
Example 1
Zumba is travelling to Malawi from the United Kingdom. He wants to convert £500 (500 British
pound Sterling) into Malawi Kwacha. How many Malawi Kwacha can he get? The market rates are:
£1 = $1.239, and
Zumba needs the relationship between £ and MWK to find the amount he can get. In this example,
the relationship between £ and MWK is indirect; US$ is the common factor between £ and MWK.
Therefore, the calculation has two parts:
£1 = $1.239
$1.239 = £1
$1.239 = £1
1.239 1.239
$1 = £0.807
With this derivation, the relationship between the three currencies can be easily expressed as:
£1 = 725.23 MWK
0.807
Therefore,
Example 2
Meena is travelling to Japan. She exchanges US$1500 and receives 169,080 Japanese Yen. On
arrival at the destination airport, she converts $200 more and gets 22,300 yen. How many more
Japanese yen did she receive per $1 in the first transaction?
$1 = 16,9080 yen
1500
$1 = 112.72 yen
$1 = 22,300 yen
200
$1 = 111.5 yen
Therefore, the extra yen per $1 in the first transaction is 112.72 – 111.5 = 1.22 yen
© ABE 37
Chapter 1 Numeracy for Business
Over to you
Activity 31
NEED TO KNOW
There are various types of numbers: natural numbers, whole numbers, integers, fractions
and decimals.
According to the rules of numeracy, the operations division and multiplication are
performed only after opening brackets and simplifying exponents. However, both division
and multiplication come before addition and subtraction.
Arithmetic operations, when performed on two positive numbers always result in a positive
number.
When arithmetic operations involve either a positive number and a negative number or two
negative numbers, the result is based on certain rules.
There are various types of fractions: equivalent fractions, improper fractions, mixed fractions.
An improper fraction can be changed into a mixed fraction by dividing the numerator with
the denominator.
A fraction should always be simplified and should always be expressed as the smallest
value of the numerator and the denominator.
A fraction can be converted into decimals by dividing its numerator by the denominator
and writing the answer as a decimal.
The number can be expressed in decimal terms in standard form by adding a decimal point
and each time the decimal is moved towards left the power of 10 is increased by 1.
Quantities are expressed in percentages when these need to be compared by bringing
them to a common base.
Ratios express the relationship between two or more values. A ratio can only be expressed
for items that have some form of comparable measurement.
Ratios and proportions are inter-related. Two quantities are in direct proportion if they
increase or decrease in the same ratio.
Simple interest is the interest that applies only to the amount borrowed or invested. It is
calculated as a percentage of the principal amount only, for a number of years.
Compound interest is the interest calculated not only on the principal amount but also on
the accumulated interest.
The concept of present value accounts for the time value of money and is widely used in
financial modelling for taking long-term investment decisions.
38 © ABE
Numeracy for Business Chapter 1
Two commonly used methods of depreciation are straight-line method and reducing
balance method.
Straight-line method of depreciation spreads the cost of the asset evenly throughout the
useful life of the asset. It assumes that there will be a uniform use of the asset over its life.
Reducing balance method of depreciation for each year is calculated at a fixed rate on the
diminishing balance of the value of the asset.
READING LIST
ABE (2017). Introduction to Quantitative Methods. ABE. ISBN 978-1-911550-13-6
Curwin, J. and Slater, R. (2010). Quantitative Methods: A Short Course. Cengage Learning;
001 (Revised Printing) edition. ISBN 978-1844809059
Pickerden, M. and Wright, C. (2016). Essential Maths Skills for AS/A Level Business. Philip
Allan, 3rd Ed. ISBN 978-1471863479
RESOURCES
BBC Bitesize (2015). Maths. http://www.bbc.co.uk/education/subjects/z38pycw
© ABE 39
Chapter 2
Algebraic Methods
Introduction
Algebra, like arithmetic, is a branch of Mathematics. While arithmetic uses only numbers to express
mathematical relationships, algebra uses letters, numbers, exponents, symbols and arithmetical
operators of addition, subtraction, multiplication and division to depict mathematical relationships.
Business managers use algebraic methods for solving a variety of problems. In many situations
where unknown elements are present, the application of algebraic methods becomes useful. For
example, when a firm introduces a new product, price is an unknown element. The solution to the
problem of what price should be set for the product is possible with algebra.
In this chapter, you will learn to use algebraic methods. You will understand how to simplify
algebraic expressions and solve simple linear equations, formulate and solve simultaneous
equations and also quadratic equations. You will also learn to derive the equation of a straight line
to show relationship between variables.
Learning outcome
After completing this chapter you will be able to:
2 Apply algebraic methods to formulate and solve business problems. (Weighting 25%)
Assessment criteria
2.1 Simplify or solve equations by employing algebraic methods
2.2 Derive the equation of a straight line to show relationship between variables
© ABE
Level 4
Introduction to
Quantitative Methods
CASE STUDY 1
Gemma’s monthly earnings and expenditure
Gemma works in a small shop on a part-time basis. She earns
$100 per day. Every month she spends part of her salary to meet her
monthly expenses and pays $20 towards a magazine subscription.
Coefficient Operator
100x – y – 20
Variables Constant
© ABE 41
Chapter 2 Algebraic Methods
In the algebraic expression in Figure 1, the letters ‘x’ and ‘y’ are unknown quantities termed as
variables. The values of variables change with the values taken by the unknowns. Number 20 is
called a constant because it is a value that is known and does not change.
The coefficient of a variable is the number that accompanies a variable. If there is no number
placed before the variable, then the coefficient is 1.
Over to you
Activity 1: Algebraic expressions
Gemma’s friend, Kevin, is a web designer. He earns $70 per hour and spends $25 per day
travelling to his place of work.
1 Express Kevin’s earnings per day as an algebraic expression.
42 © ABE
Algebraic Methods Chapter 2
Over to you
Activity 2: Addition of algebraic terms
Multiplication
1 Like terms can be multiplied together by raising the product to the power of the number of
times the term appears.
Example x × x × x = x3
The number 3 in x3 is called an ‘exponent’ or ‘power’ and x is called the base.
x1 is equal to x as its exponent is 1. The same is not true for x0 because the value of x0 = 1
2 Two expressions with the same base can be multiplied even if they have different exponents or
powers.
Example x2 × x3 = (x × x) × (x × x × x) = x(2+3) = x5
Therefore, xa × xb = x(a + b)
3 A term raised to the power of another term is denoted with the base raised to the power of
product of the two exponents.
Example (x3)2 = x(3 × 2) = x6
or
1
(x2) 2 = x(2 × 2 ) = x
1
Division
1 Division of two terms can be expressed by using the operator ÷
Example 4xyz ÷ zx
This can also be expressed as:
4xyz
zx
2 Algebraic terms can be easily cancelled out while dividing. Therefore, if there are like terms in
the numerator and the denominator, these can cancel each other out to simplify the algebraic
expression.
4xyz 4y
Example = = 4y
zx 1
3 Two expressions with the same base but different exponents can be divided by each other by
simply taking the difference between the exponents.
y5
Example = y(5 − 2) = y3
y2
Similarly,
xy = x y =x y =y
(− 12 −1) (1−2 − 32 1
Example 2
3
3
) 3 3
2
x b = b xa
a
xa
= x(a − b)
xb
x−a = a
1
x Revision
on the go
There are two more rules that may apply to all algebraic expressions.
xb = b x
1
a
x b = b xa
y3
1
y3 y
1
3
=
x
3
2 x3
44 © ABE
Algebraic Methods Chapter 2
Over to you
Activity 3: Multiplication and division in algebra
There are primarily three key rules that apply to brackets in algebra.
1 Each term within the bracket should be multiplied by the term in front of the bracket.
2 If the bracket is preceded by a + sign, each term within the bracket stays the same.
3 If the bracket is preceded by a − sign, the sign of each term within the bracket changes. Thus a
+ sign becomes a − sign and a − sign becomes a + sign.
CASE STUDY 2
Using brackets
Fatima wants to simplify the following algebraic expression.
3z4
2(3x2 + 5z3 +
z + 2zx ) − (2y + 5x − y)
3 2
She does not know where to start as the expression has brackets,
multiple terms and uses all arithmetic operations.
3z43
= 2(3x2 + 5z3 +
z + 2zx ) − (2y + 5x −y)
3 2
Step 2: Since 2 precedes the first brackets, multiply each term within the first brackets with 2.
Step 3: Check the sign that precedes each bracket. The first set of brackets are preceded by a
plus sign, therefore the sign of all the terms within these brackets will remain the same when the
brackets are removed. However, the second set of brackets is preceded by a minus sign. The signs
of all terms within these brackets will change when the brackets are removed.
Therefore,
Over to you
Activity 4: Using brackets
xy
Let’s look at Gemma’s monthly earnings and expenditure (Case study 1) again. Gemma’s earnings
were stated in an algebraic expression as:
100x − y − 20
If in January, after all her expenditure during the month, the balance remaining with Gemma was
$500, this relationship can be expressed as:
100x − y − 20 = 500
An equation has two sides. These two sides should always be equal for the equation to stay true
or valid. If any change of variables or constants is done on one side of the equation, the same
change should also be done on the other side of the equation. For example, if a number is added
or subtracted on one side, the same number should be added or subtracted from the other side.
Similarly, if the terms on one side are multiplied or divided by a number, the same number should
multiply or divide the terms on the other side also.
Algebraic equations have unknown values that can only be known after the equation is solved.
An equation can be solved by separating unknown quantities (variables) from known quantities
(constants) or by reorganising the equation.
46 © ABE
Algebraic Methods Chapter 2
Algebraic equations can be of various types. The focus of this section is on learning how to solve
the following types of equations.
1 Single variable linear equations
2 Simultaneous linear equations in two variables
3 Quadratic equations
A single variable linear equation has only one unknown quantity or variable.
This is a linear equation in one variable x, where x represents the number of days for which Gemma
worked during the month of February. This equation can be solved by determining the value of x.
Step 1: Simplify both sides of the equation by clearing brackets and combining like terms.
Step 2: Separate the variable from constants by bringing all the terms with the variable on one side
of the equation and moving all the constants on the other side.
This movement of algebraic terms from one side to the other is known as transposition.
Transposition helps to separate the unknown variable on one side so that a solution can be found.
All the terms containing the unknown x are kept on left hand side of the equation and all the known
values are moved to the right-hand side.
Note carefully, that during transposition, the sign of each term changes when it is moved to the
other side of the equation.
In this example, the coefficient of the variable is an integer ‘40’. Therefore, divide both sides of the
equation by 40.
The solution to the equation is the value that equates the variable when its coefficient as 1.
In this example x = 19.
Therefore, Gemma worked for 19 days in February.
Over to you
Activity 5: Solving single variable linear equations
2 3(x + 6) + 3x = 3(−9 − x)
3 2t −2 = 3
t+3 t − 10
48 © ABE
Algebraic Methods Chapter 2
x+y=5
This is a linear equation in two variables x and y, which can take multiple values such as (5,0), (4,1),
(3,2), (2,3), (1,4), (0,5) and so on. To solve this kind of an equation, we require another equation
that has a relationship between the two unknown variables. The two equations are then used at the
same time or simultaneously to arrive at the correct pair of values for x and y. The two equations
used to arrive at the answer to the two unknown variables are called simultaneous equations.
CASE STUDY 2
Solving simultaneous equations
Marie has two equations to solve. She has to find the values of x
and y. The equations are:
5x + 2y = 144
2x + 2y = 72
The equations Marie is solving are simultaneous linear equations in two variables x and y.
Elimination method
In the elimination method, one of the variables is removed from the two equations. This is based
on the premise, that if the relationship shown in the two simultaneous equations is true, then any
equation that is derived from this relationship is also true.
Elimination method: one variable in the two equations has the same coefficient
This can be easily done if one of the variables has the same coefficient regardless of sign of the
coefficient. The following steps need to be performed:
Step 1: See whether one of the two unknowns has the same coefficient. If yes, identify it. In these
equations y has the same coefficient ‘2’ in both equations.
Step 2: If the variable that has the same coefficient has opposite signs, then add the two equations.
However, if the variable with the same coefficients has the same sign, then subtract the two
equations from each other. This step will eliminate the variable.
© ABE 49
Chapter 2 Algebraic Methods
In Marie’s case as the variable y in both equations has a + sign, the second equation is subtracted
from the first equation:
+5x + 2y = 144
−2x + −2y = −72
+3x + 0 = 72
Step 3: The equation becomes a single variable linear equation, which can be solved for the
remaining variable, that is, x.
+3x + 0 = 72
3x = 72
3x = 72
3 3
x = 24
Step 4: Replace x with its value in either of the equations to find the value of y.
2x + 2y = 72
2(24) + 2y = 72
48 + 2y = 72
48 + 2y − 48 = 72 − 48
2y = 24
y = 12
You can verify your answer by substituting the values you have calculated in either of the equations.
5x + 2y = 144
5(24) + 2(12) = 144
144 = 144
Elimination method: none of the two variables in the two equations has the
same coefficient
6u + 2v = 56
5u − v = 76
In these equations, the coefficients of both variables are different. Such equations can be solved
by manoeuvring one or both equations so that at one variable gets same coefficients in both
equations. This will help in eliminating the variable.
50 © ABE
Algebraic Methods Chapter 2
Step 1: Identify the variable whose coefficient can easily be made the same in both equations.
The coefficient of ‘v’ in equation 2 can be made same as that in equation 1 by simply multiplying
each term on both sides of equation 2 by 2 to get a new equation (equation 3).
6u + 2v = 56 Equation 1
5u − v = 76 Equation 2
2 × 5u − 2 × v = 76 × 2
10u − 2v = 152 Equation 3
Variable v in both equations has the same coefficient but with opposite signs. We can therefore add
the two equations to eliminate v.
6u + 2v = 56
10u − 2v = 152
16u + 0 = 208
Step 3: It now becomes a single variable linear equation that can be solved for the remaining
variable, that is, u.
16u + 0 = 208
16u = 208
16u 208
=
16 16
u = 13
Step 4: Substitute the value of u in either of the equations and find the value of v.
6u + 2v = 56
6(13) + 2v = 56
78 + 2v = 56
78 + 2v − 78 = 56 − 78
2v = −22
v = −11
Therefore, u = 13 and v = −11
You can verify your answer by substituting the values you have calculated in either of the equations.
Over to you
Activity 6: Simultaneous equations
Using the elimination method, solve the following equation by eliminating u rather than v.
6u + 2v = 56
5u − v = 76
Hint: you will need to manoeuvre both equations.
© ABE 51
Chapter 2 Algebraic Methods
1 + 1 = 11 Equation 2
x y
These can be solved as follows:
1 = r and 1 = s and rewrite the equations as:
Step 1: Assume
x y
4r − s = 9
r + s = 11
Step 2: In these equations s has the same coefficient ‘1’ in both equations. As s has opposite signs
in the two equations, add the two equations to eliminate s.
4r − s = 9
r + s = 11
5r = 20
Step 3: It now becomes a single variable linear equation which can be solved for the remaining
variable, that is, r.
5r = 20
20 = 4
r=
5
Step 4: Substitute the value of r in either of the equations and find the value of s.
r + s = 11
4 + s = 11
4 + s − 4 = 11 − 4
s=7
1 = r and 1 = s, the answer is 1 = 4 and 1 = 7
Since
x y x y
You can verify your answer by substituting the values you have calculated in either of the equations.
Over to you
Activity 7: Simultaneous equations
52 © ABE
Algebraic Methods Chapter 2
Substitution method
As the name suggests, with substitution method, the value of one variable is stated in terms of the
second variable. The value derived for the first variable is then used in the second equation. This
eliminates the first variable in the second equation and leaves a linear equation in single variable.
The second variable in this equation can be solved easily.
Now Marie (Case study 2) solves the second set of equations by using the substitution method. The
steps are:
Step 1: Use the first equation to express the value of u in terms of v. Please note that you can use
any one of the two equations to get the value of any one of the two variables.
6u + 2v = 56
6u + 2v − 2v = 56 − 2v
6u = 56 − 2v
6u = 56 − 2v
6 6
u = 56 − 2v = 2(28 − v) = 28 − v
6 63 3
Step 3: Replace v with –11 in the first equation to get the value of u.
6u + 2v = 56
6u + 2(−11) = 56
6u − 22 = 56
6u − 22 + 22 = 56 + 22
6u = 78
u = 13
Therefore, u = 13, v = −11.
© ABE 53
Chapter 2 Algebraic Methods
Over to you
Activity 8: Simultaneous equations: substitution method
Using the substitution method solve Marie’s first set of simultaneous equations.
5x − 2y = 144
2x + 2y = 72
CASE STUDY 3
Formulating simultaneous equations
There is a new fast food restaurant in town. The restaurant
charges different prices for an adult’s meal and a child’s
meal. Sue and Mike take their two children to the
restaurant and order four meals. They pay $55. Ahmed
takes his three children to the same restaurant and orders
four meals. He pays $48. We will now:
1 Formulate the simultaneous equations
2 Calculate the price of an adult’s meal and a child’s meal.
The number of meals in both cases is the same but since the restaurant charges different prices
for an adult’s meal and a child’s meal, the total amount of money paid by Sue and Mike is different
from the amount paid by Ahmed. There are two unknowns in this situation: (1) price of an adult’s
meal and (2) the price of a child’s meal. The value of these two unknowns can be determined with
simultaneous equations.
Let,
Equation 1: Sue and Mike with their two children implies 2 adult’s meals and 2 children’s meals,
with a total payment of $55. This can be expressed as equation:
2x + 2y = $55
Equation 2: Ahmed with his three children implies 1 adult’s meal and 3 children’s meals, with a total
payment of $48. This can be expressed as equation:
x + 3y = $48
Solving these two simultaneous equations will tell us the price of an adult’s meal x and a child’s
meal y. The equations can be solved using either elimination or substitution method.
54 © ABE
Algebraic Methods Chapter 2
2x + 2y = $56
x + 3y = $48
We can give x the same coefficient in both equations by multiplying the second equation with 2.
Remember that to have a balanced equation, you must multiply all elements of the equation with 2.
This gives a new equation:
2 × x + 2 × 3y = 2 × 48
2x + 6y = 96
After this step, the two equations can now be solved as:
2x + 2y = 56
−2x + −6y = −96
0 − 4y = −40
40
y= = $10
4
Next, substitute y = 10 in the first equation.
2x + 2y = $56
2x + 2(10) = 56
2x + 20 = 56
2x + 20 − 20 = 56 − 20
2x = 36
36
x=
2
x = $18
Thus, the price of an adult’s meal is $18 and that of a child’s meal is $10.
Over to you
Activity 9: Simultaneous equations
Using the substitution method, find the price of an adult’s meal and a child’s meal.
2x + 2y = $56
x + 3y = $48
Where,
© ABE 55
Chapter 2 Algebraic Methods
Quadratic expressions can also exist in equations in which the power of a variable is a multiple of 2.
For example 2x4 + 3x2 + 7 is a quadratic expression of an algebraic relationship in x2 because this
equation can also be expressed as 2(x2)2 + 3(x2) + 7. If it is assumed that x2 = y, then the expression
can be written as 2y2 + 3y + 7 which is a normal quadratic expression.
For example,
3x2 − 4x + 1 = 0
or
u2 − u = 5
There is no definitive solution of a quadratic equation because usually the solution to a quadratic
equation has two possible values for the unknown. Linear equations, when plotted on a graph, give
a straight line, quadratic equations, when plotted on a graph, result in a curve.
This would require you to be able to present the equation as the product of two numbers and
equate it to 0. The steps are:
Step 1: Collect all the terms of the quadratic equation to left side and make the equation equal
to 0.
2x2 − 5x = 7
Therefore, 2x2 − 5x − 7 = 0
Step 2: Factorise the left-hand side of the equation. This involves presenting the left-hand side as
a product of two algebraic expressions. This can be done by using the factors of the product of
56 © ABE
Algebraic Methods Chapter 2
coefficients of a and c in the equation ax2 + bx + c = 0 and organising them such that their sum is
equal to the coefficient of the middle term b.
2x2 − 5x − 7
= 2x2 − 7x + 2x − 7
= x(2x − 7) + 1(2x − 7)
= (x + 1)(2x − 7)
Step 3: Take each factor after factorisation and equate it to 0 and work the two values of x.
Therefore,
(x + 1) = 0
x+1=0
x = −1
and
(2x − 7) = 0
2x − 7 = 0
2x = 7
7 1
x= =3
2 2
1
Therefore, x = −1 or x = 3
2
Over to you
Activity 10: Quadratic equations: factorisation method
© ABE 57
Chapter 2 Algebraic Methods
CASE STUDY 4
Solving quadratic equations
Asha wants to construct a fence around her rectangular garden in a way
that the length of the garden is 4 feet more than its width. The area
of the garden is 60 square feet. She wants to know what would be the
length and the width of her garden.
The area of a rectangle is equal to the product of its length and width, both of which are unknown
values in this example.
Let the length of the garden be x. As width is 4 feet less than the length, it can be written as (x − 4).
Algebraically, this equation can be presented as:
x(x − 4) = 60
x(x − 4) = 60
x2 − 4x = 60
x2 − 4x − 60 = 0
x2 + 6x − 10x − 60 = 0
x(x + 6) − 10(x + 6) = 0
(x + 6)(x − 10) = 0
Therefore
(x + 6) = 0
x+6=0
x = −6
or
(x − 10) = 0
x − 10 = 0
x = 10
Since the length or width of the garden cannot be a negative value, the length = 10 feet and the
width = 10 − 4 = 6 feet.
The quadratic equation expressed as ax2 + bx + c = 0 can be solved with the formula:
−b ± b2 − 4ac
x=
2a
58 © ABE
Algebraic Methods Chapter 2
In this instance of case study 4, you will not easily to find the values of length and width using the
factorisation method. The equation can be expressed as:
x(x − 6) = 60
x2 − 6x − 60 = 0
2a
Where,
a = 1,
b = −6,
c = −60
Therefore,
2(1)
= 6 ± 36 + 240
2
= 6 ± 16.6
2
The value of x can be either 6 + 16.6 = 11.3 or 6 − 16.6 = −5.3
2 2
Since the length of the garden cannot be negative, therefore the length (x) = 11.3 feet, and the
width is 11.3 – 6 = 5.3 feet
Over to you
Activity 11: Quadratic equations: formula method
Asha has decided to construct a garden that is square shaped. Calculate the length of
the garden if the area of the garden is 60 square feet.
© ABE 59
Chapter 2 Algebraic Methods
Over to you
Activity 12: Quadratic equations: formula method
13
11
9 (4, 8)
7
y-axis
5
3 Origin
1
–13 –11 –9 –7 –5 –3 –1 1 3 5 7 9 11 13
–1
x-axis
–3
(–10, 3)
–5
–7
Co-ordinate
–9
–11
–13
60 © ABE
Algebraic Methods Chapter 2
position on the y-axis. For example, (4, 8) in Figure 2 refers to a point at the intersection of 4 on
the x-axis and 8 on the y-axis.
A linear equation when plotted on a graph always gives a straight line. For plotting a straight line
on a graph, we will need a minimum of three co-ordinate points derived from the linear equation
that needs to be plotted. To do so, choose three values of x (independent variable) and by using
the linear equation find the corresponding values of y (dependent variable). The three x and y co-
ordinates when plotted on a graph and joined will give a straight line.
y = 2x + 1
x y = 2x + 1
0 2(0) + 1 = 1
2 2(2) + 1 = 5
4 2(4) + 1 = 9
This gives three co-ordinates for the graph (0, 1), (2, 5) and (4, 9). These co-ordinates when plotted
and joined give the graph for y = 2x + 1. This is illustrated in Figure 3.
13
11
9 (4, 9)
5 (2, 5)
1 (0, 1)
x
–13 –11 –9 –7 –5 –3 –1 1 3 5 7 9 11 13
–1
–3
–5
–7
–9
–11
–13
Therefore, a linear equation is an equation of a straight line. The straight line can be
extended and for any value of x, the value of y can be found out.
© ABE 61
Chapter 2 Algebraic Methods
Over to you
Activity 13: Plotting an equation
Given equation y − 3x = 2
1 Plot the graph for the equation.
2 State the shape of the graph.
where,
m represents the gradient or slope of the line. For example, the slope of y = 2x + 1 is 2.
c represents the point where the straight line crosses the y-axis. It is also known as the y -intercept.
In Figure 3, the straight line crosses the y-axis at y = 1. Therefore, the y-intercept is 1.
13
11
9
y=x
7
1
x
–13 –11 –9 –7 –5 –3 –1 1 3 5 7 9 11 13
–1
–3
–5
–7
–9
–11
–13
The equation of a straight line that passes through the origin is y = mx as the y-intercept
in this case is 0. This is shown in Figure 4.
62 © ABE
Algebraic Methods Chapter 2
y = mx + c
y − c = mx
mx = y − c
( y − c)
m=
x
We can also find the gradient of a straight line by using the formula:
Change in x
Gradient = Change in y
(y2 − y1)
m=
(x2 − x1)
Where,
y1and y2 are two points on the y-axis and x1 and x2 are corresponding points on the x-axis.
CASE STUDY 5
Jiang’s assignment on the equation of a
straight line
Jiang’ is doing an assignment on equations of straight lines.
He wants to determine the gradient and y-intercept in the
equation 2y − 5x = 8
The equation 2y − 5x = 8 is not currently in its general form and should be put in the form
y = mx + c to determine the gradient and y-intercept. For this, Jiang should transpose all terms
except y to the right-hand side of equation
2y − 5x = 8
2y = 8 + 5x
8 + 5x
y=
2
y=4+5x
2
y=5x+4
2
Therefore, the gradient = 5 and y–intercept = 4.
2
© ABE 63
Chapter 2 Algebraic Methods
Over to you
Activity 14: Gradient and y-intercept of an equation of a straight line
Consider an example. The gradient of a straight line is − 12 and the y–intercept is 35 . The equation for
a straight line that can be derived from the available information is:
y = −1x + 3
2 5
Over to you
Activity 15: Deriving the equation of a straight line
Derive the equation of the straight line for each of the following:
1 Gradient = 1
6
and y-intercept = –5
2 y = 1 and m = 0.7
64 © ABE
Algebraic Methods Chapter 2
In this case, Jiang knows the gradient of the line but does not know its y-intercept. This equation
can be easily derived in two steps.
Step 1: In the equation of a straight line put m = 1 and use the co-ordinates of the given point for x
3
and y. This will help derive c, the y-intercept.
y = mx + c
x = 4, y = 3, m = 1
3
Therefore,
3=1×4+c
3
3−4=c
3
c= 5
3
Step 2: Insert the values of the gradient (m) and y-intercept (c) in the general equation of a straight
line to get the required equation.
y = mx + c
y = 1x + 5
3 3
© ABE 65
Chapter 2 Algebraic Methods
y2 − y1
y − y1 = (x − x1)
x2 − x1
y − y1 = m(x − x1)
y1 and y2 are two points on the y-axis and x1 and x2 are corresponding points on the x-axis.
This equation of a straight line can be derived from the co-ordinates of two points lying on it by
using the equation:
y − y1 x − x1
=
y2 − y1 x2 − x1
In this case,
y1 = 4, y2 = 5, x1 = 2, x2 = 3
Therefore,
y−4 x−2
=
5−4 3−2
y−4 x−2
=
1 1
y−4=x−2
y=x−2+4
y=x+2
Alternatively, the equation can be derived by using the equation y − y1 = m(x − x1).
In this example m = 5 − 4 = 1
3−2
Therefore, using (2,4), the equation will be:
y − y1 = m(x − x1)
y − 4 = 1(x − 2)
y−4=x−2
y=x−2+4
y=x+2
66 © ABE
Algebraic Methods Chapter 2
Over to you
Activity 16: Deriving the equation of a straight line
NEED TO KNOW
An algebraic term may be expressed as simply a letter or a combination of a number and a
letter.
An algebraic expression is a collection of algebraic terms used to express a relationship. It uses
integers, constants, variables and arithmetic operators to express a relationship.
Only like terms in an algebraic expression can be added or subtracted.
Like terms can be multiplied together by raising the product to the power of the number of
times the term appears.
Two expressions with the same base can be multiplied even if they have different exponents or
powers.
A term raised to the power of another term is denoted with the base raised to the power of the
product of the two exponents.
Unlike addition and subtraction, terms that are NOT like terms can also be multiplied and the
product is obtained by simply writing the terms being multiplied next to each other.
If one or more terms have coefficients greater than 1, then coefficients are multiplied and the
resulting value is written before the product of the letters.
Algebraic terms can be easily cancelled out while dividing.
© ABE 67
Chapter 2 Algebraic Methods
Two expressions with the same base but different exponents can be divided by each other by
simply taking the difference between the exponents.
A term having a negative exponent can be expressed as its reciprocal with a positive exponent.
It is a good practice to simplify all terms within the brackets as much as possible. This makes the
algebraic expression more manageable. There are rules that apply to brackets in algebra.
An algebraic equation is a mathematical statement that depicts the equality of two expressions.
The two sides should always be equal for the equation to stay true or valid. If any change of
variables or constants is done on one side of the equation, the same change should also be
done on the other side of the equation.
Algebraic equations have unknown values that can only be known after the equation is solved.
A linear equation is an equation which has one or more variables.
Two properties of a linear equation are:
• the maximum power of each variable is one;
• when plotted on a graph, the equation gives a straight line.
The two equations used to arrive at the answer to the two unknown variables are called
simultaneous equations.
There are two methods of solving simultaneous equations: Elimination method and substitution
method.
Under elimination method, one of the variables is removed from the two equations. This is
based on the premise, that if the relationship shown in the two simultaneous equations is true,
then any equation that is derived from this relationship is also true.
Under substitution method, the value of one variable is stated in terms of the second variable.
The value derived for the first variable is then used in the second equation. This eliminates the
first variable in the second equation and leaves a linear equation in single variable.
Quadratic equations are formulated from quadratic expressions. A quadratic expression is an
algebraic expression in which the highest power of a variable is 2.
Quadratic equations can be solved using the factorisation method. The basic premise of the
factorisation method is that if the product of two terms is zero, then either one or both of the
terms must also be equal to zero.
At times it is not easy to factorise all quadratic expressions. In many cases we need to use the
quadratic formula to solve the equations.
A linear equation when plotted on a graph always gives a straight line and takes the form of
y = mx + c
In cases when both gradient and y-intercept are given, put the given values of gradient and
y–intercept in the general form of the equation of a straight line, that is, y = mx + c.
The equation of the straight line that passes through two given points can be written as:
y − y1 x − x1
=
y2 − y1 x2 − x1
68 © ABE
Algebraic Methods Chapter 2
READING LIST
ABE (2017). Introduction to Quantitative Methods. ABE. ISBN 978-1-911550-13-6
Huettenmueller, R. (2011). Algebra DeMYSTiFieD. McGraw Hill Education, 2nd Ed. ISBN 978-
0071743617
Larson, R.E. and Hodgkins, A.V. (2011). College Algebra with Applications for Business and Life
Sciences. Brooks/Cole; 2nd International edition. ISBN 978-0547052694
READING RESOURCES
BBC KS3 Bitesize (2017). Algebra. BBC website, available at http://www.bbc.co.uk/bitesize/
ks3/maths/algebra/
© ABE 69
Chapter 3
Business Statistics
Introduction
Statistics is all about data. There are two important aspects related to data. The first is that data
is not always in the form of numbers. The second is that for many problems, data is obtained
only from a sample of a large population, and then it is used to extract meaningful information
for making decisions. This chapter will focus on three topics. First, it will examine the various
sources from which data can be obtained, the types of data, and its use in business. Next it will
explore sampling techniques involved in data collection. Finally, it will discuss the classification and
tabulation of collected data.
Learning outcome
After completing this chapter, you will be able to:
3 Discuss the process of gathering business and management data (Weighting 25%)
Assessment criteria
3.1 Explain main sources, types and uses of data relevant for business and management
information
3.2 Evaluate alternative methods of sampling and measurement scales used in context of
business information
3.3 Classify and tabulate statistical data
© ABE
Level 4
Introduction to
Quantitative Methods
Data in statistics
Statistics is a specialised branch of mathematics consisting of methods that are used to
systematically collect, organise and analyse data with the aim to get meaningful information that
can be used for decision-making.
The branches are tightly integrated. Inferential statistics draws upon the methods of descriptive
statistics. Data is the core of statistics.
There are important factors to consider before you undertake a statistical study:
• state the objective clearly
• define the scope of research
• the required accuracy of data.
The stages of a statistical study are depicted in Figure 1. Collection and classification of data is
discussed in Chapter 3. Analysis of data and presentation of results will be discussed in Chapter 4.
Classification of
Objective of Collection of Analysis of Presentation of
data (tabular
statistical study data data results
presentation)
© ABE 71
Chapter 3 Business Statistics
CASE STUDY 1
David and Fatima’s research study
David is a university student. He learns from a
newspaper article titled “The age of fast fashion”
that 80% of university students buy at least one
item of casual clothing every week. According to
the report, 70% students consider price as the
most important factor when they shop for clothes,
and only 30% of students consider style and
design as a more important factor than price. He
shares this information with his classmate, Fatima.
Both agree to undertake similar research on their
own university campus.
David and Fatima need information on how students in their university buy items of casual
clothing and the importance they give to factors such as price, style, and design while making a
purchase. For this they will need to collect data.
Data plays an important role in the functioning of a society. Individuals, business organisations
and governments receive data on a regular basis and use it for decision-making. There are many
definitions of data.
The Economic Commission for Europe and United Nations (UNECE) gives a more elaborate definition:
Data is facts that can be either numbers or attributes. When data is collected for the first time, it
is raw and unorganised. Decisions cannot be taken with raw data. Therefore, it is important to
organise and process raw data into information before it can be used for decision making.
Let’s look at Table 1, showing sales of t-shirts in a shop. It has examples of data that can be
processed to obtain information. On analysis, the shop owner learns that:
• 14 customers purchased polo t-shirts today. He learns this only after he has counted the sales
invoices;
72 © ABE
Business Statistics Chapter 3
• blue coloured t-shirts have maximum sales. He learns this only after he has organised a large
number of sales invoices for a certain period of time.
The shop owner can use this information to make a decision on what colours of t-shirts to stock.
Over to you
Activity 1: Data and information
Make a list of data that can be gathered from a monthly mobile phone bill. What useful
information can be gained after this data is analysed?
Sources of data
Let’s look at David and Fatima’s research study (in case study 1). The initial source of data for
David was a newspaper. Data obtained from such pre-existing published or unpublished sources is
called secondary data. Other sources of secondary data include journals, government reports,
television news, and articles on the internet.
Now David and Fatima want to do similar research in their university. Therefore, they decide to
collect data directly from the university students who are now the subject of their statistical study.
This original data that they will be collecting is called primary data. Sources of primary data in a
business context are surveys of customers, employees and suppliers with the aid of questionnaires,
focus groups, personal interviews, and direct observations.
The differences between secondary and primary data are presented in Table 2.
© ABE 73
Chapter 3 Business Statistics
Questionnaires are widely used for a variety of surveys. These include market research, government
censuses and opinion polls. A focus group is a specific type of group interview used for understanding
customer attitudes and perceptions, and also testing new product concepts.
The Organisation of Economic Co-operation and Development (OCED) defines a focus group as:
Over to you
Activity 2: Primary and secondary data
Classify these examples as primary data or secondary data.
1 J ohn checked the bills and counted the number of customers who had placed an
order for a chicken burger at the counter.
2 A
hmed likes gaming apps. He checks a website to find out the list of apps that have
received a rating of 5 stars.
3 N
ancy takes the heights of her classmates at school and makes a record of their
measurements.
4 L
i Wei checks a website to find out the value of Chinese exports to the United
Kingdom in 2015 and 2016.
Data
(according to source)
Primary data
Secondary data
(collected from questionnaire surveys,
(collected from newspapers,
personal or telephone interviews,
government reports, census, journals)
focus groups)
74 © ABE
Business Statistics Chapter 3
Quantitative data is further classified into discrete data and continuous data.
Shoe size is a notable exception of discrete data that can have a fractional value.
For example, a shoe size of 4½ is discrete quantitative data.
The time (in minutes and seconds) spent by one customer in the shop.
This can take many values: 15.2 or 15.23 or 15.235 or 15.2354 and so on.
It is evident that all fractional values of time in quantitative continuous data make sense. The same
is not true for discrete data; the value 2.35 clothes has no meaning.
The differences between discrete and continuous data are presented in Table 3.
Variables
Table 4 gives data for the number and colour of t-shirts bought by six customers. In this table, the
value ‘3’ for customer A will have a meaning only if it relates to the characteristic ‘number of t-shirts’.
Similarly, the colour ‘blue’ has meaning only when it relates to the characteristic ‘colour of the t-shirts’.
These characteristics are called variables because their data values keep changing for each subject.
A researcher can collect data for a single or multiple variables.
© ABE 75
Chapter 3 Business Statistics
Variable: Variable:
Customers
Number of t-shirts bought Colours of t-shirts bought
Customer A 3 Blue
Customer B 2 Red
Customer C 5 Yellow
Customer D 2 Grey
Customer E 1 Green
Customer F 4 Purple
• Variables for which numeric data is collected are called quantitative variables; for
example, number of t-shirts.
• Variables for which non-numeric data is collected are called qualitative variables; for example,
colours of t-shirts bought.
Data values collected for a variable from several customers when presented together are called a
data set. In this case, two data sets are obtained.
• The numeric data set {3, 2, 5, 2, 1, 4} for the quantitative discrete variable ‘number of t-shirts
bought’.
• The categorical data set {red, blue, yellow, grey, green, purple} is for the ‘colour of t-shirts
bought’, which is a qualitative variable.
Customers
(variables about purchase of
casual clothes)
3 2 5 2 1 4 C C C C C C
76 © ABE
Business Statistics Chapter 3
Types of variables
Types of Variables
Over to you
Activity 3: Types of data
Alia wants to buy a fashionable case for her new mobile phone. She visits an online
shop. State which type of data Alia will get from each of the questions below.
1 What different types of materials are cases available in?
2 What is the price for each type of case?
Over to you
Activity 4: Discrete and continuous data
The owner of a retail outlet wants to find out the number of items sold last month.
Is this data discrete or continuous?
© ABE 77
Chapter 3 Business Statistics
Over to you
Activity 5: Discrete and continuous data
Over to you
Activity 6:
Refer to Case study 1. If you’re studying with others, form groups of two students in
your classroom.
1 L
ist down examples of 10 questions that will help David and Fatima to collect
qualitative and quantitative data for getting the complete picture of their
population’s shopping habits and preferences for clothes.
2 Classify your examples of quantitative data into discrete and continuous.
3 A
lso mention the method that you will use for data collection and state the reason
for choosing your method.
The aim is better decision-making and superior organisational performance. Some information is
also shared with the investors and government. Figure 5 depicts the various kinds of data generated
in a business organisation (in rectangles) and some examples of its use (in the central circle).
Since the arrival of computers, it takes less human effort to process large volume of data. However,
interpretation and communication of data requires people with special skills.
78 © ABE
Business Statistics Chapter 3
Sales data
Examples
• Sales
• Quantity and amount
• Number of items
Production data Marketing data
Examples Examples
• Inventory • Customer preferences
• Stock • Advertising costs
• Variable cost • Dealer incentive
Advertising budget
Debt recovery
Pricing policy
Forecasting
Stock levels
Wage policy
Human resource data Financial data
Examples Examples
• Worker productivity • Cost of sales
• Industry salary norms • Rent
• Employee attitude • Debtors
The subject of a statistical study is called the population. This population can be people, objects or
institutions. In David and Fatima’s research study, the population is 6000 students studying in their
university. Gathering data from a large population like this is both time-consuming and costly. A
practical way to collect data is to select a subset of this population. This subset is called a sample.
Data collected from a sample is organised and analysed with the application of statistical methods
with the aim to draw conclusions about the population.
© ABE 79
Chapter 3 Business Statistics
You can see the sampling process in Figure 7. The key terms are explained in Table 5.
Key terms
Census This is the act of collecting data from every person or about every
object present in a national geography. A government of a country
conducts this kind of large-scale survey.
Population This is the complete set of people or objects that is the subject of
statistical study.
Example: Students studying in a university.
Parameter This is the numerical property of a population.
Sampling unit This is the most fundamental building block of a sample. This can
be either an individual or an object that can be counted, measured
or observed for a statistical study.
Sample This is an appropriately sized subset of the population from which
data is collected to draw true and unbiased conclusions about the
population under study.
Example: A sample of students on the campus.
Frame This is a published source on population that is the subject of
statistical study. A frame may not list the complete population, but
is often used for selecting a sample.
Examples: A directory of schools; or a telephone directory of listed
households in a city.
80 © ABE
Business Statistics Chapter 3
Over to you
Activity 7: Census
1 Find out when was the last time a census was conducted in your country.
2 List five key items of information that are produced by a census.
It is important to define the population and sample before data collection is initiated. The
researcher should decide a sample carefully. According to Newbold, Carlson and Thorne (2012: 7),
the key factors to consider in making sample choices are:
• objectives of the study;
• nature and definition of population;
• research design considerations;
• availability of resources;
• ethical and legal considerations.
The size of the sample is an important consideration in research. Sample size should be optimum,
i.e. neither too small nor too large. It is determined by two factors:
• Cost – a sample size that is larger than required can be expensive.
• Precision – a sample size, if smaller than required, may fail to give true picture of the population.
The key differences between random and non-random sampling is presented in Table 6.
© ABE 81
Chapter 3 Business Statistics
Random and non-random sampling can be applied with various techniques presented in Table 7.
CASE STUDY 2
Chen’s research
Chen has been asked to carry out research on
the companies based in a local industrial park.
The objective of the research is to understand
the methods of recruitment that these companies
prefer to use for attracting entry-level employees,
for example, job advertisements, recruitment
consultants, university campus visits, referrals, etc.
82 © ABE
Business Statistics Chapter 3
Chen aims to collect data from eight organisations with the aid of a questionnaire. He decides to
use random sampling technique that gives all subjects (in this case organisations) in the frame equal
probability of being included in the sample. The steps involved in selecting the sample are:
1 List all members in the frame, numbering them from 1 to 40.
2 Use the random number function on a scientific calculator or spreadsheet software to generate
a random number between 1 and 40.
3 Select the subject whose number matches the random number and add it to the sample list.
4 Repeat this, seven more times. Ignore any number that is repeated, and generate a
new number.
For example, if the random numbers generated are: 25, 6, 35, 40, 20, 11, 29, 31, then the subject
selected as sample from the frame are:
Systematic sampling
This is a sampling technique in which the sample is made of subjects that are placed at equal
intervals. If the required sample size is 8 and the given frame has 40 subjects, then the selection of
8 subjects will be determined by:
1 the first sampling unit selected randomly;
2 an appropriate interval k determined by the formula k = N/n (where N is the size of the frame,
and n is the sample size).
In this case, the frame size is 40 and the sample size is 8, therefore, the interval is 5. If number 2 is
the starting number, then the numbers selected for sample will be:
This implies that the subjects that will make up the sample include:
© ABE 83
Chapter 3 Business Statistics
Let’s look at Chen’s research (Case study 2) again. Chen realises that his frame has two subgroups:
• 12 organisations that are small and medium enterprises (SMEs) with less than 250 employees;
• 28 organisations that are large organisations with more than 250 employees.
Chen decides to use stratified random sampling for greater accuracy. He aims to collect data for
understanding:
1 the methods that organisations prefer for entry-level recruitment;
Chen aims to select a sample of eight subjects (organisations), with four sampling units from each
sub-group.
The steps involved in selecting the sample are:
1 Divide the population or the frame into two subgroups or strata according to a specific attri-
bute. In this example, the attribute is size of the organisation.
2 Organise the two subgroups and number each subject in each subgroup. For example, for stra-
tum one comprising of 12 SMEs, number the subjects from 1 to 12, and for stratum two, com-
prising of 28 large organisations, number the subjects from 1 to 28.
3 Apply simple random sampling technique on each stratum. In this context, generate four ran-
dom numbers between 1 and 12 for stratum one, and, generate four random numbers between
1 and 28 for stratum two.
4 Select the organisations that correspond to the random numbers for each stratum.
Stratum one
random sample
(4 sampling units) SAMPLE
FRAME
(40 units)
random sample
(4 sampling units)
Stratum two
84 © ABE
Business Statistics Chapter 3
The biggest advantage of a stratified sampling technique is that it has a greater chance of
representing the population than both simple random and systematic random sampling.
This reduces the sampling error. However, the disadvantages are that it is costly and time consuming.
Cluster sampling
This sampling technique is also called area sampling. The population is divided into clusters that are
natural miniatures of the population. Each cluster has all kinds of members.
Let’s look at Chen’s research (case study 2) again. Instead of considering one industrial park in his
town as his population, Chen redefines the population for his study as all the industrial parks at various
locations within his region. He further defines each industrial park as one cluster. For example, if there
are six industrial parks in Chen’s region, then the population is made up of six clusters. He further
defines his sample size as any ten organisations from any two clusters, i.e. five sampling units from each
cluster. He then decides to apply a simple random sampling technique for selecting his sample.
2 Use the simple random sampling technique to generate two random numbers between 1 and 6.
Select the industrial parks whose number matches the random numbers.
3 Apply the simple random sampling technique again to randomly select five organisations from
each of the two selected clusters.
4 Collect data from the selected subjects within the two clusters.
The difference between stratified sampling and cluster sampling is depicted in Figure 9.
© ABE 85
Chapter 3 Business Statistics
Over to you
Activity 8: Sampling techniques
Bilal is conducting research through which he wants to understand whether male and female
school teachers adopt different teaching styles. His population consists of 12 schools in his small
town. What sampling technique has been used by Bilal for the following two approaches?
1 H
e decides to select a sample with equal numbers of male and female teachers from
all the 12 schools.
2 F
rom the 12 schools, he decides to interview all teachers of only two schools, A and B.
School A is a boys’ school with all male teachers. School B is girls’ school with all female
teachers.
Quota sampling
In this approach to sampling, the population is divided into strata. However, instead of random selection
of sampling units from each stratum, the sample is selected in a non-random manner. A quota is fixed
for each stratum. The quota may be decided according to the proportion of the strata within the
population. The researcher aims to collect data from each stratum according to the assigned quota.
Quota sampling is a non-random variation of stratified sampling. It is less expensive than stratified
sampling because it is easier to manage. Quota sampling is widely used for opinion polls.
Percentage
Irish
White1 Gypsy or Irish Traveller
Other White
Indian
Pakistani
Asian/Asian
Bangladeshi
British
Chinese
Other Asian
Black/ African
African/
Caribbean
Caribbean/
Black British Other Black
86 © ABE
Business Statistics Chapter 3
Let’s look at Figure 10. The population is divided according to ethnic groups. The researcher
assigns the quota as: White (100 sampling units); Asian British (45 sampling units); and Black British
(35 sampling units).
The data, when it is analysed, gives information about each subgroup, and the whole population.
Convenience sampling
As the name suggests, the researcher’s convenience determines what sampling units are selected.
According to Black (2009), convenience is based on three factors:
• availability
• proximity or accessibility
• willingness of the sampling unit to participate.
Judgement sampling
Professional researchers often use their earlier experience and judgement to select a sample. The
main aim of using non-random judgement sampling is to save time and money. However, if the
researcher’s judgement is not balanced, there is a risk of bias.
Two similar but independent statistical studies that use judgement sampling can produce very
dissimilar pictures of the population.
Snowball sampling
This is an inexpensive way of sampling in which one sampling unit leads the researcher to the next
sampling unit through reference. The premise of this technique is that referrals are likely to be both,
accessible and willing to participate in the survey.
Let’s look at the David and Fatima’s research study (case study 1) again. If David and Fatima use
snowball sampling technique, then their sample will be selected as:
1 Interview the first student who is willing to respond to their questionnaire.
2 After collecting data, ask the student to suggest names of friends who buys casual clothing, and
would be willing to answer their questions.
4 Ask the interviewees for more referrals and repeat the process till sample size is achieved.
Bias is a consequence of adopting a practice that distorts data and therefore leads to an untrue
picture of the population. Bias is a non-random, systematic error. Examples include: interviewer
bias, error in recording, questionnaires that are not well-designed, measurements that are not
carefully taken, respondents who do not answer truthfully.
© ABE 87
Chapter 3 Business Statistics
Appraoches to sampling
Measurement scales
Now look at Figure 12. There are four different questions, which, when answered by a respondent,
help in taking measurements.
88 © ABE
Business Statistics Chapter 3
1 2 3 4 5 Response:
• Term 1 3
• Term 2 9
• Term 3 6
This kind of data measurement scale used for classification is called nominal level data measurement.
• Question Two: Let us suppose that the respondent ranks the subjects as shown in Figure 12.
By ranking the three subjects, the respondent is only indicating his preference. This kind of
measurement clearly shows that the respondent prefers business statistics to marketing, and
marketing to human resources. However, the ranking does not tell us whether the degree of the
respondent’s preference for any two subjects is equal.
The data measurement scale that is used for ranking elements is termed as ordinal level data
measurement.
• Question Three: You can see that the scale that the respondent will use to rate the business
statistics lecture in this example has equal intervals. The data is numeric. This implies that
ranking of lecture is measurable with this scale.
An important feature of interval level data measurement is that zero is just one of the many
intervals. A good example of this measurement is the temperature scale with which readings are
taken at every degree change in temperature. Zero degree is not the lowest value on this scale
because there are negative and positive temperature intervals on either side.
• Question Four: It is understood that no student can get books issued from the library less
than zero times. Therefore, the value zero has significance in this measurement scale. It is a
fixed point that gives meaning to other data values. A value can also be expressed as a ratio of
another value and therefore data can be interpreted meaningfully. For example, in term three,
the library was used twice as much as in term one for getting textbooks.
© ABE 89
Chapter 3 Business Statistics
Over to you
Activity 9
This chapter will focus on classification and presentation of data using tables. Presentation of data
using charts and diagrams, and analysis of data will be discussed in Chapter 4.
90 © ABE
Business Statistics Chapter 3
Let’s look at the David and Fatima’s research study (case study 1) again. David and Fatima collected
raw data from a mix of male and female respondents. They arranged the questionnaires filled with
responses in alphabetical order. The numeric data against each name represents “the number of
clothes bought” by the respondents for their own use in the last three months.
Ahmed Male 7
Alice Female 7
Asha Female 6
Ben Male 1
Elizabeth Female 14
George Male 5
Jodie Female 7
John Male 10
Julie Female 9
Kartik Male 5
Li Na Female 12
Nancy Female 11
Paul Male 4
Roger Male 6
Samir Male 5
Stella Female 8
Sue Female 8
Zoya Female 8
Simple classification
David and Fatima use simple classification to construct a table. The classification is based on the
number of clothes that were bought by male and female students. The data is presented in Table 8.
© ABE 91
Chapter 3 Business Statistics
Male students 43
Female students 90
Total 133
Complex classification
David and Fatima have also collected data on the type of casual clothes that the student bought.
Two of the clothing items are t-shirts and jeans. You can see the raw data for number of t-shirts
(column 3) and jeans (column 4) bought in the last three months below.
Ahmed Male 5 2
Alice Female 4 3
Asha Female 4 2
Ben Male 1 0
Elizabeth Female 10 4
George Male 4 1
Jodie Female 5 2
John Male 7 3
Julie Female 6 3
Kartik Male 3 2
Li Na Female 10 2
Nancy Female 6 5
Paul Male 2 2
Roger Male 5 1
Samir Male 4 1
Stella Female 6 2
Sue Female 4 4
Zoya Female 3 5
David and Fatima use complex classification to construct a two-way table that gives information on
the number of t-shirts and jeans bought (variable 1) by male and female students (variable 2). You
can see the data in Table 9.
92 © ABE
Business Statistics Chapter 3
Female students 58 32 90
Total 89 44 133
Over to you
Activity 10: Two-way tables
Jiao and Waheeda are conducting research on the gaming market. They decide to
randomly interview 20 young male adults and 20 young female adults. They find that
13 males play games only on their mobile phones and 7 males play games only on
their gaming consoles, while 15 females play games only on their mobile phones and 5
females play games only on their gaming consoles.
Prepare a two-way table to present this data.
Types of classification
© ABE 93
Chapter 3 Business Statistics
Frequency distribution
Frequency distribution is tabular classification of data for large data sets. A frequency distribution
table shows the number of times (or frequency) a variable takes each of its data values.
Ahmed 4 Kartik 4
Alice 6 Li Na 4
Asha 7 Nancy 4
Ben 4 Paul 3
Elizabeth 4 Roger 3
George 5 Samir 4
Jodie 6 Stella 5
John 4 Sue 5
Julie 4 Zoya 6
3 || 2
4 |||| |||| 9
5 ||| 3
6 ||| 3
7 | 1
Total 18
94 © ABE
Business Statistics Chapter 3
The table shows maximum tally marks against 4. This implies that the variable “number of shopping
trips” takes the data value 4 nine times. In other words, the maximum number of respondents made
4 shopping trips for buying clothes.
David and Fatima have collected data on “the number of clothes bought” by the respondents for
their own use in the last three months.
Ahmed 7 Kartik 5
Alice 7 Li Na 12
Asha 6 Nancy 11
Ben 1 Paul 4
Elizabeth 14 Roger 6
George 5 Samir 5
Jodie 7 Stella 8
John 10 Sue 8
Julie 9 Zoya 8
1–3 | 1
4–6 |||| | 6
7–9 |||| || 7
10 – 12 ||| 3
13 – 15 | 1
Total frequency 18
© ABE 95
Chapter 3 Business Statistics
Let us look at the grouped frequency distribution presented in Table 11. When you divide the range
of values in raw data into groups, the grouped frequency table acquires a structure. The specific
elements of this table structure are:
• Class: This is the group of data values. In this example, six classes have been created:
As a thumb rule, the number of classes should be between 5 and 10. The reason you would not
have less than 5 or more than 10 classes is that it becomes difficult to draw conclusions.
• Class interval: The range of data values in a class. In this example, the class interval is 3.
• Class frequency: The number of instances (items) that fall within a class interval. This can be
easily determined with the use of tally marks. In this example, class frequency for the class
interval 4–6 is 6.
• Class limits: The lowest and highest values in a class. In this example, the class limits for class 1–3
are 1 (lowest value) and 3 (highest value).
• Total frequency: The total number of instances for all observations (sample). In this example,
total frequency is 18.
This table gives some meaningful information. For instance, with a quick look, we understand that
the maximum number of instances is in the 7–9 group. Broadly, this means that more than one-third
of respondents have purchased 7 to 9 items of clothing in the past three months.
It is a good practice that, wherever possible, a frequency distribution table should have equal classes.
This is helpful for comparison. However, in cases where there are only a few instances in the upper or
lower ends (also called outliers), these class intervals may be combined to avoid too many classes.
Over to you
Activity 12: Classification and tabulation
Jiao and Waheeda also collected data on the number of games bought in the past month by
40 respondents.
2 6 14 6 7
8 9 7 9 9
2 6 8 2 12
3 2 15 10 8
7 4 20 18 19
4 10 4 3 6
18 17 1 6 4
6 3 6 5 1
1–3 1 1
4–6 6 7
7–9 7 14
10 – 12 3 17
13 – 15 1 18
Total frequency 18
From the cumulative frequency column in Table 12, you can see that 14 out of 18 respondents have
bought up to 9 items of clothing in the past three months.
Cumulative frequency distribution is useful for understanding how many items are equal to a
specified value (for ungrouped data), and also less than or up to or more than a specified value (for
grouped data).
1–3 1 5 1 5
4–6 6 34 7 39
7–9 7 39 14 78
10 – 12 3 17 17 95
13 – 15 1 5 18 100
From the relative frequency column in Table 13, you can see that 78% of respondents have
bought up to 9 items of clothing in the past 3 months.
© ABE 97
Chapter 3 Business Statistics
Over to you
Activity 10: Frequency distribution table
Jiao and Waheeda have also collected data on the number of games bought in the past month
by 40 respondents.
2 6 14 6 7
8 9 7 9 9
2 6 8 2 12
3 2 15 10 8
7 4 20 18 19
4 10 4 3 6
18 17 1 6 4
6 3 6 5 1
NEED TO KNOW
Statistics is a specialised branch of mathematics consisting of methods that are used to
systematically collect, organise and analyse data with the aim to get meaningful information
that can be used for decision-making.
There are two branches of statistics: descriptive statistics and inferential statistics.
There are important factors to consider before a statistical study is undertaken: Stating
the objective clearly, defining the scope of research and specifying the required accuracy
of data.
Data is the physical representation of information in a manner suitable for communication,
interpretation or processing by human beings or by automatic means.
Data obtained from pre-existing published or unpublished sources is called secondary data.
Other sources of secondary data include journals, government reports, television news, and
articles on the internet.
The original data that is collected for a research is called primary data. Sources of primary
data in a business context are surveys of customers, employees and suppliers with the aid of
questionnaires, focus groups, personal interviews, and direct observations. Questionnaires
are widely used for a variety of surveys.
Secondary and primary data can be either quantitative or qualitative. Quantitative data are
numeric observations, and qualitative data are non-numeric (or categorical) observations.
Quantitative data is further classified into discrete data and continuous data.
A variable is any characteristics, number, or quantity that can be measured or counted.
A variable may also be called a data item.
Smart managers understand the new environment within which a business exists and use the
large volume of data generated each day to take decisions.
The subject of a statistical study is called the population. This population can be people,
objects or institutions.
98 © ABE
Business Statistics Chapter 3
Gathering data from a large population is both time-consuming and costly. A practical way is to
collect data from a sample.
Data collected from a sample is organised and analysed with the application of statistical
methods with the aim to draw conclusions about the population.
The key factors that should be considered in making sample choices are: objectives of the
study, nature of the population, definition of the population, research design considerations,
availability of resources and ethical and legal considerations.
There are three key approaches to sampling: random sampling, mon-random sampling and
mixed sampling.
Random sampling techniques include simple random, systematic, stratified random sampling
and cluster (or area) sampling.
Non-random sampling techniques include quota, convenience, judgement and snowball sampling.
Sampling error is the consequence of selecting a sample whose measurement offers a result
that does not reflect the true picture of the population characteristic being studied.
Sample size should be optimum. It is determined by two factors: cost and required precision.
Measurement scales for categorising different types of variables include nominal level, ordinal
level, interval level and ratio level.
Meaningful information and conclusions can be drawn from this data only after it is classified,
presented in the form of tables or charts and diagrams and analysed.
Classification of data is the act of arranging items in groups according to their similarity. Simple
classification and complex classification are two key ways of classifying data.
A two-way table is the result of complex classification of data in rows and columns that gives
information about two inter-related variables.
Frequency distribution is tabular classification of data for large data sets. A frequency distribution
table shows the number of times (or frequency) a variable takes each of its data values.
Reading List
Anderson, D.R.; Sweeney, D.J.; Williams, T.A.; Freeman, J. and Shoesmith, E. (2014).
Statistics for Business and Economics. Cengage Learning, 3rd Ed. ISBN 978–1408072233
Burton, G.; Carroll, G. and Wall, S. (2001). Quantitative Methods for Business and
Economics. Financial Times/Prentice Hall, 2nd Ed. ISBN 978–0273655701
Silver, M. (1997). Business Statistics. McGraw Hill Education, 2nd Ed. ISBN 978–
9780077092252
Resources: Books
Weiss, N.A. (2013). Introductory Statistics. Pearson, 9th Ed. ISBN 978–1292022017
Sources: Websites
Australian Bureau of Statistics Website (2017). Statistical Language – Quantitative
and Qualitative Data. http://www.abs.gov.au/websitedbs/a3121120.nsf/home/
statistical+language
OCED Website (2013). Glossary of Statistical Terms. https://stats.oecd.org/glossary/index.htm
© ABE 99
Chapter 4
Statistical Tools and
Data Analysis
Introduction
Chapter 3 introduced you to data, which is the core of statistics. You also saw that raw data is just
unorganised numbers or attributes. Raw data becomes useful for drawing meaningful conclusions
only after it is processed, summarised and presented. This chapter will begin by taking a step
towards visual presentation of data in the form of charts and graphs.
The first section in this chapter will focus on analysis of data by using descriptive statistics.
We will also learn to determine correlation between variables and use linear regression for
forecasts. It is important that you understand classification and tabulation of data and also
various charts and graphs before you begin the section on data analysis.
Learning outcome
4 Analyse data using statistical tools and interpret the results. (Weighting 25%).
Assessment criteria
4.1 Construct and interpret appropriate charts and diagrams from tabular data
4.2 Employ a set of descriptive statistics for analysis and interpretation of grouped and
ungrouped data
4.3 Determine correlation between two business variables
4.4 Perform linear regression to make business forecasts
© ABE
Level 4
Introduction to
Quantitative Methods
The downside of using graphs is that information presented may not be completely accurate and
consistent with the original data. For this reason, a conclusion drawn from a chart or graph may be
inconclusive.
You should present charts and graphs for easy reading and interpretation. You can follow these
rules or guidelines.
1 Title: a chart or graph should have a meaningful, yet brief, title.
2 The axes: Label both, horizontal x-axis (also called abscissa) and vertical y-axis (ordinate)
properly.
3 Scale: Find a suitable scale for both axes.
4 Data values: Plot these points carefully to reflect information correctly.
5 Legends: You should provide these where needed and define scales wherever required.
However, avoid excessive details within the chart or graph as it reduces its clarity.
6 Data: supplement the chart or graph with data on which it is based.
The components discussed above are essential for creating meaningful charts and graphs.
Following these rules brings clarity and reduces ambiguity in the information being presented. You
can see the components depicted in Figure 1.
© ABE 101
Chapter 4 Statistical Tools and Data Analysis
Dependent variable
(units)
10000
8000
6000
4000
2000
0
Quarter 1 Quarter 2 Quarter 3 Quarter 4 Independent variable (units)
Axis with Quarters Axis label
scale
There are two broad categories of charts and graphs. These are:
1 Qualitative data charts and graphs
2 Quantitative data charts and graphs
There are various formats of these two types. These are listed in Table 1.
Qualitative data charts and graphs Quantitative data charts and graphs
(Constructed from a nominal or ordinal (Constructed from an interval or ratio scale
scale of measurement) of measurement)
• Bar chart • Histogram
• Scatter diagram*
Let’s understand the other charts and graphs with the help of case study 1.
102 © ABE
Statistical Tools and Data Analysis Chapter 4
CASE STUDY 1
Chikelu’s ice cream shop
Bar chart
A bar chart is also called a bar graph. Three commonly used formats for a bar chart are:
• Simple bar chart;
• Multiple bar chart;
• Component bar chart.
The lengths of the bars are in proportion with the size of the data category represented by them. In
other words, the length of each bar determines its value.
Bar Chart
Multiplar bar chart
(Vertical or Horizontal)
Let’s construct a simple bar chart for the three years’ data Chikelu has collected on his monthly
sales of ice cream. The data is presented in Table 2.
1 Add up the monthly sales for 2016 to get quarterly sales, as presented in Table 3.
4 Carefully construct vertical bars so that each bar corresponds to the correct values.
104 © ABE
Statistical Tools and Data Analysis Chapter 4
15000
Sales in ($)
10000
5000
0
Quarter 1 Quarter 2 Quarter 3 Quarter 4
Quarters
For example, with a simple bar chart created for the data presented in Table 2, Chikelu can
compare the quarterly sales for the four quarters in the year 2016.
© ABE 105
Chapter 4 Statistical Tools and Data Analysis
Sales (in $)
10000
8000
6000
4000
2000
0
Quarter 1 Quarter 2 Quarter 3 Quarter 4
Quarters
You can see from the bar chart that the ice cream shop experiences highest sales in Quarter 3. This
is a consistent pattern in the last three years. The chart also indicates that there is an increasing
trend in sales over the last three years in all quarters.
Quarter 4
Quarter 3
Quarters
Quarter 2
2016
2015
Quarter 4 2014
106 © ABE
Statistical Tools and Data Analysis Chapter 4
• the legend or key has been added to the graph to show the colours representing different quarters
• the height of each component (defined by the colour) in a bar represents its value or amount.
The components are drawn in the same order across all bars to facilitate comparison.
20000
10000
0
2014 2015 2016
Years
This is the difference between the top and bottom end of the coloured segment for Quarter 3.
Over to you
Activity 1
1 Refer to the data in Table 2 and construct a vertical multiple bar chart to show
Chikelu’s monthly shop sales in 2014, 2015 and 2016.
2 How would you interpret the bar chart you have drawn?
© ABE 107
Chapter 4 Statistical Tools and Data Analysis
Over to you
Activity 2: Component bar chart
Construct a component bar chart to compare the sales made by Chikelu in the summer
months (April–September) over the three years 2014, 2015 and 2016. (Extract data
from Table 2).
Pie charts
A pie chart is used for presenting categorical data. It also called a pie graph or circular diagram. It
resembles a round pizza or pie with slices of various sizes.
A pie chart is an appropriate diagrammatic tool when the numbers of items to be presented
are ideally not more than six. Each item is presented as a segment (or a slice), which is a certain
proportion of 360°. The slices denote either the value or percentage.
Since a pie chart is circular, it is a presentation of data in 360 degrees (360°). Therefore, in a
pie chart: total of values of all items = 360° = 100%
108 © ABE
Statistical Tools and Data Analysis Chapter 4
Follow the steps to create the pie chart for the sales data presented in Table 6.
Step 2: Convert the calculated percentages into degrees. Each value is a proportion of 360 degrees.
Total 42400
Step 3: Use the obtained values presented in Table 9 to construct an accurate pie chart.
© ABE 109
Chapter 4 Statistical Tools and Data Analysis
Table 8: Quarterly sales, percentage sales and corresponding degrees for 2016 Revision
on the go
The pie chart for absolute values of quarterly sales is shown in Figure 6. The same pie chart can also
present the data as percentage sales. This is shown in Figure 7.
$5800
$14000 Quarter 4
$6100 Quarter 3
Quarter 2
Quarter 1
$16500
110 © ABE
Statistical Tools and Data Analysis Chapter 4
14% 14%
Quarter 4
Quarter 3
Quarter 2
39% 33% Quarter 1
Over to you
Activity 3: Pie charts
Chikelu has his maximum sales in July each year. He wants to break down the $6000 sales for
July 2016 by flavour.
$ $
Vanilla 1100 Chocolate 1800
Strawberry 800 Raspberry 500
Butterscotch 1200 Coconut 600
2 Describe how you would interpret the pie chart you have drawn.
© ABE 111
Chapter 4 Statistical Tools and Data Analysis
Histograms
A histogram displays information in the form of vertical, rectangular bars. The key properties of a
histogram (‘histo’ is a Greek word for area) are:
• It presents data that is numerical, continuous and grouped. The data can be numbers (absolute
frequencies) or percentages (relative frequencies).
• The bars are contiguous (i.e. the bars touch each other). This is because a histogram presents
continuous data.
• Class boundaries are plotted on the horizontal axis (x-axis) and frequency is plotted on the
vertical axis (y-axis).
• The area of the rectangular bars denotes the frequency for the respective class intervals.
This gives rise to two possibilities:
1 When class intervals are equal, the width of the bars on the horizontal axis is equal.
2 W
hen the class intervals are unequal, the width and height of the bar for the greater class
interval changes, and the dimensions reflect an area that corresponds to the frequency.
0–20 5
20–40 15
40–60 16
60–80 45
80–100 40
100–120 15
120–140 8
140–160 6
112 © ABE
Statistical Tools and Data Analysis Chapter 4
Follow the steps given below to translate Table 9 into a histogram that has equal class intervals.
1 Draw the axes and define appropriate scales for both horizontal and vertical axes.
2 Plot the upper class boundaries of the classes (number of ice cream sold) on the horizontal axis.
3 Plot the frequencies (number of days) on the vertical axis.
4 Carefully construct vertical bars so that each bar corresponds to the correct value. Since the class
intervals are equal, and height of each bar should correspond to the respective frequency.
40
35
Number of customers
30
25
20
15
10
0
0 20 40 60 80 100 120 140 160
Waiting time (seconds)
Frequency (Col. B)
Number of standard widths (Col. D)
© ABE 113
Chapter 4 Statistical Tools and Data Analysis
In this example, the standard width is 2, therefore, frequency density implies frequency
per two units.
Temperature in February
12
10
Frequency Density
0
0 2 4 6 8 10 12 14
Temperature
Histograms
the width of the bars on the the width and height of the bar for
horizontal axis is equal. The the greater class interval changes.
dimensions reflect an area that The dimensions reflect an area
corresponds to the frequency. that corresponds to the frequency.
Revision
on the go
114 © ABE
Statistical Tools and Data Analysis Chapter 4
Over to you
Activity 4: Histogram
Mohammed, a human resource manager, asks 36 workers in the organisation how long it
takes them to travel from home to office. He collects the following data:
0 to 10 minutes 5
10 to 20 minutes 12
20 to 30 minutes 7
30 to 40 minutes 6
40 to 50 minutes 4
50 to 60 minutes 2
Frequency polygon
A frequency polygon is extracted from a histogram to show the pattern in frequency distribution of
grouped data. A frequency polygon is a line that joins the midpoints of the class intervals plotted
on a graph. The data presented in Table 11 is constructed as a frequency polygon in Figure 10.
Table 11: Grouped frequency data with class interval midpoints Revision
on the go
© ABE 115
Chapter 4 Statistical Tools and Data Analysis
40
35
30
Frequency
25
20
15
10
5
0
0
10 30 50 70 90 110 130 150
Time (seconds)
Let’s construct an ogive with the data obtained from Chikelu’s ice cream shop. The data is
presented in Table 12.
1–20 5 5
21–40 15 20
41–60 16 36
61–80 45 81
81–100 40 121
101–120 15 136
121–140 8 144
141–160 6 150
116 © ABE
Statistical Tools and Data Analysis Chapter 4
1 Draw the axes and define the appropriate scales for both horizontal and vertical axes.
2 Plot the upper class boundaries of the classes (number of ice creams sold) on the horizontal axis.
4 Carefully join the plotted points on the graph by drawing a line that passes through these points.
The ogive resulting from Table 12 is shown in Figure 11.
120
100
80
60
40
20
0
20 40 60 80 100 120 120 160
Number of ice-creams sold
Over to you
Activity 5: Frequency polygon
In December 2016, Chikelu sold only 480 ice creams in 26 days. His total sales for the month was
$1200. The daily unit sales is presented in Table 13.
11, 7, 12, 8, 17, 8, 25, 17, 15, 13, 24, 15, 6, 22, 9, 28, 33, 12, 15, 22, 31, 42, 45, 21, 13, 9
© ABE 117
Chapter 4 Statistical Tools and Data Analysis
1 Arrange all stems (leading digits) in a vertical column on the left in the ascending order of
magnitude. All items with the same leading digit are grouped within the same stem. For single
digit values, the stem is 0.
2 Arrange the leaf component (trailing digit) of each item horizontally in the column adjacent to its
corresponding stem. These are also arranged in ascending order.
3 Write down the key to communicate to the reader the meaning of stem | leaf
The stem and leaf diagram for Table 3 is shown in Figure 12.
Key: 2 | 8 implies 28
0 6, 7, 8, 8, 9, 9
1 1, 2, 2, 3, 3, 5, 5, 5, 7, 7
2 1, 2, 2, 4, 5, 8
3 1, 3
4 2, 5
• Where the maximum frequencies or occurrences lie, i.e. towards upper end or lower end. In this
example, the maximum occurrences are in 10 to 20 units.
• The value(s), which occur the most. In Figure 12, three days have recorded sales of 15 units,
making it the most frequently occurring units of ice cream sold in a day.
• The range of data, which in this example is from 6 units to 45 units, indicates a high variation in
the number of unit sold.
• All data values are used in getting the information. This reduces the loss of information, which
typically occurs in frequency distribution, because of using class midpoints for gaining information.
118 © ABE
Statistical Tools and Data Analysis Chapter 4
Over to you
Activity 6: Stem and leaf plot
Theiry is a heavy user of her mobile phone. She realises that her mobile phone bill has
increased significantly. She records the call durations of her calls in the past one week.
The data in minutes is:
4.6, 8.2, 7.5, 6.8, 4.5, 3.1, 9.3, 4.5, 5.2, 8.6, 6.8, 6.5, 9.7, 2.3, 1.5, 3.8, 5.5, 4.5, 1.8, 3.9
Draw a stem and leaf diagram to show the duration of calls made by Theiry. Interpret
the plot.
Ogive (Cumulative
Frequency Graph)
Scatter diagram
Revision
on the go
© ABE 119
Chapter 4 Statistical Tools and Data Analysis
Descriptive statistics was defined in Chapter 3. As the name suggests, this branch of statistics helps
to summarise a data set in a way that it truly represents either the entire population or its sample.
Descriptive statistics includes:
• measures of central tendency;
• measures of variability or spread or dispersion.
There are three measures of central tendency (or location). These are:
1 arithmetic mean (popularly called mean)
2 median
3 mode
120 © ABE
Statistical Tools and Data Analysis Chapter 4
Arithmetic mean
The arithmetic mean is the average of all values in a data set. Let’s understand how to find the
arithmetic mean.
Let’s again refer to case study 1 and look at the monthly sales data for Chikelu’s ice cream shop.
This data is presented in Table 14.
This is ungrouped data. Therefore, the arithmetic mean for Chikelu’s monthly ice cream
sales in 2016 is calculated simply as:
Total annual sales
Number of months
$42400
= $3533.33
12
Note that when the mean value of $3533.33 is subtracted from each sales value in Table 14, the
sum of the deviations will be 0.
© ABE 121
Chapter 4 Statistical Tools and Data Analysis
If Chikelu’s monthly ice cream sales are denoted as x, his annual sales can be shown as the sum
of sales for 12 months. Statistically his total sales for 12 months are represented as ∑ x (read as
summation x), i.e. ∑ x sum of monthly sales in 2016.
Therefore, the formula for calculating arithmetic mean, X (also called x-bar), is:
∑x
X=
n
Where,
X is the arithmetic mean
∑ x = sum of the values for the item under observation
n = number of observations
In the above example, we have a small discrete data set of n = 12 and this made it easy to
determine the arithmetic mean. The formula is also simple. However, in real life, where research
generates a large number of observations and mostly relies on frequency distribution (as discussed
∑x
in Chapter 3), you can determine the arithmetic mean in such cases by using a variation of X = .
n
∑ fx
X=
f
Where,
X = mean of x
∑ f = sum of frequencies
CASE STUDY 2
At Chikelu’s ice cream shop, the maximum sales occur in July.
This is a consistent pattern for many years. In July 2016, his
shop was open only for 26 days, and the sales amounted to
$6000. Chikelu collected daily data on the number of ice
creams sold in July 2016.
100, 79, 100, 85, 98, 98, 85, 75, 65, 139, 75, 155, 92, 96, 92,
85, 75, 92, 75, 75, 155, 72, 85, 96, 84, 72
Chikelu wants to find out his mean sales in units on any day when the shop was open in July 2016.
However, because the number of observations is large, i.e. n = 26, there is a greater chance of
making an error in calculation of mean. Therefore, it is a good practice to organise the data as
frequency distribution.
122 © ABE
Statistical Tools and Data Analysis Chapter 4
∑ fx
You can calculate the mean sales by using the formula for arithmetic mean X = .
f
The steps for calculating the mean are:
1 Find the product of x and f for each individual item and write it in the last column.
2 Total the frequency column f and also the product column fx
∑ fx
3 Apply the formula X =
f on the values calculated in Table 15 to obtain the arithmetic mean.
Table 15 Revision
on the go
∑ fx 2400
X= = = 92.3 ≈ 93
f 26
The answer is 93 ice creams. The reason why the value is rounded up is because number of ice
creams is a discrete data.
Let us look at Chikelu’s ice cream sales data again. Table 16 shows the grouped distribution of the
number of ice creams sold (classes) on summer days (frequency) between April and September
2016. Chikelu had kept his shop open for 150 days during the six summer months.
Classes Frequency
1–20 5
21–40 15
41–60 16
© ABE 123
Chapter 4 Statistical Tools and Data Analysis
Classes Frequency
61–80 45
81–100 40
101–120 15
121–140 8
141–160 6
The method of determining mean in the case of grouped frequency distribution is similar
to that for simple frequency distribution, except for one difference. Unlike simple frequency
distribution, where an item is expressed as a single value x, in a grouped distribution, x can lie
within a range of values or a group organised into class intervals. As a result, we need to assume
that all the values in any group are equal to the midpoint of the group. Therefore, we use the
midpoint to determine the mean value. This has been illustrated in Table 17.
Table 17 Revision
on the go
124 © ABE
Statistical Tools and Data Analysis Chapter 4
∑ fx 11715
X= = = 78.1 ≈ 79
f 150
An average of 79 ice creams were sold per day between April and September 2016. Note that the
final answer 78.1 has been rounded upwards to 79. Since number of ice creams is a discrete data,
the answer makes sense.
Total ∑ f = 150
Table 18 Revision
on the go
Step 3: Take the product of f and d for each group and write the product in the last column.
d = (x – assumed
Group/Class Midpoint (x) Frequency ( f ) fd
mean)
1–20 10.5 5 –80 –400
21–40 30.5 15 –60 –900
© ABE 125
Chapter 4 Statistical Tools and Data Analysis
d = (x –assumed
Group/Class Midpoint (x) Frequency ( f ) fd
mean)
41–60 50.5 16 –40 –640
61–80 70.5 45 –20 –900
81–100 90.5 40 0 0
101–120 110.5 15 20 300
121–140 130.5 8 40 320
141–160 150.5 6 60 360
Table 19 Revision
on the go
In this example ∑ fd = –1860. This is not zero and is also negative. This indicates an overestimation
of the assumed mean. This value of mean should be adjusted.
1
We use the value of ∑ f to adjust the assumed mean (A). The formula is × ∑ fd
∑f
Therefore, the assumed mean of 90.5 is adjusted as:
1
A+ × ∑ fd
∑f
1
90.5 + × (–1860)
150
= 90.5 – 12.4
= 78.1 ≈ 79
Arithmetic mean can also be used to compare the mean sales for multiple years and analyse the
reasons for drop or rise in sales.
126 © ABE
Statistical Tools and Data Analysis Chapter 4
385
Her mean marks will be = 77
5
Note that except for her score of 5 in one subject, she has scored 90 marks or above in all other
subjects, and therefore the mean value 77 does not reflect her true performance.
This example illustrates the limitation of arithmetic mean as a measure of central tendency. When
the data set is dominated by extremely small or large values (also called outliers), the arithmetic
mean is swayed by these outliers and does not reflect the central tendency. The mean in such cases
is therefore not representative of the sample or the population.
For these distributions, median and mode are better measures for central tendency.
Median
Median is the middle value in a distribution and, therefore, it divides the distribution into two equal
halves. In other words, half of the distribution is above the median, and the other half is below it.
Median value is calculated by arranging the data in the order of its magnitude, either in ascending
or descending order. The value that emerges in the middle of the arrangement is the median value.
Let look at Manju’s example again. The marks, when arranged in the order of magnitude are:
5, 90, 95, 95, 100
Note that 95 is repeated as a value, yet it is arranged twice, and in the order of magnitude. It is also
the value that lies at middle of the arrangement. Therefore, 95 is the median for this data. You can
see that the median value (95 marks) is a more accurate measure of Manju’s performance than the
mean value (77 marks).
The number of observations can be either odd or even, and therefore the calculation of the middle
value of the distribution differs. The formula for each is given in Table 20.
n+1
For odd number of observations (n), the median value is th
5
For even number of observations, the median value is n n+2
and
between 2 2
Table 20 Revision
on the go
© ABE 127
Chapter 4 Statistical Tools and Data Analysis
Table 21 Revision
on the go
26
The total number of observations is 26. Median value will be the middle value, that is,= 13th value.
2
The 13th value can be determined by calculating the cumulative frequencies from Table 22.
Table 22 Revision
on the go
From the cumulative frequency values, you can see that the 13th item lies between 9 and
14, or in other words between 79 and 85 units sold.
128 © ABE
Statistical Tools and Data Analysis Chapter 4
Therefore, the median value of number of ice creams sold per day in July is 85 as the 13th item will
belong to the cumulative frequency 14.
However, there is one difference. Unlike simple frequency distribution, the exact value of
median cannot be obtained. Once the median class is determined, you can calculate the
median with the formula:
i n
M=l –c
f 2
Where,
l = lower class boundary of median class
i = median class interval
f = frequency of median class
n = total number of observations
c = cumulative frequency of the class preceding median class
Let’s apply this method to calculate the median for the number of ice creams sold per day by
Chikelu between April and September 2016. The data is presented in Table 23.
Table 23: Daily ice cream sales (April – Sept 2016) Revision
on the go
Step 1: Find the cumulative frequencies of the grouped distribution as presented in Table 24.
© ABE 129
Chapter 4 Statistical Tools and Data Analysis
Table 24 Revision
on the go
Step 2: Determine the median class. The total frequency is 150. Therefore, the median is
150
the = 75th observation. From the cumulative frequency column, this observation would lie in
2
the group 61–80 as this group takes observations between 36th and 81st. This is the median class.
i n
M=l –c
f 2
20 150
= 61 + – 36
45 2
20
= 61 + × 39
45
= 78.33 ≈ 79
130 © ABE
Statistical Tools and Data Analysis Chapter 4
Cumulative frequency
120
100 75th Observation
80
60
40
20 78.33
0
20 40 60 80 100 120 120 160
Number of ice-creams sold
Figure 13: Ogive for number of ice creams sold per day Revision
on the go
Mode
It is common for a distribution to have a value that keeps reoccurring. For example, if you ask 100
people about the number of items of clothing they bought in the past one month, perhaps you
will get a lot of 2s and 3s in your distribution. It is important to measure the value that occurs most
frequently in a distribution. This measure of central tendency is called the mode.
65 1
72 2
75 5
79 1
85 5
92 3
96 2
98 2
100 2
138 1
155 2
26
Table 25 Revision
on the go
© ABE 131
Chapter 4 Statistical Tools and Data Analysis
Table 25 shows that there are two values that have a frequency of 5, making them the most frequently
occurring value in this distribution. Therefore, the mode values for the series are 75 and 85.
As the series has two modes, it is a bi-modal series. A series can also be multi-modal. The mode is
indicated in terms of x and not in terms of the frequencies. Thus, mode is not 5 but 75 and 85.
Let’s understand how to find the value of mode for these two situations.
Situation 1: Where all groups in the distribution have the same class interval
Let’s use this method to find the mode of the number of ice creams sold per day by Chikelu
between April and September.
Group/Class Frequency
1–20 5
21–40 15
41–60 16
61–80 45
81–100 40
101–120 15
121–140 8
141–160 6
Table 26 Revision
on the go
Step 1: Determine the modal class (group) by looking at the frequencies. The group, which has the
highest frequency, is the modal class. In this case, the group 61–80 has the highest frequency of 45.
Therefore, this is the modal class.
fa – fa–1
Mo = l + × ia
( fa – fa – 1 ) + ( fa – fa – 1 )
Where,
132 © ABE
Statistical Tools and Data Analysis Chapter 4
Given this,
45 – 16
Mo = 61 + × 20
(45 – 16) + (45 – 40)
29
= 61 + × 20
29 + 5
29
= 61 + × 20 = 78.05
34
Therefore, the mode of number of ice creams sold each day is 78.
Calculating mode where all groups in the distribution have the same class interval.
Step 1: identify the group that has the highest frequencies. It is the modal class.
fa – fa–1
Mo = l + × ia
( fa – fa – 1 ) + ( fa – fa – 1 )
l = lower class boundary of modal ia = modal class interval
Situation 2: Where all groups in the distribution have the different class interval
Chikelu has the following data presented in Table 27 on the number of ice creams bought by
his 35 loyal customers over 15 days. He wants to find the mode for this data.
Group Frequency
0–5 5
5–7 6
7–10 12
10–12 7
13–14 5
Table 27 Revision
on the go
In the example presented in Table 27, the class intervals are not equal. Mode in such cases
can be determined as follows:
© ABE 133
Chapter 4 Statistical Tools and Data Analysis
Step 1: Find the height (h) of each class by using the formula ha =
fa
ia
Table 28 Revision
on the go
The modal class is the one with the maximum height. In this case, it is the 7–10 group.
ha = fa
ia
The modal class is the one with greatest height.
134 © ABE
Statistical Tools and Data Analysis Chapter 4
Over to you
Activity 7: Mean, median mode
Mohammed, a human resource manager, asks 36 workers in the organisation how long it
takes them to travel from home to office. He collects the following data:
0 to 10 minutes 5
10 to 20 minutes 12
20 to 30 minutes 7
30 to 40 minutes 6
40 to 50 minutes 4
50 to 60 minutes 2
Calculate the mean, median and mode for this data.
Measures of dispersion
Consider these two equal sets of data with 10 items each:
Data set 1: 8, 9, 7, 8, 9, 8, 9, 8, 7, 7
Data set 2: 2, 14, 6, 7, 6, 9, 16, 10, 3, 7
Note that:
• The arithmetic mean (central value) for both sets of data is 8.
• However, the spread of data in set 1 is much smaller (items are close to each other and to the
central value) than the spread in set 2 (items vary from 2 to 16).
7 8 9 1 8 16
(a) (b)
© ABE 135
Chapter 4 Statistical Tools and Data Analysis
In a statistical study, it is not only important to have the knowledge of the central location
but also of the spread. Therefore, both must be measured.
There are various measures of dispersion. The focus of this syllabus is on three measures. These are:
1 range
2 inter-quartile range and quartile deviation
3 standard deviation.
Range
Range is the simplest method of measuring the spread of a distribution. It is expressed as the
difference between the largest value and the smallest value.
Let’s consider this example and understand how to determine the value of range.
Chikelu’s sister, Naomi, runs a stationery shop. Table 29 presents the quarterly sales for Naomi’s
shop and Chikelu’s shop for the year 2016. Let us compare the data for both shops and determine
the range of sales.
Chikelu Naomi
$ $
Quarter 1 5800 7500
Quarter 2 14000 7200
Quarter 3 16500 8000
Quarter 4 6100 8500
Total 42400 31200
Table 29 Revision
on the go
Range is the difference between the highest and the lowest values. Therefore:
Difference
Value of range
(highest sales – lowest sales)
Chikelu’s sales $16500 – $5800 $10700
Naomi’s sales $8500 – $7200 $1300
You can see that the range is much less for Naomi’s sales when compared with Chikelu’s sales.
Interpretation: You can see from these values of range that Naomi, although she has lower total
annual sales than Chikelu’s, has more consistent sales on a month-to-month basis.
136 © ABE
Statistical Tools and Data Analysis Chapter 4
The range as a measure of spread has both advantages and disadvantages. Look at Table 30.
Advantages Disadvantages
Quick to calculate Heavily influenced by two outliers in widely spread data, and
assumes that all other values are evenly distributed
Easy to understand Ignores variability among other in-between values, and
is therefore a weak measure
Table 30 Revision
on the go
You would not often use the value of range for drawing conclusions in business situations.
Called the lower quartile Called the median Called the upper quartile
Has 25% of the distribution, Has 50% of the distribution Has 75% of the distribution,
with 1/4th of the distribution with 3/4th of the distribution
below it below it.
Table 31 Revision
on the go
© ABE 137
Chapter 4 Statistical Tools and Data Analysis
Q1 has 1/4th observations and Q3 has 3/4th observations in the distribution below them. Since total
frequency of the distribution is 150, 1/4th and 3/4th, observations could be calculated as:
Q1 = l + i n −c
f 4
i 3n
Q3 = l + −c
f 4
Where,
l = lower class boundary of quartile class
i = class interval
f = frequency of quartile class
n = total number of observations
c = cumulative frequency of the class preceding quartile class
Therefore,
Q1 = 61 + 20 150 − 36
45 5
= 61 + 0.66
= 61.66
Q3 = 81 + 20 3(150) − 81
40 5
= 81 + 15.75
= 96.75
Like the median, lower and upper quartiles can also be determined from an ogive. This is shown in
Figure 15.
120
100
80
60
40
20
Q1 Q2 Q3
0
20 40 60 80 100 120 120 160
Number of ice-creams sold
Figure 15: Ogive showing median, lower and upper quartiles Revision
on the go
138 © ABE
Statistical Tools and Data Analysis Chapter 4
You should note that quartiles derived from a graph are almost never 100% accurate.
Standard deviation
This is the most popular measure of dispersion. Simply, deviation implies the distance between a
value in a distribution and arithmetic mean of the distribution.
Therefore, if:
Just like all other measures, standard deviation (σ) can be calculated for ungrouped data, simple
frequency distribution and grouped frequency distribution.
The three formulae for calculating standard deviation are shown in Table 32.
Formula for ungrouped data Formula for simple and Alternative formula for simple
grouped frequency and grouped frequency
distribution distribution
∑ (X − X )2 ∑ f (X − X )2 1 (∑ fx)2
σ= σ= σ= (∑ fx2) −
n ∑f n n
Table 32 Revision
on the go
Where,
© ABE 139
Chapter 4 Statistical Tools and Data Analysis
65 1
72 2
75 5
79 1
85 5
92 3
96 2
98 2
100 2
138 1
155 2
26
Table 33 Revision
on the go
∑ f (X − X )2
Standard deviation is calculated by using the formula σ =
∑f
For this we will first need the summation of the following values:
Mean X, deviation from the mean X − X, square of deviation from the mean (X − X )2 and product
of frequency and square of deviation of the mean f (X − X )2. The calculations are presented in
Table 34.
140 © ABE
Statistical Tools and Data Analysis Chapter 4
Table 34 Revision
on the go
The totals calculated in Table 34 are now inserted in the formula for standard deviation.
∑ f (X − X )2
σ=
∑f
= 13,671.54
26
= 525.83
= 22.93
Group Frequency
1–20 5
21–40 15
41–60 16
61–80 45
81–100 40
101–120 15
121–140 8
141–160 6
Table 35 Revision
on the go
In this case, you could calculate standard deviation using any the formula for standard deviation
of grouped distribution.
© ABE 141
Chapter 4 Statistical Tools and Data Analysis
1 (∑ fx)2
We will use, σ = (∑ f x 2) −
n n
For this we will first need the summation of the following values: Mid-values of each group, product
of frequency and mid value ( f x), square of mid-value (x 2), product of frequency and square of mid
value ( f x 2).
Table 36
Revision
on the go
1 (∑ fx)2
σ= (∑ fx2) −
n n
σ= 1 (1061878) − (11715)2
150 150
= 1 (1,061,878 − 914,941.5)
150
= 1 × 146,936.5
150
= 979.58
= 31.30
142 © ABE
Statistical Tools and Data Analysis Chapter 4
Skewness of data
In an ideal distribution, the values are equally distributed on both sides of the mean. The frequency
in this case is equal, and when plotted, the distribution shows symmetry. However, in many
distributions, a large number of values may gather either on the right side or left side of the mean.
This indicates skewness of data.
There are three possible distribution patterns you can see in Table 37 and in Figure 16.
Symmetric or not skewed The values are placed at equal distance from the mean, and
their frequency is equal. The shape of the distribution looks
mean = median = mode
like a bell because mean = median = mode
Right skewed The values that are smaller than the median gather closely,
i.e. occur with higher frequency than values lower than
mean > median > mode
the median, which have relatively higher distance from the
median. This is also called positively skewed distribution.
Left skewed The values that are greater than the median gather closely,
i.e. occur with higher frequency than values greater than
mean < median < mode
the median, which have relatively higher distance from the
median. This is also called negatively skewed distribution.
Table 37
Revision
on the go
© ABE 143
Chapter 4 Statistical Tools and Data Analysis
Over to you
Activity 8
Mohammed, a human resource manager, asks 36 workers in the organisation how long it
takes them to travel from home to office. He collects the following data:
0 to 10 minutes 5
10 to 20 minutes 12
20 to 30 minutes 7
30 to 40 minutes 6
40 to 50 minutes 4
50 to 60 minutes 2
Calculate the standard deviation of the data.
Table 38 Revision
on the go
144 © ABE
Statistical Tools and Data Analysis Chapter 4
The value of skewness can be as low as –3 or as high as +3. However, value of less than –1 or more
than +1 are rare, as these values indicate highly skewed data.
Let’s calculate the skewness for the data on number of ice creams sold by Chikelu in July 2016. The
data is presented in Table 39.
65 1
72 2
75 5
79 1
85 5
92 3
96 2
98 2
100 2
138 1
155 2
26
Table 39 Revision
on the go
The mean, median, mode and standard deviation for this data have been calculated earlier. The
values are:
Mean X = 92.3
Median = 85
Mode = 75 or 85
Therefore,
3(92.3 − 85)
Pearson’s coefficient of skewness = = 0.96
22.93
Therefore, we can conclude that data is positively skewed.
© ABE 145
Chapter 4 Statistical Tools and Data Analysis
Correlation is measured by examining the linear relationship between paired data. The value
indicates the extent to which variables move together, whether in the same or opposite directions.
If variables are correlated, the correlation between them may be either positive or negative. A third
situation may be that there is no correlation between two variables at all.
Positive correlation Two variables move in the same direction. If one increases, the
other also increases.
Negative correlation Two variables move in opposite directions. If one increases, the
other decreases.
No correlation Two variables do not move in any particular pattern and increase
or decrease in one is not dependent on the other.
Table 40 Revision
on the go
The three possible forms of relationship between two variables, x and y, are depicted in
the scatter graphs in Figure 17.
You would plot the observations for the independent variable on the x-axis and observations for
the dependent variable on the y-axis. The various points plotted on the graph show the kind of
relationship between the two variables.
CASE STUDY 3
Fen works in a factory that employs 10 production workers.
He is responsible for ensuring the quality of finished products.
His job involves carrying out inspections on the finished
products and rejecting all units that do not meet the quality
standards set by the factory.
In last few months, there has been an increase in the number
of units rejected by him. Fen is preparing his monthly report
for his employer to explain the reason for the increase in
the number of rejections. Fen thinks that there is a positive correlation between a worker’s
experience and quality. The more experienced workers have fewer rejects.
Fen wants to arrive at a final conclusion, but only after analysing the data. He wants to clearly
establish if the number of rejects is dependent on the number of months of experience that a
worker has. He also wants to conclude the kind of relationship between the two variables.
Fen’s collects one week’s data for 10 factory workers. You can see this data in Table 41.
1 12 22
2 11 23
3 16 18
4 3 35
5 10 25
6 14 21
7 6 36
8 13 21
9 9 28
10 8 31
Table 41 Revision
on the go
Let’s look at the given data to analyse whether the number of rejects (dependent variable y) is
affected by the experience of a worker (independent variable x). For this, let’s draw a scatter graph
by following the given steps.
1 Plot the independent variable (experience of workers) for each worker on the x-axis.
2 Plot the dependent variable (number of rejects) for each worker on the y-axis.
3 Draw a line of best fit. This line passes almost through the middle of the plotted points.
© ABE 147
Chapter 4 Statistical Tools and Data Analysis
Note: You should draw the line in such a way that most of the points lie on the line, and the
number of points above the line are almost the same as the number of points below it. The
strength of correlation depends on how close the points are to the line of best fit.
The closer the points are to the line, the stronger is the correlation between the two variables.
You can see the scatter graph (diagram) showing the relationship between experience of a worker
and the number of rejects in Figure 18.
Scatter diagram
40 A
(per 100 units)
30
Rejects
20
R
10
0
0 5 10 15 20
Experience (in months)
This implies that workers with greater experience have lesser numbers of rejects.
r=1 r = –1 r=0
r= n(∑ xy) − (∑ x) (∑ y)
n∑ x2 − (∑ x)2 n∑ y2 − (∑ y)2
Where,
x = Observations on independent variable
y = Observations on dependent variable
n = Number of observations
Let’s refer to case study 3 and calculate the value of Pearson’s coefficient of correlation for data
presented in Table 42. We will need the following values for calculating the coefficient.
∑ x, ∑ y, ∑ xy, ∑ x2, ∑ y2
© ABE 149
Chapter 4 Statistical Tools and Data Analysis
Table 42
Revision
on the go
10 × 2443 −(102)(260)
r=
10 × 1176 − (102)2 10 × 7110 − (260)2
24430 − 26520
=
11,760 − 10,404 71100 − 67,600
−2090
=
1356 × 3500
−2090
= = −0.95
4,746,000
150 © ABE
Statistical Tools and Data Analysis Chapter 4
CASE STUDY 4
Farah has data on marks scored by her students in
Financial Management and Quantitative Methods.
She thinks that only those candidates who perform
well in Quantitative Methods get high marks in
Financial Management. In other words, she thinks
that there is a correlation.
She takes a sample of 12 students and decides
to determine the relationship, if any, between the
performances of candidates in the two subjects.
The data is presented in Table 43.
Table 43 Revision
on the go
Let’s calculate Spearman’s rank correlation for the data in Table 43. The steps are:
1 Create a table with 7 columns. The first two columns contain the data whose correlation needs
to be measured.
2 Rank the marks scored by candidates in quantitative methods. Enter the ranks in R1 column.
Ranking ‘1’ implies highest marks and lowest marks get the lowest ranking.
3 Rank the students on the same basis on their marks in Financial Management and enter the
ranks in R2 column.
4 Find the difference in the ranks (d ) of each row by subtracting R2 from R1. Square the value of
each (d ) to remove the negative values and enter in the last column.
© ABE 151
Chapter 4 Statistical Tools and Data Analysis
Table 44
Revision
on the go
6∑d 2
Finally, use r = 1 − to determine the Spearman’s correlation coefficient.
n(n2 − 1)
r = 1 − 6 × 160
12(12 − 1)
2
r = 1 − 960 = 0.44
1716
The value 0.44 indicates a positive correlation between performance of candidates in quantitative
methods and financial management.
The independent variable is also called predictor or explanatory variable and the dependent
variable is called response or outcome. The independent variable is used to extrapolate data and
make business forecasts.
In the equation x is the independent variable, y is the dependent variable, b is the slope of the
linear regression line and a is the y-intercept.
Least-squares regression
The use of the least squares method is the most popular method of fitting a simple regression
line. Broadly, the method calculates the line of best fit for the observed data in a way that we can
minimise the sum of the squares of the vertical deviations from each data point to the line. Vertical
deviations of any point on the line of best fit are zero.
Method 1
We can find the line of best fit for a relationship by finding the values of a and b using the formula
a = y − bx
∑(x − x ) × (y − y)
Where, b =
∑(x − y)
These values can be put in the equation y = a + bx to find the simple linear regression equation.
Let’s again refer to case study 4. In the previous section, we identified a strong negative correlation
between experience of production workers and the number of rejects. We can now fit a least
square regression line to express this relationship so that we can forecast the number of units that
are likely to be rejected at specific levels of experience of production workers.
Table 45
Revision
on the go
© ABE 153
Chapter 4 Statistical Tools and Data Analysis
∑ (x − x) × (y − y)
b=
∑ (x − x)2
For this we need the summation of following values,
x − x, y − y, (x − x) × (y − y) and (x − x)2
a = y − bx
= 26 − (−1.54)10.2
= 26 + 15.71 = 41.71
Step 4: Insert the values of b and a in the equation y = a + bx to get the simple linear regression
equation.
Method 2
The alternate method is similar to method 1 as for calculation of y-intercept a. The difference is in
calculation of the slope b.
154 © ABE
Statistical Tools and Data Analysis Chapter 4
Table 46
Revision
on the go
Therefore,
(24,430 − 26,520)
=
(11,760 − 10,404)
−2090
= = −1.54
1356
a = y − bx
= 26 − (−1.54)10.2
= 26 + 15.71 = 41.71
Therefore, y = 10.29 − 1.54x
© ABE 155
Chapter 4 Statistical Tools and Data Analysis
NEED TO KNOW
Charts and graphs are powerful tools for presenting data because they help to condense
data into a visual format. Visual presentation is simple to understand.
You should present charts and graphs for easy reading and interpretation. There should be a
meaningful title of the chart or graph. Label the axes properly. The scale should be suitably
depicted for both the axes and the data values plotted carefully to reflect information correctly.
Provide legends but avoid excessive details within the chart or graph as it reduces its clarity. A
chart or graph should be supplemented with data on which it is based.
There are two broad categories of charts and graphs: qualitative data charts and graphs (bar
chart and pie chart) and quantitative data charts and graphs (histogram, frequency polygon,
ogive, stem and leaf, scatter).
A bar chart can be a simple bar chart, multiple bar chart or component bar chart.
Bar charts visually present categorical data and its quantitative values. They are constructed
either in vertical (also called column) format or horizontal format.
Bar charts are good for visual presentation when a comparison needs to be made for sets of
data between different groups or trends need to be identified.
Use a pie chart for presenting categorical data. It also called a pie graph or circular diagram. It
is an appropriate diagrammatic tool when the numbers of items to be presented are not more
than six.
A histogram shows information in the form of vertical, rectangular bars. It presents data that
is numerical, continuous and grouped. The data can be numbers (absolute frequencies) or
percentages (relative frequencies). The bars touch each other and area of the rectangular bars
denotes the frequency for the respective class intervals.
A frequency polygon is a line graph constructed by joining the mid-top points (dots) of a
histogram, and therefore it is also called the dot-and-line graph. It is a snapshot of the pattern
in frequency distribution.
An ogive is a graph that presents cumulative frequencies against the upper class boundaries for
the classes in a frequency distribution.
A stem and leaf plot is a diagrammatic summarisation of raw quantitative data into groups.
It is an alternative method to frequency distribution table.
A stem and leaf plot is constructed by splitting each data value into two components; the
leading digit is called stem and remaining digit(s) are leaf.
Descriptive statistics helps to summarise a data set in a way that it truly represents either the
entire population or its sample. These include measures of central tendency and measures of
variability or spread.
A measure of central tendency is a summary measure that attempts to describe a whole set
of data with a single value that represents the middle or centre of its distribution. The three
measures of central tendency are arithmetic mean, median and mode.
The arithmetic mean is average of all values in a data set. Median is the value that splits the
distribution into two equal halves. The mode is the value that occurs the maximum number of
times in a distribution.
For ungrouped data, the arithmetic mean is calculated simply by dividing the total of the values
by the number of observations.
The mean for grouped frequency distribution is determined with the product of midpoint of the
classes and the corresponding frequencies.
156 © ABE
Statistical Tools and Data Analysis Chapter 4
Measures of spread describe how similar or varied the set of observed values are for a particular
variable (data item). Measures of spread include the range, quartiles and the interquartile range,
variance and standard deviation.
Range is the simplest method of measuring the spread of a distribution. It is expressed as the
difference between the largest value and the smallest value.
Inter-quartile range and quartile deviation measure the deviation between upper and lower
quartiles. These provide a clearer picture of the distribution than range as these measures
remove the extreme values when determining the dispersion.
Standard deviation is the most popular measure of dispersion. Higher deviation indicates
greater spread of data.
There are three possible distribution patterns:
mean = median = mode, the distribution is not skewed
mean > median > mode, the distribution is right skewed
mean < median < mode, the distribution is left skewed.
Karl Pearson’s coefficient of skewness is used for measuring the extent of skewness in a
distribution.
Correlation is measured by examining the linear relationship between paired data. If variables
are correlated, the correlation between them may be either positive or negative.
Scatter graphs are diagrammatic presentation of the relationship between two variables, an
independent variable x and a dependent variable y.
A scatter graph shows how a change in the independent variable affects the dependent
variable. In other words, it indicates correlation between them.
Pearson’s coefficient of correlation measures the linear relationship between variables. When
there is a change in one variable, it results in a proportional change in the other variable.
Correlation is represented by the letter r or R The value of r or R lies between −1 and +1.
Spearman’s rank coefficient of correlation or Spearman’s correlation coefficient, represented by
symbol r or ρ(rho) , measures the strength and direction of association between the rankings of
two variables.
Simple linear regression is a statistical method used for analysing the association between two
quantitative variables for business modelling.
The use of least squares method is the most popular method of fitting a simple regression line.
Businesses use regression equation for correlated variables to estimate the value of one variable
corresponding to another variable.
Reading List
Anderson, D.R.; Sweeney, D.J.; Williams, T.A.; Freeman, J. and Shoesmith, E. (2014).
Statistics for Business and Economics. Cengage Learning, 3rd Ed. ISBN 978–1408072233
Burton, G.; Carroll, G. and Wall, S. (2001). Quantitative Methods for Business and Economics.
Financial Times/Prentice Hall, 2nd Ed. ISBN 978–0273655701
Silver, M. (1997). Business Statistics. McGraw Hill Education, 2nd Ed. ISBN 978–9780077092252
Resources: Books
Weiss, N.A. (2013). Introductory Statistics. Pearson, 9th Ed. ISBN 978–1292022017
© ABE 157
Glossary
Glossary
Absolute frequency is the number of Consequent is the second term in a given
instances/occurrences observed for a particular ratio or the second and fourth terms in a given
value for a variable. proportion. For example, in the ratio 2 : 3,
the value 3 is the consequent. Similarly in a
Antecedent is the first term in a given
proportion, 2 : 3 :: 4 : 5, the values 3 and 5 are
ratio or the first and third terms in a given
consequents. Also see antecedents.
proportion. For example, in the ratio 2 : 3,
the value 2 is the antecedent. Similarly in a Constant is the quantity that does not
proportion, 2 : 3 :: 4 : 5, the values 2 and 4 are change in a mathematical expression. For
antecedents. Also see consequent. example, in the equation x + 7 = y, 7 is a
constant.
Arithmetic operation is a mathematical
process performed on numbers. The basic Correlation is a statistical approach that
operations are add, subtract, multiply and measures the strength of association between
divide (+, –, x and ÷). Examples of more two variables.
complex operations include squares, cubes,
Denominator is the non-zero divisor
in a fraction. If a is a fraction then b is the
square root, cube root.
b
BEDMAS is an acronym for the rule for order denominator.
of operations in arithmetic and algebra. Also
Dependent variable is a variable that is
see order of operations.
affected by change in another variable. For
Bias is a deliberate step in the process example, demand of a product may be affected
of statistical analysis that cause results or by the variable price. Also see response.
conclusions which are not a true representation.
Equation is a specific type of algebraic
Bias is different from random sampling error. An
expression that has arithmetic operation(s) and
example of bias is ‘sample selection bias’ that
an equal sign. For example, 2X + 2 = 8 is an
systematically chooses non-random data based
equation. Similarly, A = 2l + 2 w is an equation.
on particular attributes.
Exponent is power used on a base in
Chart or graph is a visual representation of an exponential notation. For example, in
data in various forms such as rectangular bars,
exponential notation 53, 3 is the exponent on
lines or a circular pie. Information is easily and
5, and the expression indicates 5 is used three
quickly gained with the help of a chart or a
times as a factor.
graph.
Foreign exchange is the exchange of a
Class boundary the boundary that separates country’s currency for another country’s currency
two classes or groups of data. A class has
based on current market rates. The system is
an upper class boundary and a lower class
useful for international trade and travel.
boundary.
Gradient is the slope of a straight line
Class interval is the range of a class or a calculated as change in vertical length divided
group of data.
by change in horizontal length or change in y .
Coefficient a number that is attached to and change in x
multiplies a variable in an algebraic expression. Independent variable is a variable
For example, in the equation ax2 + bx + c = 0, x that is not affected by change in any other
is a variable, while a and b are coefficients. variable. For example, age or gender. Also see
predictor.
Compound interest in the first instance of
calculation, it is always equal to simple interest. Legend is a brief identification of data
From second instance of calculation, compound presented in a chart, graph or table.
interest is the interest earned or paid on the Linear equation is the first order equation
original amount or principal plus any interest consisting of one or more variables with
accumulated in previous period(s). It is based exponent 1. It is generally expressed as ax + b
on a specific rate percentage. = 0. A linear equation when plotted on a graph
gives a straight line.
158 © ABE
Glossary
© ABE 159