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
Este exercício faz parte do curso
Introduction to Statistics in Google Sheets
Instruções do exercício
- 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.
Exercício interativo prático
Transforme a teoria em ação com um de nossos exercícios interativos
