Evaluting employee performance
Now to calculate the profit (or loss!) for each day using the
Output ($)
and Total Costs ($)
you found in the previous exercises. You'll also evaluate the employee's performance each day as either good
or bad
, depending on the net income and the number of products finished.Diese Übung ist Teil des Kurses
Datenanalyse in Google Sheets
Anleitung zur Übung
- Calculate the
Net ($)
by subtracting theTotal Costs ($)
from theOutput ($)
. - In the
Performance
column, returngood
if theNet ($)
for the day was positive, greater than0
, ANDFinished
was greater than10
, and returnbad
, otherwise.
Interaktive Übung zum Anfassen
Setzen Sie die Theorie mit einer unserer interaktiven Übungen in die Tat um
