Instruction: Provide an example of how array formulas can be used to perform complex calculations across multiple data ranges.
Context: This question tests the candidate's understanding of array formulas and their ability to use them for advanced data analysis.