RAINBOW SCHOOL
SAHARANPUR
APPLIED MATHEMATICS
PROJECT FILE
Submitted by: -
Name: Keshav Garg
Class : XII C
ACKNOWLEDGEMENT
I would like to express my special thanks
of gratitude to my mathematics teacher
Mrs. Sonika Gupta Ma’am as well as
our principal, Mr. Dharmendra Rawat
ma’am for giving me the golden
opportunity to do this wonderful project
on 4 different topics on MS EXCEL, which
helped to learn a lot in the research and
course of completion for this project.
I am also thankful to my family and
friends for their invaluable support,
advise and love which helped me to do
this project within the given time frame.
INDEX
1. MATRIX MULTIPLICATION
2. Finding the Inverse matrix using MS Excel
3. Demand and Supply functions on Excel
4. How to Calculate Probability Using MS Excel?
1. MATRIX MULTIPLICATION
Before going to matrix multiplication, we need to know
about the basics of the matrix, what is the matrix?
A matrix is an arrangement of numbers in rows and
columns.
For example, Matrix A has two rows and two columns
1. Matrices 3x3 matrix A and matrix B as shown in the
given figure below.
2. Multiplication of two matrices A and B, the number of
columns in the first matrix must be equal to the number of rows
in the second matrix. After selecting the cells 3x3 and write down
the MMULT () function in the given cell. You can see in the below
figure once you write the MMULT function it asks for array 1 and
array2.
So, Array 1 is the first matrix and Array 2 is the second matrix.
After opening the bracket of the MMULT function select the cells
of Matrix A (B2:D4), as well as Matrix B (H2:J4) separated with
comma.
3. While calculating the result, key Combination Ctrl+Shift+Enter
should be used and you will get the desired output.
2. Finding the Inverse matrix using MS Excel
1. For calculating the inverse of a given matrix, the MINVERSE
function is used. First, create the matrix A (3x3). Enter the values
in rows and columns.
2. Once you create the matrix, then write the MINVERSE in the
highlighted cell in which where you want to place the resulting
matrix. For the array, select the Matrix A cells F41:H43.
3. While calculating the result, combination Ctrl+Shift+Enter
should be used and you will get the desired output.
3. Demand and Supply functions on Excel
1. A spreadsheet provides various types of charts to display demand
and supply information. Different types of charts are available to
use but it depends on what kind of analysis you are going to
perform. If the data requires finding the equilibrium for supply and
demand, a line graph provides the best results as well as
visualization but if you want to show the variations between supply
and demand, a column chart is more suitable.
For creating different charts on supply and demand, the steps are as
follows:
Open a new spreadsheet, add the data in the different columns as in
the image shown below
i.e., price, quantity demanded and quantity supplied.
2. Select columns of price, quantity demanded, and quantity
supplied and click on the Insert Tab, choose line chart from chart
group.
3. After choosing a line chart, it will appear with the mentioned
data values on the x-axis and y-axis with different colours. By
default, the price would be at x–axis.
With the same data, you can also visualize the data by using a
scatter plot. The scatter chart is shown below. The supply and
demand curve will intersect at a point which is your equilibrium
point and it is visible in both the charts .
4. How to Calculate Probability Using MS
Excel?
Probability is the branch of mathematics and it is defined as the
likelihood for which an event is probable, or likely to happen. MS
Excel has built-in function PROB for calculating the probability.
PROB function is classified under the MS Excel statistical
functions. The function of probability worked in different
domains like in business, sports, in financial analysis for
estimating the long- term business losses and gain.
Formula:
=PROB (x_range, prob_range, [lower_limit],[upper_limit])
1. range – the range of numeric values containing our data
2. prob range – the range of probabilities for each corresponding
value in our range
3. lower_limit –the lower limit of the values for which we want
to calculate the probability
4. upper_limit –the upper limit of the values for which we want
to
5. calculate the probability
Let us take an example to understand the usage of the built-in
function PROB for calculating the probability.
The Below table contains grades and their corresponding
probabilities.
Here we set the lower limit to 50 and the upper limit to 80.
1. After entering the data in the table, we write the PROB function
in the formula bar along with the arguments. Select the cell (A2:A7)
for grades and B2:B7 for corresponding probabilities with lower
limit 50 and upper limit 80.
2. After applying the formula, you will get the resultant in desired
cell i.e.C2 cell 0.705
