Purpose of Assignment
The purpose of this assignment is to provide students opportunities to reinforce the fundamental topics in data analytics. Through this assignment, students will learn how to read information from bar charts, pie charts, line charts, and frequency distributions. Students will also use Microsoft Excel’s pivot table functionality to create frequency distributions, bar charts, and pie charts. The assignment also includes evaluating basic descriptive statistics using Microsoft Excel®.
Resources: Data Analytics Problem Set Excel® Template, Excel® 2016 Essential Training
Save the Data Analytics Problem Set Excel® Template to your computer.
Read the instructions on the first tab.
Complete the twelve exercises located in the template and record your answers in the highlighted spaces.
For problem 7, please use Pivot tables. It is a pretty simple pivot table.