# Topic 1 - Basic Concepts and Numerical and Descriptive Statistics

### Week 2

Hello,

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.

## Question 1 (a)

Calculate sum based on sigma notation.

## Question 1 (b)

Construct a stem and leaf plot.

Construct a Histogram (with 5 intervals).

Construct a percentage polygon and cumulative percentage polygon.

## Question 1 (c)

Calculate mean, mode, median, Quartile 1 and 3, Interquartile range, Box Whisker plot.

## Question 1 (d)

Calculate the sample mean and variance.

## Question 1 (e)

Use Excel data analysis toolpack to replicate the descriptive statistics.

## Question 1 (f)

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

## Question 1 (g)

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