(a) What is the simplest formula (hint-use a single function) would you use to c
ID: 3889108 • Letter: #
Question
(a) What is the simplest formula (hint-use a single function) would you use to calculate the arithmetic mean of the following data set: 11, 22, 33, 44, 55? (b) Assume that cell B1 contained the formula you provided to correctly answer (a) above. What formula would allow you to round that result to the nearest whole number? (c) What formula would you use to determine the most common value of the data set: 7, 9, 3, 5, 7, 1? (d) Assume for a moment that last year's labor rate for a building inspector hired by the city was $35 per hour. For this year, the union negotiated a contract with a $39.95 per hour rate on behalf of all of the inspectors. What algebraic expression could you use to determine the percent increase in labor costs? Note: Assume that the cell is set for a General format, not percent. (e) Assume the calculation to solve the problem immediately above (e) is entered correctly into cell c1. What formula can be used to round that specific cell to two significant digits after the decimal point? Assume that a billboard on an interstate highway rents for $o.35 (35 cents) per hour and rents by the month. What formula should be used to determine the bill for the entire month of September? (f)Explanation / Answer
1. = AVERAGE(11,22,33,44,55)
2. = ROUND(B1,0) // Zero indicates number of digits after decimal point
3. =MODE(7,9,3,5,7,1)
d. =(39.95-35)*100/39.95
e. = ROUND(C1,2) //2 indicates number of digits after decimal point
f. = 0.35 *24*30 // for f30 days ,each day 24 hours and rent 0.35 per hour
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.