Statistics for MBA/ Business statistics explained by example

Learn how to compute the arithmetic mean, the most used measure of central tendency, using ungrouped and grouped data, with step-by-step Excel examples and the average function.

Highlight the advantages and disadvantages of the arithmetic mean as a central measure. It captures information from all observations yet is sensitive to extreme values and open-ended classes.

The range equals maximum minus minimum, offering an easy measure of spread, but it ignores variance among data points and is highly sensitive to outliers, making it an imperfect representation.

The lecture explains that the sum of squared distances from observations is minimized at the mean, and a constant prediction based on the mean minimizes squared error across all observations.

Explore normal distribution and the central limit theorem, their detailed properties, and how data take their shape, using Excel simulations to verify concepts.

Understand the normal distribution as a bell-shaped, symmetric curve where mean, median, and mode coincide. Standardize to z-scores to reveal 68.27% within one sd, 95.45% within two, 99.73% within three.

Normal distribution appears in nature as a bell-shaped curve, symmetric around the mean with most data near the center and fewer at the extremes.

the lecture shows the average of sample means equals the population mean and the standard deviation of sample means is sigma divided by sqrt(n), illustrating the central limit theorem.

See how sample proportions follow a normal distribution and lead to a confidence interval. Using two standard deviations around the sample proportion, estimate the population proportion with 95 percent.

Compute a 95% confidence interval for the sample proportion, p-hat = 0.55, from 200 students, as an estimate of the population parameter, using the standard error and 1.96 multiplier.

The lecture explains constructing a confidence interval for the mean using the standard error sigma-hat over sqrt(n), rooted in the central limit theorem, with an Excel-based demonstration.

Calculate a confidence interval for a small sample using a t-table with 9 degrees of freedom; for mean 11400 and sd 700, n=10, the 95% interval is 10899 to 11901.

Explore a business hypothesis testing example using copper wire diameter data to illustrate mean, standard deviation, normal distribution, and probability distributions, with Excel demonstrations.

Define Type I and II errors and the power of a test, then illustrate with a supplier risk example and central limit theorem using sample means.

Learn to select the correct statistic for hypothesis tests using a practical table, including z-tests, t-tests, one-sample proportion tests, and a medicine example.

Explore simple linear regression with an intuitive example, derive the ordinary least squares equation, and use Excel to estimate slope, correlation coefficient, and coefficient of determination.

Explore scenarios for one-way ANOVA across distinct groups, comparing means of scores, mileage, and bacteria counts to determine if group differences are due to treatment rather than chance.

Learn to calculate within-sample variance across multiple groups, weighting each variance by n_i−1, and obtain the pooled estimate of population variance with degrees of freedom N−k.

Learn to run one-way ANOVA in Excel using the data analysis toolpak. The method computes between and within variances, F-statistics, and p-values, with clear interpretation at the 5 percent level.