Home /
Expert Answers /
Computer Science /
nbsp-15-complete-the-analysis-section-using-formulas-with-statistical-functions-use-named-ran-pa771
(Solved): 15. Complete the Analysis section using formulas with statistical functions. Use named ran ...
15. Complete the Analysis section using formulas with statistical functions. Use named ranges instead of cell references in the formulas. a. Price b. MPG City C. d. e. MPG Highway Average MPG Maintenance/Year Registration Fee g. Insurance/Year h. Amount to Borrow 1. APR Years k. Loan Pavment f. 27
Expert Answer
ANSWER_--> The formula for average is =AVERAGE(E15,E16). The formula for highest is =MAX(F15,F16). The formula for lowest is =MIN(G15,G16). MS Excel has a small box on the left-hand side be