For your first assignment you are asked to work with the data in the spreadsheet titled "Concert Sales" to demonstrate your understanding of descriptive statistics.

There are a number of ways to do this. For example, you can run 10 measures from the below:

measures of central tendency (mean, median, mode, proportion),

measures of dispersion (range, variance, standard deviation), and

frequency distributions, rank and percentile, scatterplots and histograms.

Choose measures mentioned above and carry them out directly in the Excel spreadsheet.

With this task, you will practice 10 Excel formulas manually and demonstrate your competency of charting skills: scatterplots (manually) and histograms (manually or Data Analysis Add-on)

Concert Sales
	Thousands of	Thousands of
Sales ($1000)	Radio&TV ads	Newspaper ads
$1,119.00	0	40
$973.00	0	40
$875.00	25	25
$625.00	25	25
$910.00	30	30
$971.00	30	30
$931.00	35	35
$1,177.00	35	35
$882.00	40	25
$982.00	40	25
$1,628.00	45	45
$1,577.00	45	45
$1,044.00	50	50
$914.00	50	50
$1,329.00	55	20
$1,330.00	55	20
$1,405.00	60	30
$1,436.00	60	30
$1,521.00	65	35
$1,741.00	65	35
$1,866.00	70	40
$1,717.00	70	40