Squared error (SE) is the difference between a predicted value and actual value squared, i.e., (p- a)?. In Excel, predicted values have been entered in A1:A20. The corresponding actual values have...

Extracted text: Squared error (SE) is the difference between a predicted value and actual value squared, i.e., (p- a)?. In Excel, predicted values have been entered in A1:A20. The corresponding actual values have been entered in B1:B20. I want the SE shown in cells C1:C20 using a single multicell dynamic array formula in cell C1. Which of the following formulas for cell C1 accomplishes this? Select one: O a. =A1-B1^2, copied to cells C1 through C20 O b. = (A1:A20 – B1:B20)^2 O c. =(Sum(A1:A20)-Sum(B1:B20))^2 O d. = (A1 – B1: A20 – B20)^2