Excel Assignment #1 To download the Excel document below, click

 

Excel Assignment #1

download icon To download the Excel document below, click on the download icon at the top right of the document once you open the link (should look like the downward arrow). Be sure to save this file. Your assignment is to complete the tasks provided within the Excel document. Upload your Excel submission to Blackboard

Using the McGraw-Hill Dataset in the Excel file, located here, complete the following tasks:

Task #1: What is the mean sales price? What is the median sales price? Is one measure more representative of the typical sales prices than the others?

Task #2: What is the range of sales prices? What is the standard deviation? About 95% of the sales prices are between what two values? Is the standard deviation a useful statistic for describing the dispersion of sales price?