Question 2: Two opposing provincial members of parliament are debating the merits of increasing funding for education. The member representing the opposition party claims that additional funding will...


Question 2: Two opposing provincial members of parliament are debating the merits of increasing<br>funding for education. The member representing the opposition party claims that additional funding will<br>reduce failure rate, while the governing member maintains that this is not evident. The opposition member<br>presents the following data to support her claim, taken from eight cities in the province.<br>5.2<br>7.3<br>3.5<br>Operating Budget<br>(millions/year)<br>Number of graduates<br>| (hundreds)<br>9.8<br>16.4<br>2.8<br>6.6<br>6.1<br>13<br>16<br>11<br>25<br>74<br>8.5<br>17<br>15<br>Perform a two-variable data analysis to determine if increased funding for education will reduce the<br>failure rate. Note: Use excel or google sheets only to create graphs and calculations.<br>The following should be included in your answer:<br>• Scatter plot(s) including line of best fit and correlation coefficient.<br>• Classification of the linear correlation and type of causal relationship.<br>Extraneous variables that may affect either variable. Any possible bias?<br>• Does your statistical analysis support either claim being made by the political party?<br>Conclusions based on your data analysis. Is there sufficient enough data and information<br>presented to make conclusions?<br>

Extracted text: Question 2: Two opposing provincial members of parliament are debating the merits of increasing funding for education. The member representing the opposition party claims that additional funding will reduce failure rate, while the governing member maintains that this is not evident. The opposition member presents the following data to support her claim, taken from eight cities in the province. 5.2 7.3 3.5 Operating Budget (millions/year) Number of graduates | (hundreds) 9.8 16.4 2.8 6.6 6.1 13 16 11 25 74 8.5 17 15 Perform a two-variable data analysis to determine if increased funding for education will reduce the failure rate. Note: Use excel or google sheets only to create graphs and calculations. The following should be included in your answer: • Scatter plot(s) including line of best fit and correlation coefficient. • Classification of the linear correlation and type of causal relationship. Extraneous variables that may affect either variable. Any possible bias? • Does your statistical analysis support either claim being made by the political party? Conclusions based on your data analysis. Is there sufficient enough data and information presented to make conclusions?

Jun 07, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here