Need an Excel Expert -- 2
Budget: $250 – $750 AUD
I need formulas done to analyze Rainfall data over a 50 year period. I have a series of questions that need formulas done on the data to help answer my question with a number.
Questions will be along the lines of:
- if less than 20mm falls in may how often will more that 50mm fall in June on that same year.
- If less than 20mm falls in May how often will less than 50mm fall in June on that Same year
- if 50mm falls in May how often does greater than 50mm in either July or august and more than 20mm in the month that doesn't reach greater than 50mm in that same year.
- if less than 50mm had falled in both April and May (also how often this this happen) and how often does more than 50mm fall in both february and march that same year.
Many other questions similar to this. Will be roughly 20 to 30 questions. similar to the above.
Questions will be along the lines of:
- if less than 20mm falls in may how often will more that 50mm fall in June on that same year.
- If less than 20mm falls in May how often will less than 50mm fall in June on that Same year
- if 50mm falls in May how often does greater than 50mm in either July or august and more than 20mm in the month that doesn't reach greater than 50mm in that same year.
- if less than 50mm had falled in both April and May (also how often this this happen) and how often does more than 50mm fall in both february and march that same year.
Many other questions similar to this. Will be roughly 20 to 30 questions. similar to the above.