Using Microsoft Excel for Social Research

Using Microsoft Excel for Social Research PDF Author: Charlotte Brookfield
Publisher: SAGE
ISBN: 1529753228
Category : Social Science
Languages : en
Pages : 186

Get Book Here

Book Description
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.

Quantitative Data Analysis Using MS Excel: a School Administrator's Guide

Quantitative Data Analysis Using MS Excel: a School Administrator's Guide PDF Author: Gerard Babo
Publisher:
ISBN: 9781495128578
Category :
Languages : en
Pages :

Get Book Here

Book Description


Statistical Analysis

Statistical Analysis PDF Author: Conrad Carlberg
Publisher: Que Publishing
ISBN: 0133823997
Category : Business & Economics
Languages : en
Pages : 714

Get Book Here

Book Description
Use Excel 2013’s statistical tools to transform your data into knowledge Conrad Carlberg shows how to use Excel 2013 to perform core statistical tasks every business professional, student, and researcher should master. Using real-world examples, Carlberg helps you choose the right technique for each problem and get the most out of Excel’s statistical features, including recently introduced consistency functions. Along the way, he clarifies confusing statistical terminology and helps you avoid common mistakes. You’ll learn how to use correlation and regression, analyze variance and covariance, and test statistical hypotheses using the normal, binomial, t, and F distributions. To help you make accurate inferences based on samples from a population, this edition adds two more chapters on inferential statistics, covering crucial topics ranging from experimental design to the statistical power of F tests. Becoming an expert with Excel statistics has never been easier! You’ll find crystal-clear instructions, insider insights, and complete step-by-step projects—all complemented by extensive web-based resources. Master Excel’s most useful descriptive and inferential statistical tools Tell the truth with statistics—and recognize when others don’t Accurately summarize sets of values Infer a population’s characteristics from a sample’s frequency distribution Explore correlation and regression to learn how variables move in tandem Use Excel consistency functions such as STDEV.S() and STDEV.P() Test differences between two means using z tests, t tests, and Excel’s Data Analysis Add-in Use ANOVA to test differences between more than two means Explore statistical power by manipulating mean differences, standard errors, directionality, and alpha Take advantage of Recommended PivotTables, Quick Analysis, and other Excel 2013 shortcuts

Research Methods and Statistics for Public and Nonprofit Administrators

Research Methods and Statistics for Public and Nonprofit Administrators PDF Author: Masami Nishishiba
Publisher: SAGE Publications
ISBN: 1483301419
Category : Political Science
Languages : en
Pages : 393

Get Book Here

Book Description
Research Methods and Statistics for Public and Nonprofit Administrators: A Practical Guide is a comprehensive, easy-to-read, core text that thoroughly prepares readers to apply research methods and data analysis to the professional environments of public and non-profit administration. The authors expertly incorporate original case examples to demonstrate concepts using “real actors,” facing specific scenarios, in which research methods must be applied. This unique approach—presented in language accessible to both students new to research as well as current practitioners—guides the reader in fully understanding the research options detailed throughout the text.

Quantitative Methods for Decision Making Using Excel

Quantitative Methods for Decision Making Using Excel PDF Author: Glyn Davis
Publisher: Oxford University Press, USA
ISBN: 0199694060
Category : Business & Economics
Languages : en
Pages : 653

Get Book Here

Book Description
Quantitative Methods for Decision Making is a comprehensive guide that provides students with the key techniques and methodology they will need to successfully engage with all aspects of quantitative analysis and decision making; both on their undergraduate course, and in the larger context of their future business environments. Organized in accordance with the enterprise functional structure where the decision making takes place, the textbook encompasses a broad range of functions, each detailed with clear examples illustrated through the single application tool Microsoft Excel. The authors approach a range of methods which are divided into major enterprise functions such as marketing, sales, business development, manufacturing, quality control and finance; illustrating how the methods can be applied in practice and translated into a working environment. Each chapter is packed with short case studies to exemplify the practical use of techniques, and contains a wealth of exercises after key sections and concepts, giving students the opportunity to monitor their own progress using the solutions at the back of the book. An Online Resource Centre accompanies the text and includes: For students: - Numerical skills workbook with additional exercises, questions and content - Data from the examples and exercises in the book - Online glossary of terms - Revision tips - Visual walkthrough videos covering the application of a range of quantitative methods - Appendices to the book For lecturers: - Instructor's manual including solutions from the text and a guide to structuring lectures and seminars - PowerPoint presentations - Test bank with questions for each chapter - Suggested assignment and examination questions

Decision Analytics

Decision Analytics PDF Author: Conrad George Carlberg
Publisher: Que Publishing
ISBN: 0789751682
Category : Business & Economics
Languages : en
Pages : 288

Get Book Here

Book Description
Explains how to distil big data into manageable sets and use them to optimise business and investment decisions. Reveals techniques to improve a wide range of decisions, and use simple Excel charts to grasp the results. Includes downloadable Excel workbooks to adapt to your own requirements.

R for Microsoft® Excel Users

R for Microsoft® Excel Users PDF Author: Conrad Carlberg
Publisher: Que Publishing
ISBN: 0134571894
Category : Business & Economics
Languages : en
Pages : 440

Get Book Here

Book Description
This is the eBook of the printed book and may not include any media, website access codes, or print supplements that may come packaged with the bound book. Microsoft Excel can perform many statistical analyses, but thousands of business users and analysts are now reaching its limits. R, in contrast, can perform virtually any imaginable analysis–if you can get over its learning curve. In R for Microsoft® Excel Users, Conrad Carlberg shows exactly how to get the most from both programs. Drawing on his immense experience helping organizations apply statistical methods, Carlberg reviews how to perform key tasks in Excel, and then guides you through reaching the same outcome in R–including which packages to install and how to access them. Carlberg offers expert advice on when and how to use Excel, when and how to use R instead, and the strengths and weaknesses of each tool. Writing in clear, understandable English, Carlberg combines essential statistical theory with hands-on examples reflecting real-world challenges. By the time you’ve finished, you’ll be comfortable using R to solve a wide spectrum of problems–including many you just couldn’t handle with Excel. • Smoothly transition to R and its radically different user interface • Leverage the R community’s immense library of packages • Efficiently move data between Excel and R • Use R’s DescTools for descriptive statistics, including bivariate analyses • Perform regression analysis and statistical inference in R and Excel • Analyze variance and covariance, including single-factor and factorial ANOVA • Use R’s mlogit package and glm function for Solver-style logistic regression • Analyze time series and principal components with R and Excel

Health Services Research and Analytics Using Excel

Health Services Research and Analytics Using Excel PDF Author: Nalin Johri, PhD, MPH
Publisher: Springer Publishing Company
ISBN: 0826150284
Category : Medical
Languages : en
Pages : 252

Get Book Here

Book Description
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

Advanced Excel for Scientific Data Analysis

Advanced Excel for Scientific Data Analysis PDF Author: Robert De Levie
Publisher: Oxford University Press, USA
ISBN: 0195152751
Category : Computers
Languages : en
Pages : 631

Get Book Here

Book Description
This guide to Excel focuses on three areas--least squares, Fourier transformation, and digital simulation. It illustrates the techniques with detailed examples, many drawn from the scientific literature. It also includes and describes a number of sample macros and functions to facilitate common data analysis tasks. De Levie is affiliated with Bowdoin College. Annotation : 2004 Book News, Inc., Portland, OR (booknews.com).

The Coding Manual for Qualitative Researchers

The Coding Manual for Qualitative Researchers PDF Author: Johnny Saldana
Publisher: SAGE
ISBN: 1529755980
Category : Social Science
Languages : en
Pages : 355

Get Book Here

Book Description
This invaluable manual from world-renowned expert Johnny Saldaña illuminates the process of qualitative coding and provides clear, insightful guidance for qualitative researchers at all levels. The fourth edition includes a range of updates that build upon the huge success of the previous editions: A structural reformat has increased accessibility; the 3 sections from the previous edition are now spread over 15 chapters for easier sectional reference There are two new first cycle coding methods join the 33 others in the collection: Metaphor Coding and Themeing the Data: Categorically Includes a brand new companion website with links to SAGE journal articles, sample transcripts, links to CAQDAS sites, student exercises, links to video and digital content Analytic software screenshots and academic references have been updated, alongside several new figures added throughout the manual It remains the only book that looks specifically at coding qualitative data, as a core but often neglected skill that researchers and students alike need to effectively make sense of their data and to identify patterns, before they can analyse the material. Saldana presents a range of coding options with advantages and disadvantages to help researchers to choose the most appropriate approach for their project, reinforcing their perspective with real world examples, used to show step-by-step processes and to demonstrate important skills.