Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Master statistical analysis in Excel 2010 through comprehensive coverage of functions, formulas, charts, and PivotTables essential for business and economics applications. Explore fundamental statistical concepts starting with Excel setup and the Data Analysis Add-in, then progress through data organization, sorting, and visualization techniques using pie charts, column charts, bar charts, line graphs, and scatter plots. Learn to work with proportions, probabilities, percentages, and percentage change calculations while mastering cell references and formatting options. Dive deep into descriptive statistics including frequency distributions, histograms, measures of central tendency (mean, median, mode), variability measures, percentiles, quartiles, and outlier detection. Understand probability theory fundamentals, probability laws, conditional probability, Bayes' theorem, and various probability distributions including binomial, Poisson, normal, exponential, and uniform distributions. Practice sampling techniques, construct sampling distributions, and calculate confidence intervals for population means and proportions. Master hypothesis testing procedures for both means and proportions using p-values and critical values with z-distribution and t-distribution methods. Conclude with linear regression analysis covering scatter diagrams, correlation coefficients, covariance, slope calculations, y-intercepts, and coefficient of determination for goodness of fit assessment.
