A recent survey collected data from 1000 randomly selected Internet users. The characteristics of the users include their gender, age, education, marital status, and annual income. Using Excel®, the following pivot tables are produced.

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question
A recent survey collected data from 1000 randomly selected Internet users. The
characteristics of the users include their gender, age, education, marital status, and
annual income. Using Excel®, the following pivot tables are produced.
Count of Education Education
Marital Status -
High school or less
Beyond high school
Total
Single
Married
32.00%
Total
16.00%
48.00%
15.10%
36.90%
52.00%
31.10%
68.90%
100.00%
Count of Gender Gender
Women Grand Total
Age
16-29
Men
19.20% 12.60%
31.80%
30-43
22.20% 15.10%
37.30%
44-57
13.30%
7.20%
20.50%
58-71
5.10%
3.80%
8.90%
72-85
1.50%
0.50%
60.80% 39.20% 100.00%
1.00%
Grand Total
Count of Employment
Employment
Unemployed
Employed
Grand Total
Total
23.20%
76.80%
100.00%
Average of Annual_Income
Employment
Unemployed
Employed
Grand Total
Total
22988.93103
60563.76432
51846.403
Approximate the percentage of these Internet users who are in the 58-71 age group.
5%
3%
9%
20%
Transcribed Image Text:A recent survey collected data from 1000 randomly selected Internet users. The characteristics of the users include their gender, age, education, marital status, and annual income. Using Excel®, the following pivot tables are produced. Count of Education Education Marital Status - High school or less Beyond high school Total Single Married 32.00% Total 16.00% 48.00% 15.10% 36.90% 52.00% 31.10% 68.90% 100.00% Count of Gender Gender Women Grand Total Age 16-29 Men 19.20% 12.60% 31.80% 30-43 22.20% 15.10% 37.30% 44-57 13.30% 7.20% 20.50% 58-71 5.10% 3.80% 8.90% 72-85 1.50% 0.50% 60.80% 39.20% 100.00% 1.00% Grand Total Count of Employment Employment Unemployed Employed Grand Total Total 23.20% 76.80% 100.00% Average of Annual_Income Employment Unemployed Employed Grand Total Total 22988.93103 60563.76432 51846.403 Approximate the percentage of these Internet users who are in the 58-71 age group. 5% 3% 9% 20%
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman