Ch14test02a - h. Apply the results of the Frequency formula...

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

View Full Document Right Arrow Icon
BUSINESS MATH USING EXCEL Name ______________________________ Date ______________________________ Chapter 14 - Test 02 Date Range Frequency 1-Jul 62 70 3 2-Jul 85 71-90 90 5 3-Jul 124 91-110 110 1 4-Jul 65 111-130 130 3 5-Jul 78 2 6-Jul 86 7-Jul 69 8-Jul 86 9-Jul 124 10-Jul 131 11-Jul 124 12-Jul 108 13-Jul 136 14-Jul 86 Directions: a. In Cell E5 enter 70, the first break point. b. In Cell E6 enter 90, the second break point. c. In Cell E7 enter 110, the third break point. d. In Cell E8 enter 130, the last break point. f. Key in the Data_array box the range for the grades in Column B.
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: h. Apply the results of the Frequency formula to the selected cells. Car Restoration Weblog Hit Count for July 1 July 14 Web Site Hits Break Points e. Select Cells F5 through F9. Key the first part of the Frequency formula FREQUENCY g. Key the range of cells containing your break points in Column E in the Bins_array box. i. Save the file as ch14test02a.xls. A B C D E F 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30...
View Full Document

Ask a homework question - tutors are online