Exploratory Data Analysis in Excel - Analyzing Data in Excel (83)
// Exploratory Data Analysis in Excel //
You can also analyze data exploratively in Excel. You can use location parameters (mean, median, etc.) and dispersion parameters (standard deviation, quantiles, etc.). These are most easily accessed via the so-called population parameters in Excel's data analysis function.
In addition, you can also create charts – depending on the number of variables to be analyzed. Histograms and boxplots are particularly useful. These are useful for describing a distribution in terms of its center and the dispersion around that center. However, if you want to uncover a relationship (keyword: correlation) between two variables, a scatterplot is worthwhile. If necessary, you can even insert a trend line along with the function and the coefficient of determination.
For questions or suggestions regarding Exploratory Data Analysis in Excel, please use the comments function. You can indicate whether you found the video helpful by giving it a thumbs up or down. #statistikampc
⭐Become a channel member⭐:
======================
/ @statistikampc_bjoernwalther
Timestamp ⏰
============
0:00 Introduction
0:14 Population characteristics
3:13 Graphical studies
Support the channel? 🙌🏼
===================
Paypal donation: https://www.paypal.com/paypalme/Bjoer...
Amazon affiliate link: http://amzn.to/2iBFeG9
Thank you for your support! ♥