TrainityTrainity
All ideas

Doubt regarding Questions in Both CS-1 and CS-2

In Case Study 1, Question A: for finding number of jobs reviewed per hour per day, we need to divide the number of jobs reviewed for each day by 24 (since 1 day = 24 hrs) or by total sum of seconds for each day given in time_spent column after converting it into hours? From the language of the question i.e. "number of jobs reviewed per hour per day", I have divided the number of job reviews for each day by 24. In Case Study 1, Question B: Same question as above. Do I need to divide number of job reviews for each day by total number of seconds in a day (i.e. 86400 sec) or by total sum of seconds for each day given in time_spent column? In Case Study 2, Question C: for getting the users who signed up, do I need to consider the users who completed the signup process (i.e. eventname=completesignup) or the users who have just created their account (i.e. eventtype=createuser only and activation state=pending)