Question

Create a Categorical Frequency Table and Grouped Frequency Distribution table in Excel using the above data

Example 2-1 Distribution of Blood Types Twenty-five army inductees were given a blood test to determine their blood type. The data set i:s ВВАВ B AO О O A AB B Construct a frequency distribution for the data

Answer 1

HomensertPage Layout Formulas Data Review View Cut Copy Format Painter B I Autosum. Fill General ǐ 译鹵Merge & Center, 펭. % , 'il: conditional Format. Cell- Insert Delete Format Formatting as Table Styles в 1 Sort & Find & , · . Styles. Insert Delete Format 2 ClearFilter Select Editing Clipboard Alignment Cells H 12 Blood Type Count 14 4 ト | Sheet1, Sheet2· Sheet3 0 57495 BABAO . i 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25

io Creaïx:萌(it Dup63d I.requcricy dis í ribu :ion ihe: data required from the Question 2-2. Which is not given. Only data for Question 2-1 is given to

Making a Grouped Frequency Distribution (Quantitative Data) 1. Press [Ctrl]-N for a new workbook 2. Enter the raw data from Example 2-2 in column A, one number per cell.