Uber Interview Question

Calculate weighted average of requests/driver based on data set in csv format

Interview Answer

Anonymous

Jan 25, 2019

this can be done using SUMPRODUCT and SUM functions. Weighted average can be calculated as SUMPRODUCT(NUMBER, WEIGHT)/SUM(WEIGHT)