In this week you will learn about the mean, median, mode, Q1, Q2, variance and some important charting techniques using excel such as histograms and polygons.
Calculate sum based on sigma notation.
Construct a stem and leaf plot.
Construct a Histogram (with 5 intervals).
Construct a percentage polygon and cumulative percentage polygon.
Calculate mean, mode, median, Quartile 1 and 3, Interquartile range, Box Whisker plot.
Calculate the sample mean and variance.
Use Excel data analysis toolpack to replicate the descriptive statistics.
Based on the following portfolio data draw a pie chart:
type | amount in 1000’s $ |
stocks | 46.5 |
bonds | 32 |
cd | 15.5 |
savings | 16 |
Illustrate the following data with the most appropriate chart.
A | B | C | |
stocks | 46.5 | 55 | 27.5 |
bonds | 32 | 44 | 19 |
cd | 15.5 | 20 | 13.5 |
saving | 16 | 28 | 7 |