You are here

Basic Computational Techniques For Data Analysis

Basic Computational Techniques For Data Analysis
An Exploration in MS-Excel

  • D. Narayana - Honorary Professor, Gulati Institute of Finance and Taxation, Chavadimukku, Thiruvananthapuram
  • Sharad Ranjan - Faculty, Department of Economics, Zakir Husain Delhi College Evening, University of Delhi
  • Nupur Tyagi - Faculty, Department of Commerce, Gargi College, University of Delhi
Additional resources:

March 2021 | 284 pages | SAGE Texts
This book will help readers acquire knowledge and equip them in handling various statistical and financial computations using MS Excel.

The book is designed to equip students to navigate through MS Excel spreadsheets to compute  various statistical and financial measures for use in data analysis. 

Basic Computational Techniques for Data Analysis illustrates the concepts used in economic and financial decision-making in business as well as in day-to-day life,  thus enhancing a deeper understanding of the concepts from both theoretical and practical perspectives. After going through the textbook, readers will be able to ascertain the inbuilt capabilities in MS Excel and comprehend basic computations in statistics and finance. 

This book is essential as a supportive companion for students of economics, commerce, management and social science subjects in general.

Key Features:

• Provides an in-depth and clear understanding of various data analysis techniques

• Systemic and stepwise explanation of financial and statistical concepts using MS Excel functions

• Prior knowledge of statistics, finance and MS-Excel functions not required to understand the concepts

• Simplistic clarification of topics such as Future Value of Money, Loan Amortization and Investment Decision Criteria

About the Book
Getting Started with Microsoft Excel
Basic Arithmetic Operations in Excel
Data: Input into Excel and Sources
Visualization of Data Using Graphs in Excel
Measures of Central Tendency
Measures of Dispersion
Compounding: Future Value of Money
Investment Decision Criteria: NPV and IRR
Loan Amortization
Correlation Coefficient
Regression Analysis
Hypothesis Testing in Regression Analysis


“This book is self-composite in terms of explaining the concept, definition and computation of statistical methods with numerical examples and with MS-EXCEL…In addition to beginning students, researchers and teachers in social sciences, business and management, the book is useful to all in other subjects if they wish to pursue a quantitative approach.”

Dr M.R. Narayana ,Fiscal Policy Institute, Bengaluru

For instructors

Select a Purchasing Option

ISBN: 9789353886202