Mar 14
Statistical Analysis with Excel-Chapter4
Adding a Spark
Sparkline is a tiny chart you can integrate into text /table to quickly illustrate a trend.
Its size is equal to a word.
Types:
Line chart
Column chart
Win and losses
In all previous chapters, we went through North American countries. Let us have an overview of Vaccination rates in Asian countries with the highest population in the year 2021.
Insert tab- Sparklines-Line-Data range (A3:M8) and Location Range-N3:N8
Insert tab- Sparklines-Column-Data range (A3:M8) and Location Range-O3:O8
The last type of chart is not shown in the above chart but I will show an example where it is applicable.
Insert tab-Sparklines-Win and losses-Data Range(A2:I6) and Location Range(J2:J6).
The 1 represents they won the gold medal,-1 represents if they did not receive any medal in that sport.0 represents that they did not win gold but at least won Silver/bronze.
I agree that this is not one of the best examples but took this data as it is recent.
Continue practicing….
Passing the Bar
The bar chart is similar to a Column chart studied in Chapter1, but the horizontal axis is the y-axis and tracks the dependent variable. The vertical axis holds the independent variable and is referred to as X-axis.
I would recommend these charts when I am plotting categorical Vs Numerical values Or also can be used when I want to make a point about reaching a goal /inequities in attaining a goal.
2D and 3D bars are available types.
Time to remember we are using the same Kaggle dataset and converting it into a pivot table.
Select the data/table-Insert tab-Pivot table
Pivot table fields :
columns-(country)
Rows-(date)
Values-(max of people fully vaccinated)
Insert-pivot chart.
The goal is to attain the vaccination of the total population of 34 million .
To have a similar chart I formatted the units and bounds on Format axis.
We can clearly depict that 90% of people are fully vaccinated .
