Spreadsheet
Spreadsheet
Spreadsheet
Camp
Activity Fee
Aerobics 45
Football 50
volleyball 53
Swimming 50
CAMP INFORMATION
Camper Total Updated
Id Activity Number Activity Tours Camp Camp
Number Lastname Firstname Selected of Tours Fee Fees Fees Discount Fees
CK456 kidd claudia football 3 50 $60 $160 $8.00 $152
CG6444 Garner calvin swimming 1 50 $20 $120 $0.00 $112
ML678 little marquis volleyball 1 53 $20 $123 $0.00 $115
TR123 Roth talia arobics 2 45 $40 $135 $6.75 $127
TP098 padmore tiara volleyball 3 53 $60 $163 $8.15 $155
UM583 malone uriel swimming 2 50 $40 $140 $7.00 $132
RR067 raymond rosario volleyball 2 53 $40 $143 $7.15 $135
DS508 skye dennis volleyball 2 53 $40 $143 $7.15 $135
PM345 mosley pierce swimming 2 50 $40 $140 $7.00 $132
Camp
Activity Fee
Aerobics 45
Football 50
volleyball 53
Swimming 50
Camp Activity Fee
Aerobics 45
Football 50
volleyball 53
Swimming 60
Data
Activity SelectedCount of Lastname Count of Total Camp Fees
arobics 2 2
football 8 8
swimming 5 5
volleyball 9 9
(empty)
Total Result 24 24
NUMBER OF FEES PAID
Activity Selected
8%
arobics
football
38% swimming
volleyball
33% (empty)
21%
Activity Selected
arobics
football
swimming
volleyball
(empty)
CAMP INFORMA
Camper Id Number Lastname Firstname Activity Selected
CG6444 Garner calvin swimming
DC342 cannon dennis football
ML098 little marquis football
ML678 little marquis volleyball
EA600 armstorng elieja volleyball
CG999 grayhound charlie volleyball
TR123 Roth talia arobics
UM583 malone uriel swimming
PM345 mosley pierce swimming
LW109 weaver lexie football
JY701 yang joaquin swimming
BR450 benzema roesi football
RR067 raymond rosario volleyball
DS508 skye dennis volleyball
KW801 weaver krystal volleyball
MM661 morton makima volleyball
AF667 franco aiden arobics
Number of Tours Activity Fee Tours Fees Total Camp Fees Discount
>=2
Number of Tours Activity Fee Tours Fees Total Camp Fees Discount
2 45 $40 $135 $6.75
3 45 $60 $155 $7.75
$160
$160
$160
$160
$160
$163
$163