Pivot Table assignment
The excel document contains 8 exercises about using and making pivot tables
Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper
Need help completing all 8.
Ex1
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
| Group Name |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Buttersworth Co |
| Row Labels |
Count of Group Name |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Marleyville Tea |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Postcards Store |
| 4 |
2
Marleyville Tea
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Randles Roadshack |
37 |
Marleyville Tea
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Examineers Inc |
| 34 |
Postcards Store Buttersworth Co
Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper
|
|
| 32 |
Buttersworth Co
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| FASST Trax |
32
Postcards Store
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Hula Hoopers |
32
Buttersworth Co
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Hehehe |
30 |
Buttersworth Co Marleyville Tea
25 |
Examineers Inc
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Creepy Lada |
|
|
| 20 |
Postcards Store
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Jokes R Us |
1
|
|
| 6 |
Buttersworth Co
|
|
|
|
|
|
|
|
|
|
|
| Petie’s Palace |
11 |
FASST Trax
|
| Grand Total |
| 31 |
1
Hehehe
Randles Roadshack
Hehehe
Marleyville Tea
FASST Trax
Randles Roadshack
Examineers Inc
Randles Roadshack
Creepy Lada
Marleyville Tea
Buttersworth Co
Hehehe
FASST Trax
Hula Hoopers
Buttersworth Co
Randles Roadshack
Hehehe
Hehehe
Postcards Store
Randles Roadshack
Hula Hoopers
Buttersworth Co
FASST Trax
FASST Trax
Creepy Lada
Hehehe
Creepy Lada
Petie’s Palace
Postcards Store
Examineers Inc
FASST Trax
Hehehe
Randles Roadshack
Hula Hoopers
Examineers Inc
Buttersworth Co
Postcards Store
Marleyville Tea
Creepy Lada
Buttersworth Co
Buttersworth Co
Examineers Inc
Examineers Inc
FASST Trax
Marleyville Tea
Creepy Lada
Hehehe
Jokes R Us
Marleyville Tea
Hehehe
Buttersworth Co
Randles Roadshack
Postcards Store
Examineers Inc
Marleyville Tea
Postcards Store
Postcards Store
Postcards Store
Buttersworth Co
Randles Roadshack
FASST Trax
Postcards Store
Marleyville Tea
Hula Hoopers
Buttersworth Co
Postcards Store
Hula Hoopers
Hehehe
Hehehe
Randles Roadshack
Hula Hoopers
FASST Trax
Postcards Store
FASST Trax
Buttersworth Co
Examineers Inc
Marleyville Tea
Hula Hoopers
Postcards Store
FASST Trax
Creepy Lada
Postcards Store
Hula Hoopers
FASST Trax
Petie’s Palace
Randles Roadshack
Postcards Store
Examineers Inc
Buttersworth Co
Jokes R Us
Randles Roadshack
Buttersworth Co
Creepy Lada
Examineers Inc
Randles Roadshack
Examineers Inc
Examineers Inc
Hehehe
Buttersworth Co
Randles Roadshack
Postcards Store
Randles Roadshack
Postcards Store
Randles Roadshack
Marleyville Tea
Randles Roadshack
Hula Hoopers
Hehehe
FASST Trax
FASST Trax
Hehehe
Marleyville Tea
Postcards Store
Jokes R Us
Examineers Inc
Postcards Store
Marleyville Tea
Hula Hoopers
Postcards Store
Petie’s Palace
Examineers Inc
Postcards Store
Examineers Inc
Creepy Lada
Randles Roadshack
Buttersworth Co
Jokes R Us
Examineers Inc
Hula Hoopers
Hehehe
Randles Roadshack
Petie’s Palace
Creepy Lada
Jokes R Us
Petie’s Palace
Hehehe
Buttersworth Co
Randles Roadshack
Hula Hoopers
Examineers Inc
Hula Hoopers
Examineers Inc
Creepy Lada
Creepy Lada
FASST Trax
Postcards Store
FASST Trax
Hula Hoopers
Buttersworth Co
Postcards Store
Jokes R Us
Randles Roadshack
Postcards Store
Randles Roadshack
Jokes R Us
Postcards Store
Buttersworth Co
Postcards Store
FASST Trax
FASST Trax
Marleyville Tea
Buttersworth Co
Hula Hoopers
Hula Hoopers
Petie’s Palace
Hehehe
Randles Roadshack
Examineers Inc
Examineers Inc
Examineers Inc
Randles Roadshack
Marleyville Tea
Jokes R Us
Hula Hoopers
Postcards Store
Buttersworth Co
Hula Hoopers
Examineers Inc
Postcards Store
Examineers Inc
Hula Hoopers
Postcards Store
Postcards Store
Hehehe
Hehehe
Buttersworth Co
Hehehe
Jokes R Us
Petie’s Palace
Marleyville Tea
FASST Trax
Creepy Lada
Petie’s Palace
Examineers Inc
Examineers Inc
Hehehe
Marleyville Tea
Hula Hoopers
Buttersworth Co
Marleyville Tea
Examineers Inc
FASST Trax
Randles Roadshack
Hehehe
Postcards Store
Randles Roadshack
Postcards Store
Randles Roadshack
Examineers Inc
Randles Roadshack
Hehehe
Examineers Inc
Hula Hoopers
Hehehe
Jokes R Us
Hula Hoopers
Petie’s Palace
Hula Hoopers
Examineers Inc
Randles Roadshack
Hula Hoopers
Marleyville Tea
FASST Trax
Postcards Store
Creepy Lada
Hehehe
Buttersworth Co
Hula Hoopers
Postcards Store
Hehehe
Hula Hoopers
Creepy Lada
Hula Hoopers
Randles Roadshack
Postcards Store
Jokes R Us
Postcards Store
Examineers Inc
Buttersworth Co
Hula Hoopers
Hehehe
Petie’s Palace
Marleyville Tea
FASST Trax
Examineers Inc
Hula Hoopers
FASST Trax
FASST Trax
Examineers Inc
FASST Trax
FASST Trax
Jokes R Us
Randles Roadshack
Postcards Store
Randles Roadshack
Jokes R Us
Examineers Inc
Examineers Inc
Randles Roadshack
FASST Trax
Buttersworth Co
Petie’s Palace
Hula Hoopers
Jokes R Us
Postcards Store
Hehehe
Buttersworth Co
Postcards Store
Marleyville Tea
Randles Roadshack
Jokes R Us
Randles Roadshack
Randles Roadshack
Creepy Lada
Buttersworth Co
Marleyville Tea
Marleyville Tea
Hehehe
FASST Trax
Hehehe
Creepy Lada
Postcards Store
Creepy Lada
Randles Roadshack
Creepy Lada
Marleyville Tea
Randles Roadshack
Hula Hoopers
Jokes R Us
FASST Trax
FASST Trax
Hula Hoopers
Creepy Lada
FASST Trax
Buttersworth Co
Creepy Lada
Postcards Store
FASST Trax
Exercise 1:
*You have a list of repeating group names.
*Using a pivot table, count how many times each group name appears in the list.
*Keep pivot table in this tab.
Notice that this pivot table is a list comprised of each group name only occurring once.
Then, within the pivot table, put the list in decreasing order based on the number of times the name appears in the list.
Create a Piovt Chart to supplement the Pivot Table.
Number of order
Total
Postcards Store Randles Roadshack Examineers Inc Buttersworth Co FASST Trax Hula Hoopers Hehehe Marleyville Tea Creepy Lada Jokes R Us Petie’s Palace
42 |
37 34 32 32 32 30 25 20 16 11
Sheet1
Row Labels
Sum of
|
|
|
|
|
|
| Expenses |
| 306 |
.07
8 |
083
|
|
|
|
| 41 |
23 |
| 2
| 75 |
.30
65 |
3
73 |
107
7
| 38 |
.50
81 |
|
| 57 |
9 |
| 27 |
9
|
|
| 43 |
1.
47 |
4
94 |
3255
|
| 84 |
9
.2
| 59 |
|
| 92 |
484
| 39 |
| 94.
|
| 51 |
70
36 |
|
| 64 |
31
|
|
|
| 88 |
5
.
|
| 24 |
3242
8382 |
323.9
| 7688 |
5302
| 10
| 60 |
.4
86 |
5
46 |
4279
| 607.3436
| 71 |
1671
| 11
| 93 |
.06
61 |
6
| 22 |
927
|
| 14 |
8.
|
|
|
|
| 13 |
47430675
|
| 12 |
92.5195029237
|
|
|
|
|
| 123.1056275262 |
| 1331 |
.2645
18 |
0
15 |
3
|
|
|
|
|
| 959.230732332 |
|
| 17 |
34
.4124
|
| 28 |
7934
| 864.14
|
|
| 63 |
818564
| 1854.63
|
| 21 |
5818
| 98 |
|
|
|
|
|
| 930.5482506081 |
|
|
|
|
| 1939.7810982667 |
|
|
|
|
|
| 413.9417923424 |
| 1946 |
.1366556306
|
|
|
|
|
| 273.5117357051 |
|
|
|
|
| 2198.6577925002 |
|
|
|
|
|
| 1037.2944248302 |
2210.74
| 87 |
570109
|
|
|
|
|
| 465.5261878633 |
2555.
| 99 |
|
| 90 |
671807
|
|
|
|
|
| 824.1294903511 |
| 25
|
|
| 97 |
.3536595
| 96 |
9
489.9
| 8697 |
76835
| 2665 |
.11
40 |
925001
|
|
|
|
|
| 654.9796658203 |
|
|
|
|
| 2743.8026187562 |
|
| 222.9192618
|
|
| 72 |
7
| 3151 |
.4227753704
|
|
|
|
|
|
| 848.2135170178 |
| 3178 |
.1969187318
|
|
|
|
|
| 756.2079622278 |
| 3185 |
.1817433305
|
|
|
|
|
| 455.4647279589 |
| 3222 |
.2105426214
|
|
|
|
|
| 760.2840912571 |
|
|
|
|
| 3434.6941177052 |
|
|
|
|
|
| 574.1248994173 |
| 3667 |
.2011903398
|
|
|
|
|
| 680.7146779199 |
| 3695 |
.1930207613
|
|
|
|
|
| 217.656286454 |
|
|
|
|
| 3712.5650123251 |
|
|
|
|
|
| 432.5485875 |
| 3931 |
.33
4369 |
7968
|
|
|
|
|
| 191.4213294839 |
| 4023 |
.2273803651
|
|
|
|
|
| 166.4942195963 |
|
|
|
|
|
| 4047.6691780881 |
|
|
|
|
|
|
| 481.0083008923 |
| 4151 |
.4397576795
|
|
|
|
|
| 336.4056384211 |
|
|
|
|
| 4168.8717148103 |
|
|
|
|
|
| 650.9037445718 |
|
|
|
|
| 4240.7446320371 |
|
|
|
|
|
| 737.0688535015 |
|
|
|
|
| 4246.8831914754 |
|
|
|
|
|
| 644.5164909708 |
4368.8062
| 3713 |
14
|
|
|
|
|
| 203.3753446594 |
|
|
|
|
| 4551.6036698894 |
|
|
|
|
|
| 701.0456588856 |
|
|
|
|
| 4575.5271715324 |
|
|
|
|
|
| 657.6493200788 |
|
|
|
|
| 4722.7733516562 |
|
|
|
|
|
| 837.7133331881 |
| 4723 |
.9958751125
|
|
|
|
|
| 463.2899115583 |
| 4797 |
.08750
4576 |
1
|
|
|
|
|
|
| 962.3550943443 |
| 4811 |
.0377530315
|
|
|
|
|
| 193.174936848 |
| 5038 |
.3068133744
|
|
|
|
|
| 306.9576869105 |
5050.97
| 5927 |
6909
|
|
|
|
|
| 618.3260163369 |
| 5220 |
.4269398047
|
|
|
|
|
| 589.1737959411 |
| 5401 |
.2418187665
|
|
|
|
|
| 877.9679090344 |
|
|
|
|
| 5512.7676568329 |
|
|
|
|
|
| 542.6187225193 |
5575.671
| 739 |
7643
|
|
|
|
|
| 148.3339740683 |
|
|
|
|
| 5927.0420304617 |
|
|
|
|
|
| 501.2388428822 |
| 6180 |
.0357471981
|
|
|
|
|
|
| 551.2667803915 |
| 6221 |
.2486222635
|
|
|
|
|
| 414.8820747116 |
|
|
|
|
| 6444.5836306461 |
|
|
|
|
|
| 258.5026825916 |
|
|
|
|
|
| 6537.8001010167 |
|
|
|
|
|
|
| 931.9697247837 |
|
|
|
|
|
| 6557.8729832219 |
|
|
|
|
|
|
| 83.3393859721 |
| 6589 |
.1246624486
|
|
|
|
|
| 278.188383772 |
| 6741 |
.4600639306
|
|
|
|
|
| 418.0317384718 |
| 6772 |
.1330424373
|
|
|
|
|
|
| 436.8799836118 |
|
|
|
|
| 7007.7682447152 |
|
|
|
|
|
| 765.6916987833 |
|
|
|
|
| 7157.6275489008 |
|
|
|
|
|
| 915.9245386615 |
| 7282 |
.1887565894
|
|
|
|
|
| 387.5496207223 |
|
|
|
|
| 7350.6122898348 |
|
|
|
|
|
| 271.9879435914 |
| 7506 |
.472
6445 |
372
|
|
|
|
|
| 408.0083325832 |
| 7567 |
.0351493276
|
|
|
|
|
| 720.319063955 |
| 7596 |
.4395031012
|
|
|
|
|
| 134.8225879903 |
|
|
|
|
| 7688.4341585784 |
|
|
|
|
|
| 851.8513374504 |
| 7692 |
.2168494089
|
|
|
|
|
| 1015.8743011635 |
| 7822 |
.0618391282
|
|
|
|
|
| 924.356296138 |
| 7904 |
.2936251937
|
|
|
|
|
| 764.5839324212 |
| 7972 |
.3018907032
|
|
|
|
|
| 917.1406009069 |
| 8105 |
.417292176
|
|
|
|
|
| 647.6468244176 |
|
|
|
|
| 8174.8391784214 |
|
|
|
|
|
| 206.6453096591 |
| 8204 |
.3205994819
|
|
|
|
|
| 278.7477843631 |
|
|
|
|
| 8237.8478361811 |
|
|
|
|
|
| 48.295935834 |
| 8249 |
.3276698127
|
|
|
|
|
|
| 594.878242008 |
|
|
|
|
| 8303.942664325 |
|
|
|
|
|
| 680.7503719864 |
| 8328 |
.4456772697
|
|
|
|
|
| 898.709187836 |
|
|
|
|
| 8382.2143021092 |
|
|
|
|
|
| 958.2511684014 |
|
|
|
|
| 8466.6998122226 |
|
|
|
|
|
| 450.5696925698 |
|
|
|
|
| 8578.8035799992 |
|
|
|
|
|
| 670.2412285641 |
| 8601 |
.0660961888
|
|
|
|
|
| 666.9245543096 |
|
|
|
|
| 8657.8271850026 |
|
|
|
|
|
| 171.6024125265 |
|
|
|
|
| 8696.7559833849 |
|
|
|
|
|
| 581.4444768178 |
|
|
|
|
| 8921.5218567564 |
|
|
|
|
|
| 259.3318537021 |
| 9021 |
.0164310181
|
|
|
|
|
| 402.0587254044 |
| 9195 |
.0795951441
|
| 100 |
0.6729727959
| 9378 |
.1404699585
|
|
|
|
|
|
| 566.7976536033 |
|
|
|
|
|
| 9504.7818270498 |
|
|
|
|
|
|
| 827.5632244434 |
| 9549 |
.4868167864
|
|
|
|
|
| 835.0236504696 |
|
|
|
|
| 9598.9767485102 |
|
|
|
|
|
| 613.291159948 |
| 9715 |
.2700007066
|
|
|
|
|
| 536.2618534938 |
| 9841 |
.2295754339
|
|
|
|
|
| 824.4756791813 |
| 9915 |
.4543112251
|
|
|
|
|
|
| 336.8576784372 |
|
|
|
|
| 10013.8111744499 |
|
|
|
|
|
| 807.8507674011 |
| 10051 |
.2553898009
|
|
|
|
|
| 1003.7298818404 |
|
|
|
|
| 10157.8136696377 |
|
|
|
|
|
| 508.1698277468 |
| 10299 |
.0292603392
|
|
|
|
|
| 287.8049257787 |
|
|
|
|
| 10331.5784748428 |
|
|
|
|
|
| 440.4744097264 |
|
|
|
|
| 10338.8006490912 |
|
|
|
|
|
| 979.8520025153 |
10340.533346
| 2744 |
|
|
|
|
|
| 250.0846509055 |
| 10458 |
.2660169081
|
|
|
|
|
| 692.7631083142 |
| 10494 |
.443301691
|
|
|
|
|
| 565.4318597359 |
(blank) |
Grand Total
54720.7023033922 |
Ex2
|
|
|
|
|
|
| Group Segment |
|
|
|
|
|
| Revenue |
Expenses
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Medium |
8249 594.878242008
Medium
6558 |
83.3393859721
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Small |
6180 551.2667803915
Medium 9915 336.8576784372
Small
4048 |
481.0083008923
Small 4797 962.3550943443
Small
6538 |
931.9697247837
Medium 3151 848.2135170178
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Big |
9505 |
827.5632244434
Medium 9378 566.7976536033
Big 6772 436.8799836118
Small
1855 |
930.5482506081
Big
8304 |
680.7503719864
Small 6741 418.0317384718
Small 4151 336.4056384211
Small 7972 917.1406009069
Big
10332 |
440.4744097264
Small 3695 217.656286454
Small 7904 764.5839324212
Medium 849
|
|
|
| 94.5170366431 |
Big
7158 |
915.9245386615
Medium 3713 432.5485875
Small 7596 134.8225879903
Small
2199 |
1037.2944248302
Big
4724 |
463.2899115583
Medium 1331 959.230732332
Medium 2744
|
|
| 222.9192618727 |
Big 5038 306.9576869105
Small 10458 692.7631083142
Small 7567 720.319063955
Big 7688 851.8513374504
Small 4023 166.4942195963
Medium
4552 |
701.0456588856
Medium 2665 654.9796658203
Small 6589 278.188383772
Medium 5220 589.1737959411
Medium 7282 387.5496207223
Small 6445 258.5026825916
Small 10299 287.8049257787
Small 9841 824.4756791813
Small
8238 |
48.295935834
Medium 6221 414.8820747116
Medium 5401 877.9679090344
Small
10014 |
807.8507674011
Big
8467 |
450.5696925698
Small 8382 958.2511684014
Small 8105 647.6468244176
Small 10051 1003.7298818404
Small 3667 680.7146779199
Small 7822 924.356296138
Small 4576 657.6493200788
Small 3178 756.2079622278
Small 1734
|
|
|
| 864.1463818564 |
Medium 8601 666.9245543096
Medium 8328 898.709187836
Medium 9715 536.2618534938
Medium 4723 837.7133331881
Medium
3435 |
574.1248994173
Small 8697 581.4444768178
Medium 9195
|
|
|
| 1000.6729727959 |
Big
4169 |
650.9037445718
Big 885
|
|
|
|
| 323.976885302 |
Medium 3222 760.2840912571
Small 3185 455.4647279589
Small
5051 |
618.3260163369
Small 306
|
|
|
| 275.3065373107 |
Small
9599 |
613.291159948
Small
10339 |
979.8520025153
Medium
7351 |
271.9879435914
Small 7506 408.0083325832
Small
1940 |
413.9417923424
Big 7692 1015.8743011635
Big 1060
|
|
|
| 607.3436711671 |
Medium 739
|
|
|
| 431.474943255 |
Small
8175 |
206.6453096591
Small 4369 203.3753446594
Small
1293 |
123.1056275262
Big
2211 |
465.5261878633
Big
4241 |
737.0688535015
Small 5927 501.2388428822
Small 2597
|
|
|
|
| 489.9869776835 |
Small 9549 835.0236504696
Small 3931 191.4213294839
Small
8579 |
670.2412285641
Big 1946 273.5117357051
Medium 9021 402.0587254044
Medium
5576 |
148.3339740683
Big 1193
|
|
|
| 148.1347430675 |
Small
10341 |
250.0846509055
Small
5513 |
542.6187225193
Medium
2556 |
824.1294903511
Small
10158 |
508.1698277468
Medium
8922 |
259.3318537021
Big 10494 565.4318597359
Medium
7008 |
765.6916987833
Medium 4811 193.174936848
Small
8658 |
171.6024125265
Medium 8204 278.7477843631
Small
4247 |
644.5164909708
Exercise 2
There are preset 3 segments that all groups are put into:
Big
Medium
Tiny
Using a pivot table, create a table displaying Revenue for each segment.
Keep pivot table in this tab.
Large $ amounts (over $100 or so) are typically shown with zero decimals.
Create a Pivot Chart to supplement the Pivot Table
Ex3
Group Segment Revenue Expenses
Member Months |
Medium
|
|
|
|
| 8249.3276698127 |
594.878242008 13
Medium 6557.8729832219 83.3393859721 9
Small
|
|
|
|
| 6180.0357471981 |
551.2667803915 51
Medium
|
|
|
|
| 9915.4543112251 |
336.8576784372 97
Small 4047.6691780881 481.0083008923 92
Small
|
|
|
|
| 4797.0875045761 |
962.3550943443 63
Small 6537.8001010167 931.9697247837 43
Medium
|
|
|
|
| 3151.4227753704 |
848.2135170178 64
Big 9504.7818270498 827.5632244434 28
Medium
|
|
|
|
| 9378.1404699585 |
566.7976536033 41
Big
|
|
|
|
| 6772.1330424373 |
436.8799836118 75
Small
|
|
| 1854.6321581898 |
930.5482506081 21
Big 8303.942664325 680.7503719864 13
Small
|
|
|
| 6741.4600639306 |
418.0317384718 96
Small
|
|
|
| 4151.4397576795 |
336.4056384211 20
Small
|
|
|
| 7972.3018907032 |
917.1406009069 43
Big 10331.5784748428 440.4744097264 94
Small
|
|
|
| 3695.1930207613 |
217.656286454 98
Small
|
|
|
| 7904.2936251937 |
764.5839324212 13
Medium
|
|
|
| 849.2599248439 |
94.5170366431 57
Big 7157.6275489008 915.9245386615 20
Medium 3712.5650123251 432.5485875 4
Small
|
|
|
| 7596.4395031012 |
134.8225879903 63
Small 2198.6577925002 1037.2944248302 13
Big
|
|
|
| 4723.9958751125 |
463.2899115583 84
Medium
|
|
|
| 1331.2645180153 |
959.230732332 39
Medium 2743.8026187562 222.9192618727 73
Big
|
|
|
| 5038.3068133744 |
306.9576869105 41
Small
|
|
|
| 10458.2660169081 |
692.7631083142 41
Small
|
|
|
| 7567.0351493276 |
720.319063955 6
Big 7688.4341585784 851.8513374504 100
Small
|
|
|
| 4023.2273803651 |
166.4942195963 38
Medium 4551.6036698894 701.0456588856 17
Medium
|
|
|
| 2665.1140925001 |
654.9796658203 97
Small
|
|
|
| 6589.1246624486 |
278.188383772 24
Medium
|
|
|
| 5220.4269398047 |
589.1737959411 90
Medium
|
|
|
| 7282.1887565894 |
387.5496207223 65
Small 6444.5836306461 258.5026825916 15
Small
|
|
|
| 10299.0292603392 |
287.8049257787 72
Small
|
|
|
| 9841.2295754339 |
824.4756791813 12
Small 8237.8478361811 48.295935834 87
Medium
|
|
|
| 6221.2486222635 |
414.8820747116 92
Medium
|
|
|
| 5401.2418187665 |
877.9679090344 90
Small 10013.8111744499 807.8507674011 60
Big 8466.6998122226 450.5696925698 71
Small 8382.2143021092 958.2511684014 51
Small
|
|
|
| 8105.417292176 |
647.6468244176 88
Small
|
|
|
| 10051.2553898009 |
1003.7298818404 36
Small
|
|
|
| 3667.2011903398 |
680.7146779199 96
Small
|
|
|
| 7822.0618391282 |
924.356296138 14
Small 4575.5271715324 657.6493200788 13
Small
|
|
|
| 3178.1969187318 |
756.2079622278 24
Small
|
|
|
| 1734.4124287934 |
864.1463818564 28
Medium
|
|
|
| 8601.0660961888 |
666.9245543096 24
Medium
|
|
|
| 8328.4456772697 |
898.709187836 88
Medium
|
|
|
| 9715.2700007066 |
536.2618534938 34
Medium 4722.7733516562 837.7133331881 6
Medium 3434.6941177052 574.1248994173 98
Small 8696.7559833849 581.4444768178 41
Medium
|
|
|
| 9195.0795951441 |
1000.6729727959 88
Big 4168.8717148103 650.9037445718 57
Big
|
|
|
| 885.2432428382 |
323.976885302 59
Medium
|
|
|
| 3222.2105426214 |
760.2840912571 32
Small
|
|
|
| 3185.1817433305 |
455.4647279589 99
Small
|
|
|
| 5050.9759276909 |
618.3260163369 27
Small
|
|
|
| 306.0780834123 |
275.3065373107 39
Small 9598.9767485102 613.291159948 90
Small 10338.8006490912 979.8520025153 57
Medium 7350.6122898348 271.9879435914 46
Small
|
|
|
| 7506.4726445372 |
408.0083325832 12
Small 1939.7810982667 413.9417923424 21
Big
|
|
|
| 7692.2168494089 |
1015.8743011635 40
Big
|
|
|
| 1060.4865464279 |
607.3436711671 31
Medium
|
|
|
| 738.5081579279 |
431.474943255 42
Small 8174.8391784214 206.6453096591 6
Small
|
|
|
| 4368.8062371314 |
203.3753446594 27
Small
|
|
|
| 1292.5195029237 |
123.1056275262 64
Big
|
|
|
| 2210.7487570109 |
465.5261878633 86
Big 4240.7446320371 737.0688535015 64
Small 5927.0420304617 501.2388428822 22
Small
|
|
|
| 2597.3536595969 |
489.9869776835 41
Small
|
|
|
| 9549.4868167864 |
835.0236504696 28
Small
|
|
|
| 3931.3343697968 |
191.4213294839 59
Small 8578.8035799992 670.2412285641 13
Big
|
|
|
| 1946.1366556306 |
273.5117357051 47
Medium
|
|
|
| 9021.0164310181 |
402.0587254044 72
Medium
|
|
|
| 5575.6717397643 |
148.3339740683 20
Big
|
|
|
| 1193.0661622927 |
148.1347430675 72
Small
|
|
|
| 10340.5333462744 |
250.0846509055 8
Small 5512.7676568329 542.6187225193 61
Medium
|
|
|
| 2555.9990671807 |
824.1294903511 93
Small 10157.8136696377 508.1698277468 63
Medium 8921.5218567564 259.3318537021 18
Big
|
|
|
| 10494.443301691 |
565.4318597359 81
Medium 7007.7682447152 765.6916987833 92
Medium
|
|
|
| 4811.0377530315 |
193.174936848 23
Small 8657.8271850026 171.6024125265 41
Medium
|
|
|
| 8204.3205994819 |
278.7477843631 97
Small 4246.8831914754 644.5164909708 22
Exercise 3
Make a pivot table showing each segments revenue and expenses. Make sure to use both row headers and column headers. Have “Sum of Member Months” be the left most column.
Create a column adjacent to the pivot table that represents the Revenue and Expenses PMPM’s. PMPM’s are typically represented with dollar signs ($) and to two decimal places.
Keep the table in this tab.
Ex4
|
| Subdivision |
Group Segment Revenue Expenses
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Bigger |
Medium 8249.3276698127 594.878242008
Bigger Medium 6557.8729832219 83.3393859721
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Pretty Small |
Small 6180.0357471981 551.2667803915
Bigger Medium 9915.4543112251 336.8576784372
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Very Small |
Small 4047.6691780881 481.0083008923
Pretty Small Small 4797.0875045761 962.3550943443
Pretty Small Small 6537.8001010167 931.9697247837
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Not as Big |
Medium 3151.4227753704 848.2135170178
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Not Real Big |
Big 9504.7818270498 827.5632244434
Not as Big Medium 9378.1404699585 566.7976536033
Not Real Big Big 6772.1330424373 436.8799836118
Pretty Small Small 1854.6321581898 930.5482506081
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| More than 500 |
Big 8303.942664325 680.7503719864
Pretty Small Small 6741.4600639306 418.0317384718
Very Small Small 4151.4397576795 336.4056384211
Pretty Small Small 7972.3018907032 917.1406009069
Not Real Big Big 10331.5784748428 440.4744097264
Pretty Small Small 3695.1930207613 217.656286454
Pretty Small Small 7904.2936251937 764.5839324212
Bigger Medium 849.2599248439 94.5170366431
More than 500 Big 7157.6275489008 915.9245386615
Bigger Medium 3712.5650123251 432.5485875
Very Small Small 7596.4395031012 134.8225879903
Very Small Small 2198.6577925002 1037.2944248302
Not Real Big Big 4723.9958751125 463.2899115583
Bigger Medium 1331.2645180153 959.230732332
Not as Big Medium 2743.8026187562 222.9192618727
More than 500 Big 5038.3068133744 306.9576869105
Very Small Small 10458.2660169081 692.7631083142
Pretty Small Small 7567.0351493276 720.319063955
More than 500 Big 7688.4341585784 851.8513374504
Pretty Small Small 4023.2273803651 166.4942195963
Not as Big Medium 4551.6036698894 701.0456588856
Not as Big Medium 2665.1140925001 654.9796658203
Very Small Small 6589.1246624486 278.188383772
Not as Big Medium 5220.4269398047 589.1737959411
Not as Big Medium 7282.1887565894 387.5496207223
Pretty Small Small 6444.5836306461 258.5026825916
Very Small Small 10299.0292603392 287.8049257787
Pretty Small Small 9841.2295754339 824.4756791813
Very Small Small 8237.8478361811 48.295935834
Bigger Medium 6221.2486222635 414.8820747116
Bigger Medium 5401.2418187665 877.9679090344
Very Small Small 10013.8111744499 807.8507674011
More than 500 Big 8466.6998122226 450.5696925698
Pretty Small Small 8382.2143021092 958.2511684014
Very Small Small 8105.417292176 647.6468244176
Very Small Small 10051.2553898009 1003.7298818404
Pretty Small Small 3667.2011903398 680.7146779199
Pretty Small Small 7822.0618391282 924.356296138
Very Small Small 4575.5271715324 657.6493200788
Pretty Small Small 3178.1969187318 756.2079622278
Pretty Small Small 1734.4124287934 864.1463818564
Bigger Medium 8601.0660961888 666.9245543096
Bigger Medium 8328.4456772697 898.709187836
Not as Big Medium 9715.2700007066 536.2618534938
Bigger Medium 4722.7733516562 837.7133331881
Not as Big Medium 3434.6941177052 574.1248994173
Very Small Small 8696.7559833849 581.4444768178
Not as Big Medium 9195.0795951441 1000.6729727959
Not Real Big Big 4168.8717148103 650.9037445718
Not Real Big Big 885.2432428382 323.976885302
Bigger Medium 3222.2105426214 760.2840912571
Pretty Small Small 3185.1817433305 455.4647279589
Pretty Small Small 5050.9759276909 618.3260163369
Very Small Small 306.0780834123 275.3065373107
Pretty Small Small 9598.9767485102 613.291159948
Very Small Small 10338.8006490912 979.8520025153
Bigger Medium 7350.6122898348 271.9879435914
Very Small Small 7506.4726445372 408.0083325832
Very Small Small 1939.7810982667 413.9417923424
More than 500 Big 7692.2168494089 1015.8743011635
Not Real Big Big 1060.4865464279 607.3436711671
Bigger Medium 738.5081579279 431.474943255
Very Small Small 8174.8391784214 206.6453096591
Very Small Small 4368.8062371314 203.3753446594
Pretty Small Small 1292.5195029237 123.1056275262
More than 500 Big 2210.7487570109 465.5261878633
Not Real Big Big 4240.7446320371 737.0688535015
Very Small Small 5927.0420304617 501.2388428822
Very Small Small 2597.3536595969 489.9869776835
Very Small Small 9549.4868167864 835.0236504696
Pretty Small Small 3931.3343697968 191.4213294839
Pretty Small Small 8578.8035799992 670.2412285641
More than 500 Big 1946.1366556306 273.5117357051
Not as Big Medium 9021.0164310181 402.0587254044
Not as Big Medium 5575.6717397643 148.3339740683
More than 500 Big 1193.0661622927 148.1347430675
Very Small Small 10340.5333462744 250.0846509055
Very Small Small 5512.7676568329 542.6187225193
Not as Big Medium 2555.9990671807 824.1294903511
Pretty Small Small 10157.8136696377 508.1698277468
Bigger Medium 8921.5218567564 259.3318537021
More than 500 Big 10494.443301691 565.4318597359
Bigger Medium 7007.7682447152 765.6916987833
Not as Big Medium 4811.0377530315 193.174936848
Pretty Small Small 8657.8271850026 171.6024125265
Bigger Medium 8204.3205994819 278.7477843631
Pretty Small Small 4246.8831914754 644.5164909708
Exercise 4
Create a column entitled “
Net Income/Loss |
.” This column will represent Revenue minus Expenses.
Make a pivot table representing Each Segment and Subdivision by Revenue, Expenses, and Net Income. Use row headers and column headers.
Keep pivot table in this tab.
Ex5
Subdivision Group Segment Revenue Expenses
| Service Month |
| Paid Month |
Bigger Medium 8249.3276698127 594.878242008
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Jan-07 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Feb-07 |
Bigger Medium 6557.8729832219 83.3393859721 Feb-07
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Apr-07 |
Pretty Small Small 6180.0357471981 551.2667803915
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Mar-07 |
Apr-07
Bigger Medium 9915.4543112251 336.8576784372 Apr-07
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| May-07 |
Very Small Small 4047.6691780881 481.0083008923 May-07 May-07
Pretty Small Small 4797.0875045761 962.3550943443 Jan-07 Apr-07
Pretty Small Small 6537.8001010167 931.9697247837 Feb-07 Feb-07
Not as Big Medium 3151.4227753704 848.2135170178 Mar-07
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Jun-07 |
Not Real Big Big 9504.7818270498 827.5632244434 Apr-07
| Sep-07 |
Not as Big Medium 9378.1404699585 566.7976536033 May-07 May-07
Not Real Big Big 6772.1330424373 436.8799836118 Jan-07 Jan-07
Pretty Small Small 1854.6321581898 930.5482506081 Feb-07 Feb-07
More than 500 Big 8303.942664325 680.7503719864 Mar-07 Apr-07
Pretty Small Small 6741.4600639306 418.0317384718 Apr-07 Apr-07
Very Small Small 4151.4397576795 336.4056384211 May-07 Jun-07
Pretty Small Small 7972.3018907032 917.1406009069 Jan-07 Jan-07
Not Real Big Big 10331.5784748428 440.4744097264 Feb-07 Feb-07
Pretty Small Small 3695.1930207613 217.656286454 Mar-07 Apr-07
Pretty Small Small 7904.2936251937 764.5839324212 Apr-07 Jun-07
Bigger Medium 849.2599248439 94.5170366431 May-07 May-07
More than 500 Big 7157.6275489008 915.9245386615 Jan-07 Jan-07
Bigger Medium 3712.5650123251 432.5485875 Feb-07 May-07
Very Small Small 7596.4395031012 134.8225879903 Mar-07 May-07
Very Small Small 2198.6577925002 1037.2944248302 Apr-07 Apr-07
Not Real Big Big 4723.9958751125 463.2899115583 May-07 May-07
Bigger Medium 1331.2645180153 959.230732332 Jan-07 Jan-07
Not as Big Medium 2743.8026187562 222.9192618727 Feb-07 Mar-07
More than 500 Big 5038.3068133744 306.9576869105 Mar-07 Mar-07
Very Small Small 10458.2660169081 692.7631083142 Apr-07 Apr-07
Pretty Small Small 7567.0351493276 720.319063955 May-07 May-07
More than 500 Big 7688.4341585784 851.8513374504 Jan-07 Jan-07
Pretty Small Small 4023.2273803651 166.4942195963 Feb-07 Feb-07
Not as Big Medium 4551.6036698894 701.0456588856 Mar-07 Mar-07
Not as Big Medium 2665.1140925001 654.9796658203 Apr-07 Apr-07
Very Small Small 6589.1246624486 278.188383772 May-07 Jun-07
Not as Big Medium 5220.4269398047 589.1737959411 Jan-07
|
|
| Jul-07 |
Not as Big Medium 7282.1887565894 387.5496207223 Feb-07 Feb-07
Pretty Small Small 6444.5836306461 258.5026825916 Mar-07 Apr-07
Very Small Small 10299.0292603392 287.8049257787 Apr-07 May-07
Pretty Small Small 9841.2295754339 824.4756791813 May-07 May-07
Very Small Small 8237.8478361811 48.295935834 Jan-07 Jan-07
Bigger Medium 6221.2486222635 414.8820747116 Feb-07 Apr-07
Bigger Medium 5401.2418187665 877.9679090344 Mar-07 Apr-07
Very Small Small 10013.8111744499 807.8507674011 Apr-07 Jun-07
More than 500 Big 8466.6998122226 450.5696925698 May-07 May-07
Pretty Small Small 8382.2143021092 958.2511684014 Jan-07 May-07
Very Small Small 8105.417292176 647.6468244176 Feb-07 Mar-07
Very Small Small 10051.2553898009 1003.7298818404 Mar-07 Apr-07
Pretty Small Small 3667.2011903398 680.7146779199 Apr-07 Apr-07
Pretty Small Small 7822.0618391282 924.356296138 May-07 May-07
Very Small Small 4575.5271715324 657.6493200788 Jan-07 Feb-07
Pretty Small Small 3178.1969187318 756.2079622278 Feb-07 Feb-07
Pretty Small Small 1734.4124287934 864.1463818564 Mar-07 Mar-07
Bigger Medium 8601.0660961888 666.9245543096 Apr-07 May-07
Bigger Medium 8328.4456772697 898.709187836 May-07 Jun-07
Not as Big Medium 9715.2700007066 536.2618534938 Jan-07 Jan-07
Bigger Medium 4722.7733516562 837.7133331881 Feb-07 Mar-07
Not as Big Medium 3434.6941177052 574.1248994173 Mar-07 Apr-07
Very Small Small 8696.7559833849 581.4444768178 Apr-07 Apr-07
Not as Big Medium 9195.0795951441 1000.6729727959 May-07
|
|
|
|
| Aug-07 |
Not Real Big Big 4168.8717148103 650.9037445718 Jan-07 Feb-07
Not Real Big Big 885.2432428382 323.976885302 Feb-07 Feb-07
Bigger Medium 3222.2105426214 760.2840912571 Mar-07 Apr-07
Pretty Small Small 3185.1817433305 455.4647279589 Apr-07 May-07
Pretty Small Small 5050.9759276909 618.3260163369 May-07 Jun-07
Very Small Small 306.0780834123 275.3065373107 Jan-07 Jan-07
Pretty Small Small 9598.9767485102 613.291159948 Feb-07 Feb-07
Very Small Small 10338.8006490912 979.8520025153 Mar-07 Apr-07
Bigger Medium 7350.6122898348 271.9879435914 Apr-07 Jul-07
Very Small Small 7506.4726445372 408.0083325832 May-07 Aug-07
Very Small Small 1939.7810982667 413.9417923424 Jan-07 Feb-07
More than 500 Big 7692.2168494089 1015.8743011635 Feb-07 Feb-07
Not Real Big Big 1060.4865464279 607.3436711671 Mar-07 Apr-07
Bigger Medium 738.5081579279 431.474943255 Apr-07 May-07
Very Small Small 8174.8391784214 206.6453096591 May-07 May-07
Very Small Small 4368.8062371314 203.3753446594 Jan-07 Feb-07
Pretty Small Small 1292.5195029237 123.1056275262 Feb-07 Jun-07
More than 500 Big 2210.7487570109 465.5261878633 Mar-07 Mar-07
Not Real Big Big 4240.7446320371 737.0688535015 Apr-07 May-07
Very Small Small 5927.0420304617 501.2388428822 May-07 May-07
Very Small Small 2597.3536595969 489.9869776835 Jan-07 Jan-07
Very Small Small 9549.4868167864 835.0236504696 Feb-07 Mar-07
Pretty Small Small 3931.3343697968 191.4213294839 Mar-07 Apr-07
Pretty Small Small 8578.8035799992 670.2412285641 Apr-07 Apr-07
More than 500 Big 1946.1366556306 273.5117357051 May-07 Jun-07
Not as Big Medium 9021.0164310181 402.0587254044 Jan-07 Jan-07
Not as Big Medium 5575.6717397643 148.3339740683 Feb-07 Mar-07
More than 500 Big 1193.0661622927 148.1347430675 Mar-07 Apr-07
Very Small Small 10340.5333462744 250.0846509055 Apr-07 Apr-07
Very Small Small 5512.7676568329 542.6187225193 May-07 May-07
Not as Big Medium 2555.9990671807 824.1294903511 Jan-07 Jan-07
Pretty Small Small 10157.8136696377 508.1698277468 Feb-07 Mar-07
Bigger Medium 8921.5218567564 259.3318537021 Mar-07 Apr-07
More than 500 Big 10494.443301691 565.4318597359 Apr-07 May-07
Bigger Medium 7007.7682447152 765.6916987833 May-07 Aug-07
Not as Big Medium 4811.0377530315 193.174936848 Jan-07 Apr-07
Pretty Small Small 8657.8271850026 171.6024125265 Feb-07 Mar-07
Bigger Medium 8204.3205994819 278.7477843631 Mar-07 Jun-07
Pretty Small Small 4246.8831914754 644.5164909708 Apr-07 Jun-07
Exercise 5
Make a pivot table of Expenses by Service Month and Paid Month for just the “Big” group segment.
Keep pivot table in this tab.
The result is referred to as a Claims Lag Triangle.
Ex6
Subdivision Group Segment Revenue Expenses Service Month Paid Month
Bigger Medium 8249.3276698127 594.878242008 Jan-07 Feb-07
Bigger Medium 6557.8729832219 83.3393859721 Feb-07 Apr-07
Pretty Small Small 6180.0357471981 551.2667803915 Mar-07 Apr-07
Bigger Medium 9915.4543112251 336.8576784372 Apr-07 May-07
Very Small Small 4047.6691780881 481.0083008923 May-07 May-07
Pretty Small Small 4797.0875045761 962.3550943443 Jan-07 Apr-07
Pretty Small Small 6537.8001010167 931.9697247837 Feb-07 Feb-07
Not as Big Medium 3151.4227753704 848.2135170178 Mar-07 Jun-07
Not Real Big Big 9504.7818270498 827.5632244434 Apr-07 Sep-07
Not as Big Medium 9378.1404699585 566.7976536033 May-07 May-07
Not Real Big Big 6772.1330424373 436.8799836118 Jan-07 Jan-07
Pretty Small Small 1854.6321581898 930.5482506081 Feb-07 Feb-07
More than 500 Big 8303.942664325 680.7503719864 Mar-07 Apr-07
Pretty Small Small 6741.4600639306 418.0317384718 Apr-07 Apr-07
Very Small Small 4151.4397576795 336.4056384211 May-07 Jun-07
Pretty Small Small 7972.3018907032 917.1406009069 Jan-07 Jan-07
Not Real Big Big 10331.5784748428 440.4744097264 Feb-07 Feb-07
Pretty Small Small 3695.1930207613 217.656286454 Mar-07 Apr-07
Pretty Small Small 7904.2936251937 764.5839324212 Apr-07 Jun-07
Bigger Medium 849.2599248439 94.5170366431 May-07 May-07
More than 500 Big 7157.6275489008 915.9245386615 Jan-07 Jan-07
Bigger Medium 3712.5650123251 432.5485875 Feb-07 May-07
Very Small Small 7596.4395031012 134.8225879903 Mar-07 May-07
Very Small Small 2198.6577925002 1037.2944248302 Apr-07 Apr-07
Not Real Big Big 4723.9958751125 463.2899115583 May-07 May-07
Bigger Medium 1331.2645180153 959.230732332 Jan-07 Jan-07
Not as Big Medium 2743.8026187562 222.9192618727 Feb-07 Mar-07
More than 500 Big 5038.3068133744 306.9576869105 Mar-07 Mar-07
Very Small Small 10458.2660169081 692.7631083142 Apr-07 Apr-07
Pretty Small Small 7567.0351493276 720.319063955 May-07 May-07
More than 500 Big 7688.4341585784 851.8513374504 Jan-07 Jan-07
Pretty Small Small 4023.2273803651 166.4942195963 Feb-07 Feb-07
Not as Big Medium 4551.6036698894 701.0456588856 Mar-07 Mar-07
Not as Big Medium 2665.1140925001 654.9796658203 Apr-07 Apr-07
Very Small Small 6589.1246624486 278.188383772 May-07 Jun-07
Not as Big Medium 5220.4269398047 589.1737959411 Jan-07 Jul-07
Not as Big Medium 7282.1887565894 387.5496207223 Feb-07 Feb-07
Pretty Small Small 6444.5836306461 258.5026825916 Mar-07 Apr-07
Very Small Small 10299.0292603392 287.8049257787 Apr-07 May-07
Pretty Small Small 9841.2295754339 824.4756791813 May-07 May-07
Very Small Small 8237.8478361811 48.295935834 Jan-07 Jan-07
Bigger Medium 6221.2486222635 414.8820747116 Feb-07 Apr-07
Bigger Medium 5401.2418187665 877.9679090344 Mar-07 Apr-07
Very Small Small 10013.8111744499 807.8507674011 Apr-07 Jun-07
More than 500 Big 8466.6998122226 450.5696925698 May-07 May-07
Pretty Small Small 8382.2143021092 958.2511684014 Jan-07 May-07
Very Small Small 8105.417292176 647.6468244176 Feb-07 Mar-07
Very Small Small 10051.2553898009 1003.7298818404 Mar-07 Apr-07
Pretty Small Small 3667.2011903398 680.7146779199 Apr-07 Apr-07
Pretty Small Small 7822.0618391282 924.356296138 May-07 May-07
Very Small Small 4575.5271715324 657.6493200788 Jan-07 Feb-07
Pretty Small Small 3178.1969187318 756.2079622278 Feb-07 Feb-07
Pretty Small Small 1734.4124287934 864.1463818564 Mar-07 Mar-07
Bigger Medium 8601.0660961888 666.9245543096 Apr-07 May-07
Bigger Medium 8328.4456772697 898.709187836 May-07 Jun-07
Not as Big Medium 9715.2700007066 536.2618534938 Jan-07 Jan-07
Bigger Medium 4722.7733516562 837.7133331881 Feb-07 Mar-07
Not as Big Medium 3434.6941177052 574.1248994173 Mar-07 Apr-07
Very Small Small 8696.7559833849 581.4444768178 Apr-07 Apr-07
Not as Big Medium 9195.0795951441 1000.6729727959 May-07 Aug-07
Not Real Big Big 4168.8717148103 650.9037445718 Jan-07 Feb-07
Not Real Big Big 885.2432428382 323.976885302 Feb-07 Feb-07
Bigger Medium 3222.2105426214 760.2840912571 Mar-07 Apr-07
Pretty Small Small 3185.1817433305 455.4647279589 Apr-07 May-07
Pretty Small Small 5050.9759276909 618.3260163369 May-07 Jun-07
Very Small Small 306.0780834123 275.3065373107 Jan-07 Jan-07
Pretty Small Small 9598.9767485102 613.291159948 Feb-07 Feb-07
Very Small Small 10338.8006490912 979.8520025153 Mar-07 Apr-07
Bigger Medium 7350.6122898348 271.9879435914 Apr-07 Jul-07
Very Small Small 7506.4726445372 408.0083325832 May-07 Aug-07
Very Small Small 1939.7810982667 413.9417923424 Jan-07 Feb-07
More than 500 Big 7692.2168494089 1015.8743011635 Feb-07 Feb-07
Not Real Big Big 1060.4865464279 607.3436711671 Mar-07 Apr-07
Bigger Medium 738.5081579279 431.474943255 Apr-07 May-07
Very Small Small 8174.8391784214 206.6453096591 May-07 May-07
Very Small Small 4368.8062371314 203.3753446594 Jan-07 Feb-07
Pretty Small Small 1292.5195029237 123.1056275262 Feb-07 Jun-07
More than 500 Big 2210.7487570109 465.5261878633 Mar-07 Mar-07
Not Real Big Big 4240.7446320371 737.0688535015 Apr-07 May-07
Very Small Small 5927.0420304617 501.2388428822 May-07 May-07
Very Small Small 2597.3536595969 489.9869776835 Jan-07 Jan-07
Very Small Small 9549.4868167864 835.0236504696 Feb-07 Mar-07
Pretty Small Small 3931.3343697968 191.4213294839 Mar-07 Apr-07
Pretty Small Small 8578.8035799992 670.2412285641 Apr-07 Apr-07
More than 500 Big 1946.1366556306 273.5117357051 May-07 Jun-07
Not as Big Medium 9021.0164310181 402.0587254044 Jan-07 Jan-07
Not as Big Medium 5575.6717397643 148.3339740683 Feb-07 Mar-07
More than 500 Big 1193.0661622927 148.1347430675 Mar-07 Apr-07
Very Small Small 10340.5333462744 250.0846509055 Apr-07 Apr-07
Very Small Small 5512.7676568329 542.6187225193 May-07 May-07
Not as Big Medium 2555.9990671807 824.1294903511 Jan-07 Jan-07
Pretty Small Small 10157.8136696377 508.1698277468 Feb-07 Mar-07
Bigger Medium 8921.5218567564 259.3318537021 Mar-07 Apr-07
More than 500 Big 10494.443301691 565.4318597359 Apr-07 May-07
Bigger Medium 7007.7682447152 765.6916987833 May-07 Aug-07
Not as Big Medium 4811.0377530315 193.174936848 Jan-07 Apr-07
Pretty Small Small 8657.8271850026 171.6024125265 Feb-07 Mar-07
Bigger Medium 8204.3205994819 278.7477843631 Mar-07 Jun-07
Pretty Small Small 4246.8831914754 644.5164909708 Apr-07 Jun-07
Exercise 6
Make a pivot table for the Group Segment “Big” and show Revenue and Expense by Subdivision.
Create a second Pivot Table. Copy and paste the entire pivot table and change the Segment to “Medium.”
Change the order of each of the rows. Meaning if it was the top row label, switch it with the bottom row label.
Now, switch the Revenue column with the Expenses column.
Keep both pivot tables in this tab.
To go to Exercise 7, unhide the tab entitled “
Ex7
.”
Ex7
Group Name Group Segment Revenue Expenses Net Income/Loss
Data |
Postcards Store Big 8249.3276698127 594.878242008
7654.4494278048 |
Group Segment
Sum of Expenses |
Sum of Revenue |
Randles Roadshack Small 6557.8729832219 83.3393859721
6474.5335972499 |
Big
41586390.9696846 |
48945091.5423439 |
Examineers Inc Medium 6180.0357471981 551.2667803915
5628.7689668066 |
Medium
2310.7997296187 |
22222.6176752647 |
Buttersworth Co Small 9915.4543112251 336.8576784372
9578.5966327879 |
Small
2186.2988659312 |
30444.5522903428 |
FASST Trax Small 4047.6691780881 481.0083008923
3566.6608771959 |
Grand Total
41590888.0682801 |
48997758.7123095 |
Hula Hoopers Big 4797.0875045761 962.3550943443
3834.7324102318 |
Hehehe Medium 6537.8001010167 931.9697247837
5605.830376233 |
Marleyville Tea Small 3151.4227753704 848.2135170178
2303.2092583526 |
Creepy Lada Medium 9504.7818270498 827.5632244434
8677.2186026064 |
Jokes R Us Big 9378.1404699585 566.7976536033
8811.3428163552 |
Petie’s Palace Small 6772.1330424373 436.8799836118
6335.2530588255 |
Ramone’s Castle |
Big
48922666.9867 |
41584266.9386946 |
7338400.04800493 |
Exercise 7
Because Ramone’s Castle is a high outlier, take it out of the pivot table that is already done.
Show Revenue and Expenses by Group Segment (excluding Ramone’s Castle).
Have “Sum of Revenue” be the left column (you may need to switch the two columns).
Keep pivot table in this tab.
Ex8
Group Segment Revenue Expenses
Medium 8249.3276698127 594.878242008
Medium 6557.8729832219 83.3393859721
Small 6180.0357471981 551.2667803915
Medium 9915.4543112251 336.8576784372
Small 4047.6691780881 481.0083008923
Small 4797.0875045761 962.3550943443
Small 6537.8001010167 931.9697247837
Medium 3151.4227753704 848.2135170178
Big 9504.7818270498 827.5632244434
Medium 9378.1404699585 566.7976536033
Big 6772.1330424373 436.8799836118
Small 1854.6321581898 930.5482506081
Big 8303.942664325 680.7503719864
Small 6741.4600639306 418.0317384718
Small 4151.4397576795 336.4056384211
Small 7972.3018907032 917.1406009069
Big 10331.5784748428 440.4744097264
Small 3695.1930207613 217.656286454
Small 7904.2936251937 764.5839324212
Medium 849.2599248439 94.5170366431
Big 7157.6275489008 915.9245386615
Medium 3712.5650123251 432.5485875
Small 7596.4395031012 134.8225879903
Small 2198.6577925002 1037.2944248302
Big 4723.9958751125 463.2899115583
Medium 1331.2645180153 959.230732332
Medium 2743.8026187562 222.9192618727
Big 5038.3068133744 306.9576869105
Small 10458.2660169081 692.7631083142
Small 7567.0351493276 720.319063955
Big 7688.4341585784 851.8513374504
Small 4023.2273803651 166.4942195963
Medium 4551.6036698894 701.0456588856
Medium 2665.1140925001 654.9796658203
Small 6589.1246624486 278.188383772
Medium 5220.4269398047 589.1737959411
Medium 7282.1887565894 387.5496207223
Small 6444.5836306461 258.5026825916
Small 10299.0292603392 287.8049257787
Small 9841.2295754339 824.4756791813
Small 8237.8478361811 48.295935834
Medium 6221.2486222635 414.8820747116
Medium 5401.2418187665 877.9679090344
Small 10013.8111744499 807.8507674011
Big 8466.6998122226 450.5696925698
Small 8382.2143021092 958.2511684014
Small 8105.417292176 647.6468244176
Small 10051.2553898009 1003.7298818404
Small 3667.2011903398 680.7146779199
Small 7822.0618391282 924.356296138
Small 4575.5271715324 657.6493200788
Small 3178.1969187318 756.2079622278
Small 1734.4124287934 864.1463818564
Medium 8601.0660961888 666.9245543096
Medium 8328.4456772697 898.709187836
Medium 9715.2700007066 536.2618534938
Medium 4722.7733516562 837.7133331881
Medium 3434.6941177052 574.1248994173
Small 8696.7559833849 581.4444768178
Medium 9195.0795951441 1000.6729727959
Big 4168.8717148103 650.9037445718
Big 885.2432428382 323.976885302
Medium 3222.2105426214 760.2840912571
Small 3185.1817433305 455.4647279589
Small 5050.9759276909 618.3260163369
Small 306.0780834123 275.3065373107
Small 9598.9767485102 613.291159948
Small 10338.8006490912 979.8520025153
Medium 7350.6122898348 271.9879435914
Small 7506.4726445372 408.0083325832
Small 1939.7810982667 413.9417923424
Big 7692.2168494089 1015.8743011635
Big 1060.4865464279 607.3436711671
Medium 738.5081579279 431.474943255
Small 8174.8391784214 206.6453096591
Small 4368.8062371314 203.3753446594
Small 1292.5195029237 123.1056275262
Big 2210.7487570109 465.5261878633
Big 4240.7446320371 737.0688535015
Small 5927.0420304617 501.2388428822
Small 2597.3536595969 489.9869776835
Small 9549.4868167864 835.0236504696
Small 3931.3343697968 191.4213294839
Small 8578.8035799992 670.2412285641
Big 1946.1366556306 273.5117357051
Medium 9021.0164310181 402.0587254044
Medium 5575.6717397643 148.3339740683
Big 1193.0661622927 148.1347430675
Small 10340.5333462744 250.0846509055
Small 5512.7676568329 542.6187225193
Medium 2555.9990671807 824.1294903511
Small 10157.8136696377 508.1698277468
Medium 8921.5218567564 259.3318537021
Big 10494.443301691 565.4318597359
Medium 7007.7682447152 765.6916987833
Medium 4811.0377530315 193.174936848
Small 8657.8271850026 171.6024125265
Medium 8204.3205994819 278.7477843631
Small 4246.8831914754 644.5164909708
Exercise 8
SUMIF Function
Using SUMIF, create the same table as Exercise 2 (Show Revenue By Group Segment).
Note
Submitted by Emily Tipton on April 19, 2008 |
Questions? Email emily.tipton@yahoo.com |
Turn in your highest-quality paper
Get a qualified writer to help you with
“ Pivot Table assignment ”
Get high-quality paper
NEW! AI matching with writer