In Canada, the House of Commons is the popularly elected component of Parliament. There are currently...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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: A 1 First Name 2 Ziad 3 Scott 4 Dan 5 Omar 6 Leona 7 Dean 8 William 9 Anita 10 Gary 11 Charlie. 12 Mel 13 René 14 Chandra 15 Niki 16 Jenica 17 Taylor 18 Vance 19 Larry 20 Navdeep 21 Yvan 22 Tony 23 John 24 Michael 25 Xavier B Last Name Aboultaif Aitchison Albas Alghabra Alleslev Allison Amos Anand Anandasangaree Angus Arnold Arseneault Arya Ashton Atwin Bachrach Badawey Bagnell Bains Baker Baldinelli Barlow Barrett Barsalou-Duval Constituency Edmonton Manning Parry Sound-Muskoka Central Okanagan-Similkameen-Nicola Mississauga Centre Aurora-Oak Ridges-Richmond Hill Niagara West Pontiac Oakville Scarborough-Rouge Park Timmins-James Bay North Okanagan-Shuswap Madawaska-Restigouche Churchill-Keewatinook Aski Nepean Fredericton Skeena-Bulkley Valley C Niagara Centre Yukon Mississauga-Malton Etobicoke Centre Niagara Falls Foothills Leeds-Grenville-Thousand Islands and Rideau Lakes Pierre-Boucher-Les Patriotes-Verchères D Province / Territory Alberta Ontario British Columbia Ontario Ontario Ontario Quebec Ontario Ontario Ontario British Columbia New Brunswick Ontario Manitoba New Brunswick British Columbia Ontario Yukon Ontario Ontario Ontario Alberta Ontario Quebec Political Affiliation Population (2016) Conservative 121,048 Conservative Conservative Liberal Conservative Conservative Liberal Liberal Liberal NDP E Conservative Liberal Liberal NDP Green Party NDP Liberal Liberal Liberal Liberal Conservative Conservative Conservative Bloc Québécois 94,400 110,293 124,849 115,227 90,838 115,531 119,649 102,275 83,257 124,605 60,378 119,110 87,027 101,760 90,586 109,067 35,874 118,240 114,910 128,357 113,227 100,546 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. ● ● Each cell in the Political Affiliation column can only take one of the following values: ● Bloc Québécois ● Conservative ● Political Affiliation, which is the political party that the member belongs to. Population, which is the 2016 population of that constituency. ● ● 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 2 1.25 pts Column E notes the political party each member is from. Your task is to create a formula that can provide an answer to the following question: What fraction of all MPs are from the Conservative Party? The output of this formula shall result in a number between 0 and 1. That is, if all the members of Parliament were Conservative, the answer would be 1. If none of them were, the answer would be 0. Clearly, the answer is something in between. Remember that the answer should be based on all 338 members of Parliament, not just the 24 shown in the attached case. The starting equal = sign has been provided for you. Do NOT retype the starting equal sign. Do NOT use any $ signs in your formula. Do NOT leave any spaces within your formula, unless a space is absolutely needed to separate two words. 11 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: A 1 First Name 2 Ziad 3 Scott 4 Dan 5 Omar 6 Leona 7 Dean 8 William 9 Anita 10 Gary 11 Charlie. 12 Mel 13 René 14 Chandra 15 Niki 16 Jenica 17 Taylor 18 Vance 19 Larry 20 Navdeep 21 Yvan 22 Tony 23 John 24 Michael 25 Xavier B Last Name Aboultaif Aitchison Albas Alghabra Alleslev Allison Amos Anand Anandasangaree Angus Arnold Arseneault Arya Ashton Atwin Bachrach Badawey Bagnell Bains Baker Baldinelli Barlow Barrett Barsalou-Duval Constituency Edmonton Manning Parry Sound-Muskoka Central Okanagan-Similkameen-Nicola Mississauga Centre Aurora-Oak Ridges-Richmond Hill Niagara West Pontiac Oakville Scarborough-Rouge Park Timmins-James Bay North Okanagan-Shuswap Madawaska-Restigouche Churchill-Keewatinook Aski Nepean Fredericton Skeena-Bulkley Valley C Niagara Centre Yukon Mississauga-Malton Etobicoke Centre Niagara Falls Foothills Leeds-Grenville-Thousand Islands and Rideau Lakes Pierre-Boucher-Les Patriotes-Verchères D Province / Territory Alberta Ontario British Columbia Ontario Ontario Ontario Quebec Ontario Ontario Ontario British Columbia New Brunswick Ontario Manitoba New Brunswick British Columbia Ontario Yukon Ontario Ontario Ontario Alberta Ontario Quebec Political Affiliation Population (2016) Conservative 121,048 Conservative Conservative Liberal Conservative Conservative Liberal Liberal Liberal NDP E Conservative Liberal Liberal NDP Green Party NDP Liberal Liberal Liberal Liberal Conservative Conservative Conservative Bloc Québécois 94,400 110,293 124,849 115,227 90,838 115,531 119,649 102,275 83,257 124,605 60,378 119,110 87,027 101,760 90,586 109,067 35,874 118,240 114,910 128,357 113,227 100,546 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. ● ● Each cell in the Political Affiliation column can only take one of the following values: ● Bloc Québécois ● Conservative ● Political Affiliation, which is the political party that the member belongs to. Population, which is the 2016 population of that constituency. ● ● 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 2 1.25 pts Column E notes the political party each member is from. Your task is to create a formula that can provide an answer to the following question: What fraction of all MPs are from the Conservative Party? The output of this formula shall result in a number between 0 and 1. That is, if all the members of Parliament were Conservative, the answer would be 1. If none of them were, the answer would be 0. Clearly, the answer is something in between. Remember that the answer should be based on all 338 members of Parliament, not just the 24 shown in the attached case. The starting equal = sign has been provided for you. Do NOT retype the starting equal sign. Do NOT use any $ signs in your formula. Do NOT leave any spaces within your formula, unless a space is absolutely needed to separate two words. 11
Expert Answer:
Answer rating: 100% (QA)
The ask here is to count the number of MPs that fall in specific criteria The crite... View the full answer
Related Book For
Introduction to Statistical Investigations
ISBN: 978-1118922002
1st edition
Authors: Beth L.Chance, George W.Cobb, Allan J.Rossman Nathan Tintle, Todd Swanson Soma Roy
Posted Date:
Students also viewed these accounting questions
-
Your task is to create a society or culture that fosters all of the support foundations of Maslow's pyramid to permit individuals to strive for the pinnacle. You will develop the essay in three...
-
Your task is to create and test a database in MySQL using PhpMyAdmin. You are provided with a scenario and supporting documents, describing the requirements that Southern Cross University may have...
-
Generous Company uses the retail inventory method. The following information is available for the current year: Cost Beginning inventory Purchases Freight in Purchase returns Purchase allowances...
-
Its estimated that the average corporate user sends and receives some 112 e-mails daily.78 Thats about 14 e-mails per hour, and even if half of those dont require a lot of time and concentration,...
-
a. Use the following values and five-digit rounding arithmetic to construct the Hermite interpolating polynomial to approximate sin 0.34. b. Determine an error bound for the approximation in part...
-
The specific gravity of cast iron is 7.20. Find its density and the mass of 60.0 cm 3 of it.
-
The usual expansion device used in a window air conditioner is (a) capillary tube (b) automatic expansion valve (c) float valve (d) hand expansion valve
-
Dok Company acquired a 30 percent interest in Oak on January 1 for $2,000,000 cash. Assume the cost of the investment equals the fair value of Oaks net assets. Dok assigned the $500,000 fair value...
-
Leo and Elizabeth were getting married and planned a wedding reception for 150 people. They entered a contract with Snuffy's, a banquet hall, to hold the reception between 6:00 p.m. and 11:00 p.m. on...
-
The Ploughman family owns and operates a 640-acre farm that has been in the family for several generations. The Ploughmans always have had to work hard to make a decent living from the farm and have...
-
Figure <3 of 3 > A wire is connected to two supports. (EFigure 3) The support on the wall has coordinates the i, j, and k components of the unit vector u that describes the line of action from point...
-
a. As the plan is not a safe harbor plan, the general rule is met as the highest allocation rate for any HCE is greater than the lowest allocation rate for any NHCE. True False. Regardless of your...
-
The December 31, 2024 balance sheet of Cullumber Co. included the following items: 10% bonds payable due December 31, 2030 $5,006,000 Unamortized discount on bonds payable 420,504 On January 1, 2025,...
-
Consider 24 PRNS,U 1,U2,...,U4, and suppose that the average of those observationssU= 24-1 U/24-0.7.Use these PRNs to generate a single approximately Nor(0,1) random variate via our "desert island"...
-
VQA regulations set standards including: Question 19 options: Addition of sugar, vineyard yeilds, grape varieties. Grape varieties, brix, labelling, origin. Brix, de-acidification, blending...
-
Find the free cash flow Tesla Valuation Model assumptions based on anaylst reports Upside YOY Revenue Growth Downside YOY Revenue Growth Base Case YOY Revenue Growth Total Cost of Revenue (% of Rev)...
-
1. Tooth dimension accuracy can be measured with the David Brown tangent comparator, shown in (a), which is a special caliper measuring the length of common normals, simply illustrated in (b). Prove,...
-
Refer to the information from Exercise 22-19. Use the information to determine the (1) Weighted average contribution margin , (2) Break-even point in units, and (3) Number of units of each product...
-
Recall that the two errors discussed in this chapter were regarded as false alarm and missed opportunity. In some fields, these errors are also regarded as consumers risk and producers risk. With...
-
Reconsider the previous exercise. If a 99% confidence interval had instead been produced from the same sample data for the parameter 05-06 88-94, what would the midpoint of this confidence interval...
-
As seen in Exploration 6.1, an instructor collected data on prices (in dollars) paid by students for their most recent haircut, also recording each students sex, to test whether females in the...
-
The MINITAB commands will create a normal scores plot from observations that were set in C1. (MINITAB uses a variant of the normal scores, \(m_{i}\), that we defined.) Construct a normal scores plot...
-
With reference to the preceding exercise, find the corresponding distribution function and use it to determine the probabilities that a random variable having this distribution function will take on...
-
Use the computing formula for \(\sigma^{2}\) to rework part (b) of the preceding exercise. Data From Preceding Exercise Determining a joint cumulative distribution function Find the joint cumulative...
Study smarter with the SolutionInn App