This course is about a new set of charting tools that are available exclusively in EXCEL 2016.
The new charting features extend the analytical capability of EXCEL and provide the analyst with the ability to do exploratory data analysis that was not possible in EXCEL2010-2013.
The course uses real world datasets in the area of health, world economy, baseball statistics, education and industry to showcase how the data should be organized and transformed prior to the analysis, how the analysis should be performed and especially how to interpret the results.
The datafiles used for the course are available for the student to practice. The course will take about an hour or less to complete and the skills learned can be used right away in your daily business or educational activities.
This course is essential for those interested in data analytics in EXCEL 2016 as it showcases how to effectively use the new EXCEL charting tools for data analysis.
In this section, we will cover the basics of the features that will use for creating charts.
The project file name is ProjectNewChartingtoolsExcel2016. I added new datafiles for you to use for the project work. The name of the sheet in the file tells you what needs to be done. Exemple: Boxplot (do a boxplot comparing men and women literacy rate for all countries in the world). For histogram, you only need to do the histogram of the total literacy rate.
When you are done or if you need help, please contact me.
At the end of this lecture, the students will know more about the Pareto chart and the Pareto principle.
After completing this lecture,students will know about box and whiskers, how they are constructed and used to compare the groups.
At the end of this lecture, students will know about the WATERFALL new chart and the areas of application of this new charting tool.
At the end of this lecture, the students will know about the TREEMAP advanced charting feature and when to use it for hierarchal data.
At the end of this lecture, students will know about the SUNBURST chart and when it is used instead of the TREEMAP.
This lecture provides basic explanations about the histogram and what it is used for.
At the end of this lecture, the student will learn about the funnel charting tool and will be able to use for appropriate datasets for analytical purposes.
After completing this lesson, you will be able to use the advanced histogram chart tool to easily analyze the distribution of any quantitative variable in your data.
After this lesson, you will know how to effectively use the funnel chart to analyze data and draw interpretation about the resulting chart.
In this lecture, you will learn how to create a histogram in EXCEL 2016 and make interpretation of the results.
In this lecture, you will learn how to create and interpret a Pareto chart in EXCEL 2016
In this lecture, we continue to reinforce the Pareto principle with more suitable examples/
In this lecture, you will learn how to use the EXCEL 2016 advanced analysis tool TREEMAP to analyze causes of death datasets.
In this lecture, you will learn how to use the SUNBURST charting tool to analyze a dataset and make interpretations of the results.
At the end of this lesson, you will know how the data needs to be organized and prepared before using the boxplot charting tool.
In this lecture, you will learn how to use the boxplot charting tools to compare two or more groups means and then draw conclusion from the resulting analytical chart.
At the end of this lecture, students will be able to use people charts tool to analyze data
At the end of this lecture, you will know how to use effectively the Waterfall chart to analyzed data with positive and negative values.
At the end of this lesson, the student will understand how to use the funnel chart to display data that progresses in stages.
After this lesson, you will know how to construct an effective funnel chart by sorting the data before or after producing the chart.
In this lecture, you will learn how to use the funnel charting tool to analyze data and also be able to interpret the resulting analysis.
Concluding remarks for the course
Choosing the right type of advanced charting tool for analyzing data
Determining the composante of a box and whisker chart in EXCEL 2016
Finding which gender group literacy is higher than the other.
I have over 18 years of work experience in the field of statistics as an Applied Statistician. For the last twelve years, I have also been teaching undergraduate college level statistics courses at St Petersburg College. As an Applied Statistician, I have developed over the years a strong interest in using EXCEL as a statistical tool with my classes in order to give to the students real world hands-on experience with Statistics.