Kerala Education Society Senior
Secondary School, R.K Puram
Applied Math
Practical File
Navneet Krishna
XI-B
19
Certificate
This is too certify that Navneet Krishna, Roll No. 19
of Class X1-B, Session 2022-2023 has successfully
completed the practical file as per the prescribed
practical syllabus of Applied Mathematics, Class 11
(CBSE) under my supervision. This file is authentic
work done by him under my guidance.
Signature of Teacher-in-charge
______________
Acknowledgement
I would like to express my gratitude to my Principal, Ms.
Meera S. Nair who gave me the opportunity to complete
this work. I would also like to express my special thanks
to my teacher, Archana Kumari (teacher-in-charge),
under whose guidance and supervision I was able to
complete my practical file. While working on this, I
achieved a good understanding of different concepts of
Statistics and Calculus.
Navneet Krishna
XI-B
Question:
Calculating average, interest (simple and
compound), creating pictograph drawing, pie
chart, bar graph, calculating central tendency,
visualizing circle, parabola, using real time data.
INDEX
S. No. Title Pg. No.
1 Interest & Central Tendency 4
2 Pictograph 6
3 Circle 7
4 Parabola 9
Interest & Central Tendency
To calculate interest and central tendencies, a data set was first
gathered. This data set contained bank info of 10 individuals. It
included their Initial Amount, Interest (per annum), and Time
Period.
After this, using the formula FA(SI)=A+(A* PRT/100) and
FA(CI)=A*(1+I/100)^T, simple and compound interest is calculated.
Averages are also found out. Then, central tendencies are found
out. Mean is same as average and Median is calculated using
MEDIAN() function of Excel. Mode does not exist in this context.
Footnotes-
Final Table-
Pictograph
For the pie charts, “Final Amount”>“Simple” and “Amount”,
respectively are used for values. “Name” is used for indexing in
the pie chart.
For the bar graphs, “Amount” and “Interest”, respectively are
used for values. “Name” is used for indexing in the bar graph.
Circle
To plot the circle, 20 points were decided upon. These points are
calculated using the general equation of a circle-
(x-h)^2+(y-k)^2=r^2, when centre and radius are inputted.
Input-
The calculations were performed using “Solver” Analysis tool of
Excel.
After this, a Scatter chart was inserted into the document, with
the “x” and ”y” fields as data values. The type was changed to show
lines. In this example, the centre has been taken as (0,0) and
radius has been taken as 5 units.
Final Circle-
Parabola
The calculation of the parabola was more or less the same as the
circle. The general equation used was-
y=a(x-h)^2+k, where h and k are the coordinates of the vertex.
Input-
Calculations were again performed using “Solver”, and 20 points
were calculated.
Again, a Scatter Chart was used, and x and y points were used as
values. Centre was taken to be (0,0) and a was taken to be 5.
Final Parabola-
Conclusion
This project has been, in its entirety, done in Excel 2013. Various
in-built functions were used for calculations, which means that
even if input was changed, the calculations and pictographs would
update to reflect that change. One obstacle was overcoming the
lack of conditional calculation, as parabolas can face different
directions, which changes its formula. Unfortunately, this barrier
cannot be overcome as it is a fundamental lack in Excel itself. This
sheet can be modified to use real-time data, as asked in the
question, if the input field is attached to an online source. The only
limitation would be the computer’s processing powers, and, as
mentioned before, the lack of conditional calculation.
Navneet Krishna
XI-B
Bibliography
simonsezit.com
makeuseof.com
excelforum.com
stackoverflow.com
math.stackexchange.com
khanacademy.org
byjus.com
cuemath.com
qc.edu.hk
geeksforgeeks.org
support.microsoft.com
