Tuesday, March 22, 2016

How to install the Data Analysis toolpak in Ms Excel

How to install the Data Analysis toolpak in Ms Excel

Data Analysis Toolpak is a tool allowing us to analyze data such as: analysis of variance (ANOVA): single factor and two factors, correlation, covariance, histogram, descriptive statistics, exponential smoothing, test statistics, moving average, fourier analysis, regression, rank and percentile, sampling. In this video, you will learn how to install the Data Analysis Toolpak in Microsoft Excel 2013 (also 2016)....

How to create a Histogram in Microsoft Excel 2016

How to create a Histogram in Microsoft Excel 2016

In this video, you will learn about histogram and how to create it in Microsoft Excel 2016. It is step-by-step tutorial that you can follow easily. Let's watch the video tutorial. When you plot a histogram, you might see different sharp or form of a distribution. This is called skewness of histogram as shown below: If you have any...