Solving and Analyzing Dataset B for Earnings and Net Earnings

PROJECT PART 1 AND
PART 2
PART 2: DATASET B

TABLE OF CONTENTS
 DATASET
 SOLVING GIVEN DATASET
 FORMULA TAB FUNCTIONS
 CHART SHOWING EARNINGS VS NET EARNINGS
 REFERENCES

DATASET: A
Date
Player Counts Tax 45%
Player Income (£) Rank High/Low Income Tax Net Income
Lionel Messi 111000 1
Gareth Bale 34600 1
Paul Pogba 29500 2
Oscar 27500 2
Cristiano Ronaldo 108000 1
Neymar 90000 1
Total Net Earnings Total Net Earnings of Position 2
Average Net Earnings
Average Net Earnings of
Position 1
Highest Net Earnings Count of Net Earnings >£50000
Lowest Net Earnings Count of Net Earnings <£50000