Chapter2_Pie and Bar Chart2

Chapter2_Pie and Bar Chart2 - Brand 1 1 5 1 3 3 3 7 2 6 1 6...

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

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Brand 1 1 5 1 3 3 3 7 2 6 1 6 3 4 5 2 5 5 2 1 1 5 1 2 3 3 6 1 5 5 4 1 3 1 6 3 1 1 2 1 1 2 1 1 5 1 2 1 3 7 6 3 BIN 1 2 3 4 5 6 7 Bud Light Busch Light Coors Light Michelob Light Miller Lite Natural Light Other Brands BASIC INSTRUCTIONS (additonal detail given in class) 1. Create a frequency table (tools - data analysis - histogram) 2. Fill in input range with Brand data 3. Fill in Bin range with the BIN category designation 4. Press OK 5. Draw pie or a bar chart from frequency information from step 1 (Insert, Chart, P See the Pie and Bar tab Below... 7 4 4 2 4 3 5 1 1 1 3 1 4 3 6 1 1 1 1 3 5 5 3 7 6 5 1 7 2 5 3 5 7 5 3 5 1 3 3 1 5 3 5 5 3 1 3 3 4 1 5 5 6 3 6 1 3 2 1 3 1 1 6 1 5 1 5 1 3 3 5 3 6 3 6 3 1 1 1 7 1 5 4 6 1 1 5 5 5 3 6 2 4 7 6 1 1 3 5 1 3 3 6 6 1 3 2 3 1 3 3 1 4 3 5 3 7 1 5 1 5 3 5 2 2 7 3 3 3 1 5 6 6 7 6 7 5 1 5 1 1 3 5 3 1 3 1 3 1 1 3 1 5 2 1 7 3 7 5 2 5 1 5 3 5 1 1 5 3 5 5 1 2 1 1 2 2 5 1 4 4 1 5 3 6 6 3 3 7 3 5 4 1 5 6 1 1 5 5 1 5 5 3 1 1 3 6 1 5 1 5 5 1 7 3 1 1 6 5 1 3 3 1 1 1 1 1 7 1 5 1 1 5 om step 1 (Insert, Chart, Pie or Bar, Data Range is the Frequancy Information) BIN 1 2 3 4 5 6 7 More Frequency 90 19 62 13 59 25 17 0 Other Brands 6% Natural Light 9% Bud Light 32% Bud Light Busch Light Coors Light Michelob Light Miller Lite Natural Light Other Brands Miller Lite 21% Michelob Light 5% Coors Light 22% Busch Light 7% Bar Chart 100 90 80 70 60 50 40 30 20 10 0 90 62 Frequency 59 19 25 13 17 Busch Light Michelob Light Natural Light Bud Light Coors Light Miller Lite Other Brands Light Beer Brand ght 32% Light 7% Bud Light Busch Light Coors Light Michelob Light Miller Lite Natural Light Other Brands 59 25 17 ht Natural Light Miller Lite Other Brands nd ...
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online