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
G2calculate thecorrelThen compare with church visits' correlation0.61 - Highlight
B1:C501to select the fields for the chart. - Using the navigation bar,
insertaChart - Select
Scatterfrom theChart typedropdown.
Exercício interativo prático
Transforme a teoria em ação com um de nossos exercícios interativos
Começar o exercício