0
Still curious? Ask our experts.
Chat with our AI personalities
Taiga
Coach
ViviAdd your answer:
Earn +20 pts
How would you calculate 10 percent of something in excel?
There are a few ways. Assuming the value you want 10% of is in cell A1, then in another cell you could use any of the following formulas: =A1*10% =A1/10 =A1*0.1 =A1/100*10
What is arithmetic mean number?
The mean of the numbers a1, a2, ..., an is equal to (a1 + a2 + ..., + an)/n. This number is used mostly as the average. It is called the arithmetic mean.
How in excel would you calculate the total pay for an employee who receives regular time for 40 hours time and a half for 40-50 hours and double-time for hours over 50?
-- The number of hours will be entered in Column-A. Type in B1: " =if(A1<=40,A1,"") " Type in C1: " =if(and(A1>40, A1<=50),A1-40,"") " Type in D1: " =if(A1>50, A1-50,"") " Type in E1: " = F1 * (B1 + 1.5*C1 + 2*D1) " Type in F1: the employee's regular hourly rate of pay Copy (B1 through D1) down some handy distance. ======================================== When you enter the number of hours worked in the week in Column-A, the employee's total pay for the week appears in Column-E.
How many pieces of A4 fit into A1?
A4*2 = A3 A3*2 = A2 = 2*2*A4 A2*2 = A1 = 2*2*2*A4 = 8*A4 Answer: 8 pieces of A4 zized papers will fit on 1 sheet of A1.
What is the Relation between geometric mean and arithmetic mean?
The mean of the numbers a1, a2, a3, ..., an is equal to (a1 + a2 + a3 +... + an)/n. This number is also called the average or the arithmetic mean.The geometric mean of the positive numbers a1, a2, a3, ... an is the n-th roots of [(a1)(a2)(a3)...(an)]Given two positive numbers a and b, suppose that a< b. The arithmetic mean, m, is then equal to (1/2)(a + b), and, a, m, b is an arithmetic sequence. The geometric mean, g, is the square root of ab, and, a, g, b is a geometric sequence. For example, the arithmetic mean of 4 and 25 is 14.5 [(1/2)(4 + 25)], and arithmetic sequence is 4, 14.5, 25. The geometric mean of 4 and 25 is 10 (the square root of 100), and the geometric sequence is 4, 10, 25.It is a theorem of elementary algebra that, for any positive numbers a1, a2, a3, ..., an, the arithmetic mean is greater than or equal to the geometric mean. That is:(1/n)(a1, a2, a3, ..., an) ≥ n-th roots of [(a1)(a2)(a3)...(an)]
