Administration and Executive AssistantTier 725 minadvanced

MAP: Sum of Squares

Calculate the sum of a list's squared values, not the square of its total.

What you will learn

• Use MAP with LAMBDA to apply a calculation to every value in a list
• Explain why summing squared values is different from squaring a sum
• Recognise that squaring a sum always overstates the true sum of squares once there is more than one value

Excel skills

MAP, LAMBDA · Array Formulas

The task

Eight readings are listed. Work out the sum of their squares in Summary!B3 - each reading squared individually, then those squares added up.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free