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 16.00% Married Total 32.00% 36.90% 48.00% 15.10% 52.00% 100.00% 31.10% 68.90% Count of Gender Gender Age 16-29 Women Grand Total 31.80% 37.30% Men 19.20% 12.60% 30-43 22.20% 15.10% 44-57 13.30% 7.20% 20.50% 8.90% 1.50% 39.20% 100.00% 58-71 5.10% 3.80% 1.00% 60.80% 72-85 0.50% Grand Total Count of Employment Employment Unemployed Employed Grand Total -Total 23.20% 76.80% 100.00%
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 16.00% Married Total 32.00% 36.90% 48.00% 15.10% 52.00% 100.00% 31.10% 68.90% Count of Gender Gender Age 16-29 Women Grand Total 31.80% 37.30% Men 19.20% 12.60% 30-43 22.20% 15.10% 44-57 13.30% 7.20% 20.50% 8.90% 1.50% 39.20% 100.00% 58-71 5.10% 3.80% 1.00% 60.80% 72-85 0.50% Grand Total Count of Employment Employment Unemployed Employed Grand Total -Total 23.20% 76.80% 100.00%
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
Related questions
Question

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
16.00%
Married
Total
32.00%
48.00%
15.10%
36.90%
52.00%
31.10%
68.90%
100.00%
Count of Gender Gender
Age
Men
Women Grand Total
16-29
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.00%
0.50%
1.50%
Grand Total
60.80% 39.20% 100.00%
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 men under the age of
30.
15%
19%
23%
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 2 steps with 1 images

Recommended textbooks for you

MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc

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
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning

MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc

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
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning

Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON

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
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman