Title M4_Descriptive Stats Using Excel Datasets.pdf ✅

Agenda ⮚Descriptive Statistics Using Excel ⮚ Univariate Analysis ⮚ Measure of Spread ⮚ Skewness ⮚ Measure of Dispersion ⮚ Bivariate Analysis ⮚ Covariance and Correlation ⮚ Multivariate Analysis ⮚Charts in Excel ⮚ FDT ⮚ Bar Chart ⮚ Pie Chart ⮚ Pareto Chart ⮚ Cross Tab ⮚ Histogram ⮚ Scatter Plot
Descriptive Statistics Using Excel Statistical Functions
Descriptive Statistics •Where is the center of the data? (location) •What is the shape of the data? (shape) •How much does the data vary? (scale)
Univariate analysis is a basic kind of analysis technique for statistical data. Here the data contains just one variable and does not have to deal with the relationship of a cause and effect Univariate