Need help with problem two, it's asking to calculate 100,000 Honduras Homicide.

Honduran Immigration to the United States In 2012, Honduras was declared the homicide capital of the world, having the highest murder rate in a non- war country (per Wikipedia), causing many migrants to flee violence at home. Does the homicide rate in Honduras have an impact on the number of Honduran migrants coming to the United States? Data in the accompanying spreadsheet documents the number of homicides in Honduras and the number of Honduran migrants living in the United States in the years 1990 to 2018. 28yrs. 1. Does it appear the quantities for the homicides and the number of Honduran migrants in the United States are positively related or negatively related? Why do you think the number of homicides and the number of migrants would be related in this way? 2. Homicide rates are usually reported as a number of homicides per 100,000 people living in that country. Create a new column that calculates the number of homicides per 100,000 Hondurans for each year. **Include a copy of this column in your report. 3. Scatterplots can be used to test correlation between different sets of data. Create a scatterplot that compares the homicide rate per 100,000 Hondurans and the number of Honduran migrants in the United States. Then have your spreadsheet program create a linear regression trendline for the data, displaying the equation and the coefficient of determination (R2) on the graph. (You can create a scatterpolot in Microsoft Excel by highlighting all of the data, clicking the "Insert" tab, and selecting "Scatter". You can display a regression line by right-clicking on a data point in your scatterplot, selecting "Add Trendline...", and selecting "Display Equation on chart" and "Display R- squared value on chart".) **Include a copy of this scatterplot in your report. 4. Find the correlation coefficient R for your linear regression trendline. Does that value indicate a strong correlation or a weak correlation? Note: You must calculate and discuss R, but the spreadsheet program displays R. 5. Based on the linear regression trendline you just generated, how many migrants could the United States expect to have if the homicide rate in Honduras rose to 100 per 100,000 Hondurans? Use an equation editor to show calculations to support your answer. 6. Based on the linear regression trendline you just generated, what does the Honduran homicide rate need to be in order to reduce the number of Honduran migrants in the United States to 300,000 Hondurans? Use an equation editor to show calculations to support your answer. 7. Discuss the result you found in number 6. Do you think that the number of Honduran migrants in the United States would actually reduce to 300,000? Why or why not? Discuss another variable that could affect the validity of this prediction