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.

Packed with practical advice and real-world examples, this step-by-step guide is an accessible introduction to doing quantitative social research using Microsoft Excel.

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.

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

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.

For undergraduate Marketing Research courses. Best-selling authors Burns and Bush are proud to introduce Basic Marketing Research, the first textbook to utitlize EXCEL as a data analysis tool. Each copy includes XL Data Analyst(R), a user-friendly Excel add-in for data analysis. This book is also a first in that it's a streamlined paperback with an orientation that leans more toward how to use marketing research information to make decisions vs. how to be a provider of marketing research information.

Praise for earlier editions: I have been using this textbook as a required reading for my research class since 2004 because I found the text’s coverage of research concepts to be in-depth, and easy to read without the technicalities. —Ziblim Abukari, PhD, MSW, Assistant Professor, Department of Social Work, Westfield State University Applied Social Research. . . is thorough, well organized, and clear, making it highly appreciated by my students. —Barry Loneck, PhD, School of Social Welfare, SUNY Albany Discover the practical side of research in human services with this easy-to-follow classic Designed for students and professionals in social work, public administration, nursing, criminal justice, and other human services fields, this text breaks down complex concepts into accessible, real-world applications. Follow along with easy-to-read language and engaging examples to uncover nonintimidating, practical tools for everyday problem-solving. Several new features, such as recorded practitioner interviews and Technology in Research boxes, clarify and reinforce the value of applied social research and innovative tools real professionals use in their work. This textbook takes readers on a journey through the entire research process, from identifying problems to collecting and analyzing data, and finally, to effectively communicating your findings. Each chapter closes with critical thinking and self-assessment questions to help evaluate students’ understanding of the Council on Social Work Education’s (CSWE) 2022 Educational Policy and Accreditation Standards (EPAS), promoting in-depth learning. Instructors will also welcome a wide array of instructor resources, including a new Instructor Manual, Sample Syllabi, Test Bank, and chapter PowerPoint presentations. New to the Eleventh Edition: Every chapter opens with an extended vignette highlighting how professionals incorporate research methods into their work. New Practitioner Profiles provide real-world insights into human services, and podcast segments with recorded interviews are included with every chapter. Chapters now include Technology in Research and Research in Practice boxes, helping readers understand the research practice and technological innovations. The new Instructor Manual includes additional discussion questions relating to the podcasts, learning activities to help students evaluate competencies, and more. Key Features: Clear explanations of the research process, from problem-solving to data analysis, simplifies learning. Explore real-life stories via practitioner interviews and vignettes in every chapter. All chapters close with bulleted main points, key terms for review, and several types of questions for evaluating competencies and self-assessment. Understand the link between research and improved services and develop logic-based research skills.