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
Questo esercizio fa parte del corso
Introduction to Statistics in Google Sheets
Istruzioni dell'esercizio
- 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.
Esercizio pratico interattivo
Passa dalla teoria alla pratica con uno dei nostri esercizi interattivi
Inizia esercizio