R studio : profit margin for each month - equals to profit a after tax divided by revenue profit.margin <- round(profit_after_tax/revenue, 2)*100 profit.margin Result: 12 18 -30 -22 -5 63 50 28 23 -11 4 53 How to change the results based on the note: All results need to be presented as vectors. Results for dollar values need to be calculated with $0.01 precision, but need to be presented in Units of $1,000 (i.e. 1k) with no decimal points. Results for the profit margin ratio need to be presented in units of % with no decimal points. Note: You colleague has warned you that it is okay for tax for any given month to be negative (in accounting terms, negative tax translates into a deferred tax asset).
Max Function
Statistical function is of many categories. One of them is a MAX function. The MAX function returns the largest value from the list of arguments passed to it. MAX function always ignores the empty cells when performing the calculation.
Power Function
A power function is a type of single-term function. Its definition states that it is a variable containing a base value raised to a constant value acting as an exponent. This variable may also have a coefficient. For instance, the area of a circle can be given as:
R studio : profit margin for each month - equals to profit a after tax divided by revenue
profit.margin <- round(profit_after_tax/revenue, 2)*100
profit.margin
Result: 12 18 -30 -22 -5 63 50 28 23 -11 4 53
How to change the results based on the note: All results need to be presented as
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
