Please find the following Excel form for calculating the bonus as required. Please ensure the equation is duplicated even so, with the sign "=." It is possible to insert this formula into cell L12. Then cut/paste the cell into other L12:L39 cells.
The mixed microbial reference here is used in L7, L8, and L9 so these cell references are not moved whenever the formula is copied to L12:L39.
Please verify that whenever the copy has also been copied, the cell formula appears beneath in each cell.
Please find the following Excel form for calculating the bonus as required. Please ensure the equation is duplicated even so, with the sign "=." It is possible to insert this formula into cell L12. Then cut/paste the cell into other L12:L39 cells.
The mixed microbial reference here is used in L7, L8, and L9 so these cell references are not moved whenever the formula is copied to L12:L39.
Please verify that whenever the copy has also been copied, the cell formula appears beneath in each cell.
Using proportions, it is found that the marginal distribution is:
90% of the flights were on time.10% of the flights were delayed.
---------------------------
In total, there were 170 + 120 + 55 + 20 = 365 flights.Of those, 167 + 115 + 40 + 8 = 330 on time. The percentage on time is:90% on time, and the rest, that is, 100% - 90% = 10% were delayed, and the marginal distribution is described by these percentages.