Joseph Schmuller - Statistical Analysis with Excel For Dummies

Здесь есть возможность читать онлайн «Joseph Schmuller - Statistical Analysis with Excel For Dummies» — ознакомительный отрывок электронной книги совершенно бесплатно, а после прочтения отрывка купить полную версию. В некоторых случаях можно слушать аудио, скачать через торрент в формате fb2 и присутствует краткое содержание. Жанр: unrecognised, на английском языке. Описание произведения, (предисловие) а так же отзывы посетителей доступны на портале библиотеки ЛибКат.

Statistical Analysis with Excel For Dummies: краткое содержание, описание и аннотация

Предлагаем к чтению аннотацию, описание, краткое содержание или предисловие (зависит от того, что написал сам автор книги «Statistical Analysis with Excel For Dummies»). Если вы не нашли необходимую информацию о книге — напишите в комментариях, мы постараемся отыскать её.

Become a stats superstar by using Excel to reveal the powerful secrets of statistics  Microsoft Excel offers numerous possibilities for statistical analysis—and you don’t have to be a math wizard to unlock them. In 
fully updated for the 2021 version of Excel, you’ll hit the ground running with straightforward techniques and practical guidance to unlock the power of statistics in Excel.
Bypass unnecessary jargon and skip right to mastering formulas, functions, charts, probabilities, distributions, and correlations. Written for professionals and students without a background in statistics or math, you’ll learn to create, interpret, and translate statistics—and have fun doing it! 
In this book you’ll find out how to: 
Understand, describe, and summarize any kind of data, from sports stats to sales figures Confidently draw conclusions from your analyses, make accurate predictions, and calculate correlations Model the probabilities of future outcomes based on past data Perform statistical analysis on any platform: Windows, Mac, or iPad Access additional resources and practice templates through Dummies.com For anyone who’s ever wanted to unleash the full potential of statistical analysis in Excel—and impress your colleagues or classmates along the way—
 walks you through the foundational concepts of analyzing statistics and the step-by-step methods you use to apply them.

Statistical Analysis with Excel For Dummies — читать онлайн ознакомительный отрывок

Ниже представлен текст книги, разбитый по страницам. Система сохранения места последней прочитанной страницы, позволяет с удобством читать онлайн бесплатно книгу «Statistical Analysis with Excel For Dummies», без необходимости каждый раз заново искать на чём Вы остановились. Поставьте закладку, и сможете в любой момент перейти на страницу, на которой закончили чтение.

Тёмная тема
Сбросить

Интервал:

Закладка:

Сделать

13 Chapter 13FIGURE 13-1: The Anova: Two-Factor Without Replication data analysis tool dialo...FIGURE 13-2: Output from the Anova: Two-Factor Without Replication data analysi...FIGURE 13-3: Combining the levels of Presentation Method with the levels of Pre...FIGURE 13-4: The Anova: Two-Factor With Replication data analysis tool dialog b...FIGURE 13-5: Output from the Anova: Two-Factor With Replication data analysis t...FIGURE 13-6: Data for a study with a Between Group variable and a Within Group ...FIGURE 13-7: The completed ANOVA table for the analysis of the data in Figure 1...FIGURE 13-8: The ANOVA table for the first of two ANOVAs.FIGURE 13-9: The first ANOVA table after modifications.FIGURE 13-10: The modified first ANOVA table and the second ANOVA table.FIGURE 13-11: The ANOVA table with the information for the Between Group variab...FIGURE 13-12: The ANOVA table with all the SS, df, MS, and F -ratios.FIGURE 13-13: The data along with the Means table and the Standard Errors table...FIGURE 13-14: Graphing the results.FIGURE 13-15: The data from Figure 13-4, rearranged into stacked format.FIGURE 13-16: The completed StatPlus Two-Way ANOVA panel.FIGURE 13-17: Two-way ANOVA results.

14 Chapter 14FIGURE 14-1: SATs and GAPs in the Sahutsket University student body.FIGURE 14-2: The graph for y = 4 + 2 x. FIGURE 14-3: The deviations in a scatterplot.FIGURE 14-4: Data for the regression-related worksheet functions.FIGURE 14-5: The Function Arguments dialog box for SLOPE.FIGURE 14-6: The Function Arguments dialog box for INTERCEPT.FIGURE 14-7: The Function Arguments dialog box for STEYX.FIGURE 14-8: The Function Arguments dialog box for FORECAST . LINEAR.FIGURE 14-9: The Function Arguments dialog box for TREND, along with data. TREN...FIGURE 14-10: The results of TREND: Predicted GPAs for the sample SATs.FIGURE 14-11: The Function Arguments dialog box for TRENDalong with data. TREN...FIGURE 14-12: The results of TREND: Predicted GPAs for a new set of SATs.FIGURE 14-13: The Function Arguments dialog box for LINESTalong with the data ...FIGURE 14-14: LINEST's results in the output array.FIGURE 14-15: The Regression data analysis tool dialog box along with the SAT-G...FIGURE 14-16: The upper half of the Regression data analysis tool’s tabled outp...FIGURE 14-17: The lower half of the Regression data analysis tool’s tabled outp...FIGURE 14-18: The Normal Probability Plot shows the percentile data for the y- v...FIGURE 14-19: The SAT Residual plot graphs the residuals against the x- variable...FIGURE 14-20: The SAT Line Fit Plot shows the observed y- values and the predict...FIGURE 14-21: The Function Arguments dialog box for TRENDalong with data. TREN...FIGURE 14-22: The results of TREND: Predicted GPAs for the sample SATs and high...FIGURE 14-23: The Function Arguments dialog box for LINESTalong with the data ...FIGURE 14-24: LINEST's multiple regression results in the output array.FIGURE 14-25: Part of the output from the Regression data analysis tool: Regres...FIGURE 14-26: Using LINESTthe iPad way. (Compare with Figure 14-13.)FIGURE 14-27: The completed StatPlus Multiple Linear Regression panel.FIGURE 14-28: The StatPlus Multiple Linear Regression output.

15 Chapter 15FIGURE 15-1: A scatterplot of 20 students’ SATs and GPAs at Sahutsket Universit...FIGURE 15-2: Scatterplot of the 20 students, including the regression line.FIGURE 15-3: One point in the scatterplot and its associated distances.FIGURE 15-4: The Function Arguments dialog box for CORRELalong with data.FIGURE 15-5: The Correlation data analysis tool dialog box along with data for ...FIGURE 15-6: The Correlation data analysis tool’s tabled output.FIGURE 15-7: The Covariance data analysis tool’s tabled output for SAT, High Sc...FIGURE 15-8: The FISHER Function Arguments dialog box.FIGURE 15-9: The completed StatPlus Linear Correlations panel.FIGURE 15-10: The StatPlus Linear Correlations output.

16 Chapter 16FIGURE 16-1: Quarterly sales figures for the FarDrate MeesKyte watch.FIGURE 16-2: Formatting the trendline to produce a moving average.FIGURE 16-3: The completed Moving Average dialog box.FIGURE 16-4: The results: Moving averages, standard errors, and a chart.FIGURE 16-5: The Exponential Smoothing data analysis tool dialog box.FIGURE 16-6: Exponential smoothing with three damping factors.FIGURE 16-7: The Create Forecast Worksheet dialog box.FIGURE 16-8: The expanded Create Forecast Worksheet dialog box.FIGURE 16-9: The created Forecast worksheet.FIGURE 16-10: The forecast statistics.FIGURE 16-11: The completed StatPlus Moving Average pane.FIGURE 16-12: The StatPlus Moving Average output.FIGURE 16-13: The completed StatPlus Exponential Smoothing pane.FIGURE 16-14: The StatPlus Exponential Smoothing output.

17 Chapter 17FIGURE 17-1: The Mann-Whitney U test.FIGURE 17-2: The Kruskal–Wallis one-way analysis of variance.FIGURE 17-3: The Wilcoxon matched-pairs signed ranks test.FIGURE 17-4: The Friedman two-way analysis of variance.FIGURE 17-5: Cochran's Q test.FIGURE 17-6: Spearman’s r S.

18 Chapter 18FIGURE 18-1: The Function Arguments dialog box for PERMUT.FIGURE 18-2: The probability distribution for x, a random variable based on the...FIGURE 18-3: The standard normal distribution: a probability density function.FIGURE 18-4: The BINOM.DIST Function Arguments dialog box.FIGURE 18-5: The binomial distribution for x successes in ten tosses of a die, ...FIGURE 18-6: The Function Arguments dialog box for BINOM . DIST . RANGE.FIGURE 18-7: The NEGBINOM.DIST Function Arguments dialog box.FIGURE 18-8: The BINOM.INV Function Arguments dialog box.FIGURE 18-9: The HYPGEOM.DIST Function Arguments dialog box.FIGURE 18-10: The hypergeometric distribution for x successes in a six-item sam...

19 Chapter 19FIGURE 19-1: The Beta Density function for four successes in ten trials.FIGURE 19-2: The BETA.DIST Function Arguments dialog box.FIGURE 19-3: The BETA.INV Function Arguments dialog box.FIGURE 19-4: The POISSON.DIST Function Arguments dialog box.FIGURE 19-5: Poisson probabilities and binomial probabilities.FIGURE 19-6: The density function for gamma, with Alpha = 2 and Beta =1.FIGURE 19-7: The GAMMA.DIST Function Arguments dialog box.FIGURE 19-8: The GAMMA.INV Function Arguments dialog box.FIGURE 19-9: The EXPON.DIST Function Arguments dialog box.

20 Chapter 20FIGURE 20-1: Visualizing the Poisson distribution.FIGURE 20-2: Web page hits/hour — Poisson-predicted (μ =3) and observed.FIGURE 20-3: Web page hits/hour — Poisson-predicted (μ =3) and observed along w...FIGURE 20-4: The χ 2distribution, df = 6. The shaded area is the probability of...FIGURE 20-5: Runs scored, runs allowed, predicted wins, and wins for each team ...FIGURE 20-6: The CHISQ.TEST Function Arguments dialog box.FIGURE 20-7: Outcomes and probabilities for a pair of loaded dice.FIGURE 20-8: The Random Number Generation dialog box.FIGURE 20-9: The results of simulating 200 tosses of a pair of loaded dice.FIGURE 20-10: The Random Number Generation dialog box for a normal distribution...FIGURE 20-11: The results of the central limit theorem simulation.FIGURE 20-12: When you copy a cell array and then right-click another cell, thi...FIGURE 20-13: The worksheet for the business simulation.FIGURE 20-14: Choosing What-If | Data Table.FIGURE 20-15: The Data Table dialog box.FIGURE 20-16: A histogram visualizes the 1,000 simulation results.

21 Chapter 21FIGURE 21-1: The scatterplot for the data in Table 21-1.FIGURE 21-2: Logistic regression model for the data in Table 21-1.FIGURE 21-3: Worksheet with the data in Table 21-1.FIGURE 21-4: The XLMiner Analysis ToolPak in the Office Add-Ins box.FIGURE 21-5: Clicking the Show ToolPak button opens the XLMiner Analysis ToolPa...FIGURE 21-6: Select Logistic Regression in the XLMiner Analysis ToolPak pane to...FIGURE 21-7: The completed Logistic Regression fields and the output of logisti...FIGURE 21-8: Numerators (column C) and estimated probabilities (column D) for t...

Читать дальше
Тёмная тема
Сбросить

Интервал:

Закладка:

Сделать

Похожие книги на «Statistical Analysis with Excel For Dummies»

Представляем Вашему вниманию похожие книги на «Statistical Analysis with Excel For Dummies» списком для выбора. Мы отобрали схожую по названию и смыслу литературу в надежде предоставить читателям больше вариантов отыскать новые, интересные, ещё непрочитанные произведения.


Отзывы о книге «Statistical Analysis with Excel For Dummies»

Обсуждение, отзывы о книге «Statistical Analysis with Excel For Dummies» и просто собственные мнения читателей. Оставьте ваши комментарии, напишите, что Вы думаете о произведении, его смысле или главных героях. Укажите что конкретно понравилось, а что нет, и почему Вы так считаете.

x