(BQ) Part 1 book “Statistics for managers using Microsoft excel” has contents: Defining and collecting data, organizing and visualizing variables, numerical descriptive measures, basic probability, discrete probability distributions, the normal distribution and other continuous distributions, and other contents. | A Roadmap for Selecting a Statistical Method Data Analysis Task For Numerical Variables For Categorical Variables Describing a group or Ordered array, stem-and-leaf display, frequency Summary table, bar chart, pie several groups distribution, relative frequency distribution, chart, doughnut chart, Pareto chart percentage distribution, cumulative percentage (Sections and ) distribution, histogram, polygon, cumulative percentage polygon, sparklines, gauges, treemaps (Sections , , , ) Mean, median, mode, geometric mean, quartiles, range, interquartile range, standard deviation, variance, coefficient of variation, skewness, kurtosis, boxplot, normal probability plot (Sections , , , ) Index numbers (online Section ) Inference about one group Confidence interval estimate of the mean (Sections and ) t test for the mean (Section ) Chi-square test for a variance or standard deviation (online Section ) Confidence interval estimate of the proportion (Section ) Z test for the proportion (Section ) Comparing two groups Tests for the difference in the means of two independent populations (Section ) Wilcoxon rank sum test (Section ) Paired t test (Section ) F test for the difference between two variances (Section ) Z test for the difference between two proportions (Section ) Chi-square test for the difference between two proportions (Section ) McNemar test for two related samples (online Section ) Comparing more than One-way analysis of variance for comparing several Chi-square test for differences two groups means (Section ) among more than two proportions (Section ) Kruskal-Wallis test (Section ) Two-way analysis of variance (Section ) Randomized block design (online Section ) Analyzing the relationship between two variables Scatter plot, time-series plot (Section ) Covariance, coefficient of correlation (Section ) Simple linear .
