how to calculate variance and range

[Tele]

Hello,
I am having trouble using the formula to calculate variance and range.
Please help me out.

 

[Fred Smith]

Post the formula. Excel we're good at. Mindreading not so much.

Regards,
Fred