Basic Computational Techniques for Data Analysis : An Exploration in MS Excel (2ND)

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 wo