The purpose of this assignment is to provide students hands-on experience with summarizing raw data using graphs and charts and interpreting results. Students will also use Excel® Pivot Tables and Pivot Charts to summarize raw data. In the era of big data, tools like Pivot Tables and PowerPivot are critical tools to summarize the data.
Resources: Microsoft® Excel®
Complete the five exercises on the Microsoft® Excel® file, “Graphical Techniques Template.”
Note: Detailed instructions for the first four questions are provided in the document, “Graphical Techniques Instructions.”