π Lecture 1 β COURSE OVERVIEW
π Overview: This first lecture introduces the entire MTH 302 courseβits purpose, structure, modules, evaluation, and expected outcomes. It serves as a roadmap for students, explaining what topics will be covered across 45 lectures, how grades are calculated, and what resources are needed, with a strong emphasis on using Microsoft Excel for business problem-solving.
ποΈ Topics Covered
This lecture covers the course title and instructor background, the overall objective of applying mathematics to business decisions, eight course modules spanning basic mathematics, algebra, ratio and proportion, merchandising, break-even analysis, statistics, probability, and linear programming, as well as the marking scheme, required resources (including Excel), evaluation criteria, and detailed topic breakdowns for all 45 lectures.
π Lecture Summary
COURSE TITLE
The title of this course is βBUSINESS MATHEMATICS AND STATISTICSβ. The instructor is Dr. Zahir Fikri, who holds a Ph.D. in Electric Power Systems Engineering from the Royal Institute of Technology, Stockholm, Sweden. His thesis title was βStatistical Load Forecasting for Distribution Network Planning.β
Objective
The purpose of the course is to provide the student with a mathematical basis for personal and business financial decisions through eight instructional modules. The course stresses business applications using arithmetic, algebra, ratio-proportion, and graphing. Applications include payroll, cost-volume-profit analysis, and merchandising mathematics. The course also includes Statistical Representation of Data, Correlation, Time Series and Exponential Smoothing, Elementary Probability, and Probability Distributions. This course stresses logical reasoning and problem solving skills. Access to Microsoft Excel software is required for the course.
Course Outcomes
Successful completion of this course will enable the student to:
- Apply arithmetic and algebraic skills to everyday business problems.
- Use ratio, proportion and percent in the solution of business problems.
- Solve business problems involving commercial discount, markup and markdown.
- Solve systems of linear equations graphically and algebraically and apply to cost volume-profit analysis.
- Apply Statistical Representation of Data, Correlation, Time Series and Exponential Smoothing methods in business decision making
- Use elementary probability theory and knowledge about probability distributions in developing profitable business strategies.
COURSE MODULES
The following are the main eight modules of this course:
- Module 1 (Lectures 1-6): Applications of Basic Mathematics β Overview, arithmetic operations, fractions/percent/base, gross earnings, averages, commission, brokerage, discount, simple and compound interest, average due date.
- Module 2 (Lectures 7-11): Applications of Basic Algebra & Ratio β Exponents and radicals, linear equations, rearranging formulas, compounding percent changes, investment returns, matrices, ratios, proportions, prorata allocation.
- Module 3 (Lectures 12-16): Merchandising and Financial Mathematics β Trade discounts, equivalent single discount rates, markup and markdown, financial mathematics parts 1-3.
- Module 4 (Lectures 17-22): Break-Even Analysis β Graphing linear equations, solving two linear equations, cost-volume-profit analysis, break-even charts, algebraic approach, contribution margin, Microsoft Excel applications.
- Module 5 (Lectures 23-27): Statistical Representation of Data β Statistical data, measures of central tendency (parts 1 & 2), measures of dispersion and skewness (parts 1 & 2).
- Module 6 (Lectures 28-33): Correlation, Time Series and Exponential Smoothing β Correlation (parts 1 & 2), line fitting (parts 1 & 2), time series and exponential smoothing (parts 1 & 2).
- Module 7 (Lectures 34-40): Elementary Probability β Factorials, permutations and combinations, elementary probability (parts 1 & 2), binomial, Poisson, and normal distributions (parts 1-4).
- Module 8 (Lectures 41-45): Probability Distributions & Linear Programming β Estimating from samples (inference parts 1 & 2), hypothesis testing (Chi-Square distribution parts 1 & 2), production planning (linear programming).
MARKING SCHEME
As per VU Rules, the grading breakdown is:
- Mid Term Exam: 35%
- Final Exam: 50%
- 4 Assignments: 15% Note: The course modules are subject to change.
DESCRIPTION OF TOPICS
The document provides a detailed table mapping all 45 lectures to their main module, lecture topics, and recommended reading references. Key highlights include:
- Module 1 covers basic mathematics (Lectures 1-6)
- Module 2 covers basic algebra (Lectures 7-9) and ratio/proportion (Lectures 10-11)
- Module 3 covers merchandising/finance (Lectures 12-16)
- Module 4 covers break-even analysis (Lectures 17-22) with an assignment and mid-term examination
- Module 5 covers statistics (Lectures 23-27)
- Module 6 covers correlation/time series (Lectures 28-33) with an assignment
- Module 7 covers probability (Lectures 34-40)
- Module 8 covers inference, hypothesis testing, and linear programming (Lectures 41-45) with an assignment and end-term examination
Methodology
There will be 45 lectures each of 50 minutes duration as indicated above. The lectures will be delivered in a mixture of Urdu and English. The lectures will be heavily supported by slide presentations. The slides for a lecture will be made available on the VU website for the course a few days before the actual lecture is televised. This will allow students to carry out preparatory reading before the lecture. The course will be provided its own page on the VUβs web site, which will be used to provide lecture and other supporting material. The page will have a link to a web-based discussion and bulletin board for the students. Teaching assistants will be assigned by VU to provide various forms of assistance such as grading, answering questions posted by students and preparation of slides.
Text and Reference Material
The course is based on material from different sources. The following material will be used by the students as reference:
- Reference 1: Course Outline
- Reference 2: Instructorβs Power Point Slides
- Reference 3: Business Mathematics & Statistics by Prof. Miraj Din Mirza
- Reference 4: Elements of statistics & Probability by Shahid Jamal
- Reference 5: Quantitative Approaches in Business studies by Clare Morris
- Reference 6: Microsoft Excel Help File
β Key Takeaways
This lecture lays the foundation for the entire course. Students must understand that MTH 302 is divided into eight modules spanning 45 lectures, covering basic math through to advanced topics like linear programming and hypothesis testing. The course places heavy emphasis on Microsoft Excel as a required tool for nearly every topic. The grading scheme is critical: the mid-term exam is worth 35%, the final exam is worth 50%, and four assignments contribute 15%. Students should note that lectures mix Urdu and English with heavy slide support, and all materials are available online. Finally, the course is designed to be accessible to students with no prerequisite mathematical skills, with Excel proficiency being an advantage but not a requirement.
π§ Quick Revision Questions
- What are the three components of the grading scheme for MTH 302, and what percentage does each contribute to the final grade?
- Name at least three of the eight course modules listed in this lecture.
- Which software application is mandatory for the successful completion of this course?
- How many lectures are there in the entire course, and what is the duration of each lecture?
- What is the main objective of the course "Business Mathematics and Statistics"?
π Lecture 2 β Applications of Basic Mathematics
Part 1
π Overview: This lecture introduces the foundational arithmetic operations essential for business mathematics and statistics, and demonstrates how to perform these operations using Microsoft Excel. It covers the five basic arithmetic operations and provides step-by-step guidance on starting Excel and using formulas for addition, subtraction, multiplication, division, percentages, and exponentiation.
ποΈ Topics Covered
The lecture begins by outlining the eight course modules (Mathematics Modules 1-4 and Statistics Modules 5-8). It then explains the five basic arithmetic operations: addition, subtraction, multiplication, division, and exponents. The core of the lecture focuses on starting Microsoft Excel 2000 XP, understanding the Excel interface (workbooks, sheets, cells, ranges), entering and editing data, and using Excel formulas with arithmetic operators (+, -, *, /, %, ^) to perform calculations. Detailed examples show how to write formulas for each operation, including using the SUM function and cell references.
π Lecture Summary
COURSE MODULES
This course is divided into 8 modules. Modules 1-4 cover Mathematics, and Modules 5-8 cover Statistics. Details of these modules are provided in the lecture 01 handout.
BASIC ARITHMETIC OPERATIONS
Five arithmetic operations form the foundation for all mathematical operations. These are: addition, subtraction, multiplication, division, and exponents.
π Example - Addition: 12 + 5 = 17
π Example - Subtraction: 12 - 5 = 7
π Example - Multiplication: 12 x 5 = 60
π Example - Exponent: (4)^2 = 16; (4)^1/2 = 2; (4)^-1/2 = 1/(4)^1/2 = 1/2 = 0.5
MICROSOFT EXCEL IN BUSINESS MATHEMATICS & STATISTICS
Microsoft Excel is a spreadsheet software widely used in business mathematics and statistical applications. This course is based on EXCEL 2002 XP, though earlier versions like EXCEL 2000 or EXCEL 97 can also be used for the intended applications.
Starting EXCEL 2000 XP
To start Excel, click Start on your computer, then click All Programs, then click Microsoft Excel.
The Excel window opens showing a blank workbook (by default named book1) 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.
π Example 1: B15 means the cell in column B and row 15.
π Example 2: A cell in row 12 and column C has reference C12.
A Range defines all cells starting from the leftmost corner where the range starts to the rightmost corner in the last row. The range is specified by the starting cell, a colon, and the ending cell.
π Example 3: A Range starting from A1 and ending at D15 is referenced by A1:D15 and includes all 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. Simply enter the value followed by the Enter key. The mouse pointer moves to the cell below. If you make a mistake, select the cell again and enter the new value. To change only specific digits, double-click the cell to see the blinking cursor, then use arrow keys to move to the digit and edit it.
π‘ Why this matters: Understanding cell references, ranges, and data entry is fundamental before performing any calculations in Excel.
About Calculation Operators in Excel
In Excel, there are four different types of operators: Arithmetic operators, Comparison operators, Text concatenation operator, and Reference operators. This lecture focuses on arithmetic operators. The Excel arithmetic operators are:
π Definition β Arithmetic Operators:
- Addition: Symbol:
+(Example:=5+4Result: 9) - Subtraction: Symbol:
-(Example:=5-4Result: 1) - Multiplication: Symbol:
*(Example:=5*4Result: 20) - Division: Symbol:
/(Example:=12/4Result: 3) - Percent: Symbol:
%(Example:=20%Result: 0.2) - Exponentiation: Symbol:
^(Example:=5^2Result: 25)
Excel Formulas for Addition
All calculations in Excel are made through formulas written in cells where the result is required. To add two numbers (e.g., 10 and 5):
- Open a blank worksheet.
- Enter 10 in cell A15.
- Enter 5 in cell B15.
- Click cell where you want the sum (e.g., C15).
- Start the formula by writing
=in cell C15. - Write
(in cell C15. - Click on cell A15 (the formula shows
A15). - Write
+in cell C15. - Click on cell B15 (the formula shows
B15). - Write
)in cell C15. - Press Enter. The answer 15 is shown in cell C15.
The formula displayed in the formula bar is
=A15+B15.
To add six numbers (5, 10, 15, 20, 30, 40) entered in cells A34:F34, you can write the formula: =5+10+15+20+30+40 in cell G34 to get 120. Alternatively, you can use the SUM function: enter =SUM(A34:F34) to get the same result.
Excel Formula for Subtraction
Subtraction formulas are similar to addition but use the minus sign. To subtract 15 from 25:
- Enter 25 in cell A50 and 15 in cell B50.
- In cell C50, write the formula:
=A50-B50. - The answer is 10. The order of entries matters (A50-B50 gives a positive result; B50-A50 gives -10).
π Formula: =A50-B50 β subtracts the value in B50 from the value in A50.
Excel Formula for Multiplication
Multiplication uses the * operator. To multiply 25 by 15:
- Enter 25 in cell A50 and 15 in cell B50 (using row 60 as shown in slides, though text mentions row 50).
- In cell C50, write the formula:
=A50*B50. - The answer is 375.
π Formula: =A50*B50 β multiplies the value in A50 by the value in B50.
Excel Formula for Division
Division uses the / operator. To divide 240 by 15:
- Enter 240 in cell A75 and 15 in cell B75.
- In cell C75, write the formula:
=A75/B75. - The answer is 16.
π Formula: =A75/B75 β divides the value in A75 by the value in B75.
Excel Formula for Percent
The percent operator % converts a percentage to its decimal fraction. To convert 20%:
- Enter 20 in cell A99.
- In cell B99, write:
=A99%. - The answer is 0.2.
π Formula: =A99% β divides the value in A99 by 100 to convert from percent to decimal.
Excel Formula for Exponentiation
Exponentiation uses the ^ operator (carat). To calculate 16 raised to the power 2:
- Enter 16 in cell A85 and 2 in cell B85.
- In cell C85, write the formula:
=A85^B85. - The answer is 256.
π Formula: =A85^B85 β raises the value in A85 to the power indicated by the value in B85.
β Key Takeaways
The five basic arithmetic operationsβaddition, subtraction, multiplication, division, and exponentsβare the foundation for all business mathematics and statistical calculations. Excel is a powerful tool for performing these operations, and understanding its interface (cells, ranges, and formulas) is essential for efficient computation. All Excel formulas must start with an = sign, and cell references (like A15 or B50) are used to perform calculations dynamically. Each arithmetic operation has a specific operator: + for addition, - for subtraction, * for multiplication, / for division, ^ for exponentiation, and % for percentage conversion. Mastering Excel formulas for these operations is critical for solving real-world business problems efficiently.
π§ Quick Revision Questions
- What are the five basic arithmetic operations that provide the foundation for all mathematical operations?
- What is the symbol for exponentiation in Excel, and what is the result of
=5^2? - Describe the steps to add two numbers (like 10 and 5) using cell references in an Excel formula.
- Explain how a Range is defined in Excel. What does the reference
A1:D15mean? - What is the difference between using
=A50-B50and=B50-A50in Excel when A50 is 25 and B50 is 15? What are the results?
π Lecture 3 β Applications of Basic Mathematics Part 2
π Overview: This lecture covers the evaluation criteria and grading structure for the course, then dives into the practical mathematics of calculating gross earnings for employees. It explains the components of salary, taxation rules on allowances, and various costs borne by the company, including provident fund, gratuity fund, leaves, and social charges, concluding with a refresher on fractions, decimals, and percentages. Understanding these calculations is critical for business payroll and cost management.
ποΈ Topics Covered
The lecture begins with the course's evaluation criteria, grading breakdown, and methodology. It then introduces types of employees and defines gross earnings, focusing on the structure of allowances and the rule that only the portion above 50% of basic salary is taxable. The topics cover provident trust fund contributions (1/11th of basic salary by employee and employer), gratuity fund contributions (1/11th of basic salary by employer), costing of leaves (casual, earned, sick), and the calculation of total social charges as a percentage of gross salary. The lecture concludes with a review of converting fractions to percents and vice versa, and the formula for calculating a percentage.
π Lecture Summary
Evaluation
To pass this course, you must meet four criteria: full participation is expected, all assignments must be completed by the closing date, the overall grade will be based on VUβs existing Grading Rules, and all requirements must be met. The grading structure consists of a Mid Term Exam (35%), a Final Exam (50%), and 4 Assignments (15%). You are encouraged to collaborate with other students but must prepare your own original submissions, as copying will negatively impact your studies.
Types of Employees
There are three types of employees in a company: Regular employees drawing a monthly salary, Part time employees paid on an hourly basis, and employees with Payments on a per piece basis.
GROSS EARNINGS/SALARY
Gross salary includes Basic salary and Allowances. Allowances may include House Rent, Conveyance allowance, and Utilities allowance. According to taxation rules, if allowances are 50% of the basic salary, the amount is treated as tax free. Any allowances that exceed this amount are considered taxable for both the employee and the company.
π Definition β Taxable Allowances: The portion of allowances that exceeds 50% of the basic salary. This amount is added back to the employee's taxable income and to the company's income.
π Formula: Total Taxable Income = Basic Salary + (Total Allowances - 0.5 Γ Basic Salary)
π Example 1: Basic salary = 10,000 Rs., Allowances = 5,000 Rs.
% Allowances = (5000/10000) Γ 100 = 50%. Since allowances are exactly 50%, they are not taxable. Total taxable income = 10,000 Rs. Add back to the income of the company = 0.
π Example 2: Basic salary = 10,000 Rs., Allowances = 7,000 Rs.
% Allowances = (7000/10000) Γ 100 = 70%. Allowed non-taxable allowances = 50% = 0.5 Γ 10000 = 5,000 Rs. Taxable allowances = 70% β 50% = 7000 - 5000 = 2,000 Rs. Hence, 2,000 Rs. of allowances are taxable. Total taxable income = 10,000 + 2000 = 12,000 Rs. Add back to the income of the company = 2,000 Rs.
Structure of Allowances
The common structure of allowances is: House Rent = 45%, Conveyance allowance = 2.5%, Utilities allowance = 2.5%. π Example 3: Basic salary = 10,000 Rs. House rent allowances = 0.45 Γ 10000 = 4,500 Rs. Conveyance allowance = 0.025 Γ 10000 = 250 Rs. Utilities allowance = 0.025 Γ 10000 = 250 Rs. Thus total allowances are 4500+250+250 = 5,000 Rs.
Provident Fund
A company can establish a Provident Trust Fund for the benefit of employees. By law, 1/11th of Basic Salary per month is deducted from the employeeβs gross earnings. An equal amount (1/11th of basic salary per month) is contributed by the company to the Provident Fund for the employee. Interest earned on investments is credited to the employees' accounts. π Example 4: Basic salary = 10,000 Rs., Allowances = 5,000 Rs. Employee contribution to Provident Fund = 1/11 Γ 10000 = 909.1 Rs. Company contribution to Provident Fund = 1/11 Γ 10000 = 909.1 Rs. Total savings of employee in Provident Fund = 909.1 + 909.1 = 1,818.2 Rs.
Gratuity Fund
A company can establish a Gratuity Trust Fund for employees. By law, 1/11th of Basic Salary per month is contributed only by the company to the Gratuity Fund for the employee. Interest earned on investments is credited to the employees' accounts. π Example 5: Basic salary = 10,000 Rs., Allowances = 5,000 Rs. Company contribution to Gratuity Fund = Total savings of employee = 1/11 Γ 10000 = 909.1 Rs.
Leaves
Typical leaves allowed may be: Casual Leave = 18 Days per year, Earned Leave = 18 Days per year, Sick Leave = 12 Days per year. π Example 6: Basic salary = 10,000 Rs., Allowances = 5,000 Rs. Normal working days per month = 22. Gross salary = 10000 + 5000 = 15,000 Rs. Cost of casual leaves per year = {18 / (22 Γ 12)} Γ 15000 Γ 12 = 12,272.7 Rs. Cost of earned leaves per year = {18 / (22 Γ 12)} Γ 15000 Γ 12 = 12,272.7 Rs. Cost of Sick leaves per year = {12 / (22 Γ 12)} Γ 15000 Γ 12 = 8,181.8 Rs. Total cost of leaves per year = 12272.7 + 12272.7 + 8181.8 = 32,727.3 Rs. Total cost of leaves as percent of gross salary = (32727.3 / (12 Γ 15000)) Γ 100 = 18.2%
Social Charges
Social charges comprise leaves, group insurance, and medical. Typical medical/group insurance is about 5% of gross salary. Other social benefits may be about 5.8%. Leaves are 18.2% of gross salary. Therefore, total social charges = 18.2 + 5 + 5.8 = 29% of gross salary. π Example 7: Basic salary = 10,000 Rs., Allowances = 5,000 Rs. Gross Salary = 15,000 Rs. Leaves cost = 0.182 Γ 15000 = 2,730 Rs. Group insurance/medical = 0.05 Γ 15000 = 750 Rs. Other social benefits = 0.058 Γ 15000 = 870 Rs. Total social charges = 2730 + 750 + 870 = 4,350 Rs.
SUMMARY of Salary Components
Different components of salary are summarized as:
- Basic salary
- Allowances: 50% of basic salary
- Gratuity: 9.09% of basic salary
- Provident Fund: 9.09% of basic salary
- Social Charges: 29% of gross salary
Gross remuneration includes: 1. Basic Salary, 2. House rent allowance, 3. Conveyance allowance, 4. Utilities, 5. Provident fund, 6. Gratuity fund, 7. Leaves, 8. Group insurance, 9. Miscellaneous social charges. π‘ Why this matters: Calculating total gross remuneration is essential for determining the true cost of an employee to the company.
Converting fraction to percent
To calculate a percent, multiply the fraction by 100 and put the percent sign (%).
π Formula: Percent = Fraction Γ 100
π Example 9: Convert 0.1 to percent. 0.1 Γ 100 = 10%
Common fraction: A fraction having an integer as a numerator and an integer as a denominator (e.g., Β½, 10/100). Convert percent into Common Fraction: π Example 11: 20% = 20/100 = 0.2
Decimal fraction: Any number written in the form: an integer followed by a decimal point followed by a string of digits (e.g., 2.5, 3.9). Convert percent into decimal fraction: π Example: 20% = 0.2
Percent: 20% or 20/100 = 0.2.
Percentage: A percentage is formed by multiplying a number called the base by a percent, called the rate.
π Formula: Percentage = Base Γ Rate
π Example 13: What is 20% of 120?
Rate = 20% = 20/100 = 0.2. Base = 120.
Percentage = 0.2 Γ 120 = 24
π Example 14: What is 6% of 40?
Percentage = Rate Γ Base = 0.06 Γ 40 = 2.4
Base: To find the base when the percentage and rate are known:
π Formula: Base = Percentage / Rate
π Example 15: Find base if Rate = 24.0% = 0.24, Percentage = 96.
Base = 96 / 0.24 = 400
β Key Takeaways
The most critical concepts from this lecture are the components of gross salary and the rules for taxation, specifically that allowances up to 50% of basic salary are tax-free and any excess is taxable. You must know how to calculate employee and employer contributions to the Provident Fund and employer contributions to the Gratuity Fund, both at 1/11th of basic salary. The method for calculating the annual cost of leaves (Casual, Earned, Sick) as a percentage of gross salary is essential, along with the total Social Charges figure of 29% of gross salary. Finally, be fluent in converting between fractions, decimals, and percentages, and using the formula Percentage = Base Γ Rate to solve real-world problems.
π§ Quick Revision Questions
- What is the tax-free limit for allowances as a percentage of basic salary?
- An employee has a basic salary of 15,000 Rs. and allowances of 9,000 Rs. What is the add back to the company's income?
- If an employeeβs basic salary is 11,000 Rs., what is the total employee contribution to the Provident Fund per month?
- For an employee with a gross salary of 18,000 Rs. per month, what is the annual cost of Sick Leave (12 days/year) if normal working days per month is 22?
- If a rate is 30% and the percentage is 150, what is the base?
π Lecture 4 β Applications of Basic Mathematics Part 3
π Overview: This lecture continues the application of basic mathematics to payroll calculations, focusing on gross remuneration and social charges. It also introduces the concept of averages, including weighted averages, and provides comprehensive guidance on using Microsoft Excel for calculations, sums, and averages.
ποΈ Topics Covered
The lecture begins with a review of gross remuneration calculation based on basic salary, including house rent, conveyance, utilities, gratuity, and provident fund, with corresponding Excel formulas. It then explains how to calculate social charges and details various methods for adding numbers in Excel, such as AutoSum, SUMIF, and DSUM. The concepts of simple average, weighted average, and their Excel implementations are covered, including examples of grade calculation and labor cost averaging.
π Lecture Summary
Review Lecture 3
This section shows the worksheet calculation of Gross remuneration based on a basic salary of 6000 Rs. House rent is 45% of basic salary, Conveyance allowance is 2.5% of basic salary, Utilities allowance is 2.5% of basic salary. Both Gratuity and Provident fund are 1/11th of basic salary. The $ sign in Excel formulas (e.g., =$B$93) fixes the cell location, allowing quick and correct calculation of all allowances based on the basic salary. The ROUND function is used to round off values to a desired number of decimals, e.g., =ROUND((1/11)*$B$93;0) rounds to no decimal places.
The calculation for Social charges uses the formula B93*(29/100), representing 29% social charges. In the example, the $ sign was not used to explain that if the formula in cell D93 were copied to cell E93, the cell reference B93 would change to C93 (relative reference). $B$93 would be needed to keep the basic salary fixed.
π Definition β Gross Remuneration: The total salary including basic pay and all allowances (house rent, conveyance, utilities) before deductions. π Formula: Gross Salary = Basic Salary + House Rent + Conveyance Allowance + Utilities Allowance. House Rent = 0.45 Γ Basic Salary. Conveyance/Utilities = 0.025 Γ Basic Salary each. Gratuity = (1/11) Γ Basic Salary. π Example: Basic Salary = 6000 Rs. House Rent = 0.45 Γ 6000 = 2700 Rs. Conveyance Allowance = 0.025 Γ 6000 = 150 Rs. Utilities Allowance = 0.025 Γ 6000 = 150 Rs. Gross Salary = 6000 + 2700 + 150 + 150 = 9000 Rs. Gratuity = (1/11) Γ 6000 β 545 Rs.
AVERAGE
The Average (or Arithmetic Mean) is calculated by dividing the sum of all data values by the number of data values.
π Definition β Average (Arithmetic Mean): A measure of central tendency calculated as the sum of all values divided by the count of values. π Formula: Average = Sum / N, where Sum = total of all data values and N = number of data values. π Example: Data: 10, 7, 9, 27, 2. Sum = 10 + 7 + 9 + 27 + 2 = 55. There are 5 data values. Average = 55 / 5 = 11.
ADDING NUMBERS USING MICROSOFT EXCEL
This section details seven methods for adding numbers in Excel:
- Add numbers in a cell: Type an equation directly, e.g.,
=5+10results in 15. - Add all contiguous numbers in a row or column using AutoSum: Click a cell next to the last data value, click the AutoSum symbol (Ξ£) in the toolbar, and press ENTER.
- Add noncontiguous numbers: Use the SUM function.
- Add numbers based on one condition: Use the SUMIF function to create a total value for one range based on a value in another range.
- Add numbers based on multiple conditions: Use the IF and SUM functions together.
- Add numbers based on criteria stored in a separate range: Use the DSUM function.
- Add numbers based on multiple conditions with the Conditional Sum Wizard.
π Definition β DSUM: A function that adds numbers in a column of a list or database that match specified conditions.
π Formula: DSUM(database, field, criteria). database is the range of cells for the list, field indicates the column for the function, and criteria is the range containing specified conditions.
π Example: =DSUM(A4:E10;"Profit";A1:F2) gives the total profit from apple trees (in this case, 75).
AVERAGE USING MICROSOFT EXCEL
The AVERAGE function returns the arithmetic mean of given arguments.
π Definition β AVERAGE Function: An Excel function that calculates the arithmetic mean of a set of numbers.
π Formula: AVERAGE(number1, number2, ...), where number1, number2, ... are up to 30 numeric arguments.
π Example: To calculate the average of numbers in a contiguous row or column, use the AVERAGE function on the cell range. For non-contiguous cells, select the individual cells separated by commas in the function (e.g., =AVERAGE(A1, C1, E1)).
WEIGHTED AVERAGE
A Weighted average is an arithmetic mean where some elements of the set carry more importance (weight) than others. The weights must be in fraction form (e.g., percentages converted to decimals).
π Definition β Weighted Average: A type of average where each data point is multiplied by a predetermined weight before summing to reflect its relative importance. π Formula: Weighted Average = (xβ)(wβ) + (xβ)(wβ) + (xβ)(wβ) + ... + (xβ)(wβ), where x are the data values and w are the weights (in fractions). π Example 1 (Grades): Homework grade=92 (weight 10% or 0.1), Quiz grade=68 (weight 20% or 0.2), Test grade=81 (weight 70% or 0.7). Weighted Average = (0.10)(92) + (0.20)(68) + (0.70)(81) = 9.2 + 13.6 + 56.7 = 79.5. π Example 2 (Labor Costs): Skilled labor: 6 hours at 300 Rs. Semiskilled: 3 hours at 200 Rs. Unskilled: 1 hour at 100 Rs. Total hours = 10. Weights as fractions: Skilled = 6/10 = 0.6, Semiskilled = 3/10 = 0.3, Unskilled = 1/10 = 0.1. Weighted Average = (0.6)(300) + (0.3)(200) + (0.1)(100) = 180 + 60 + 10 = 250. π‘ Why this matters: Weighted averages are crucial for fair grade calculation in education and for determining accurate costs in business scenarios like labor where different categories contribute differently.
β Key Takeaways
The student must remember that gross remuneration is the sum of basic salary and all allowances, with house rent at 45% and conveyance/utilities at 2.5% each of basic salary. The Excel $ sign fixes a cell reference for consistent calculations, and the ROUND function manages decimal places. The simple average is the sum divided by the count. For weighted averages, each data value is multiplied by its fractional weight and then summed; this is essential for computing grades and labor costs. Key Excel functions to remember include SUM, AVERAGE, SUMIF, and DSUM for different types of data aggregation.
π§ Quick Revision Questions
- Calculate the gross remuneration for a basic salary of 8,000 Rs., given house rent is 45%, conveyance is 2.5%, and utilities is 2.5% of the basic salary.
- What is the purpose of the
$sign in the Excel formula=$B$93*0.45? - Find the simple average of the following data set: 15, 22, 30, 43, 50.
- A student has a project grade of 85 (weight 25%), a midterm grade of 78 (weight 35%), and a final exam grade of 92 (weight 40%). Calculate the student's overall weighted average.
- Which Excel function would you use to add all sales values in a column only for a specific product type listed in another column?
π Lecture 5 β Applications of Basic Mathematics Part 4
π Overview: This lecture teaches how to calculate percentage change between two values, including increases and decreases. It also covers the application of successive percentage changes for salary increases and investment returns over multiple years, with all calculations demonstrated in Microsoft Excel.
ποΈ Topics Covered
The lecture covers the concept of percentage change, including calculating increases and decreases. It then presents four detailed examples: calculating percentage change in sales, the shrinking of fresh fruit to dried fruit, the expansion of cotton after adding water, and successive wage increases over a three-year collective agreement. Finally, it applies the same logic to calculate the final value of an investment over four years with varying annual rates of return, including a negative return.
π Lecture Summary
PERCENTAGE CHANGE
This section introduces the fundamental formula for percentage change using the example of Monday's sales of Rs.1000 growing to Rs.2500 on Tuesday. The core method is explained: first find the change (final value minus initial value), then divide by the initial value and multiply by 100%. The calculation yields a 150% increase. The lecture then shows how to perform this in Excel by entering the initial value in cell C4 and the final value in cell C5, then using the formula =C5 β C4 for the change in cell C6 and =C6/C4*100 for the percentage change in cell C7, which gives the result 150%.
π Definition β Percentage Change: The relative change between an old value and a new value, expressed as a percentage.
π Formula: Percentage Change = ((Final Value β Initial Value) / Initial Value) Γ 100%
π Example: Mondayβs Sales = Rs.1000 (Initial Value), Tuesdayβs Sales = Rs.2500 (Final Value).
Change = 2500 β 1000 = 1500.
Percentage Change = (1500 / 1000) Γ 100 = 150%.
This means sales increased by 150%.
EXAMPLE 1
This example asks what percent Tuesdayβs sale is of Mondayβs sale. The calculation finds the ratio of the new value to the old value. The result is 250%, meaning Tuesdayβs sale was two and a half times Monday's sale.
π Example: Mondayβs sale = Rs.1000, Next dayβs sale = Rs.2500. Ratio = 2500 / 1000 = 2.5. Percentage = 2.5 Γ 100 = 250%. Interpretation: Next dayβs sale was 250% of Mondayβs sale, or two and a half times.
EXAMPLE 2
This section demonstrates a percentage decrease using the process of making dried fruit. Fresh fruit weighing 15 kg shrinks to 3 kg of dried fruit. The change is negative (-12 kg), leading to a negative percentage change. The result is -80%, indicating the fruit's weight was reduced by 80%. The Excel implementation is shown with data entered in cells D19 (15) and D20 (3). The formula for the change in cell D21 is = D20 β D19, and for the percentage change in cell D22 is = D21/D19*100. The results are -12 kg and -80%.
π Example: Original fresh fruit = 15 kg, Final dried fruit = 3 kg. Change = 3 β 15 = -12 kg. Percentage Change = (-12 / 15) Γ 100 = -80%. Interpretation: The size was reduced by 80%.
EXAMPLE 3
This example shows a massive percentage increase when cotton absorbs water. The original weight of 3 kg increases to 15 kg. The change is +12 kg, resulting in a 400% increase. The Excel method mirrors the previous example, with data in cells D26 (3) and D27 (15). The formulas in D28 and D29 are = D27 β D26 and = D28/D26*100, giving results of 12 kg and 400%.
π Example: Original weight = 3 kg, Final weight = 15 kg. Change = 15 β 3 = 12 kg. Percentage Change = (12 / 3) Γ 100 = 400%. Interpretation: The weight increased by 400%.
EXAMPLE 4
This section tackles successive percentage increases for a salary over a three-year collective agreement. An employee earning Rs.5000 per month receives raises of 3%, 2%, and 1% in successive years. The calculation method multiplies the original salary by each growth factor sequentially: 5000 Γ (1 + 3%) Γ (1 + 2%) Γ (1 + 1%). This simplifies to 5000 Γ 1.03 Γ 1.02 Γ 1.01, yielding Rs.5306. The Excel method uses the ROUND function to handle currency. Data is entered as: cell C35 (5000), C36 (3), C38 (2), C40 (1). The formulas are: =ROUND(C35*(1+C36/100);0) for year 2 salary in C37, =ROUND(C37*(1+C38/100);0) for year 3 salary in C39, and =ROUND(C39*(1+C40/100);0) for the final salary in C41. The results: C37 = Rs.5150, C39 = Rs.5253, C41 = Rs.5306.
π Example: Current salary = Rs.5000, Year-1 raise = 3%, Year-2 raise = 2%, Year-3 raise = 1%. Calculation: 5000 Γ 1.03 Γ 1.02 Γ 1.01 = 5306 Rs. Final salary at the end of the term = Rs.5306 per month.
EXAMPLE 5
This final example applies the same principle of successive changes to an investment with varying rates of return, including a negative return. An investment of Rs.100,000 earns 4%, 8%, -10%, and 9% over four years. The calculation multiplies the initial investment by each year's growth factor: Year 1: 100000 Γ 1.04; Year 2: Γ 1.08; Year 3: Γ 0.90 (for a -10% loss); Year 4: Γ 1.09. The final value is Rs.110,186. The Excel implementation uses data in cells C46 (100000), C47 (4), C49 (8), C51 (-10), C53 (9). The formulas are =ROUND(C46*(1+C47/100);0) for the value in year 2 (C48), =ROUND(C48*(1+C49/100);0) for year 3 (C50), =ROUND(C50*(1+C51/100);0) for year 4 (C52), and =ROUND(C52*(1+C53/100);0) for the final value end of year 4 (C54). Results: C48 = Rs.104000, C50 = Rs.112320, C52 = Rs.101088, C54 = Rs.110186.
π Example: Investment = Rs.100,000, Year-1 return = 4%, Year-2 return = 8%, Year-3 return = -10%, Year-4 return = 9%. Calculation: 100000 Γ 1.04 Γ 1.08 Γ 0.90 Γ 1.09 = 110186 Rs. Final value at the end of Year 4 = Rs.110,186.
π‘ Why this matters: Successive percentage changes cannot be simply added together (e.g., 3% + 2% + 1% = 6% of 5000 = 300, leading to 5300, which is incorrect). The correct method is to multiply the growth factors (1 + rate) for each period. This is critical for compound interest, investment returns, and multi-year financial planning.
β Key Takeaways
The most critical concepts are the calculation of percentage change using the formula (Change/Initial Value) Γ 100%, and the crucial distinction between a simple ratio (Example 1) and a percentage change (Example 0). For multi-period problems, you must apply successive percentage changes by multiplying the original value by the growth factor (1 + rate) for each period, not by adding the rates. This applies to both salary increases and investment returns, including handling negative returns by using a growth factor of less than 1 (e.g., 1 - 0.10 = 0.90). All calculations can be performed accurately in Excel using the ROUND function for monetary values and the fundamental formulas for change and percentage change.
π§ Quick Revision Questions
- A store's sales were Rs.800 on Monday and Rs.600 on Tuesday. Calculate the percentage change and state whether it is an increase or decrease.
- An employee's salary starts at Rs.45,000. She receives a 5% raise in year 1, a 7% raise in year 2, and a 3% raise in year 3. What is her salary at the end of year 3?
- If you invest Rs.50,000 and it earns 10% in year 1, loses 5% in year 2, and gains 12% in year 3, what is the final value of the investment?
- What is the correct Excel formula to calculate a 4% increase on a value in cell A1? What formula would you use to calculate a 4% decrease on the same value?
- In the dried fruit example, why is the percentage change -80%? What does the negative sign indicate, and why is the change not simply -12/15?
π Lecture 6 β Applications of Basic Mathematics Part 5
π Overview: This lecture covers practical business mathematics concepts including discount calculations, simple and compound interest, and stock market metrics. It also reinforces percentage change calculations from Lecture 5 and introduces key stock investment terminology and return calculations essential for financial decision-making.
ποΈ Topics Covered
The lecture begins with a revision of percentage increase and decrease calculations, then introduces stock market concepts including yield, earnings per share, price-earnings ratio, and net current asset value per share. It proceeds to buying shares with commission, return on investment calculations, discount formulas, and concludes with simple and compound interest computations with worked examples.
π Lecture Summary
REVISION LECTURE 5
A chartered bank lowering its interest rate from 9% to 7% results in a percent decrease of -22.2% (calculated as -2/9 Γ 100). Conversely, increasing from 7% to 9% gives a percent increase of 28.6% (2/7 Γ 100). In Excel, for the decrease: cell F4=9, F5=7, formula F6=F5-F4 gives -2, and F7=F6/F4100 gives -22.2. For the increase: cell F14=7, F15=9, formula F16=F15-F14 gives 2, and F17=F16/F14100 gives 28.6.
The Definition of a Stock
Stock represents a share in the ownership of a company and a claim on its assets and earnings. Stock yield refers to the rate of income generated from a stock in the form of regular dividends, calculated as annual dividend payments divided by the stock's current share price. Earnings per share (EPS) is total profits divided by the number of shares β a company with $1 billion earnings and 200 million shares has EPS of $5 per share.
π Definition β Price-earnings ratio (P/E ratio): A valuation ratio of a company's current share price compared to its per-share earnings. π Formula: P/E Ratio = Current Share Price / Earnings per Share π Example: If a company trades at $43 per share and earnings over the last 12 months were $1.95 per share, the P/E ratio = $43/$1.95 = 22.05
Outstanding shares are stock currently held by investors, including restricted shares owned by company officers and the public, but excluding repurchased shares. Net current asset value per share (NCAVPS) is calculated by taking current assets minus total liabilities, then dividing by total shares outstanding. Current assets include cash, accounts receivable, inventory, marketable securities, and prepaid expenses convertible to cash within one year. Liabilities are a company's legal debts or obligations from business operations. Market value is the price at which investors buy or sell a share at a given time. Face value (or par value) is the original cost of a share shown on the certificate, typically a small amount unrelated to market price.
Dividend
A dividend is the portion of profit a company distributes to shareholders. For example, a company earning Rs 1 crore keeps half (Rs 50 lakh) for reinvestment and distributes the other half as dividend. With 10,000 shares, each share earns Rs 500 dividend. If you own 100 shares, you receive Rs 50,000 (100 Γ Rs 500). When expressed as a percentage, dividend is based on face value β a 50% dividend on a Rs 10 face value share means Rs 5 per share.
BUYING SHARES
If you buy 100 shares at Rs 62.50 per share with a 2% commission, calculate total cost: π Example: 100 Γ Rs 62.50 = Rs 6,250; Commission = 0.02 Γ Rs 6,250 = Rs 125; Total = Rs 6,375
RETURN ON INVESTMENT
Suppose you bought 100 shares at Rs 52.25 and sold them after 1 year at Rs 68, with a 1% commission rate on buying and selling, and 10% dividend per share (face value Rs 10 each).
π Bought: 100 shares at Rs 52.25 = Rs 5,225; Commission at 1% = Rs 52.25; Total Cost = Rs 5,277.25
π Sold: 100 shares at Rs 68 = Rs 6,800; Commission at 1% = Rs 68; Total Sale = Rs 6,732
π Gain: Net Receipts = Rs 6,732; Total Cost = Rs 5,277.25; Net Gain = Rs 1,454.75; Dividends (100 Γ 10/10) = Rs 100; Total Gain = Rs 1,554.75; Return on investment = (1,554.75/5,277.25) Γ 100 = 29.46%
In Excel: For Bought, cell B21=100, B22=52.25, B23=B21ΓB22=5225, B24=B23Γ0.01=52.25, B25=B23+B24=5277.25. For Sold, cell B28=68, B29=B21ΓB28=6800, B30=B29Γ0.01=68, B31=B29-B30=6732. For Gain, B34=B31=6732, B35=B25=5277.25, B36=B31-B25=1454.75, B37=B36/B35Γ100=27.57.
π‘ Why this matters: The Excel % gain (27.57%) differs from the manual return on investment (29.46%) because the manual calculation includes dividends while the Excel gain calculation does not.
DISCOUNT
Discount is a rebate or reduction in price, expressed as a percentage of the list price.
π Example: List Price = Rs 2,200; Discount Rate = 15%; Discount = 2,200 Γ 0.15 = Rs 330
NET COST PRICE
Net Cost Price = List Price - Discount
π Example: List Price = Rs 4,500; Discount = 20%; Net Cost Price = 4,500 - (0.2 Γ 4,500) = 4,500 - 900 = Rs 3,600
SIMPLE INTEREST
P = Principal, R = Rate of interest percent per annum, T = Time in years, I = Simple interest π Formula: I = (P Γ R Γ T) / 100 Total amount A to be paid at end = P + I
π Example: P = Rs 500, T = 4 years, R = 11%; I = (500 Γ 4 Γ 11)/100 = Rs 220
COMPOUND INTEREST
Compound Interest also attracts interest on previously earned interest.
π Definition β Compound Interest: Interest calculated on both the initial principal and the accumulated interest from previous periods.
π Formula: S = P(1 + r/100)^n, where S = compound amount (money accrued after n years), P = Principal, r = Rate of interest, n = Number of periods. Compound Interest = S - P
π Example: P = Rs 800, r = 10%: Year 1 interest = 0.1 Γ 800 = 80, New P = 880; Year 2 interest = 0.1 Γ 880 = 88, New P = 968
π Example: Calculate compound interest on Rs 750 invested at 12% per annum for 8 years: S = 750(1+12/100)^8 = 750(1.12)^8 = Rs 1,857; Compound Interest = 1,857 - 750 = Rs 1,107
π‘ Why this matters: Compound interest grows faster than simple interest because interest earns interest, making it crucial for long-term investments and loans.
β Key Takeaways
The most critical concepts from this lecture are: (1) Stock yield, EPS, P/E ratio, and NCAVPS are essential metrics for evaluating stock investments, with P/E ratio calculated as share price divided by EPS. (2) When buying shares, total cost includes the purchase price plus commission; return on investment considers both capital gains and dividends. (3) Discount is always calculated as a percentage of list price, and net cost price equals list price minus discount. (4) Simple interest is calculated only on the principal using I = PRT/100, while compound interest grows exponentially using S = P(1+r/100)^n. (5) The percent change formula (change/original Γ 100) works for both increases and decreases, but the base value differs depending on the direction of change.
π§ Quick Revision Questions
- What is the formula for calculating the Price-Earnings ratio of a stock?
- If you buy 200 shares at Rs 50 each with a 1.5% commission, what is your total cost?
- Calculate the simple interest on Rs 1,000 at 8% per annum for 3 years.
- A stock has a face value of Rs 10 and declares a 40% dividend. How much dividend will you receive per share?
- What is the compound amount after 5 years if Rs 2,000 is invested at 10% per annum compounded annually?