Excel assignment

Literacy and Hunger
Country % Who Are Literate (x) % Who Are Undernourished (y)
Cuba 100 2
Egypt 71 4
Ethiopia 36 46
Grenada 96 7
Italy 98 2
Jamaica 80 9
Jordan 91 6
Pakistan 50 24
Russia 99 3
Togo 53 24
Uganda 67 19

 

Problem #38:
Use the data above to solve these exercises:

  1. Use technology to determine the correlation coefficient, rounded to two decimal places, between percentage of people in a country who are literate and the percentage who are undernourished.
  2. Use technology to find the equation of the regression line for the percentage who are literate and the percentage who are undernourished. Round “m” and “b” to two decimal places.
  3. Use technology to determine the percentage of people, to the nearest percent, can we anticipate are undernourished in a country where 60% of the people are literate?

Needs help with similar assignment?

We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper

Get Answer Over WhatsApp Order Paper Now