DATA ANALYTICS VIDEO EXERCISE

1. Watch videos 6 about summary statistics using the Data Analysis add-in in Excel: 

2. Download and open the pizza dataset from the dataset drive folder.

3. Follow these instructions. (Note they are for a PC. If you desire to use a MAC you will have to search for instructions on youtube or google on how to install, find, and use the analysis toolpack in the MAC excel interface.)

In excel, click on: file > options > add-ins> Go > check the analysis toolpack + solver > O

Click on data > data analysis

find descriptive statistics and select it > OK

highlight all the data in the pizza dataset

check the box for summary statistics

Click okay.

clean up the new worksheet so it reads easier.

4. Save the workbook. upload it.

5. Remember what these descriptives tell us. If you don’t recall the definitions of the different descriptive statistics listed in it are (definition wise): mean, standard deviation, median, mode, variance, kurtosis, skewness, min, max, sum, count from the prerequisite stats class you took before this class, please google the terms so you can recall the definitions.

Order Similar Assignment Now!

  • Our Support Staff are online 24/7
  • Our Writers are available 24/7
  • Most Urgent order is delivered within 4 Hrs
  • 100% Original Assignment Plagiarism report can be sent to you upon request.

GET 15 % DISCOUNT TODAY use the discount code PAPER15 at the order form.

Type of paper Academic level Subject area
Number of pages Paper urgency Cost per page:
 Total: