Problem The following data are for 30 observations involving two categorical variables, x and y. The categories for x are A, B, and C; the categories for y are 1 and 2. Show steps in Excel. a. Develop a crosstabulation for the data, with x as the row variable and y as the column variable. b. Compute the row percentages. c. Compute the column percentages. d. What is the relationship, if any, between x and y? Observation x y 1 A 1 2 B 1 3 B 1 4 C 2 5 B 1 6 C 2 7 B 1 8 C 2 9 A 1 10 B 1 11 A 1 12 B 1 13 C 2 14 C 2 15 C 2 16 B 2 17 C 1 18 B 1 19 C 1 20 B 1 21 C 2 22 B 1 23 C 2 24 A 1 25 B 1 26 C 2 27 C 2 28 A 1 29 B 1 30 B 2
Problem The following data are for 30 observations involving two categorical variables, x and y. The categories for x are A, B, and C; the categories for y are 1 and 2. Show steps in Excel. a. Develop a crosstabulation for the data, with x as the row variable and y as the column variable. b. Compute the row percentages. c. Compute the column percentages. d. What is the relationship, if any, between x and y? Observation x y 1 A 1 2 B 1 3 B 1 4 C 2 5 B 1 6 C 2 7 B 1 8 C 2 9 A 1 10 B 1 11 A 1 12 B 1 13 C 2 14 C 2 15 C 2 16 B 2 17 C 1 18 B 1 19 C 1 20 B 1 21 C 2 22 B 1 23 C 2 24 A 1 25 B 1 26 C 2 27 C 2 28 A 1 29 B 1 30 B 2
Calculus For The Life Sciences
2nd Edition
ISBN:9780321964038
Author:GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Chapter12: Probability
Section12.3: Conditional Probability; Independent Events; Bayes' Theorem
Problem 80E
Related questions
Question
Problem
The following data are for 30 observations involving two categorical variables, x and y. The categories for x are A, B, and C; the categories for y are 1 and 2. Show steps in Excel.
a. Develop a crosstabulation for the data, with x as the row variable and y as the column variable.
b. Compute the row percentages.
c. Compute the column percentages.
d. What is the relationship, if any, between x and y?
| Observation | x | y |
| 1 | A | 1 |
| 2 | B | 1 |
| 3 | B | 1 |
| 4 | C | 2 |
| 5 | B | 1 |
| 6 | C | 2 |
| 7 | B | 1 |
| 8 | C | 2 |
| 9 | A | 1 |
| 10 | B | 1 |
| 11 | A | 1 |
| 12 | B | 1 |
| 13 | C | 2 |
| 14 | C | 2 |
| 15 | C | 2 |
| 16 | B | 2 |
| 17 | C | 1 |
| 18 | B | 1 |
| 19 | C | 1 |
| 20 | B | 1 |
| 21 | C | 2 |
| 22 | B | 1 |
| 23 | C | 2 |
| 24 | A | 1 |
| 25 | B | 1 |
| 26 | C | 2 |
| 27 | C | 2 |
| 28 | A | 1 |
| 29 | B | 1 |
| 30 | B | 2 |
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 5 steps with 4 images
Recommended textbooks for you
Calculus For The Life Sciences
Calculus
ISBN:
9780321964038
Author:
GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:
Pearson Addison Wesley,
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
Calculus For The Life Sciences
Calculus
ISBN:
9780321964038
Author:
GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:
Pearson Addison Wesley,
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
Functions and Change: A Modeling Approach to Coll…
Algebra
ISBN:
9781337111348
Author:
Bruce Crauder, Benny Evans, Alan Noell
Publisher:
Cengage Learning
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt