Image from Google Jackets

Basic computational techniques for data analysis : an exploration in MS Excel / D Narayana, Sharad Ranjan, and Nupur Tyagi.

By: Contributor(s): London ; New York : Routledge, Taylor & Francis Group, 2023Edition: Second editionDescription: xiii, 282 pages : illustrations ; 24 cmISBN:
  • 9781032503547
Subject(s): DDC classification:
  • 23 005.54 N16 2023
Contents:
Getting Started With Microsoft Excel Basic Arithmetic Operations in Excel Data: Input into Excel and Sources Visualization of Data Using Charts in Excel Measures of Central Tendency Measures of Dispersion Correlation Coefficient Regression Analysis Hypothesis Testing in Regression Analysis Understanding Growth Rates Growth Rate Using Regression Analysis Compounding: Future Value of Money Investment Decision Criteria: NPV and IRR Loan Amortization
Summary: This book is designed to equip students to navigate through MS Excel and basic data computation methods, which are essential tools in research or professional settings and in classrooms. It illustrates the concepts used in research and data analysis and economic and financial decision-making in business and in daily life. The book will help students acquire knowledge and develop skills in statistical techniques and financial analysis using MS Excel. With illustrations and examples, it will help the readers to: Visualize, present, and analyze data through MS Excel spreadsheets and tables and create personal or business spreadsheets Learn how to work with spreadsheets, use formulae, and perform calculations and analysis Create tables including Pivot Tables Become familiar with basic statistical and financial measures Design creative spread sheets and communicate effectively in business using spreadsheets and data analysis This revised and updated second edition will be an essential resource for students of economics, commerce, management, and other social science subjects, and will be useful to those studying econometrics, financial technology, basic computational techniques, data analysis, and applied economics
Holdings
Item type Current library Collection Call number Status Barcode
Books Books College Library General Circulation Section GC GC 005.54 N16 2023 (Browse shelf(Opens below)) Available HNU005551

Includes web references and index.

Getting Started With Microsoft Excel
Basic Arithmetic Operations in Excel
Data: Input into Excel and Sources
Visualization of Data Using Charts in Excel
Measures of Central Tendency
Measures of Dispersion
Correlation Coefficient
Regression Analysis
Hypothesis Testing in Regression Analysis
Understanding Growth Rates
Growth Rate Using Regression Analysis
Compounding: Future Value of Money
Investment Decision Criteria: NPV and IRR
Loan Amortization

This book is designed to equip students to navigate through MS Excel and basic data computation methods, which are essential tools in research or professional settings and in classrooms. It illustrates the concepts used in research and data analysis and economic and financial decision-making in business and in daily life. The book will help students acquire knowledge and develop skills in statistical techniques and financial analysis using MS Excel. With illustrations and examples, it will help the readers to: Visualize, present, and analyze data through MS Excel spreadsheets and tables and create personal or business spreadsheets Learn how to work with spreadsheets, use formulae, and perform calculations and analysis Create tables including Pivot Tables Become familiar with basic statistical and financial measures Design creative spread sheets and communicate effectively in business using spreadsheets and data analysis This revised and updated second edition will be an essential resource for students of economics, commerce, management, and other social science subjects, and will be useful to those studying econometrics, financial technology, basic computational techniques, data analysis, and applied economics

College of Engineering and Computer Studies Bachelor of Science in Information Technology

In English

There are no comments on this title.

to post a comment.