Closed tjmahr closed 8 years ago
created view q_LENA_Averages with hourly averages. no attempt to filter out unreliable administrations, recordings with too few hours or too many hours after midnight.
q_LENA_Averages
glimpse(tbl(l2t, "q_LENA_Averages")) #> Observations: 182 #> Variables: 16 #> $ Study (chr) "TimePoint1", "TimePoint1", "TimePoint1"... #> $ ResearchID (chr) "600L", "602L", "603L", "604L", "605L", ... #> $ LENA_Date (chr) "2012-11-02", "2012-11-09", "2012-12-09"... #> $ LENA_Hours (dbl) 16.0000, 16.0000, 16.0000, 16.0000, 16.0... #> $ Prop_Meaningful (dbl) 0.1919, 0.1657, 0.1670, 0.2981, 0.2147, ... #> $ Prop_Distant (dbl) 0.2186, 0.3043, 0.2763, 0.1658, 0.3896, ... #> $ Prop_TV (dbl) 0.1134, 0.0547, 0.0759, 0.0391, 0.0171, ... #> $ Prop_Noise (dbl) 0.0176, 0.3235, 0.0249, 0.0192, 0.0424, ... #> $ Prop_Silence (dbl) 0.4585, 0.1518, 0.4559, 0.4777, 0.3361, ... #> $ AWC_Hourly (dbl) 1587.5000, 1168.3125, 1219.6250, 2129.75... #> $ CTC_Hourly (dbl) 68.8125, 39.6250, 30.6250, 87.4375, 56.8... #> $ CVC_Hourly (dbl) 221.6875, 126.8750, 119.8750, 337.2500, ... #> $ FirstHour (chr) "06:00 AM", "07:00 AM", "07:00 AM", "07:... #> $ FinalHour (chr) "10:00 PM", "11:00 PM", "11:00 PM", "11:... #> $ HoursAfterMidnight (int) 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 1... #> $ LENA_Notes (chr) NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, ...
created view
q_LENA_Averageswith hourly averages. no attempt to filter out unreliable administrations, recordings with too few hours or too many hours after midnight.