Basic Computational Techniques for Data Analysis: Mastering MS Excel and R
暫譯: 數據分析的基本計算技術：精通 MS Excel 與 R
Narayana, D., Ranjan, Sharad, Tyagi, Nupur
商品描述
This book is a multi-stage learning resource that takes readers from basic data handling and software orientation to statistical analysis and financial applications using MS Excel and R. Through a gradual, step-by-step approach, it equips readers with the essential skills needed to understand, analyse, and interpret data in today's data-driven world.
Using clear illustrations, the book enables readers to organise and manage data, perform analytical computations, create meaningful visualisations, and draw conclusions. It introduces core concepts in research, data analysis, and economic and financial decision-making, demonstrating their relevance in academic, professional, and everyday contexts. This book enables readers to:
- Work confidently with MS Excel and R for efficient data handling and analysis
- Present and visualise data using charts, tables, and Pivot Tables
- Apply statistical techniques such as descriptive statistics, correlation, regression, and hypothesis testing
- Perform financial analysis using concepts such as time value of money, compounding, NPV, IRR, and EMI calculations
By combining concepts with practical implementation, the book provides a strong foundation in computational techniques essential for modern data analysis.
This revised third edition introduces two new chapters on R for data analysis, complementing the book's Excel-based approach, making it an invaluable resource for beginners and students of economics, commerce, management, and the social sciences. This book will be useful for courses in econometrics, financial technology, and applied economics, as it equips readers with the analytical and computational skills required for academic excellence and professional success.
商品描述(中文翻譯)
這本書是一個多階段的學習資源，帶領讀者從基本的數據處理和軟體導向，進入使用 MS Excel 和 R 進行統計分析和金融應用。透過逐步的學習方式，它使讀者具備在當今數據驅動的世界中理解、分析和解釋數據所需的基本技能。
本書使用清晰的插圖，幫助讀者組織和管理數據，執行分析計算，創建有意義的視覺化，並得出結論。它介紹了研究、數據分析以及經濟和金融決策的核心概念，並展示了這些概念在學術、專業和日常生活中的相關性。本書使讀者能夠：
- 自信地使用 MS Excel 和 R 進行高效的數據處理和分析
- 使用圖表、表格和樞紐分析表呈現和視覺化數據
- 應用統計技術，如描述性統計、相關性、回歸和假設檢驗
- 使用時間價值、複利、淨現值 (NPV)、內部報酬率 (IRR) 和每月還款額 (EMI) 計算進行金融分析
通過將概念與實踐相結合，本書提供了現代數據分析所需的計算技術的堅實基礎。
這本修訂版第三版新增了兩個關於 R 的數據分析章節，補充了本書以 Excel 為基礎的方法，使其成為經濟學、商業、管理和社會科學初學者和學生的寶貴資源。本書將對計量經濟學、金融科技和應用經濟學的課程非常有用，因為它使讀者具備學術卓越和職業成功所需的分析和計算技能。
作者簡介
D Narayana is Former Director of the Gulati Institute of Finance and Taxation, Thiruvananthapuram, and Chairman of Kerala Public Expenditure Review Committee. He is a renowned economist, researcher, and statistician. He holds a PhD from Indian Statistical Institute (ISI), Kolkata. He held the Reserve Bank of India (RBI) Chair at Centre for Development Studies (CDS), Thiruvananthapuram from 2001 to 2012. He has published numerous articles in reputed national and international journals on health, state finance, decentralization, issues of SC/ST Communities, agriculture, irrigation, and migrant labour and has authored and co-edited many books. He also served as a member of many important committees, including the Expert Committee on Goods and Services Tax (GST), committee for revising the rates for the medical procedures under the centrally sponsored Rashtriya Swasthya Bima Yojana (RSBY), and the Contributory Pension Review Committee, constituted by the Government of Kerala.
Sharad Ranjan is a professor in economics at Zakir Husain Delhi College (Evening) (University of Delhi) with a teaching experience of nearly three decades. He is a PhD from the Centre for Economic Studies and Planning, Jawaharlal Nehru University, New Delhi. He has published many research papers in various journals and has also authored five books. He has conducted workshops on financial literacy for the Securities and Exchange Board of India (SEBI) as a resource person and has also co-supervised and evaluated PhD theses.
Nupur Tyagi is assistant professor at Gargi College, University of Delhi. She completed her post-graduation and MPhil from Delhi School of Economics, University of Delhi. Her areas of interest are finance and accounting.
作者簡介(中文翻譯)
D Narayana曾任位於提魯瓦南塔普蘭的古拉提金融與稅務研究所所長，以及喀拉拉邦公共支出審查委員會主席。他是一位著名的經濟學家、研究者和統計學家，擁有印度統計學研究所（ISI）加爾各答的博士學位。他於2001年至2012年期間擔任提魯瓦南塔普蘭發展研究中心（CDS）的印度儲備銀行（RBI）講座教授。他在國內外知名期刊上發表了許多有關健康、州財政、去中心化、社會階級/部落社區問題、農業、灌溉和移民勞工的文章，並著有及共同編輯多本書籍。他還曾擔任多個重要委員會的成員，包括商品和服務稅（GST）專家委員會、中央贊助的國家健康保險計劃（RSBY）下醫療程序費用修訂委員會，以及由喀拉拉邦政府成立的貢獻性退休金審查委員會。
Sharad Ranjan是德里大學扎基爾·侯賽因德里學院（晚間）經濟學教授，擁有近三十年的教學經驗。他擁有新德里賈瓦哈拉爾·尼赫魯大學經濟研究與規劃中心的博士學位。他在各種期刊上發表了許多研究論文，並著有五本書籍。他曾作為資源人員為印度證券交易委員會（SEBI）舉辦金融素養工作坊，並共同指導和評估博士論文。
Nupur Tyagi是德里大學加爾基學院的助理教授。她在德里經濟學院完成了碩士和MPhil學位。她的研究興趣包括財務和會計。
