Author : Charlotte Brookfield
Publisher : SAGE
Page : 209 pages
File Size : 29,79 MB
Release : 2021-01-20
Category : Computers
ISBN : 1529753201
Full of practical advice and real-world examples, this step-by-step guide offers you an accessible introduction to doing quantitative social research using Microsoft Excel.
Author : Charlotte Brookfield
Publisher : SAGE
Page : 206 pages
File Size : 23,11 MB
Release : 2021-01-20
Category : Social Science
ISBN : 1529753228
Full of practical advice and real-world examples, this step-by-step guide offers you an accessible introduction to doing quantitative social research using Microsoft Excel.
Author : Thomas J. Quirk
Publisher : Springer Nature
Page : 260 pages
File Size : 50,1 MB
Release : 2021-03-02
Category : Social Science
ISBN : 3030643336
This book shows the capabilities of Microsoft Excel in teaching social science statistics effectively. Similar to the previously published Excel 2016 for Social Sciences Statistics, this book is a step-by-step, exercise-driven guide for students and practitioners who need to master Excel to solve practical social science problems. If understanding statistics isn’t your strongest suit, you are not especially mathematically inclined, or you are wary of computers, this is the right book for you. Excel, a widely available computer program for students and managers, is also an effective teaching and learning tool for quantitative analyses in social science courses. Its powerful computational ability and graphical functions make learning statistics much easier than in years past. Excel 2019 for Social Science Statistics: A Guide to Solving Practical Problems capitalizes on these improvements by teaching students and managers how to apply Excel to statistical techniques necessary in their courses and work. In this new edition, each chapter explains statistical formulas and directs the reader to use Excel commands to solve specific, easy-to-understand social science problems. Practice problems are provided at the end of each chapter with their solutions in an appendix. Separately, there is a full practice test (with answers in an appendix) that allows readers to test what they have learned.
Author : Nalin Johri, PhD, MPH
Publisher : Springer Publishing Company
Page : 252 pages
File Size : 24,13 MB
Release : 2020-02-01
Category : Medical
ISBN : 0826150284
Your all-in-one resource for quantitative, qualitative, and spatial analyses in Excel® using current real-world healthcare datasets. Health Services Research and Analytics Using Excel® is a practical resource for graduate and advanced undergraduate students in programs studying healthcare administration, public health, and social work as well as public health workers and healthcare managers entering or working in the field. This book provides one integrated, application-oriented resource for common quantitative, qualitative, and spatial analyses using only Excel. With an easy-to-follow presentation of qualitative and quantitative data, students can foster a balanced decision-making approach to financial data, patient statistical data and utilization information, population health data, and quality metrics while cultivating analytical skills that are necessary in a data-driven healthcare world. Whereas Excel is typically considered limited to quantitative application, this book expands into other Excel applications based on spatial analysis and data visualization represented through 3D Maps as well as text analysis using the free add-in in Excel. Chapters cover the important methods and statistical analysis tools that a practitioner will face when navigating and analyzing data in the public domain or from internal data collection at their health services organization. Topics covered include importing and working with data in Excel; identifying, categorizing, and presenting data; setting bounds and hypothesis testing; testing the mean; checking for patterns; data visualization and spatial analysis; interpreting variance; text analysis; and much more. A concise overview of research design also provides helpful background on how to gather and measure useful data prior to analyzing in Excel. Because Excel is the most common data analysis software used in the workplace setting, all case examples, exercises, and tutorials are provided with the latest updates to the Excel software from Office365 ProPlus® and newer versions, including all important “Add-ins” such as 3D Maps, MeaningCloud, and Power Pivots, among others. With numerous practice problems and over 100 step-by-step videos, Health Services Research and Analytics Using Excel® is an extremely practical tool for students and health service professionals who must know how to work with data, how to analyze it, and how to use it to improve outcomes unique to healthcare settings. Key Features: Provides a competency-based analytical approach to health services research using Excel Includes applications of spatial analysis and data visualization tools based on 3D Maps in Excel Lists select sources of useful national healthcare data with descriptions and website information Chapters contain case examples and practice problems unique to health services All figures and videos are applicable to Office365 ProPlus Excel and newer versions Contains over 100 step-by-step videos of Excel applications covered in the chapters and provides concise video tutorials demonstrating solutions to all end-of-chapter practice problems Robust Instructor ancillary package that includes Instructor’s Manual, PowerPoints, and Test Bank
Author : Martin Lee Abbott
Publisher : John Wiley & Sons
Page : 446 pages
File Size : 20,35 MB
Release : 2014-08-21
Category : Mathematics
ISBN : 1118627180
Utilizing the latest software, this book presents the essential statistical procedures for drawing valuable results from data in the social sciences. Mobilizing interesting real-world examples from the field of education, Understanding Educational Statistics Using Microsoft Excel and SPSS supplies a seamless presentation that identifies valuable connections between statistical applications and research design. Class-tested to ensure an accessible presentation, the book combines clear, step-by-step explanations and the use of software packages that are accessible to both the novice and professional alike to present the fundamental statistical practices for organizing, understanding, and drawing conclusions from educational research data. The book begines with an introduction to descriptive and inferential statistics and then proceeds to acquaint readers with the various functions for working with quantitative data in the Microsoft Excel environment, such as spreadsheet navigation; sorting and filtering; and creating pivot tables. Subsequent chapters treat the procedures that are commonly-employed when working with data across various fields of social science research, including: Single-sample tests Repeated measure tests Independent t-tests One way ANOVA and factorial ANOVA Correlation Bivariate regression Chi square Multiple regression Individual chapters are devoted to specific procedures, each ending with a lab exercise that highlights the importance of that procedure by posing a research question, examining the question through its application in Excel and SPSS, and concluding with a brief research report that outlines key findings drawn from the results. Real-world examples and data from modern educational research are used throughout the book, and a related Web site features additional data sets, examples, and labs, allowing readers to reinforce their comprehension of the material. Bridging traditional statistical topics with the latest software and applications in the field of education, Understanding Educational Statistics Using Microsoft Excel and SPSS is an excellent book for courses on educational research methods and introductory statistics in the social sciences at the upper-undergraduate and graduate levels. It also serves as a valuable resource for researchers and practitioners in the fields of education, psychology, and the social sciences who require a statistical background to work with data in their everyday work.
Author : Martin Lee Abbott
Publisher : John Wiley & Sons
Page : 592 pages
File Size : 29,17 MB
Release : 2016-08-29
Category : Social Science
ISBN : 1119121043
Provides a step-by-step approach to statistical procedures to analyze data and conduct research, with detailed sections in each chapter explaining SPSS® and Excel® applications This book identifies connections between statistical applications and research design using cases, examples, and discussion of specific topics from the social and health sciences. Researched and class-tested to ensure an accessible presentation, the book combines clear, step-by-step explanations for both the novice and professional alike to understand the fundamental statistical practices for organizing, analyzing, and drawing conclusions from research data in their field. The book begins with an introduction to descriptive and inferential statistics and then acquaints readers with important features of statistical applications (SPSS and Excel) that support statistical analysis and decision making. Subsequent chapters treat the procedures commonly employed when working with data across various fields of social science research. Individual chapters are devoted to specific statistical procedures, each ending with lab application exercises that pose research questions, examine the questions through their application in SPSS and Excel, and conclude with a brief research report that outlines key findings drawn from the results. Real-world examples and data from social and health sciences research are used throughout the book, allowing readers to reinforce their comprehension of the material. Using Statistics in the Social and Health Sciences with SPSS® and Excel® includes: Use of straightforward procedures and examples that help students focus on understanding of analysis and interpretation of findings Inclusion of a data lab section in each chapter that provides relevant, clear examples Introduction to advanced statistical procedures in chapter sections (e.g., regression diagnostics) and separate chapters (e.g., multiple linear regression) for greater relevance to real-world research needs Emphasizing applied statistical analyses, this book can serve as the primary text in undergraduate and graduate university courses within departments of sociology, psychology, urban studies, health sciences, and public health, as well as other related departments. It will also be useful to statistics practitioners through extended sections using SPSS® and Excel® for analyzing data.
Author : J. P. Verma
Publisher : John Wiley & Sons
Page : 1227 pages
File Size : 38,70 MB
Release : 2014-06-30
Category : Mathematics
ISBN : 1118855175
This book introduces the use of statistics to solve a variety of problems in exercise science and health and provides readers with a solid foundation for future research and data analysis. Statistics for Exercise Science and Health with Microsoft Office Excel: Aids readers in analyzing their own data using the presented statistical techniques combined with Excel Features comprehensive coverage of hypothesis testing and regression models to facilitate modeling in sports science Utilizes Excel to enhance reader competency in data analysis and experimental designs Includes coverage of both binomial and poison distributions with applications in exercise science and health Provides solved examples and plentiful practice exercises throughout in addition to case studies to illustrate the discussed analytical techniques Contains all needed definitions and formulas to aid readers in understanding different statistical concepts and developing the needed skills to solve research problems
Author : Linda Herkenhoff
Publisher : Springer Science & Business Media
Page : 426 pages
File Size : 30,56 MB
Release : 2013-11-26
Category : Computers
ISBN : 1461484235
Applied Business Statistics for Business and Management using Microsoft Excel is the first book to illustrate the capabilities of Microsoft Excel to teach applied statistics effectively. It is a step-by-step exercise-driven guide for students and practitioners who need to master Excel to solve practical statistical problems in industry. If understanding statistics isn’t your strongest suit, you are not especially mathematically-inclined, or if you are wary of computers, this is the right book for you. Excel, a widely available computer program for students and managers, is also an effective teaching and learning tool for quantitative analyses in statistics courses. Its powerful computational ability and graphical functions make learning statistics much easier than in years past. However, Applied Business Statistics for Business and Management capitalizes on these improvements by teaching students and practitioners how to apply Excel to statistical techniques necessary in their courses and workplace. Each chapter explains statistical formulas and directs the reader to use Excel commands to solve specific, easy-to-understand business problems. Practice problems are provided at the end of each chapter with their solutions.
Author : Glyn Davis
Publisher :
Page : 0 pages
File Size : 22,98 MB
Release : 2014
Category : Electronic spreadsheets
ISBN : 9780199051830
Statistics for the Social Sciences using Excel offers an excellent and helpful introduction to business statistics for students who require a first course, providing all of the explanation, tools, and skills which are required in order to master the subject matter. Thorough, clear and accessible, the text guides students in a progressive, step-by-step manner through the theoretical concepts and techniques, and supports understanding by providing extensiveexamples from a South African context. The text assumes no prior knowledge of the subject, and includes refresher chapters on numerical skills and Microsoft Excel.
Author : Robert E. McGrath
Publisher : SAGE Publications
Page : 184 pages
File Size : 46,98 MB
Release : 2014-01-21
Category : Social Science
ISBN : 1483365654
Accurate data entry and analysis can be deceptively labor-intensive and time-consuming. Creating and Verifying Data Sets with Excel is a focused, easy-to-read guide that gives readers the wherewithal to make use of a remarkable set of data tools tucked within Excel—tools most researchers are entirely unaware of. Robert E. McGrath’s book is the first to focus exclusively on Excel as a data entry system. It incorporates a number of learning tools such as screenshots, text boxes that summarize key points, examples from across the social sciences, tips for creating professional-looking tables, and questions at the end of each chapter. Providing practical strategies to improve and ease the processes of data entry, creation and analysis, this step-by-step guide is a brief, but invaluable resource for both students and researchers.
