Data Analysis In Plain English With Microsoft Excel

Harvey Brightman's accessible, easy-to-understand new book focuses on helping readers learn essential statistical concepts and data analysis. In an intuitive and non-mathematical writing style, Brightman uses actual business applications and covers practical insights in business problem solving using Microsoft Excel as the primary computational tool. His clear, to-the-point presentation gives students a 'map' for learning what data analysis techniques to use and when to use them. Brightman presents descriptive and inferential methods in sequential chapters, and introduces probability only as needed and then only on a very limited basis.

The latest book from Cengage Learning on Data Analysis with Microsoft« ExcelÖ

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

Integrates quantitative, qualitative, and mixed methods approaches, as well as specific up-to-date instruction in the use of statistical software programs such as Excel and SPSS. Pays equal attention to qualitative and quantitative approaches, and is the only book for Public Administration research methods with a dedicated, 4-chapter section on mixed methodologies, exploring fundamentals, research design, data collection, and analyzing and interpreting findings. Contains a new, dedicated chapter on Big Data research, all new exhibits and examples throughout the book, a new companion website to accompany the book containing PowerPoint slides for each chapter, and new exhibits, tables, figures, and exercises, as well as key terms and discussion questions at the end of each chapter. As with past editions, the 4e will be beloved by student and professors alike for its exceptional clarity, accessibility, and plentiful illustrations.

How-to guidance for measuring lost profits due to business interruption damages A Quantitative Approach to Commercial Damages explains the complicated process of measuring business interruption damages, whether they are losses are from natural or man-made disasters, or whether the performance of one company adversely affects the performance of another. Using a methodology built around case studies integrated with solution tools, this book is presented step by step from the analysis damages perspective to aid in preparing a damage claim. Over 250 screen shots are included and key cell formulas that show how to construct a formula and lay it out on the spreadsheet. Includes Excel spreadsheet applications and key cell formulas for those who wish to construct their own spreadsheets Offers a step-by-step approach to computing damages using case studies and over 250 screen shots Often in the course of business, a firm will be damaged by the actions of another individual or company, such as a fire that shuts down a restaurant for two months. Often, this results in the filing of a business interruption claim. Discover how to measure business losses with the proven guidance found in A Quantitative Approach to Commercial Damages.