ð Lecture 11 â Relations and Functions
ð Overview: This lecture formally defines functions as a special type of relation, distinguishing them from general binary relations through two essential properties. It covers how to identify functions from arrow diagrams, ordered pairs, and graphs, and introduces fundamental concepts like domain, co-domain, range, image, and inverse image, along with binary operations as a special type of function.
ðïž Topics Covered
The lecture begins by defining a function as a relation with two specific conditions, then works through exercises identifying functions from various representations including ordered pairs and arrow diagrams. It then introduces the range of a function, the graph of a function and the vertical line test, followed by counting functions between finite sets and the concept of well-defined functions. The lecture concludes with the definition of image and inverse image of sets, several results about these operations, and an introduction to binary operations as functions from AÃA to A.
ð Lecture Summary
RELATIONS AND FUNCTIONS
A function F from a set X to a set Y is a relation from X to Y that satisfies two properties: (1) For every element x in X, there is an element y in Y such that (x,y) â F â every element of X is the first element of some ordered pair of F. (2) For all elements x in X and y and z in Y, if (x,y) â F and (x,z) â F, then y = z â no two distinct ordered pairs in F have the same first element.
ð Definition â Function: A function f from a set X to a set Y is a relationship between elements of X and elements of Y such that each element of X is related to a unique element of Y, denoted f: X â Y. X is the domain and Y is the co-domain of f. The unique element y of Y related to x by f is denoted f(x), called "f of x", the value of f at x, or the image of x under f.
ð Example: Which relations define functions from X = {2,4,5} to Y = {1,2,4,6}?
- Râ = {(2,4), (4,1)} is NOT a function because 5 â X does not appear as the first element in any ordered pair.
- Râ = {(2,4), (4,1), (4,2), (5,6)} is NOT a function because (4,1) and (4,2) have the same first element but different second elements.
- Râ = {(2,4), (4,1), (5,6)} defines a function because it satisfies both conditions.
ð Example: Let A = {4,5,6} and B = {5,6}. Define R and S from A to B: (x,y)âR â xâ¥y; xSy â 2|(x-y).
- R = {(5,5), (6,5), (6,6)} â NOT a function because 4âA is not related to any element of B.
- S = {(4,6), (5,5), (6,6)} â defines a function since each element of A is related to a unique element of B.
ARROW DIAGRAM OF A FUNCTION
The arrow diagram for a function f has two properties: (1) Every element of X has an arrow coming out of it. (2) No element of X has two arrows coming out pointing to two different elements of Y.
ð Example: X = {a,b,c}, Y = {1,2,3,4}. A function f from X to Y defined by arrow diagram shows f(a)=2, f(b)=4, f(c)=2. This satisfies both conditions.
RANGE OF A FUNCTION
Let f: XâY. The range of f consists of those elements of Y that are images of elements of X. Symbolically: Range of f = {yâY | y = f(x), for some xâX}.
Key notes: (1) The range is always a subset of the co-domain. (2) The range is also called the image of X under f. (3) When y = f(x), x is called the pre-image of y. (4) The set of all elements of X related to some yâY is called the inverse image of y.
ð Example: Determine the range of functions f, g, h from X = {2,4,5} to Y = {1,2,4,6}:
- f: range = {1, 6}
- g = {(2,6), (4,2), (5,1)}: range = {1, 2, 6}
- h(2)=4, h(4)=4, h(5)=1: range = {1, 4}
GRAPH OF A FUNCTION
Let f be a real-valued function of a real variable (f: RâR). The graph of f is the set of all points (x,y) in the Cartesian coordinate plane with x in the domain and y = f(x).
VERTICAL LINE TEST FOR THE GRAPH OF A FUNCTION
For a graph to be the graph of a function, any given vertical line in its domain intersects the graph in at most one point.
ð Example: The graph of y = x² on R defines a function (vertical line test passes). The graph of x = y² does NOT define a function (a vertical line intersects at two points).
COUNTING FUNCTIONS
ð Example: How many functions are there from a set with three elements to a set with four elements? Each of the 3 elements can map to any of the 4 elements in Y. Total functions = 4 à 4 à 4 = 4³ = 64.
ð Example: A has m elements, B has n elements.
- Number of binary relations from A to B = 2^(mn)
- Number of functions from A to B = n^m
- Fraction of binary relations that are functions = n^m / 2^(mn)
FUNCTIONS NOT WELL DEFINED
A function f: XâY is well defined iff â xâ, xâ â X, if xâ = xâ then f(xâ) = f(xâ).
ð Example: Determine if f: ZâR defined below is well defined:
- f(n) = ±n: NOT well defined (each integer has two images)
- f(n) = 1/(n²-4): NOT well defined (f(2) and f(-2) undefined)
- f(n) = ân: NOT well defined (imaginary values for n<0)
- f(n) = n²+1: Well defined (each integer has unique image)
ð Example: h: QâQ defined by h(m/n) = m/n. Claim: Not well defined. Since 1/2 = 2/4, h(1/2) = (1/2)/(1/2) = 1 but h(2/4) = (2/4)/(2/4) = 1 â 1/2? Wait â proper evaluation: h(1/2) = 1/2 divided by 2 = 1, but h(2/4) = 2/4 divided by 4 = 1/8? Actually re-evaluating: h(m/n) = m/n where the denominator is n? For 1/2: h(1/2) = 1/2 = 0.5; for 2/4: h(2/4) = 2/4 = 0.5. But this gives same value? The lecture shows different results â the key point is that the rule is ambiguous for different representations of the same rational number, so h is NOT well defined.
IMAGE OF A SET
Let f: XâY be a function and A â X. The image of A under f is: f(A) = {yâY | y = f(x), for some x in A}.
INVERSE IMAGE OF A SET
Let f: XâY be a function and C â Y. The inverse image of C under f is: fâ»Â¹(C) = {xâX | f(x)âC}.
SOME RESULTS
Let f: XâY be a function. Let A,B â X and C,D â Y:
- If AâB then f(A) â f(B)
- f(AâªB) = f(A) ⪠f(B)
- f(Aâ©B) â f(A) â© f(B)
- f(A-B) â f(A) - f(B)
- If CâD then fâ»Â¹(C) â fâ»Â¹(D)
- fâ»Â¹(CâªD) = fâ»Â¹(C) ⪠fâ»Â¹(D)
- fâ»Â¹(Câ©D) = fâ»Â¹(C) â© fâ»Â¹(D)
- fâ»Â¹(C-D) = fâ»Â¹(C) - fâ»Â¹(D)
BINARY OPERATIONS
A binary operation "" defined on a set A assigns to each ordered pair (a,b) of elements of A a uniquely determined element ab of A. A binary operation takes two elements of A and maps them to a third element of A.
ð Definition: A binary operation "*" on a set A is a function from AÃA to A, i.e., : AÃA â A. Usually written ab rather than *(a,b).
ð Examples:
- "+" and "·" are binary operations on N
- "â" is NOT a binary operation on N but IS on Z
- "÷" is a binary operation on Q-{0} but NOT on Z
- Union (âª), intersection (â©), set difference (â) are binary operations on P(A)
- Logical connectives âš, â§, â, â are binary operations on {T,F}
- OR and AND gates are binary operations on {0,1}; NOT is a unary operation
ð¡ Why this matters: Binary operations are the foundation of algebraic structures like groups, rings, and fields, and are fundamental in computer arithmetic and logic circuit design.
â Key Takeaways
A function is a special type of relation where every element of the domain maps to exactly one element of the co-domain â it must satisfy both the "every element maps" condition and the "unique image" condition. The vertical line test provides a quick graphical way to check if a relation is a function, while the well-defined condition ensures that equal inputs always produce equal outputs. The number of functions from an m-element set to an n-element set is n^m, which is a small fraction of all possible binary relations (2^(mn)). Binary operations are simply functions from AÃA to A, unifying the concepts of functions and operations in mathematics.
ð§ Quick Revision Questions
- What are the two properties that a relation must satisfy to be called a function?
- If f: {1,2,3} â {a,b,c,d} and f(1)=a, f(2)=b, what condition is violated that makes this NOT a function?
- How many functions exist from a set with 5 elements to a set with 3 elements?
- What does it mean for a function to be "well defined," and give an example of a rule that is not well defined.
- State the vertical line test and apply it to determine whether the graph of x = y² defines a function.
ð Lecture 12 â Functions
ð Overview: This lecture defines and explores three fundamental properties of functions: injectivity (one-to-one), surjectivity (onto), and bijectivity (both). Understanding these classifications is crucial for analyzing how functions map elements between sets and forms the foundation for advanced topics like invertibility and cardinality.
ðïž Topics Covered
The lecture covers injective (one-to-one) functions with formal definitions, examples, and the horizontal line test; surjective (onto) functions with similar treatment; bijective functions as a combination of both properties; and special function types including the identity function and constant function.
ð Lecture Summary
INJECTIVE FUNCTION or ONE-TO-ONE FUNCTION
Let f: X â Y be a function. f is injective or one-to-one if, and only if, â xâ, xâ â X, if xâ â xâ then f(xâ) â f(xâ). That is, f is one-to-one if it maps distinct points of the domain into distinct points of the co-domain. A one-to-one function separates points.
ð Definition â One-to-One Function: A function f: X â Y is one-to-one iff â xâ, xâ â X, if xâ â xâ then f(xâ) â f(xâ) (i.e., distinct elements of the first set have their distinct images in the second set). The equivalent contra-positive statement is: â xâ, xâ â X, if f(xâ) = f(xâ), then xâ = xâ.
FUNCTION NOT ONE-TO-ONE
A function f: X â Y is not one-to-one iff there exist elements xâ and xâ in X such that xâ â xâ but f(xâ) = f(xâ). That is, if distinct elements xâ and xâ can be found in the domain of f that have the same function value. A function that is not one-to-one collapses points together.
ð Example: In arrow diagrams, function f maps {a,b,c} to {1,2,3,4} with aâ1, bâ2, câ3 â this is one-to-one because no two different elements map to the same element. Function g maps aâ2, bâ1, câ2 â this is NOT one-to-one because a and c both map to 2.
ð Example: Define f: R â R by f(x) = 4x - 1. Is f one-to-one? Let xâ, xâ â R such that f(xâ) = f(xâ) â 4xâ - 1 = 4xâ - 1 â 4xâ = 4xâ â xâ = xâ Since f(xâ) = f(xâ) implies xâ = xâ, f is one-to-one.
ð Example: Define g: Z â Z by g(n) = n². Is g one-to-one? Let nâ, nâ â Z and suppose g(nâ) = g(nâ) â nâ² = nâ² â either nâ = nâ or nâ = -nâ Counter example: nâ = 2 and nâ = -2. Then g(2) = 4 and g(-2) = 4, but 2 â -2. Hence g is NOT one-to-one.
ð Example: Find all one-to-one functions from X = {a,b} to Y = {u,v}. There are two one-to-one functions: one maps aâu, bâv; the other maps aâv, bâu.
ð Example: How many one-to-one functions are there from a set with three elements to a set with four elements? Let X = {xâ, xâ, xâ} and Y = {yâ, yâ, yâ, yâ}. xâ may be mapped to any of 4 elements. Then xâ may be mapped to any of the remaining 3 elements. Finally xâ may be mapped to any of the remaining 2 elements. Total = 4 Ã 3 Ã 2 = 24 one-to-one functions.
ð Example: How many one-to-one functions are there from a set with three elements to a set with two elements? Let X = {xâ, xâ, xâ} and Y = {yâ, yâ}. Two elements in X could be mapped to the two elements in Y separately, but there is no element in Y for the third element of X. Accordingly, there is no one-to-one function from a set with three elements to a set with two elements.
GRAPH OF ONE-TO-ONE FUNCTION
A graph of a function f is one-to-one iff every horizontal line intersects the graph in at most one point. (Horizontal Line Test)
ð Example: y = x² is NOT one-to-one from R to R⺠because the horizontal line y=4 intersects at (-2,4) and (2,4).
SURJECTIVE FUNCTION or ONTO FUNCTION
Let f: X â Y be a function. f is surjective or onto if, and only if, â y â Y, â x â X such that f(x) = y. That is, f is onto if every element of its co-domain is the image of some element(s) of its domain. Co-domain of f = range of f.
ð Definition â Onto Function: A function f: X â Y is onto iff every element y in Y equals f(x) for at least one x in X.
FUNCTION NOT ONTO
A function f: X â Y is not onto iff there exists y â Y such that â x â X, f(x) â y. That is, there is some element in Y that is not the image of any element in X.
ð Example: In arrow diagrams, function f maps {a,b,c} to {1,2,3} with aâ1, bâ2 â f is NOT onto because 3 â f(x) for any x. Function g maps {a,b,c,d} to {1,2,3} with aâ3, bâ3, câ1, dâ2 â g IS onto because 1=g(c), 2=g(d), 3=g(a)=g(b).
ð Example: Define f: R â R by f(x) = 4x - 1. Is f onto? Let y â R. We search for x â R such that f(x) = y, or 4x-1 = y. Solving: x = (y+1)/4 â R. For every y â R, there exists x = (y+1)/4 â R such that f(x) = 4((y+1)/4) - 1 = (y+1) - 1 = y. Hence f is onto.
ð Example: Define h: Z â Z by h(n) = 4n - 1. Is h onto? Let m â Z. We search for n â Z such that h(n) = m, or 4n-1 = m. Solving: n = (m+1)/4. But n = (m+1)/4 is not always an integer for all m â Z. Counter example: Let m = 0. Then h(n) = 0 â 4n-1=0 â 4n=1 â n=1/4 â Z. Hence h is not onto.
GRAPH OF ONTO FUNCTION
A graph of a function f is onto iff every horizontal line intersects the graph in at least one point.
ð Example: y = |x| is onto from R to Râº, but NOT onto from R to R.
ð Example: Let X = {1,5,9} and Y = {3,4,7}. Define g: X â Y by g(1)=7, g(5)=3, g(9)=4. Is g one-to-one? Is g onto? g is one-to-one because each element of X maps to a different element of Y: g(1)â g(5), g(1)â g(9), g(5)â g(9). g is onto because each element of Y is the image of some element of X: 3=g(5), 4=g(9), 7=g(1).
ð Example: Define f: P({a,b,c}) â Z as follows: for all A â P({a,b,c}), f(A) = the number of elements in A. a. Is f one-to-one? f is not one-to-one because f({a}) = 1 and f({b}) = 1 but {a} â {b}. b. Is f onto? f is not onto because there is no element of P({a,b,c}) mapped to 4 â Z.
ð Example: Determine if each function is injective or surjective. a. f: Z â Z⺠defined as f(x) = |x| f is not injective because f(1)=1 and f(-1)=1 but 1â -1. f is onto because for every aâZâº, there exist -a and +a in Z such that f(-a)=a and f(a)=a.
b. g: Z⺠â Z⺠à Z⺠defined as g(x) = (x, x+1) Let g(xâ)=g(xâ) for xâ,xââZ⺠â (xâ,xâ+1) = (xâ,xâ+1) â xâ=xâ and xâ+1=xâ+1 â xâ=xâ. Hence g is one-to-one. g is not onto because (1,1)âZâºÃZ⺠is not the image of any element of Zâº.
BIJECTIVE FUNCTION or ONE-TO-ONE CORRESPONDENCE
A function f: X â Y that is both one-to-one (injective) and onto (surjective) is called a bijective function or a one-to-one correspondence.
ð Definition â Bijective Function: A function that is both injective and surjective.
ð Example: The function f: X â Y defined by the arrow diagram mapping aâ1, bâ2, câ3 is both one-to-one and onto, hence bijective.
ð Example: Let f: R â R be defined by f(x) = x³. Show f is bijective. One-to-one: Let f(xâ)=f(xâ) for xâ,xââR â xâ³=xâ³ â (xâ-xâ)(xâ²+xâxâ+xâ²)=0 â xâ=xâ (second factor has no real solution). Hence f is one-to-one. Onto: Let yâR. We search for xâR such that f(x)=y â x³=y â x=y^(1/3)âR. Hence for yâR, there exists x=y^(1/3)âR such that f(x)=f(y^(1/3))=(y^(1/3))³=y. Hence f is onto. Thus, f is bijective.
GRAPH OF BIJECTIVE FUNCTION
A graph of a function f is bijective iff every horizontal line intersects the graph at exactly one point.
IDENTITY FUNCTION ON A SET
Given a set X, define a function iâ from X to X by iâ(x) = x for all x â X. The function iâ is called the identity function on X because it sends each element of X to itself.
ð Definition â Identity Function: iâ: X â X defined by iâ(x) = x.
ð Example: Let X = {1,2,3,4}. The identity function iâ maps 1â1, 2â2, 3â3, 4â4.
ð Example: Let X be a non-empty set. Prove that the identity function on X is bijective. Let iâ: X â X be defined as iâ(x) = x â xâX. Injective: Let iâ(xâ)=iâ(xâ) for xâ,xââX â xâ=xâ. Hence iâ is one-to-one. Surjective: Let yâX (co-domain). Then there exists yâX (domain) such that iâ(y)=y. Hence iâ is onto. Thus, iâ is bijective.
CONSTANT FUNCTION
A function f: X â Y is a constant function if it maps (sends) all elements of X to one element of Y, i.e., â x â X, f(x) = c, for some c â Y.
ð Definition â Constant Function: A function where all elements of the domain map to the same element of the co-domain.
Remark:
- A constant function is one-to-one iff its domain is a singleton (has exactly one element).
- A constant function is onto iff its co-domain is a singleton (has exactly one element).
â Key Takeaways
A student must understand the precise definitions of injective, surjective, and bijective functions and be able to prove or disprove each property using algebraic methods and counterexamples. The horizontal line test provides a quick graphical way to determine injectivity, surjectivity, and bijectivity. Counting one-to-one functions from a set of m elements to a set of n elements requires n ⥠m, with the number being the falling factorial P(n,m). Special functions like the identity function (always bijective) and constant functions (injective only for singleton domains, surjective only for singleton co-domains) serve as important boundary cases.
ð§ Quick Revision Questions
- State the contra-positive definition of a one-to-one function. How is this version used in proofs?
- Is the function f: Z â Z defined by f(n) = 2n + 3 one-to-one? Onto? Prove your answers.
- How many one-to-one functions exist from a set with 4 elements to a set with 5 elements? Show your calculation.
- Explain why a function whose graph passes the horizontal line test at exactly one point for every horizontal line must be bijective.
- Under what conditions is a constant function bijective? Explain using the definitions of injectivity and surjectivity.
ð Lecture 13 â Sequences
ð Overview: This lecture introduces the concept of sequences as ordered lists of elements, provides formal definitions and notations, and explores methods for finding terms using explicit formulas. It covers two important special types of sequencesâarithmetic and geometricâalong with their general term formulas, making it foundational for understanding patterns in mathematics and computer programming.
ðïž Topics Covered
The lecture begins with the basic definition of a sequence and its notation, then proceeds to finding terms of a sequence given by an explicit formula with multiple examples. It introduces arithmetic sequences (AP) with their general term formula and worked examples, followed by geometric sequences (GP) with their general term and examples. The lecture concludes with a brief discussion of sequences in computer programming as one-dimensional arrays.
ð Lecture Summary
SEQUENCE
A sequence is just a list of elements usually written in a row. The symbol â...â is called ellipsis, and reads âand so forthâ.
ð Definition â Sequence: A function whose domain is the set of integers greater than or equal to a particular integer nâ. Usually this set is the set of Natural numbers {1, 2, 3, ...} or the set of whole numbers {0, 1, 2, 3, ...}.
Notation: We use the notation aâ to denote the image of the integer n, and call it a term of the sequence. Thus aâ, aâ, aâ, aâ ..., aâ, ... represent the terms of a sequence defined on the set of natural numbers N. A sequence is described by listing the terms in order of increasing subscripts.
FINDING TERMS OF A SEQUENCE GIVEN BY AN EXPLICIT FORMULA
An explicit formula or general formula for a sequence is a rule that shows how the values of aâ depends on k.
ð Formula: aâ = [expression in k] â plug in integer values of k to find terms
ð Example 1: Define sequence aâ, aâ, aâ, ... by the explicit formula aâ = k/(k+1) for all integers k ⥠1.
- aâ = 1/(1+1) = 1/2
- aâ = 2/(2+1) = 2/3
- aâ = 3/(3+1) = 3/4
- aâ = 4/(4+1) = 4/5
ð Example 2: Write the first four terms of sequence bⱌ = 1 + 2ʲ, for all integers j ⥠0.
- bâ = 1 + 2â° = 1 + 1 = 2
- bâ = 1 + 2¹ = 1 + 2 = 3
- bâ = 1 + 2² = 1 + 4 = 5
- bâ = 1 + 2³ = 1 + 8 = 9
Remark: The formula bⱌ = 1 + 2ʲ defines an infinite sequence having infinite number of values.
ð Example 3: Compute first six terms of Câ = 1 + (-1)â¿ for all integers n ⥠0.
- Câ = 1 + (-1)â° = 2
- Câ = 1 + (-1)¹ = 0
- Câ = 1 + (-1)² = 2
- Câ = 1 + (-1)³ = 0
- Câ = 1 + (-1)⎠= 2
- Câ = 1 + (-1)âµ = 0
Remarks: (1) If n is even, Câ = 2; if n is odd, Câ = 0. The sequence oscillates endlessly between 2 and 0. (2) An infinite sequence may have only a finite number of values.
ð Example 4: Write first four terms of Câ = (-1)â¿ n/(n+1) for all integers n ⥠1.
- Câ = (-1)¹(1)/(1+1) = -1/2
- Câ = (-1)²(2)/(2+1) = 2/3
- Câ = (-1)³(3)/(3+1) = -3/4
- Câ = (-1)âŽ(4)/(4+1) = 4/5
Remark: A sequence whose terms alternate in sign is called an alternating sequence.
ð Exercise: Find explicit formulas for sequences with initial terms given:
- 0, 1, -2, 3, -4, 5, ... â aâ = (-1)â¿âºÂ¹ n for all integers n ⥠0
- 1-1/2, 1/2-1/3, 1/3-1/4, 1/4-1/5, ... â bâ = 1/k - 1/(k+1) for all integers n ⥠1
- 2, 6, 12, 20, 30, 42, 56, ... â Câ = n(n+1) for all integers n ⥠1
- 1/4, 2/9, 3/16, 4/25, 5/36, 6/49, ... â dáµ¢ = i/(i+1)² for all integers i ⥠1 OR dⱌ = (j+1)/(j+2)² for all integers j ⥠0
ARITHMETIC SEQUENCE
A sequence in which every term after the first is obtained from the preceding term by adding a constant number is called an arithmetic sequence or arithmetic progression (A.P.). The constant number, being the difference of any two consecutive terms, is called the common difference of A.P., commonly denoted by âdâ.
ð Examples:
- 5, 9, 13, 17, ... (common difference = 4)
- 0, -5, -10, -15, ... (common difference = -5)
- x + a, x + 3a, x + 5a, ... (common difference = 2a)
GENERAL TERM OF AN ARITHMETIC SEQUENCE: Let a be the first term and d be the common difference. Then the sequence is a, a+d, a+2d, a+3d, ...
ð Definition â nth term of AP: aâ = a + (n-1)d for all integers n ⥠1, where a = first term, d = common difference.
ð Example: Find the 20th term of the arithmetic sequence 3, 9, 15, 21, ...
- Given: a = 3, d = 9-3 = 6, n = 20
- aââ = 3 + (20-1)6 = 3 + 114 = 117
ð Example: Which term of the arithmetic sequence 4, 1, -2, ... is -77?
- Given: a = 4, d = 1-4 = -3, aâ = -77
- -77 = 4 + (n-1)(-3)
- -77-4 = (n-1)(-3)
- -81/(-3) = n-1
- 27 = n-1
- n = 28 â -77 is the 28th term.
ð Example: Find the 36th term of the arithmetic sequence whose 3rd term is 7 and 8th term is 17.
- Let a = first term, d = common difference
- aâ = a + 2d = 7 ...(1)
- aâ = a + 7d = 17 ...(2)
- Subtracting (1) from (2): 10 = 5d â d = 2
- Substituting d=2 in (1): 7 = a + 4 â a = 3
- aâ = 3 + (n-1)2
- aââ = 3 + (36-1)2 = 3 + 70 = 73
GEOMETRIC SEQUENCE
A sequence in which every term after the first is obtained from the preceding term by multiplying it with a constant number is called a geometric sequence or geometric progression (G.P.). The constant number, being the ratio of any two consecutive terms, is called the common ratio of the G.P., commonly denoted by ârâ.
ð Examples:
- 1, 2, 4, 8, 16, ... (common ratio = 2)
- 3, -3/2, 3/4, -3/8, ... (common ratio = -1/2)
- 0.1, 0.01, 0.001, 0.0001, ... (common ratio = 0.1 = 1/10)
GENERAL TERM OF A GEOMETRIC SEQUENCE: Let a be the first term and r be the common ratio. Then the sequence is a, ar, ar², ar³, ...
ð Definition â nth term of GP: aâ = arâ¿â»Â¹ for all integers n ⥠1, where a = first term, r = common ratio.
ð Example: Find the 8th term of the geometric sequence 4, 12, 36, 108, ...
- Given: a = 4, r = 12/4 = 3, n = 8
- aâ = 4(3)âžâ»Â¹ = 4(3)â· = 4(2187) = 8748
ð Example: Which term of the geometric sequence is 1/8 if the first term is 4 and common ratio is 1/2?
- Given: a = 4, r = 1/2, aâ = 1/8
- 1/8 = 4(1/2)â¿â»Â¹
- 1/32 = (1/2)â¿â»Â¹
- (1/2)âµ = (1/2)â¿â»Â¹
- n-1 = 5 â n = 6 â 1/8 is the 6th term.
ð Example: Write the geometric sequence with positive terms whose second term is 9 and fourth term is 1.
- Let a = first term, r = common ratio
- aâ = ar = 9 ...(1)
- aâ = ar³ = 1 ...(2)
- Dividing (2) by (1): 1/9 = r² â r = 1/3 (rejecting r = -1/3 as terms must be positive)
- Substituting r = 1/3 in (1): 9 = a(1/3) â a = 27
- Sequence: 27, 9, 3, 1, 1/3, 1/9, ...
SEQUENCES IN COMPUTER PROGRAMMING
An important data type in computer programming consists of finite sequences known as one-dimensional arrays; a single variable in which a sequence of variables may be stored.
ð Example: The names of k students in a class may be represented by an array of k elements ânameâ as: name[0], name[1], name[2], ..., name[k-1].
ð¡ Why this matters: Understanding sequences is essential for working with arrays and indexed data structures in programming.
â Key Takeaways
This lecture establishes that a sequence is a function from integers to terms, defined by explicit formulas or by recursive patterns. The two most important special sequences are arithmetic sequences, where consecutive terms differ by a constant d (formula: aâ = a + (n-1)d), and geometric sequences, where consecutive terms have a constant ratio r (formula: aâ = arâ¿â»Â¹). You must be able to find specific terms from formulas, derive formulas from given terms, and solve for unknown parameters like a, d, r, or n using given conditions. Alternating sequences arise when terms change sign, and sequences in computing correspond to one-dimensional arrays. For exam success, practice converting between sequence descriptions and explicit formulas.
ð§ Quick Revision Questions
- Write the first four terms of the sequence defined by aâ = n/(2n+1) for n ⥠1.
- State the formula for the nth term of an arithmetic progression, defining all symbols.
- Find the 15th term of the arithmetic sequence 7, 11, 15, 19, ...
- Find the 6th term of the geometric sequence 2, -6, 18, -54, ...
- Which term of the geometric sequence with first term 5 and common ratio 2 equals 160?
ð Lecture 14 â Series
ð Overview: This lecture introduces the concept of series as the sum of terms of a sequence, along with summation notation using the Greek letter sigma (Σ). It covers computing sums, transforming sums, properties of summations, and delves into arithmetic and geometric series, including formulas for finite and infinite sums, culminating in important summation formulas and practical problem-solving.
ðïž Topics Covered
This lecture covers defining series and summation notation, computing summations from given sequences, converting between expanded form and summation notation, transforming sums by change of variable, and properties of summations. It then introduces arithmetic series and derives the sum formula, solves problems including the sum of natural numbers and sums with divisibility constraints. Finally, it covers geometric series for both finite and infinite sums, and presents important standard summation formulas for powers of integers.
ð Lecture Summary
Series
A series is the sum of the terms of a sequence. If aâ, aâ, aâ, ... represent a sequence of numbers, then the corresponding series is aâ + aâ + aâ + ... which can be written as Σ aâ (from k=1 to â).
Summation Notation
The capital Greek letter sigma (Σ) is used to write a sum in shorthand notation. For example, Σ aâ (from k=1 to n) = aâ + aâ + aâ + ... + aâ. More generally, if m and n are integers and m †n, then Σ aâ (from k=m to n) = aâ + aâââ + aâââ + ... + aâ. Here, k is called the index of the summation, m is the lower limit, and n is the upper limit.
ð Definition â Summation Notation: A compact way to represent the sum of a sequence of terms using the Greek letter sigma (Σ).
Computing Summations
Given aâ = 2, aâ = 3, aâ = -2, aâ = 1, and aâ = 0, compute:
- Σ aáµ¢ (from i=0 to 4): = aâ + aâ + aâ + aâ + aâ = 2 + 3 + (-2) + 1 + 0 = 4
- Σ aâⱌ (from j=0 to 2): = aâ + aâ + aâ = 2 + (-2) + 0 = 0
- Σ aâ (from k=1 to 1): = aâ = 3
ð Example: Compute Σ (2i - 1) (from i=1 to 3) = [2(1) - 1] + [2(2) - 1] + [2(3) - 1] = 1 + 3 + 5 = 9.
ð Example: Compute Σ (k³ + 2) (from k=-1 to 1) = [(-1)³ + 2] + [(0)³ + 2] + [(1)³ + 2] = [-1+2] + [0+2] + [1+2] = 1 + 2 + 3 = 6.
Summation Notation to Expanded Form
Write the summation Σ (-1)â± / (i + 1) (from i=0 to n) in expanded form: The expanded form is (-1)â°/(0+1) + (-1)¹/(1+1) + (-1)²/(2+1) + (-1)³/(3+1) + ... + (-1)â¿/(n+1) = 1/1 + (-1)/2 + 1/3 + (-1)/4 + ... + (-1)â¿/(n+1) = 1 - 1/2 + 1/3 - 1/4 + ... + (-1)â¿/(n+1).
Expanded Form to Summation Notation
Write the series 1/n + 2/(n+1) + 3/(n+2) + ... + (n+1)/(2n) using summation notation. Solution: Find the kth term of the series. The numerators form an arithmetic sequence 1, 2, 3, ..., n+1. First term a=1, common difference d=1, so the kth numerator aâ = a + (k-1)d = 1 + (k-1)(1) = k. The denominators form an arithmetic sequence n, n+1, n+2, ..., 2n. First term a=n, common difference d=1, so the kth denominator aâ = a + (k-1)d = n + (k-1)(1) = k + n - 1. Hence the kth term of the series is k / [(n-1) + k]. The series is Σ k / [(n-1) + k] (from k=1 to n+1) or equivalently Σ (k+1) / (n+k) (from k=0 to n).
Transforming a Sum by a Change of Variable
The index of a summation is a dummy variable because it can be replaced by any other symbol. For example, Σ k² (from k=1 to 3) = Σ i² (from i=1 to 3).
ð Example: For the sum Σ k / [(n-1) + k] (from k=1 to n+1), substitute k = j + 1 so j = k - 1. When k=1, j=0. When k=n+1, j=n. The sum becomes Σ (j+1) / [(n-1) + (j+1)] (from j=0 to n) = Σ (j+1)/(n+j) (from j=0 to n) = Σ (k+1)/(n+k) (from k=0 to n).
Properties of Summations
- Σ (aâ + bâ) (from k=m to n) = Σ aâ (from k=m to n) + Σ bâ (from k=m to n)
- Σ c·aâ (from k=m to n) = c·Σ aâ (from k=m to n), c â â
- Σ (k + i) (from k=a-i to b-i) = Σ k (from k=a to b)
- Σ (k - i) (from k=a+i to b+i) = Σ k (from k=a to b)
- Σ c (from k=1 to n) = c + c + ... + c (n times) = nc
ð Example: Express Σ (2k - 3) (from k=1 to 3) + Σ (4 - 5k) (from k=1 to n) more simply. Solution: The first sum is a constant, so Σ (2k-3) (from k=1 to 3) = 3. Using property (2) to combine, 3 + Σ (4 - 5k) (from k=1 to n) = Σ [3 + (4 - 5k)] (from k=1 to n) is incorrect as the first sum is a constant, not a summation over n. Wait: 3 · Σ (2k-3) (from k=1 to n) means multiply the sum by 3? No, the first sum is from 1 to 3, a fixed number. Let's recompute: The original sum is Σ (2k-3) (from k=1 to 3) + Σ (4-5k) (from k=1 to n). First sum = (2-3)+(4-3)+(6-3) = (-1)+(1)+(3) = 3. So the expression is 3 + Σ (4-5k) (from k=1 to n) = 3 + [Σ 4 (from k=1 to n) - Σ 5k (from k=1 to n)] = 3 + [4n - 5Σ k (from k=1 to n)].
ð¡ Why this matters: These properties allow us to break complicated sums into simpler parts and handle constant terms efficiently.
Arithmetic Series
The sum of the terms of an arithmetic sequence forms an arithmetic series (A.S.). For example, 1 + 3 + 5 + 7 + ... If a is the first term and d the common difference, the series is a + (a+d) + (a+2d) + ...
Sum of n Terms of an Arithmetic Series: Let a be the first term and d the common difference. The nth term is aâ = a + (n-1)d. The sum Sâ = n(a + l)/2, where l = aâ = a + (n-1)d. Also, Sâ = n/2 [2a + (n-1)d].
ð Formula â Sum of Arithmetic Series: Sâ = n/2 (a + l) = n/2 [2a + (n-1)d]
ð Example: Find the sum of first n natural numbers. Let Sâ = 1 + 2 + 3 + ... + n. This is an arithmetic series with a=1, d=1. Sâ = n/2 [2(1) + (n-1)(1)] = n/2 [2 + n - 1] = n(n+1)/2.
ð Example: Find the sum of all two-digit positive integers which are neither divisible by 5 nor by 2. The numbers are odd and not ending in 5: 11, 13, 17, 19, 21, 23, 27, 29, ..., 97, 99. This is not a simple arithmetic series. Group in sets of four: (11+13+17+19) + (21+23+27+29) + ... + (91+93+97+99) = 60 + 100 + 140 + ... + 380. This is an arithmetic series with a=60, d=40, l=380. Find n: 380 = 60 + (n-1)(40) â 320 = (n-1)(40) â n-1 = 8 â n=9. Sâ = 9/2 (60 + 380) = 9/2 (440) = 1980.
Geometric Series
The sum of the terms of a geometric sequence forms a geometric series (G.S.). For example, 1 + 2 + 4 + 8 + 16 + ... If a is the first term and r the common ratio, the series is a + ar + ar² + ar³ + ...
Sum of n Terms of a Geometric Series: Let a be the first term and r the common ratio. The nth term is aâ = arâ¿â»Â¹. The sum Sâ = a(1 - râ¿)/(1 - r) for r â 1.
ð Formula â Sum of Finite Geometric Series: Sâ = a(1 - râ¿)/(1 - r), r â 1.
ð Example: Find the sum of the geometric series 6 - 2 + 2/3 - 2/9 + ... to 10 terms. Here a=6, r = -2/6 = -1/3, n=10. Sââ = 6[1 - (-1/3)¹â°] / [1 - (-1/3)] = 6[1 - (1/3¹â°)] / (4/3) = 6(3/4)[1 - 1/59049] = (18/4)[59048/59049] = (9/2)(59048/59049).
Infinite Geometric Series: For an infinite geometric series a + ar + ar² + ..., if |r| < 1, then as n â â, râ¿ â 0, so the sum S = a/(1 - r). If the sum increases indefinitely, the series is divergent. If it approaches a finite limit, it is convergent.
ð Formula â Sum of Infinite Geometric Series: S = a/(1 - r), for |r| < 1.
ð Example: Find the sum of the infinite geometric series 9/4 + 3/2 + 1 + 2/3 + ... Here a=9/4, r = (3/2)/(9/4) = (3/2)(4/9) = 2/3. Since |r| < 1, S = a/(1 - r) = (9/4)/(1 - 2/3) = (9/4)/(1/3) = (9/4)(3/1) = 27/4.
ð Example: Find a common fraction for the recurring decimal 0.818181... 0.81 = 0.81 + 0.0081 + 0.000081 + ... This is an infinite geometric series with a=0.81, r=0.0081/0.81=0.01. S = a/(1 - r) = 0.81/(1 - 0.01) = 0.81/0.99 = 81/99 = 9/11.
Important Sums
- Σ k (from k=1 to n) = 1 + 2 + 3 + ... + n = n(n+1)/2
- Σ k² (from k=1 to n) = 1² + 2² + 3² + ... + n² = n(n+1)(2n+1)/6
- Σ k³ (from k=1 to n) = 1³ + 2³ + 3³ + ... + n³ = [n(n+1)/2]²
ð Example: Sum to n terms the series 1·5 + 5·11 + 9·17 + ... The series is formed from two arithmetic sequences: (i) 1, 5, 9, ... with kth term 4k-3; (ii) 5, 11, 17, ... with kth term 6k-1. The kth term of the series Tâ = (4k-3)(6k-1) = 24k² - 22k + 3. Sâ = Σ Tâ (from k=1 to n) = Σ (24k² - 22k + 3) = 24Σ k² - 22Σ k + 3Σ 1 = 24[n(n+1)(2n+1)/6] - 22[n(n+1)/2] + 3n = 4n(n+1)(2n+1) - 11n(n+1) + 3n = 8n³ + n² - 4n.
â Key Takeaways
You must master the definitions of a series and summation notation, including identifying the index, lower, and upper limits. The five properties of summations are essential for simplifying and combining sums. The formulas for arithmetic series (Sâ = n/2[a + l]) and geometric series (Sâ = a(1-râ¿)/(1-r) for finite and S = a/(1-r) for infinite with |r|<1) are fundamental tools. You should be able to convert between expanded form and summation notation, perform change of variable transformations, and apply the three important sums (Σk, Σk², Σk³) to solve complex series problems.
ð§ Quick Revision Questions
- What is the value of Σ (3k - 1) from k=1 to 4?
- Express the series 1/2 + 2/3 + 3/4 + ... + n/(n+1) using summation notation.
- Find the sum of the first 20 terms of the arithmetic series with a=5 and d=3.
- Find the sum of the infinite geometric series 8 + 4 + 2 + 1 + ...
- Find the sum of the series Σ (2k² - k + 1) from k=1 to n.
ð Lecture 15 â Applications of Basic Mathematics
ð Overview: This lecture introduces the five basic arithmetic operations that form the foundation of all mathematics and demonstrates how to perform these operations using Microsoft Excel. It covers starting Excel, understanding its interface, and writing formulas for addition, subtraction, multiplication, division, percentages, and exponents.
ðïž Topics Covered
The lecture covers the five basic arithmetic operations of addition, subtraction, multiplication, division, and exponents with examples, followed by a comprehensive introduction to Microsoft Excel 2002 XP including starting the software, understanding the workbook interface with cells and ranges, entering and editing data, and creating formulas for each arithmetic operation using cell references and Excel operators.
ð Lecture Summary
OBJECTIVES
The objectives of this lecture are to learn about different course modules, basic arithmetic operations, starting Microsoft (MS) Excel, and using MS Excel to carry out arithmetic operations.
BASIC ARITHMETIC OPERATIONS
Five arithmetic operations provide the foundation for all mathematical operations: Addition, Subtraction, Multiplication, Division, and Exponents.
ð Definition â Arithmetic Operations: The five fundamental operations that form the basis for all mathematical calculations.
ð Example â Addition: 12 + 5 = 17 ð Example â Subtraction: 12 - 5 = 7 ð Example â Multiplication: 12 x 5 = 60 ð Example â Division: 12 ÷ 5 = 2.4 ð Example â Exponent: (4)^2 = 16, (4)^1/2 = 2, (4)^-1/2 = 1/(4)^1/2 = œ = 0.5
MICROSOFT EXCEL IN BUSINESS MATHEMATICS & STATISTICS
Microsoft Corporation's Spreadsheet software Excel is widely used in business mathematics and statistical applications. The latest version covered is EXCEL 2002 XP, though earlier versions like EXCEL 2000 and EXCEL 97 can also be used for the applications in this course.
Starting EXCEL 2000 XP
EXCEL 2000 XP can be started by going through the following steps:
- Click Start on your computer
- Click All Programs
- Click Microsoft Excel
The EXCEL window opens and a blank worksheet becomes available. A Workbook by the name book1 is shown with three sheets: Sheet1, Sheet2 and Sheet3. The Excel Window has Column numbers starting from A and row numbers starting from 1. The intersection of a row and column is called a Cell. The first cell is A1 which is the intersection of column A and row 1. All cells in a Sheet are referenced by a combination of Column name and row number.
ð Definition â Cell: The intersection of a row and column in an Excel worksheet, referenced by a combination of column letter and row number. ð Example â Cell Reference: B15 means cell in column B and row 15. A cell in row 12 and column C has reference C12.
ð Definition â Range: All cells starting from the leftmost corner where the range starts to the rightmost corner in the last row, specified by the starting cell, a colon, and the ending cell. ð Example â Range: A Range which starts from A1 and ends at D15 is referenced by A1:D15 and has all the cells in columns A to D up to and including row 15.
A value can be entered into a cell by clicking that cell. The mouse pointer moves to the selected cell. Enter the value followed by the Enter key and the mouse pointer moves to the cell below. To replace a value, select the cell again and enter the new value. To change individual digits, double-click the cell to see the blinking cursor, then use arrow keys or mouse to move to the digit to be changed.
About calculation operators in Excel
In Excel there are four different types of operators:
- Arithmetic operators
- Comparison operators
- Text concatenation operator
- Reference operators
The Excel arithmetic operators are as follows:
- Addition: Symbol: + (Example: =5+4 Result: 9)
- Subtraction: Symbol: - (Example: =5-4 Result: 1)
- Multiplication: Symbol: * (Example: =5*4 Result: 20)
- Division: Symbol: / (Example: =12/4 Result: 3)
- Percent: Symbol: % (Example: =20% Result: 0.2)
- Exponentiation: Symbol: ^ (Example: =5^2 Result: 25)
Excel Formulas for Addition
All calculations in Excel are made through formulas which are written in cells where the result is required.
To add two numbers 10 and 5 in Excel:
- Open a blank worksheet
- Click on cell A15 and enter 10
- Click on cell B15 and enter 5
- Click on cell C15 (where the sum will appear)
- Enter equal sign = in cell C15
- Write "(" (left bracket) in cell C15
- Click on cell A15 (value 10) â the cell reference A15 is written
- Write "+" after A15
- Click on cell B15 (value 5) â the cell reference B15 is written
- Write ")" (right bracket)
- Press Enter key
The answer 15 is shown in cell C15. The formula "=A15+B15" is displayed in the formula bar.
ð Example â Adding multiple numbers: To add 5, 10, 15, 20, 30 and 40, enter values in cells A34 through F34. Write formula =5+10+15+20+30+40 in cell G34. The answer is 120.
Alternatively, use the SUM function: Enter =SUM(A34:F34) by typing "=" followed by SUM, followed by "(", clicking on cell A34 (value 5), dragging to cell F34 (value 40), entering ")", and pressing Enter.
Excel Formula for Subtraction
Excel formulas for subtraction use the minus sign (-). To subtract 15 from 25:
- Enter 25 in cell A50 and 15 in cell B50
- Write formula =A50-B50 in cell C50
The answer 10 is displayed in cell C50. If you enter 15 first and 25 later, the result would be 15-25 = -10.
Excel Formula for Multiplication
The Excel multiplication operator is * (asterisk). To multiply 25 by 15:
- Enter 25 in cell A60 and 15 in cell B60
- Write formula =A60*B60 in cell C60
The answer 375 is displayed in cell C60.
Excel Formula for Division
The division sign is / (forward slash). To divide 240 by 15:
- Enter 240 in cell A75 and 15 in cell B75
- Write formula =A75/B75 in cell C75
The answer 16 is displayed in cell C75.
Excel Formula for Percent
The formula for converting percent to fraction uses the symbol %. To convert 20% to fraction:
- Write =20% â the result is 0.2
If you enter 20 in cell A99, write =A99% in cell B99 to get the result 0.2.
Excel Formula for Exponentiation
The symbol for exponentiation is ^ (caret). To calculate 16 raised to the power 2:
- Enter 16 in cell A85 and 2 in cell B85
- Write formula =A85^B85 in cell C85
The answer 256 is displayed in cell C85.
â Key Takeaways
The five fundamental arithmetic operationsâaddition, subtraction, multiplication, division, and exponentsâare performed in Excel by writing formulas that begin with an equals sign (=) and use cell references and arithmetic operators (+, -, *, /, %, ^). Every formula in Excel must start with =, and it is best practice to reference cells by their coordinates (like A15) rather than typing numbers directly, so that results update automatically when values change. The SUM function provides an efficient way to add multiple values in a range. Understanding cell references, ranges, and the formula bar is essential for all spreadsheet work in business mathematics and statistics.
ð§ Quick Revision Questions
- What are the five basic arithmetic operations, and what symbols does Excel use for each?
- How do you reference a range of cells from column B row 3 to column F row 20 in Excel?
- What must every Excel formula begin with, and why is it better to use cell references instead of actual numbers in formulas?
- What is the result of the Excel formula =16^2, and what operator is used for exponentiation?
- How would you write an Excel formula to convert 45% into a decimal fraction?
ð Lecture 16 â Applications of Basic Mathematics (Continued)
ð Overview: This lecture continues the application of basic mathematics, focusing on percentage change calculations and their use in real-world scenarios like salary increases and investment returns. The lecture demonstrates how to perform these calculations both manually and using Microsoft Excel, making the concepts practical for business and financial planning.
ðïž Topics Covered
The lecture covers calculating percentage change between two values, including increases and decreases, with multiple examples such as sales growth, fruit drying, and cotton weight change. It then applies these concepts to multi-year salary increases with varying annual percentages, and finally to investment returns over multiple years with both positive and negative rates of return. All calculations are demonstrated step-by-step in Microsoft Excel.
ð Lecture Summary
Percentage Change
To find the percent change between an initial and final value, first compute the change by subtracting the initial value from the final value. Then, divide this change by the initial value and multiply by 100%. The formula works for both increases (positive change) and decreases (negative change). In Excel, the formula for change is =Final_Cell - Initial_Cell, and for percentage change it is =Change_Cell / Initial_Cell * 100.
ð Definition â Percentage Change: (Final value â Initial value) / Initial value à 100%
ð Formula: Percentage change = (Change / Initial value) Ã 100%
ð Example: Mondayâs Sales were Rs.1000 and grew to Rs.2500 the next day. Initial = 1000, Final = 2500, Change = 2500-1000 = 1500, % Change = (1500/1000) Ã 100 = 150%. In Excel, cell C4=1000, C5=2500, formula in C6 = =C5-C4 (result 1500), formula in C7 = =C6/C4*100 (result 150).
Example 1: Next Dayâs Sale as Percentage of Mondayâs Sale
This example finds what percent the next dayâs sale represents compared to Mondayâs sale. This is a ratio calculation, not a change calculation. Mondayâs sale = 1000, Next dayâs sale = 2500. Next dayâs sale as % = 2500/1000 Ã 100 = 250%, meaning the next dayâs sale was two and a half times Mondayâs sale.
Example 2: Dried Fruit â Percentage Decrease
In making dried fruit, 15 kg of fresh fruit shrinks to 3 kg of dried fruit. This is a decrease. Original = 15 kg, Final = 3 kg, Change = 3-15 = -12, % change = -12/15 Ã 100 = -80%. The size was reduced by 80%. In Excel, cell D19=15, D20=3, formula in D21 = =D20-D19 (result -12 kg), formula in D22 = =D21/D19*100 (result -80%).
Example 3: Cotton Weight â Percentage Increase
After mixing with water, cotton weight increased from 3 kg to 15 kg. Original = 3 kg, Final = 15 kg, Change = 15-3 = 12, % change = 12/3 Ã 100 = 400%. Weight increased by 400%. In Excel, cell D26=3, D27=15, formula in D28 = =D27-D26 (result 12 kg), formula in D29 = =D28/D26*100 (result 400%).
Example 4: Multi-Year Salary Increase
A union signed a three-year contract with wage increases of 3%, 2%, and 1% in successive years. An employee currently earns Rs. 5000 per month. The salary at the end of the contract is calculated by applying each percentage increase sequentially: 5000 Ã (1 + 3%) Ã (1 + 2%) Ã (1 + 1%) = 5000 Ã 1.03 Ã 1.02 Ã 1.01 = Rs. 5306. In Excel, the ROUND function is used to round to zero decimal places. Data: cell C35=5000, C36=3, C38=2, C40=1. Formulas: C37 = =ROUND(C35*(1+C36/100);0) (result 5150), C39 = =ROUND(C37*(1+C38/100);0) (result 5253), C41 = =ROUND(C39*(1+C40/100);0) (result 5306).
Example 5: Multi-Year Investment Return
An investment of Rs. 100,000 is made for 4 years with annual rates of return: 4%, 8%, -10%, and 9%. The value at the end of each year is calculated by applying the return to the previous yearâs value. Data: cell C46=100000, C47=4, C49=8, C51=-10, C53=9. Formulas: C48 = =ROUND(C46*(1+C47/100);0) (result 104000), C50 = =ROUND(C48*(1+C49/100);0) (result 112320), C52 = =ROUND(C50*(1+C51/100);0) (result 101088), C54 = =ROUND(C52*(1+C53/100);0) (result 110186). ð¡ Why this matters: This demonstrates how a negative return in one year can significantly reduce the overall investment value, and how compounding works over multiple periods.
â Key Takeaways
The formula for percentage change is always (Final â Initial) / Initial à 100%, where a negative result indicates a decrease. When calculating cumulative effects like salary increases or investment returns over multiple years, each yearâs percentage change is applied sequentially to the previous yearâs result, using the formula Previous_Value à (1 + Rate/100). The Excel ROUND function is useful for displaying whole numbers (no decimals). For percentage change, the initial value is always the denominator, while for finding what percent one value is of another, you use that value divided by the reference value.
ð§ Quick Revision Questions
- What is the formula for calculating percentage change, and how do you interpret a negative result?
- In Example 4, if the wage increases were applied in reverse order (1%, 2%, 3%), would the final salary be the same? Why or why not?
- In Example 5, calculate the value after year 2 if the rates were 5% and 10% instead of 4% and 8%, starting from Rs. 100,000.
- If Mondayâs sales are Rs. 500 and Tuesdayâs are Rs. 750, what is the percentage change from Monday to Tuesday?
- An investment of Rs. 50,000 loses 20% in year 1 and gains 25% in year 2. What is the final value after year 2?