Excel_Activity1 - Excel Activity #1: Description: Creating...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Developed by Miller/Waymire, Daytona Beach Community College Excel Activity #1: Creating a Bar Graph and Pie Chart Description : This lesson begins by having the students review the process of creating a frequency distribution for a sample of ages of people arrested in Volusia County. Excel is then used to create a histogram and pie chart representation of the data. No prior knowledge of Excel is necessary. Part I : Creating a Frequency Distribution and Histogram The following data represent the sex and age of individuals arrested in Volusia County on January 7, 2003. Note: The students may collect their own data or use the data provided below for this activity . Age Sex A g e Sex A g e Sex 1 8 M 4 8 M 3 1 M 2 5 F 2 2 M 1 9 F 3 2 M 3 0 F 2 1 M 2 9 M 1 8 M 2 7 M 1 9 M 2 8 M 3 1 M 2 2 M 5 2 M 2 9 M 3 6 M 3 3 F 2 7 F 3 4 F 4 1 M 4 0 M 1 8 M 2 0 M 3 2 M 2 7 M 2 2 M 2 4 M 1) Create a frequency distribution of the ages (men and women combined) with 6 classes. Use 18 as the lower class limit for the first class. 2) To invoke Excel, click on the Excel icon on the screen. 3) In cell A1, type: Age Group 4) In cell B1, type: Frequency 5) In cell A2, type the class limits of your first age group, such as 18-23 6) In cell B2, type the corresponding frequency. Class Limits Tally Frequency 18 –
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Developed by Miller/Waymire, Daytona Beach Community College 7) Moving down one row at a time, repeat Steps 4 and 5 to enter the remaining class limits and corresponding frequencies. 8) Place the cursor in cell A1, depress the left mouse key and while holding it down, drag the mouse to cell B7. The cells become highlighted. Release the mouse and the cells should remain highlighted. 9) While the cells are still highlighted, click the “Chart Wizard” button. A pop-up menu should appear entitled “Chart Wizard, Step 1 of 4.” Note : If the Chart Wizard icon is not on the toolbar, follow these steps: 9A) Click on the Tools menu at the top of the screen. 9B) Select “Customize” and then select the “Commands” tab on the top of the pop-up menu. 9C) Select “Insert” on the left-hand side of the menu. On the right-hand side position the cursor over the icon entitled “Chart.” Depress the left mouse key and drag the icon to the tool bar at the top of the screen. 9D) Select the Close button. 10) On the left side of the pop-up menu, click on the top choice, “Column”. On the right hand side of the pop-up menu you will see seven sub-type charts.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 5

Excel_Activity1 - Excel Activity #1: Description: Creating...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online