{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

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

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

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.
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

{[ snackBarMessage ]}

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern