Total views : 406

Doing Numerical Calculus using Microsoft EXCEL

Affiliations

  • Department of Mathematics and Sciences,College of Arts and Applied Sciences,Dhofar University, Salalah, Sultanate of Oman, Oman

Abstract


Objectives: Numerical calculus can be done using calculators, readymade packages or programming languages. The spreadsheets are a middle course between the programming languages and the readymade packages. Methods/ Statistical Analysis: Spreadsheet programs serve as a powerful tool for graphical analysis and programming. Findings: We shall describe how the ubiquitous Microsoft EXCEL can be used to do numerical calculus, with appropriate examples. Use of EXCEL does not require any prior knowledge of computer programming are straightforward to use. Applications/ Improvements: We apply the Microsoft EXCEL to the do numerical integration and to obtain numerical solutions of equations using the Newton-Raphson method.

Keywords

Microsoft EXCEL, Newton-Raphson Method, Numerical Calculus, Numerical Integration, Spreadsheets, Trapezoidal Rule.

Full Text:

 |  (PDF views: 377)

References


  • Al Rawahi FK, Khan SA and Huq A. Microsoft EXCEL in the mathematics classroom: A case study. Proceedings of The Second Annual Conference for Middle East Teachers of Mathematics, Science and Computing (METSMaC 2006). Abu Dhabi, United Arab Emirates: The Petroleum Institute; 2006 March 14-16. p. 131–4..
  • Khan SA. Microsoft Excel in the Physics Classroom. in Proceedings of The Third Annual Conference for Middle East Teachers of Mathematics, Science and Computing (METSMaC 2007). Abu Dhabi, United Arab Emirates: The Petroleum Institute; March 2007 17-19. p. 171–5.
  • Khan SA. Data analysis using microsoft excel in the physics laboratory. Bulletin of the IAPT. Indian Association of Physics Teachers. 2007 June; 24 (6): 184–6.. Available from http://www. indapt.org/
  • Power DJ. A Brief History of Spreadsheets. DSS Resources. COM. 2004. Available from http://www.dssresources.com/history/sshistory.html
  • Dan Bricklin and Bob Frankston. VisiCalc: Information from its creators. 2015. Available from http://www.bricklin.com/visicalc.htm
  • Microsoft EXCEL.Available from http://www.microsoft.com/office/excel/
  • Khan SA. Spreadsheets in Science and Education. Youth Observer. Supplement to Oman Observer. 2007; 26 (116): 10.
  • Khan SA. Zeroing in on the spreadsheets. Radiance Viewsweekly. 2015 May 17; 53 (7): 25–6.
  • Khan SA. Digital spreadsheets. BaKhabar, 2016; 9 (7):, 20–1. Available from http://www.bakhabar.biharanjuman.org/.
  • Khan SA. Place of mathematics in the development of society and technology. BaKhabar. 2015; 8 (9): 29–30. http://www.bakhabar.biharanjuman.org/
  • Mathews JH, and Fink KD. Numerical Methods. Prentice Hall International; 1999.
  • Khan SA. Introductory Physics Laboratory Manual. Germany:, LAP LAMBERT Academic Publishing; 2015. http://www.lap-publishing.com/ and http://isbn.nu/9783659771897/
  • Khan SA. Objective questions in Introductory Physics. Germany: LAP LAMBERT Academic Publishing; 2015. http://www.lap-publishing.com/ and http://isbn.nu/9783659786198/
  • Khan SA. Quadratic surfaces in science and engineering. Bulletin of the IAPT. 2010; 2 (11): 327-30. Indian Association of Physics Teachers. http://indapt.org/.
  • Khan SA. Coordinate geometric approach to spherometer. Bulletin of the IAPT. Indian Association of Physics Teachers. 2013; 5 (6):139–42. Available from http://www.indapt.org/; E-Print: http://arxiv.org/abs/1309.1951/
  • Khan SA. Coordinate geometric generalization of the spherometer and cylindrometer. Chapter-8 in Advances in Engineering Research; Volume 10. In: Victoria M Petrova. New York: Nova Science Publishers; 2015. p. 163–190. Availble from http://www.novapublishers.com/ and http://isbn.nu/9781634827843/
  • Khan SA. Coordinate geometric generalization of the spherometer. Far East Journal of Mathematical Sciences (FJMS), 2016; 100 (10). Availble from,http://www.pphmj.com/journals/fjms.htm
  • Khan SA. and Khan FA. Phenomenon of motion of salt along the walls of the container. International Journal of Current Engineering and Technology (IJCET). 2015; 5 (1): 368–70. DOI: 10.14741/Ijcet/22774106/5.1.2015.66
  • Khan SA. The bounds of the set of equivalent resistances of n equal resistors combined in series and in parallel. E-Print archive. 21 April 2016 Availble from http://www.arxiv.org/abs/1004.3346/, arXiv:1004.3346v1 [physics.gen-ph; cited 21 April 2010].
  • Khan SA. Farey sequences and resistor networks. Mathematical Sciences - Proceedings of the Indian Academy of Sciences. 2012 May; 122 (2): 153–62. DOI:10.1007/s12044-012-0066-7
  • Khan, SA. Number theory and resistor networks. Chapter-5 in Resistors: Theory of Operation. Behavior and Safety Regulations. In: Roy Abi Zeid Daou. New York; Nova Science Publishers; 2013; 99–154.
  • Khan SA. How many equivalent resistances?. Resonance Journal of Science Education. 2012 May; 17 (5): 468–75. DOI:10.1007/s12045-012-0050-7
  • Khan SA. Set theoretic approach to Resistor Networks. Physics Education. Indian Association of Physics Teachers. 2013 Oct; 29 (4): 1–9.
  • Khan SA. Beginning to count the number of equivalent resistances. Indian Journal of Science and Technology, 2016; 9. (in press). Available from http://www.indjst.org/.
  • Khan, SA. Primes in Geometric-Arithmetic Progression. Global Journal of Pure and Applied Mathematics (GJPAM). 2016; 12 (1): 1161–80. 21 April 2016 Available from E-Print: arXiv:1203.2083 [math.NT].

Refbacks

  • There are currently no refbacks.


Creative Commons License
This work is licensed under a Creative Commons Attribution 3.0 License.