Purchase Solution

# Scatter Plot in Excel

Not what you're looking for?

Here is the data:

Mean daily calories | Infant Mortality Rate (per 1,000 births)
1523 | 154
3495 | 6
1941 | 114
2678 | 24
1610 | 107
3443 | 6
1640 | 153
3362 | 7
3429 | 44
2671 | 7

a) For the above data construct a scatter plot using SPSS or Excel. What does the scatter plot show? Can you determine a type of relationship? Are there any outliers that you can see?

b) Using the same data conduct a correlation analysis using SPSS or Excel. What is the correlation coefficient? Is it a strong, moderate or weak correlation? Is the correlation significant or not? If it is what does that mean?

Solution provided by:
###### Education
• MSc, Osmania University
• MSc, Indian Institute of Technology - Roorkee (I.I.T.-ROORKEE)
• BSc, Banaras Hindu University
###### Recent Feedback
• "Very fast turnaround. Excellent communication! Much appreciated!"
• "excellent"
• "excellent"
• "excellent work"
• "Fantastic..great solution and very well explained!!!!"

##### Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.