Investigating age and volunteering

Earlier you observed a strong correlation between age & annual religious observation. Another interesting field which could indicate a profile's moral values is the number of volunteer hours annually. In each profile a user can add information regarding their annual estimated hours spent volunteering.

In addition to corrlation you decide to plot a scatter plot. If there is a correlation between age & volunteer_hrs, you should be able to observe a trend sloping upward or downward. If the correlation is low, you could surmise that people volunteer at similar rates regardless of their age

This exercise is part of the course

Introduction to Statistics in Google Sheets

View Course

Exercise instructions

  • In G2 calculate the correl Then compare with church visits' correlation 0.61
  • Highlight B1:C501 to select the fields for the chart.
  • Using the navigation bar, insert a Chart
  • Select Scatter from the Chart type dropdown.

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise