Innovative Use of What if Analysis for Visualization
Amitha P L1, Geethu Joy2, Geethu S Pillai3, Tharakrishnan L4, Soman K P5
1Amitha P L, Centre for Excellence in Computational Engineering and Networking, Amrita Vishwa Vidyapeetham, Coimbatore, India.
2Geethu Joy, Centre for Excellence in Computational Engineering and Networking, Amrita Vishwa Vidyapeetham, Coimbatore, India.
3Geethu S Pillai, Centre for Excellence in Computational Engineering and Networking, Amrita Vishwa Vidyapeetham, Coimbatore, India.
4Tharakrishnan L, Centre for Excellence in Computational Engineering and Networking, Amrita Vishwa Vidyapeetham, Coimbatore, India.
5K P Soman, Centre for Excellence in Computational Engineering and Networking, Amrita Vishwa Vidyapeetham, Coimbatore, India.
Manuscript received on January 01, 2013. | Revised Manuscript received on January 02, 2013. | Manuscript published on January 05, 2013. | PP: 252-256 | Volume-2, Issue-6, January 2013. | Retrieval Number: F1169112612/2013©BEIESP
Open Access | Ethics and Policies | Cite
© The Authors. Published By: Blue Eyes Intelligence Engineering and Sciences Publication (BEIESP). This is an open access article under the CC BY-NC-ND license (http://creativecommons.org/licenses/by-nc-nd/4.0/)
Abstract: The novelty of this paper is aimed at simplifying the tasks in Spreadsheet using a feature called what if analysis, which fires up the performance of the task we are working on. The use of spreadsheet helped us save time, perform many operations such as sorting, searching, classifying and comparing easily and to solve a problem without any programming knowledge. What if or sensitivity analysis is one of the most powerful and valuable concepts in Spreadsheet, the potential of which is not well exploited. The advantage of what if analysis is that if we show one computation in excel, the remaining part of the process will be computed by its own for a given range of variable values. It can be used to solve many problems other than the conventional managerial applications. Two Dimensional function evaluation and graphing, creating Pascal triangles, enumerating Pythagorean triplets in a given range, error function evaluation are some of the real applications. These types of applications can be exploited to enhance computational thinking of children in high schools. Computational thinking brings about a neoteric approach in problem-solving and model simulation
Keywords: Computational Thinking, Excel Computation, What if Analysis.