I need to know how to do diff sq

AutoSave Off be A15 - Normal Dist- v2 - Excel Search Fabiola Alfaro Vargas FA File Home Insert Page Layout Formulas Data Review View Help Share Comments Insert ab Calibri == 11 A A a Wrap Text General AY O DX Delete Paste . ara- E. Merge & Center $ % -28 Format Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Editing FO Analyze Sensitivity Data Analysis Sensitivity Clipboard Font Alignment Number Cells H258 X f A B D E F G H | J K L M N o P Q R S T 98 4 99 100 101 102 103 104 105 Calculate the Variance Expected Value = from previous problem above Diff from the EV = Test Score - EV Diff Sq = square the difference between the test score and the EV Probability calculation from above Diff2*P = Multiply the two values to the left Variance = sum of Diff squared*p Test #of Expected Diff from the Score Students Value EV Diff sq Probability Diff2*p 1 15 3.0 -2.0 15% 1 2 22 3.0 -1.0 22% 1 3 26 3.0 0.0 0.0 26% 0 1 4 22 3.0 1.0 1.0 22% 0.22 1 5 15 3.0 2.0 15% 1 106 107 108 1 0 3 1 1 1 0 0 3 1 1 1 109 110 1 1 1 1 1 1 1 0 5 5 3 111 0 Variance = 0 0 112 113 114 115 116 5 0 0 117 Calculate the Standard Deviation Sn-cart of the varianca 1a Ready + 100% Type here to search O a) ENG 12:34 PM 3/27/2021