Basic Computational Techniques for Data Analysis
eBook - ePub

Basic Computational Techniques for Data Analysis

An Exploration in MS Excel

  1. 282 pages
  2. English
  3. ePUB (mobile friendly)
  4. Available on iOS & Android
eBook - ePub

Basic Computational Techniques for Data Analysis

An Exploration in MS Excel

About this book

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.

Content

The book intends to illustrate the concepts used in economic and financial decision-making in business and in daily life; it helps demonstrate a deeper understanding from both theoretical and practical perspectives. An effort has been made to make the book student-friendly by using simple language and giving a number of illustrations in each chapter, solved in such a simple manner that they can be easily understood by the students. Practical questions have been included at the end of each chapter so that the students can independently solve them and test their understanding of the concepts and computations introduced in the chapter.

Outcome

At the end, students will be able to describe what a spreadsheet is and what Excel's capabilities are and can work with elements that make up the structure of a worksheet. They will be able to work with spreadsheets and enter data in Excel, use formulae and calculations, and create tables, charts and pivot tables. They will be familiar with basic statistical and financial measures of general use. They will be able to do basic computations in statistics and finance in Excel. Students will acquire the capacity to create personal and/or business spreadsheets following current professional and/or industry standards. Their potential for critical thinking to design and create spreadsheets and communicate in a business setting using spreadsheet vocabulary will be enhanced.

The educational background required for the student to understand the text is some basic English and Mathematics of school-leaving level. Some fl air for numbers will be an asset and for them it will be a breeze; others will have to make an effort but ample illustrations and practice questions make life simple, whether it is basic statistics or slightly intricate finance!

Frequently asked questions

Yes, you can cancel anytime from the Subscription tab in your account settings on the Perlego website. Your subscription will stay active until the end of your current billing period. Learn how to cancel your subscription.
No, books cannot be downloaded as external files, such as PDFs, for use outside of Perlego. However, you can download books within the Perlego app for offline reading on mobile or tablet. Learn more here.
Perlego offers two plans: Essential and Complete
  • Essential is ideal for learners and professionals who enjoy exploring a wide range of subjects. Access the Essential Library with 800,000+ trusted titles and best-sellers across business, personal growth, and the humanities. Includes unlimited reading time and Standard Read Aloud voice.
  • Complete: Perfect for advanced learners and researchers needing full, unrestricted access. Unlock 1.4M+ books across hundreds of subjects, including academic and specialized titles. The Complete Plan also includes advanced features like Premium Read Aloud and Research Assistant.
Both plans are available with monthly, semester, or annual billing cycles.
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1 million books across 1000+ topics, we’ve got you covered! Learn more here.
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more here.
Yes! You can use the Perlego app on both iOS or Android devices to read anytime, anywhere — even offline. Perfect for commutes or when you’re on the go.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app.
Yes, you can access Basic Computational Techniques for Data Analysis by D Narayana,Sharad Ranjan,Nupur Tyagi in PDF and/or ePUB format, as well as other popular books in Business & Business General. We have over one million books available in our catalogue for you to explore.

Information

Year
2023
Print ISBN
9781032459356
eBook ISBN
9781000890792
Edition
2

Table of contents

  1. Cover
  2. Endorsements
  3. Half Title
  4. Title
  5. Copyright
  6. Contents
  7. List of figures
  8. List of tables
  9. Preface to the second edition
  10. Acknowledgements
  11. List of abbreviations
  12. 1 Getting Started With Microsoft Excel
  13. 2 Basic Arithmetic Operations in Excel
  14. 3 Data: Input Into Excel and Sources
  15. 4 Visualization of Data Using Charts in Excel
  16. 5 Measures of Central Tendency
  17. 6 Measures of Dispersion
  18. 7 Correlation Coefficient
  19. 8 Regression Analysis
  20. 9 Hypothesis Testing in Regression Analysis
  21. 10 Understanding Growth Rates
  22. 11 Growth Rate Using Regression Analysis
  23. 12 Compounding: Future Value of Money
  24. 13 Investment Decision Criteria: NPV and IRR
  25. 14 Loan Amortization
  26. Web References
  27. Answer key
  28. Appendix 1: Present Value and Future Value Tables
  29. Appendix 2: t-Distribution: Critical Values of t
  30. Index