search

CodeYourFuture / CYF-Staff-Tickets

📢 CYF Staff tickets
0 stars 0 forks source link

Average Salary on Global data #418

Closed Barny-6 closed 7 months ago

Barny-6 commented 10 months ago

Create an automatic calculation for the average UK and SA salaries of CYF grads in employment

gbencci commented 9 months ago

Hi @Barny-6 I have done this. Please check that it's what you need. It's on row B50

Barny-6 commented 9 months ago

That's perfect, thanks G! Does the total average include Cape Town? It's lower than I thought?

gbencci commented 9 months ago

Cape Town has only 4 salaries in their list, so that's all you get. I had to do some extra maneuvering for them as it's another currency. You can check if average is correct manually

Barny-6 commented 9 months ago

I think there's still some work to do on this.

Working on it manually, I split the UK / SA salaries as they aren't comparable (cost of living etc.). With the known UK salaries only I got these results:

Glasgow | £28,114 London | £33,978 North West | £31,730 West Midlands | £30,289 Total | £31,939 ZA | R260,000.00 | £10,938.98

It appears there are some discrepancies with West Mids and Glasgow so worth looking in to again. Let me know if you have any questions

gbencci commented 8 months ago

hi @Barny-6 the problem with ZA was because the currency was written manually there, so it's not corrected. It's only three salaries. For Glasgow, there were two question marks. It's done