Data Analytics PIL 13 Excel DescriptiveStatistics ReplicateWithFormulas скачать в хорошем качестве

Data Analytics PIL 13 Excel DescriptiveStatistics ReplicateWithFormulas

In this video, I walk through the descriptive statistics for our data on Volume and Dwell, specifically focusing on counts, sums, means, medians, modes, standard deviations, and more. I confirmed that our count for Volume and Dwell is 22,049, and we found the mean to be reasonable at 32 containers and 3.6 days. After removing outliers, we observed significant drops in the mean and standard deviation, making the data more manageable. I encourage you to review these statistics and consider how they change after excluding outliers, as it will be important for our next steps. In the next video, we will discuss confidence levels and margins of error. 00:00 Introduction to Data Analysis 03:10 Calculating Median and Mode 05:28 Understanding Kurtosis and Skewness 07:09 Minimum and Maximum Values 10:54 Removing Outliers Impact 13:30 Conclusion and Next Steps