+1 (208) 254-6996 [email protected]
  

Assignment 1:

Data File: Concert Sales (you can locate the file in Moodle under week 1).

Don't use plagiarized sources. Get Your Custom Essay on
Excel Assignment
Just from $13/Page
Order Essay

Instructions:

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 choose

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

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

·        frequency distributions and histograms.

Choose three different ways/measures and carry them out directly in the spreadsheet. Save your spreadsheet with your Firstname_lastname and submit it in the designated area. You will need the ToolPak add-on for Excel. You can find instructions here: https://support.office.com/en-us/article/load-the-analysis-toolpak-in-excel-6a63e598-cd6d-42e3-9317-6b40ba1a66b4.

Please note, it is your responsibility to have the correct software. If you do not have MS Excel, please contact your student advisor.

Concert Sales

Concert Sales
Thousands ofThousands of
Sales ($1000)Radio&TV adsNewspaper ads
$1,119.00040
$973.00040
$875.002525
$625.002525
$910.003030
$971.003030
$931.003535
$1,177.003535
$882.004025
$982.004025
$1,628.004545
$1,577.004545
$1,044.005050
$914.005050
$1,329.005520
$1,330.005520
$1,405.006030
$1,436.006030
$1,521.006535
$1,741.006535
$1,866.007040
$1,717.007040

Order your essay today and save 10% with the discount code ESSAYHELP