Descriptive Analytics: A Spreadsheet Oriented Approach
2017 | English | ASIN: B06XQ5HHD1 | 194 pages | EPUB | 4.57 Mb
This is ebook is carefully design for students and professionals who want to do descriptive analysis for decision making. This ebook not only provide conceptual clarity but also tell you how to carry out analytics using MS Excel. The various topics it includes are:
Introduction to Data Analytics
Diagrammatic Representation
Graphic Representation
Line Chart
Bar Chart
Sub-divided Bar Graph
Percentage Bar Graph
Pie Chart
Doughnut Chat
Area Chart
Stock Chart
Scatter Chart
Bubble Chart
Frequency Distribution
Frequency Polygon
Histogram
Ogive
Exploratory Data Analysis: The Stem-and-Leaf Display
Cross Tabulation
Summarizing Data: Numerical Methods
Measures of Central Tendency
Mean
Median
Mode
Quartile
Percentile
Measures of Dispersion
Range
Inter-quartile Range
Variance
Standard Deviation
Coefficient of Variation
Measures of Shape
Symmetrical Distribution
Asymmetrical Distribution
Skewness
Kurtosis
Tchebycheff Theorem
z-Scores
Exploratory Data Analysis
Five-Number Summary
Box-Plot
Working with Grouped Data
Weighted Mean
Arithmetic Mean in Case of Grouped Data
Variance in case of Grouped Data
Covariance and Correlation
Regression