Using the posted spreadsheet, how exactly would you measure a surprise in nonfarm payrolls?Please state your answer by copying and pasting the corresponding Excel formula with cell references below.
J26 X B C D E F G H J K FactSet Economic Calendar January 01, 2015 - May 10, 2019 *0=Very Low, 1=Low, 2=Medium, 3=High Date Time (GMT -05:00) Country Event Importance* Period Consensus surprise 03-Jun-2016 08:30 AM Nonfarm Payrolls SA MAY 38.OK 123.0KR 08-Jul-2016 08:30 AM US Nonfarm Payrolls SA JUN 287.OK 180.0K 11.OK R 05-Aug-2016 08:30 AM US Nonfarm Payrolls SA JUL 255.OK 175.OK 292.OK R 02-Sep-2016 08:30 AM US Nonfarm Payrolls SA w w w w w w w w w w w w w w w w w w w w ww ww ww ww ww ww ww ww ww w w w w w ww AUG 151.OK 182.5K 275.OK R 07-Oct-2016 8:30 AM US Nonfarm Payrolls SA SEP 156.OK 175.0K 167.OK R 04-Nov-2016 08:30 AM US Nonfarm Payrolls SA OCT 161.OK 174.0K 191.OK R 02-Dec-2016 08:30 AM US Nonfarm Payrolls SA NOV 178.OK 173.5K 142.OK R 06-Jan-2017 08:30 AM US Nonfarm Payrolls SA DEC 156.OK 175.OK 204.OK R 03-Feb-2017 08:30 AM US Nonfarm Payrolls SA JAN 227.OK 157.OK R 10-Mar-2017 08:30 AM US Nonfarm Payrolls SA FEE 235.OK 238.0K R 07-Apr-2017 08:30 AM US Nonfarm Payrolls SA MAR 98 OK 180.0 219.0K R 05-May-2017 08:30 AM US Nonfarm Payrolls SA APR 211.OK 185.OK 79.0K R 02-Jun-2017 08:30 AM US Nonfarm Payrolls SA MAY 138.OK 180.OK 174.OK R 07-Jul-2017 8:30 AM US Nonfarm Payrolls SA JUN 222.OK 177.0K 152.0K R 04-Aug-2017 08:30 AM US Nonfarm Payrolls SA JUL 209.OK 180.OK 231.OK R 01-Sep-2017 08:30 AM US Nonfarm Payrolls SA AUG 156.OK 180.OK 189.0K R 06-Oct-2017 08:30 AM US Nonfarm Payrolls SA SEP 85.OK 169.0K R 03-Nov-2017 08:30 AM US Nonfarm Payrolls SA OCT 261.OK 310.OK 18.0K R 08-Dec-2017 08:30 AM US Nonfarm Payrolls SA NOV 228.OK 192.5K 244.0K R 05-Jan-2018 08:30 AM US Nonfarm Payrolls SA DEC 148.OK 252.OK R 02-Feb-2018 08:30 AM US Nonfarm Payrolls SA JAN 175.OK 160.0K R 09-Mar-2018 08:30 AM US Nonfarm Payrolls SA FEB 313.OK 200.OK 239.0K R 06-Apr-2018 08:30 AM US Nonfarm Payrolls SA MAR 103.OK 185.OK 326.0K R 04-May-2018 08:30 AM US Nonfarm Payrolls SA APR 164.OK 191.OK 135.0K R 01-Jun-2018 8:30 AM US Nonfarm Payrolls SA MAY 223.OK 190.OK 159.0KR 06-Jul-201 08:30 AM US Nonfarm Payrolls SA JUN 213.OK 244.0K R 03-Aug-2018 08:30 AM US Nonfarm Payrolls SA JUL 157.OK 248.OK R 07-Sep-2018 08:30 AM US Nonfarm Payrolls SA AUG 201.OK 189.OK 147.OK R 05-Oct-2018 08:30 AM US Nonfarm Payrolls SA SEP 134.OK 270.OK R 02-Nov-2018 08:30 AM US Nonfarm Payrolls SA OCT 250.OK 193.0K 118.0KR 07-Dec-2018 08:30 AM US Nonfarm Payrolls SA NOV 155.OK 195.OK 237.OK R 04-Jan-2019 08:30 AM US Nonfarm Payrolls SA DEC 312.OK 180.OK 176.OK R 01-Feb-2019 08:30 AM US Nonfarm Payrolls SA JAN 304.OK 165.OK 222.OK R 08-Mar-2019 08:30 AM US Nonfarm Payrolls SA FEB 180.OK 311.OK R 05-Apr-2019 08:30 AM US Nonfarm Payrolls SA MAR 196.OK 175.0K 33.0K R 03-May-2019 08:30 AM US Nonfarm Payrolls SA APR 263.OK 181.OK 189.0K R
