M
VAME-USKAN TERIWAL
tLASSAII
OUBTECT APPLED T'ATHEMATICS
JRACTICAL LE
o0
AOLLY0.E
OUBTECT TODE E2 4
ODEMAND AND SUPeLY FoNeTIONg On ExeEL_
OBTECT IVE show Denono and &opply uttrouy n Excol
STEPS
Open a ne cpaod sheat add the dala in He dilfoet columns
pua qvotity deMBndsd ad qvantiy Suppliad
2 Select columns o tho qiven data aud cuck on n gunt Tolb
Choose line chot om chat
3) A choosing a line chout iE wil appaar wth the menti onsd
data valuog e he o-axig aund ax is usith dirat calou
bdeaut th pito usould loe -axis
Wih +tho gamne data can vigualize the data by usiug
O &cabtesr plot The Slates chast 9 shouo. Tha olemad
pply cuwe vill inlensect ot a point visllala in lbo4h
ohasus Coiled Fquilbriuro Point_
DEMAND AND SUPPLY
160
140
120
100
80
60
40
20
8 10
-QUANTTY DEMANDED QUANTITY SUPPLIED
GANIUY EN MAANO quTUaU
DEMAD AND SUPPTY
o Formal Chart Arcd
eld e
neee
DEMAND AMD SUPPC
=TQuoac rinci N T UNC TON DAND AD SY O
DEMAND AND SUPPLY
160
140
120
100
80
60
40
20
0
2 6 8 10
QUANTTY DEMANDED QUANTITY SUPPLIED
MATRIX MuLTIPLICATION
OBTECTINETo Shouo Mult plieaton o madjucast exeal uth
helphelp oTmula_
STEPS-
lw Miea0s0ft Exeal the MMULT unchou J wed tor multplyiug
tus0 matncogo let fuwo Matricag b_3x3 by Matrix H *
6
2 Fo Mulhpuication c tw Matbuca A B u numban
Columngtn
Columns the irst Matrix muut he equal to te mhon o
Stowg econd Matoux : At 2aletina Hu ceu [Link]
dousn Hu MMULT() funehion k it asks for as01a L_Qual
auxay
3 Array1 MatixA Azay 2 Motrix B
4)hileCaleulahu the reult_kiy CBmlauatou Ctal+ufttEnte
ehould be used to_get a MatTix a anawe_
C orel
File Intert
Home Page Layout Formulus Data Reie Vie eip Tel me uhat you want Io do d Shae
Cabs 11 wup les Gere
fonut Rainter 4 aya a Cec % A
formalling ie Seles- D fomz Ora FhSete
re
1 bMULIAlCAGL14))
4A
Matris A
D C D G 1 K M P R S
Malaix B Formal Shape
1 03
MATRIX INVERSE PRDBABILuIY UNEAR TUNCTION QUADRATIC RINCIONDPO 1 D D
US VTV2
FuNDING HE NVERSE MATRIX VSING Mg ExCEL
OBTECTIVE TO Rd the invense oa matux Utig excel
excel
STEPS A
Fon caleulati u 130 give matou x he MlNVERSE
fuuchon u wed. First creala Matrix A (3x3
2) Ther Wue the MIN VERSE in he wahuhheol cou t
wwch yo0 wtHa suuiE For a a y eelett Matrix A
3)Whle caleulathng the uLult ky tomb uatib Ctrl ShwtttEnte
ghoulol b Usadto_get H auewen In a maix esm
Uook2rel
Malan eiwala
Tde Home Insett Page layout Farmkas Daa RevieW Ve lelp Ted me what you want to do
Cit Calubri 11 Wup Tet
Sate
Copy
format Paieter A Merge&Ceer S% rmil aCe T Dwite Foma Tind &
Cer Seleci
Agsen Nunber
J MINVE RSL(U2:D4)
A L M N O P
Motix A
1.92309 1 0384615
HFormal Shape
1.70231 0.1535
E1.53846 D 307692
Lise
0
MATRIX INVERSE PROABILITY LINEARFUNCTION QUADATICTUNCTION EXPO
AvegeR4 eat? S2tspATRE H
Vavzu22
To CALCULATE PROBABLITY UING Ms ExcEL
OBTECTIVE To Caleulale Brobabitt usifovmula in excel
STEPS
Altor entoung fhe data in ho tablu w wwte PROB tuunctron
aloug wih the asguwmenll. Salect he
in fornJabao
g rades wall tor covuspOuding probobiuty wo th o n nwt 50O
Md ugRoL wit 80
2 Aka apym t ormla L et th clestred raLult
Booke MsanPerwa
Share
Review Vie Help Ted e sfiat you want to d
D ome e l P a g Loyou!Oinutat Dal
Can Geral
Detrte loema fa Set & Find &
Piste Cepy
BIU A
ge &u Certe S % fomating Table Stles Cea Taite
Seled
ipbia
J ROBA2 AVA:B750,M0
D E F LG O Format Shape
GRADIS PHOLALBILIY OF GET ING LACH GADE WORAIIY
0.02
.1 Line
0.01 oine
Gadient n
MATREX| IVERSEPROBABILITYLUNEAR FUNCTON QUADRANC FUNCTICN |EXO- O -
PM
5o7 THE bysAPHS OF_FoLLnwING_ FUNCTIONS On ExcEL
COns-tants
cLINEAR FUneTION n) =ax+b whu a b
e xcel
OBJECTINE To plot he gaph noan kunchon Om
STEP-
Put random aluas o And Let te funehentcx be
3-3
2 No fo Caleulaung each value appy the foTmula for
Molue O to 5
gethiug dragthe ans wen Coll b He
3) Afte Vau
Cau nd w neaded Ha, the valuuas Conme automath caly
4) hen select_bot cowmns oploHhg t h 2 m a p h G 0 to
lnct Tab anol dck m chantsand Cheoce to cea Hen
plot
Your Linsan Funehon woud la_ploteol or he_givea
valuos The yraph ehows oagnt Uue
A 7P
Format Chart Arca
GRAPH OF UNEAR FUNCTION 1AJea-3
G a
GRAPH OF LINEAR FUNCTION f(x)=3x-3
12
10
6
f21) z a t bX tc, whne a,bhc a canttan.
OUADRATIe FuNCTION
exeel
o guwndrahe Fuueton
om
OBTECTIVE To Plot the graph
STEPS
DTake di fenent valuas o a b oud c for ho giveu functron fi
am bot et a= 1 b= 4 C=22
n)=MH+2
2 We Put those aluug in the aiven unehion
Put these aluuag a a , b e tn di luunt eelg o shoun
33) Af auming. the auag o a,b c 438i9n difo
Valuas to .Noy gube1tu le those walios in the fuwnchon
giveu
ben hy lale chvng the
4)APP
4 App
teu Onel
formula
he
the formula
asodoed valuus
5 ln 0ncled to U u auo- tonmplehon we eipy Jok
the Coll COutuiw Hu valuus ea,b,c
8elect Hhe coumns amel click Inturt
TalbThen
6) No
olu'el ou han aud Celect h sat plot
ee Paraboue Cuw
ww ww ip Chat Omagn Ia 9 Tel at y u n te da
ytTamla Dt
AA 1
cus
Format Chart Area
TIC FUMCLI0
uuAPITO0UADHATICTOEiO
wIASOL
uAD / t a [Link] UNEAR TUNCTAAUADATC FUNCTIOLnG 0 U
GRAPH OF QUADRATIC FUNCTION
f(x)=x^2+4x+2
50-
40
30
20
10
6 6
10
ExPONENTIAL FUNCnoN f t « ) = a", whue n is vau'able nd a is
cOustawt
0BIECTIVE T o plot the graph oExponeutral Fuuchiou on exc.
STEPS
) Take dieut vauu of xad oppy he EXP fuuch ou
2 Af pplyinrunch'en uleet te ceu amd preu ent
fer the cles ansnw
Simlanly appy for duocont values Omdl Calu lalr He
exponnthal vau'yowK):
4) Then plot H expowuhiodGTapk by cucki'0n th
TneuE Talo elect Hhe grap amd ehoosa t a l Statr
chant
5) For Trnd un mkt-eu'ee ou tHe platal graph une od
Qlect th "Add Treud uneoptou
6) List of Trendlu'u ppearg seleet amd oppu it
EXPONENTIAL FUNCTION
500000
450000
400000
350000
300000
250000
00000
150000
100000
S0000
0 6 8 10 12 14
vi 9 Td w t youi war tan 4 a
Dme
Farmat Data Series
C ONETUAL ruucnioN WITH TREFDUN
EXPONENTALUNCTIo
EXPONENTIAL FUNCTION WITH TRENDLINE
500000
450000
400000
350000
300000
250000
200000
150000
100000
50000
0 6 8 10 12 14