$3\mathrm{.}3$ Assignment: Pivot Tables and Descriptive Charts

Getting Started

Using many different skills in one project is a test of capabilities. In this exercise, you will watch a video explaining how to develop a skill and then apply that skill to new data. In this case, you will create pivot tables and graphs. Summarizing data is often the precursor to graphing, so knowing how to summarize is essential and pivot tables make it simple to do$.$ You will be given what the pivot table or chart ought to look like and re$-$create them in the homework.

Upon successful completion of this assignment, you will be able to: $1.$ Demonstrate the ability to effectively use software tools to perform statistical analyses.

$2.$ Construct a data summarization and interpretation utilizing statistical terms.

Instructions

$1.$ Review the rubric to make sure you understand the criteria for earning your grade.

$2.$ In this activity you will watch these videos and view the PowerPoint presentations on pivot tables and charts:

a$.$ Videos:

i$.$ Excel PivotTables Made Easy $-$ And Why Things Go Wrong! $-$ YouTube $($new tab$)$

ii$.$ Excel Pivot Tables in $10$ Minutes $($Productivity tips included!$)-$ YouTube $($new tab$)$

b$.$ PowerPoints:

i$.$ Lesson $-$ PivotTablePelicanData.pptx $($PowerPoint presentation$)$ ii$.$ ii$.$ Lesson $-$ PivotTableRestaurantData.pptx $($PowerPoint presentation$)$ c$.$ c$.$ Download the Excel file: DescriptiveProblems$\_$Pivots$\_$Charts.xlsx $($Excel spreadsheet$)$

$3.$ Using the Excel spreadsheet:

a$.$ Create the pivot tables required.

b$.$ Create the graphs required.