In Canada, the House of Commons is the popularly elected component of Parliament. There are currently 338 members of the House. You are interested in creating some interesting summary statistics on these members. The data for 24 members are shown below: 1 First Name Last Name Constituency Province / Territory Political Affiliation Population (2016) Ziad Aboultaif Alberta W I Edmonton Manning Conservative 21,048 Scott Aitchison Parry Sound-Muskoka Ontario Conservative 94,400 4 Dan Albas Central Okanagan-Similkameen-Nicola British Columbia Conservative 110,293 5 Alghabra Mississauga Centre Ontario Liberal 124,849 Oma 6 Leona Alleslev Aurora-Oak Ridges-Richmond Hill Ontario Conservative 115,227 7 Dean Allisor Niagara West Ontario Conservative 90,838 8 William Amos Pontiac Quebec Libera 115,531 9 Anita Anand Oakville Ontario Libera 119,649 10 Gary Anandasangaree Scarborough-Rouge Park Ontario Liberal 102,275 11 Charlie Angus Timmins-James Bay Ontario NDP 83,257 12 Me Arnold North Okanagan-Shuswap British Columbia Conservative 124,605 13 Rene Arseneault Madawaska-Restigouche New Brunswick Libera 60,378 14 Chandra Arya Nepean Ontario Liberal 119,110 15 Niki Ashton Churchill-Keewatinook Aski Manitoba NDP 87,027 16 Jenica Atwin Fredericton New Brunswick Green Party 101,760 17 Taylor Bachrach Skeena-Bulkley Valley British Columbia NDP 90,586 18 Vance Badawey Niagara Centre Ontario Liberal 109,067 19 Larry Bagnell Yukon Yukor Liberal 35,874 20 Navdeep Bains Mississauga-Malton Ontario Liberal 118,240 21 Yvan Baker Etobicoke Centre Ontario Liberal 114,910 22 Tony Baldinelli Niagara Falls Ontario Conservative 128,357 23 John Barlow Foothills Alberta Conservative 113,227 24 Michael Barrett Leeds-Grenville-Thousand Islands and Rideau Lakes Ontario Conservative 100,546 25 Xavier Barsalou-Duval Pierre-Boucher-Les Patriotes-Vercheres Quebec Bloc Quebecois 99,787 There are various columns for different pieces of data: First Name Last Name The Constituency column is the geographic area from which the member resides. The Province/Territory is exactly that: the province (such as Ontario) or territory (such as Yukon) from which the member resides. Political Affiliation, which is the political party that the member belongs to. . Population, which is the 2016 population of that constituency. Each cell in the Political Affiliation column can only take one of the following values: Bloc Quebecois Conservative . . Green Party Independent Liberal NDP Although not shown, assume that the data is correctly filled in down to row 339, which is for all 338 members of Parliament (and the header row at the top).Question 3 1.25 pts Now, you want to create a formula that can provide an answer to the following question: How many people live in constituencies that are represented by an MP that is either a Liberal or a Conservative? Remember that the answer should be based on all 338 constituencies, not just the ones shown in the case. There is AT LEAST ONE correct option, but you MUST SELECT ALL correct options. There is no partial credit. O =SUMIFS(F2:F339,E2:E339,"Bloc Quebecois",E2:E339,"Green Party",E2:E339,"Independent",E2:E339,"NDP") O =338-SUMIFS(F2:F339,E2:E339,"Bloc Quebecois",E2:E339,"Green Party",E2:E339,"Independent",E2:E339,"NDP") O =338-SUMIFS(F2:F339,E2:E339,"=Bloc Quebecois",E2:E339,"=Green Party",E2:E339,"=Independent",E2:E339,"=NDP") O =338-SUMIFS(F2:F339,E2:E339,"=Bloc Quebecois")- SUMIFS(F2:F339,E2:E339,"=Green Party")- SUMIFS(F2:F339,E2:E339,"=Independent")-SUMIFS(F2:F339,E2:E339,"=NDP") O =SUMIFS(F2:D339,E2:E339,"Conservative",E2:E339,"Liberal") O =SUMIFS(F2:F339,E2:E339,OR("Liberal", "Conservative")) =SUMIFS(F2:F339,E2:E339,OR(E2:E339="Liberal", E2:E339="Conservative")) O None of the above (if you choose this option, do NOT choose any other options)