Automobile Car Sales Analysis using EXCEL
Vlookups()
Index()
Match()
Sum()
Average()
Countif()
IF()
A data summarization tool in excel to group,filter and aggerate large data set,making it to anlayze and visualize trends and patterns.
Composition:
Piechart-% and Propotion Distribution
Comparision:
BarChart-Less than 5 products(if label name are smaller)
Column Chart-more than 5 products (big names)
ClusterChart-(product or year wise)less than 3 bar
Stacked Chart-overall value of the year or product wise
Trend patterns:
Linechart- over a period of time
Skweness:
Histrogram- distribution (only one column)
Correlation:
ScatterPlot- dependent and independent axis (3types)