{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Two-Way Tables and Charts using Chart Wizard

# Two-Way Tables and Charts using Chart Wizard - It answers...

This preview shows pages 1–2. Sign up to view the full content.

A survey of shoppers at a branch of a department store chain was taken to determine whether they preferred to pay in cash or with a credit card. The results are as follows classified by gender of the shopper. This example illustrates the formulas you type in when you enter a crosstab table in a spreadsheet by hand. See Data sheet for data.

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

View Full Document
Gender Gender Payment Male Female Payment Male Female Cash 150 425 575 Cash 15.0% 42.5% 57.5% Credit 200 225 425 Credit 20.0% 22.5% 42.5% 350 650 1000 35.0% 65.0% 100.0% Gender Gender Payment Male Female Payment Male Female Cash 26.1% 73.9% 100.0% Cash 42.9% 65.4% 57.5% Credit 47.1% 52.9% 100.0% Credit 57.1% 34.6% 42.5% 35.0% 65.0% 100.0% 100.0% 100.0% 100.0% I entered the data into the spreadsheet and then copied and pasted 3 times to be able to compute tables of row, column, and total percentages. Click on the cells to see the formulas used. This table is used to answer questions like "What percentage of Cash users are females? The table can be used to compare Cash users with credit users. This is a table of total percentages.
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: It answers questions like "What % of customers are female AND pay cash?" It is also useful for answering questions like " Which combination of Payment and gender is most likely? This is a table of column %. It answers questions like " What percent of Females use cash for purchase?" The table is useful for comparing male purchasers with female purchasers. Male Female 100 200 300 400 500 Cash Credit I got the chart to the right from highlighting the top table above from A3 to C5 and clicking on Chart Wizard and choosing Column bar chart - 3-D view. Male Female 50 100 150 200 250 300 350 400 450 Cash Credit Male Female 0.0% 10.0% 20.0% 30.0% 40.0% 50.0% 60.0% 70.0% Cash Credit The 2 charts to the right were obtained by highlighting the upper left table and lower right table and choosing row bars from Chart Wizard. Chart Wizard uses the columns for the main categories....
View Full Document

{[ snackBarMessage ]}

### Page1 / 2

Two-Way Tables and Charts using Chart Wizard - It answers...

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

View Full Document
Ask a homework question - tutors are online