The following observations are for two quantitative variables, x and y. Observation x y 1 31 26 2 80 21 3 10 81 4 17 80 5 35 71 6 20 60 7 28 82 8 67 23 9 47 62 10 57 58 Observation x y 11 78 34 12 67 41 13 39 35 14 37 60 15 87 23 16 64 40 17 51 30 18 43 65 19 89 24 20 18 88 (a) Develop a crosstabulation for the data, with x as the row variable and y as the column variable. For x use classes of 10–29, 30–49, and so on; for y use classes of 20–39, 40–59, and so on. y Grand Total 20-39 40–59 60–79 80–99 10-29 30–49 X 50–69 70–90 Grand Total (b) Compute the row percentages. (Round your answers to one decimal place.) y Grand Total 20-39 40–59 60–79 80–99 10-29 30–49 X 50–69 70–90 Grand Total (c) Compute the column percentages. (Round your answers to one decimal place.) y Grand Total 20-39 40–59 60–79 80–99 10-29 30–49 X 50–69 70–90 Grand Total

College Algebra

1st Edition

ISBN:9781938168383

Author:Jay Abramson

Publisher:Jay Abramson

Chapter4: Linear Functions

Section: Chapter Questions

Problem 40RE: For the following exercises, consider the data in Table 5, which shows the percent of unemployed ina...

See similar textbooks

Related questions

Topic Video

Question

PLEASE HELP show me how to do this in excel.

The following observations are for two quantitative variables, x and y.

Observation	x	y
1	31	26
2	80	21
3	10	81
4	17	80
5	35	71
6	20	60
7	28	82
8	67	23
9	47	62
10	57	58

Observation	x	y
11	78	34
12	67	41
13	39	35
14	37	60
15	87	23
16	64	40
17	51	30
18	43	65
19	89	24
20	18	88

(a)

Develop a crosstabulation for the data, with x as the row variable and y as the column variable. For x use classes of 10–29, 30–49, and so on; for y use classes of 20–39, 40–59, and so on.

			y			Grand Total
		20-39	40–59	60–79	80–99
	10-29
	30–49
X	50–69
	70–90
	Grand Total

(b)

Compute the row percentages. (Round your answers to one decimal place.)

			y			Grand Total
		20-39	40–59	60–79	80–99
	10-29
	30–49
X	50–69
	70–90
	Grand Total

(c)

Compute the column percentages. (Round your answers to one decimal place.)

			y			Grand Total
		20-39	40–59	60–79	80–99
	10-29
	30–49
X	50–69
	70–90
	Grand Total

(d)

What is the relationship, if any, between x and y?

Higher values of x are associated with ---Select--- higher values of y lower values of y . Lower values of x are associated with ---Select--- higher values of y lower values of y .

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 6 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

$Hypothesis Tests and Confidence Intervals for Means$

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.

Similar questions