IMPORTANT NOTE 2: When you are asked to calculate an answer by hand, you may still...

Transcribed Image Text:

IMPORTANT NOTE 2: When you are asked to calculate an answer by hand, you may still use your calculator for basic calculations (e.g. multiplication, division, taking a square-root etc.) Your workings should show that you know how a formulae or process works. 1. Consider the two linear equations below: 4 =x-5 - y = -3x-18 (2) Draw both of these linear equations on the blank plot below (i.e. your answer should have two different straight lines on this blank plot). You must use the plot below to draw your lines. No other plot is allowed. (5 marks for each line for a total of 10 marks) 45 40 35 30 25 20 15 10 5 0 0 2 4 6 01 X 8 10 12 2. This question is similar to the type of question you may encounter in one of the online numeracy quizzes. However, while the numeracy quiz requires an answer only, for this assignment submission you must also include your workings. Find the slope and the intercept of the straight line (i.e. the linear equation) containing the points (2,-5) and (-2, -10). (10 marks) 3. Below are six different scatterplots. In a random order, the correlations associated with these scatterplots are 0, -0.6, -0.9, 0.5, 0.8 and -0.3. Your task is to correctly match these correlations with the correct scatterplot. Each correlation belongs to just one scatterplot. When you are confident with your answers then write down the correct correlation for each scatterplot on the next page. (6 marks) Scatterplot A Scatterplot B Scatterplot C Scatterplot D Scatterplot E Scatterplot F Scatterplot A: correlation = Scatterplot B: correlation = Scatterplot C: correlation = Scatterplot D: correlation = Scatterplot E: correlation = Scatterplot F: correlation = 4. The variable # of Influenza Cases in Table 1 located at the end of this question sheet measures the number of influenza cases, in 2019, per 1 million members of the population for a country. This data was collected from the World Health Organization (WHO) website, https://www.who.int/en/. For this question you are going to choose another variable measured for the countries listed in Table 1 to see whether your chosen variable correlates with the number of influenza cases. Marks will not be allocated according to whether there is correlation present, but whether the data collected is appropriate. For the data to be appropriate the following must hold: The data you collect for this question needs to be easily accessible, for us to check, for at least 10 of the countries that are listed in Table 1. This also means that the data must be actual measurements associated with these countries. The data you collect must be measured no earlier than the year 2019. Also, the variable must be in the same units for each of the countries. For example, if you choose a variable that is measured per 10 million members of the population for one country, then you need to also record the data for all other countries in units of per 10 million members of the population. The variable you select must not be Population Density which is the number of members in a population per square kilometre of the country. This is the variable I selected for my model answers. Complete the following questions. (a) Briefly describe below the new variable that you have chosen including (i) the units it is measured in and (ii) where you found the data. (b) At the end of this question sheet you will find Table 1. Enter the values that you have collected for your new variable under the columns called New variable where the new variable value for each country needs to appear in the space provided to the immediate right of the country name. (4 marks) (c) Enter the data from your completed Table 1, including the data for your new variable, into Excel and create a scatterplot of the two variables making sure that you include appropriate axis labels. Copy and paste this scatterplot into your assignment solutions document. (4 marks) (d) Using Excel, calculate the correlation between these two variables. What is it equal to and what Excel formula did you use to obtain it? (6 marks) (e) Provide some brief comments on what you see in the scatterplot and also on what you think the correlation value tells you. For example, does there appear to be a linear relationship between the two variables? Country # of Influenza Cases per 1 mil. # of Influenza Cases New variable Country New variable per 1 mil. Argentina 2140.74 Pakistan 21.47 Australia 3642.79 Russia 131.99 Brazil 85.47 South Africa 127.76 Canada 1139.89 South Korea 234.99 China 417.44 United Kingdom 625.05 India 35.27 United States 4781.93 Japan 76.75 Uruguay 345.00 Mexico 237.33 Table 1: Number of Influenza Cases for 2019. IMPORTANT NOTE 2: When you are asked to calculate an answer by hand, you may still use your calculator for basic calculations (e.g. multiplication, division, taking a square-root etc.) Your workings should show that you know how a formulae or process works. 1. Consider the two linear equations below: 4 =x-5 - y = -3x-18 (2) Draw both of these linear equations on the blank plot below (i.e. your answer should have two different straight lines on this blank plot). You must use the plot below to draw your lines. No other plot is allowed. (5 marks for each line for a total of 10 marks) 45 40 35 30 25 20 15 10 5 0 0 2 4 6 01 X 8 10 12 2. This question is similar to the type of question you may encounter in one of the online numeracy quizzes. However, while the numeracy quiz requires an answer only, for this assignment submission you must also include your workings. Find the slope and the intercept of the straight line (i.e. the linear equation) containing the points (2,-5) and (-2, -10). (10 marks) 3. Below are six different scatterplots. In a random order, the correlations associated with these scatterplots are 0, -0.6, -0.9, 0.5, 0.8 and -0.3. Your task is to correctly match these correlations with the correct scatterplot. Each correlation belongs to just one scatterplot. When you are confident with your answers then write down the correct correlation for each scatterplot on the next page. (6 marks) Scatterplot A Scatterplot B Scatterplot C Scatterplot D Scatterplot E Scatterplot F Scatterplot A: correlation = Scatterplot B: correlation = Scatterplot C: correlation = Scatterplot D: correlation = Scatterplot E: correlation = Scatterplot F: correlation = 4. The variable # of Influenza Cases in Table 1 located at the end of this question sheet measures the number of influenza cases, in 2019, per 1 million members of the population for a country. This data was collected from the World Health Organization (WHO) website, https://www.who.int/en/. For this question you are going to choose another variable measured for the countries listed in Table 1 to see whether your chosen variable correlates with the number of influenza cases. Marks will not be allocated according to whether there is correlation present, but whether the data collected is appropriate. For the data to be appropriate the following must hold: The data you collect for this question needs to be easily accessible, for us to check, for at least 10 of the countries that are listed in Table 1. This also means that the data must be actual measurements associated with these countries. The data you collect must be measured no earlier than the year 2019. Also, the variable must be in the same units for each of the countries. For example, if you choose a variable that is measured per 10 million members of the population for one country, then you need to also record the data for all other countries in units of per 10 million members of the population. The variable you select must not be Population Density which is the number of members in a population per square kilometre of the country. This is the variable I selected for my model answers. Complete the following questions. (a) Briefly describe below the new variable that you have chosen including (i) the units it is measured in and (ii) where you found the data. (b) At the end of this question sheet you will find Table 1. Enter the values that you have collected for your new variable under the columns called New variable where the new variable value for each country needs to appear in the space provided to the immediate right of the country name. (4 marks) (c) Enter the data from your completed Table 1, including the data for your new variable, into Excel and create a scatterplot of the two variables making sure that you include appropriate axis labels. Copy and paste this scatterplot into your assignment solutions document. (4 marks) (d) Using Excel, calculate the correlation between these two variables. What is it equal to and what Excel formula did you use to obtain it? (6 marks) (e) Provide some brief comments on what you see in the scatterplot and also on what you think the correlation value tells you. For example, does there appear to be a linear relationship between the two variables? Country # of Influenza Cases per 1 mil. # of Influenza Cases New variable Country New variable per 1 mil. Argentina 2140.74 Pakistan 21.47 Australia 3642.79 Russia 131.99 Brazil 85.47 South Africa 127.76 Canada 1139.89 South Korea 234.99 China 417.44 United Kingdom 625.05 India 35.27 United States 4781.93 Japan 76.75 Uruguay 345.00 Mexico 237.33 Table 1: Number of Influenza Cases for 2019.