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
Exercise instructions
- In
G2
calculate thecorrel
Then compare with church visits' correlation0.61
- Highlight
B1:C501
to select the fields for the chart. - Using the navigation bar,
insert
aChart
- Select
Scatter
from theChart type
dropdown.
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
