Statistical Analysis with Excel-Chapter6
In this chapter, I want to finish some of the not most important charts altogether.
Surface
Radar
Treemap and Sunburst.
The surface chart is a 3-dimensional way to show the results of combining one variable with another.
I am using my same Kaggle dataset of covid vaccinations.
Use this data set and converted into Pivot table then used Axis(country)-USA, UK, India, Germany, France, Brazil as these countries have highest Covid cases.Values(Max of people fully vaccinated), Legend(Years-2021).
This means that I am taking the X-axis as countries, the Y-axis as Quarters of the Year 2021, and the Z-axis as the Max of people fully vaccinated.
Insert-pivot chart-surface chart
Other types:
Wireframe 3-D surface
Contour
Wireframe contour
Radar
Radar chart plots the values of each of a set of categories on a set of concentric rings. The values appear along the axis that starts at the center and ends on the outer ring.
In the above chart, I did not give you my Pivot table field settings but gave you a glimpse of the pivot table obtained after formatting. As we went through a lot of practice I want you to try on your own.
Treemap
Treemap is a type of hierarchical chart that shows patterns in the data.
The rectangle represents tree branches and smaller rectangles represent subbranches.
I will take a different dataset that is similar to hierarchical data.
https://www2.census.gov/library/publications/2011/compendia/statab/131ed/tables/12s0805.xls
Took the data from there and made a data list containing only this information.
Sunburst
Sunburst chart illustrates same type of data.The highest level in the hierarchy is in the inner ring and sublevels in the outer ring.
Do not forget to continue reading the next chapter ,I cannot stress enough of its importance in Data Science.