Chapter 14 - Key =MINA(B5:B10). Press Enter. c. Enter a...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Chapter 14 - Exercise 14 Make/Model Rank BMW X5 8.2 Lexus RX300 8.2 Acura MDX 8.7 Lincoln Navigator 8.7 Mercedes-Benz ML320 9.1 Infiniti OX4 9.5 9.5 8.2 1.3 0.51 Directions: f. Format Cell B14 for Number. Set Decimal places to 2. Clayton Auto Dealers Association Luxury SUV’s Acceleration Highest Lowest Range Standard Deviation a. Enter a formula in Cell B11 to find the highest elevation. Key =MAXA(B5:B10). Press Enter. b. Enter a formula in Cell B12 to find the lowest elevation.
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Key =MINA(B5:B10). Press Enter. c. Enter a formula in Cell B13 to find the range of elevations. (Range = Highest value Lowest value) d. Enter a formula in Cell B14 for standard deviation. Key =STDEV(B5:B10). Press Enter. e. Format Cells B11 through B13 for Number. Set Decimal places to 1. g. Save the file as ch14ex14a.xls....
View Full Document

This note was uploaded on 04/13/2010 for the course BUSINESS 15643 taught by Professor Schilz during the Spring '10 term at École Normale Supérieure.

Ask a homework question - tutors are online