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:

December 2020 | 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

D. Narayana

D. Narayana, Former Director, Gulati Institute of Finance and Taxation, Thiruvananthapuram, is Chairman of Kerala Public Expenditure Review Committee. He is a renowned economist, researcher and statistician. He holds a PhD from Indian Statistical Institute. He held the Reserve Bank of India Chair at Centre for Development Studies during 2001–2012. He is the chairman of the committee on implementation of Karunya Arogya Suraksha Padhathi, Kerala, in alignment with Ayushman Bharat: Prime Minister Jan Arogya Yojana. He has published numerous articles in reputed national and international journals on health, state finance, decentralization,... More About Author

Sharad Ranjan

Sharad Ranjan is an Associate Professor of Economics at Zakir Husain Delhi College (Evening), University of Delhi, with a teaching experience of more than two decades. He is a PhD from the Centre for Economic Studies and Planning, JNU, New Delhi. He has published many researchpapers in various journals of repute such as Economic & Political Weekly, Social Scientist, Indian Journal of Labour Economics, Productivity and Journal of Rural Development. He has also authored five books. He has conducted 100 workshops on financial literacy on behalf of the Securities and Exchange Board of India as resource person. He has also co-supervised and... More About Author

Nupur Tyagi

Nupur Tyagi, an Assistant Professor at Gargi College, University of Delhi, has completed her graduation from Sri Venkateswara College, University of Delhi, and postgraduated from Delhi School of Economics, University of Delhi. She is a rank holder in both BCom(H) and MCom. She is currently pursuing MPhil from Delhi School of Economics, University of Delhi. Her area of interest is finance and accounting. More About Author

For instructors

Purchasing options

Please select a format:

ISBN: 9789353886202