Case Problem 1Young Professional Magazine Young Professional magazine was developed for a target audience of recent college graduates who are in their first 10 years in a business/professional career. In its two years of publication, the magazine has been fairly successful. Now the publisher is interested in expanding the magazine’s advertising base. Potential advertisers continually ask about the demographics and interests of subscribers to Young Professional. To collect this information, the magazine commissioned a survey to develop a profile of its subscribers. The survey results will be used to help the magazine choose articles of interest and provide advertisers with a profile of subscribers. As a new employee of the magazine, you have been asked to help analyze the survey results, a portion of which are shown in the following table. Gender Real Estate Purchases? Value of Investments ($) Number of Transactions Broadband Access? Female No 12200 4 Yes Male No 12400 4 Yes Female No 26800 5 Yes Female Yes 19600 6 No Female Yes 15100 5 No Male No 39700 3 Yes Male Yes 21900 2 Yes Female Yes 41900 2 Yes Male Yes 16100 4 Yes Female Yes 18400 11 Yes Female No 33800 3 No Female Yes 15500 6 No Female No 17300 7 Yes Male No 47900 5 Yes Female No 28200 3 No Male Yes 19400 6 No Male Yes 31000 12 No Male No 21300 6 No Female No 21300 10 Yes Female No 21300 7 Yes Female No 34100 6 Yes Male No 32600 7 Yes Male Yes 0 10 Yes Male Yes 20800 10 Yes Female Yes 23100 6 Yes Male No 39800 9 Yes Female No 17900 2 No Male No 33300 2 No Female Yes 21800 8 Yes Male No 54000 7 Yes Female Yes 34800 12 No Female Yes 36100 7 Yes Female Yes 44300 5 Yes Male No 21400 5 No Male Yes 8600 6 Yes Male No 23200 3 No Male No 24800 4 No Female No 26600 5 Yes Male No 33100 8 No Male No 27000 4 No Male No 48700 6 No Female Yes 17100 4 No Male No 19900 6 No Male No 13200 9 No Female Yes 32400 6 No Female No 14200 5 Yes Male No 20100 5 No Male Yes 32000 5 Yes Female No 41900 3 No Male No 12000 3 No Female No 14000 6 No Female No 10000 4 Yes Female No 27200 5 Yes Female Yes 34500 4 Yes Female No 26000 6 Yes Female No 53400 3 Yes Male No 23100 7 Yes Male No 24900 5 No Male No 10900 10 Yes Female No 52500 2 Yes Female No 24600 16 Yes Female No 28800 6 No Female Yes 37300 11 Yes Male Yes 21100 9 Yes Male No 40900 3 No Female No 24700 7 Yes Male No 33600 8 Yes Male Yes 20000 6 No Male No 23900 2 No Male Yes 11700 8 No Female No 19200 5 Yes Male No 11900 6 No Male No 17700 8 Yes Male No 23900 6 Yes Female Yes 27500 4 Yes Male Yes 25300 4 No Female No 66900 5 No Male No 18800 5 Yes Male No 24400 3 Yes Male No 45500 9 Yes Male Yes 54700 3 Yes Female No 32200 4 No Male No 16200 3 Yes Female No 16000 9 No Female Yes 24000 3 No Male No 28800 3 Yes Male No 14100 5 Yes Female Yes 17700 11 Yes Male No 29800 7 Yes Female Yes 27200 3 Yes Male Yes 43000 2 No Female Yes 15500 7 Yes Male Yes 8700 6 No Male No 13900 14 Yes Male No 14200 6 Yes Female Yes 27100 3 No Male Yes 22300 3 No Female Yes 29500 4 Yes Male No 18800 2 Yes Female Yes 26400 9 Yes Male Yes 16400 5 Yes Male No 39500 3 Yes Male Yes 20900 6 Yes Female No 52800 5 Yes Male No 36500 4 Yes Female No 30400 11 Yes Female No 39800 7 No Female Yes 18100 9 No Male Yes 69500 7 No Female No 33000 5 Yes Female Yes 32100 3 No Male Yes 15200 8 No Female Yes 49800 3 Yes Male No 28100 6 No Male No 15200 6 Yes Male No 30800 3 Yes Male No 21200 3 No Male No 24600 4 Yes Male Yes 24700 9 Yes Female Yes 26300 16 No Female Yes 32200 6 No Male No 20300 6 Yes Female No 60900 6 Yes Male No 15800 11 Yes Female No 31700 6 Yes Male Yes 0 5 Yes Female Yes 20900 9 Yes Female No 37900 12 No Male Yes 22400 7 Yes Male No 26600 5 Yes Male Yes 20800 10 No Male No 31100 7 Yes Male No 31200 5 Yes Male No 0 2 No Male Yes 38900 7 Yes Male Yes 29500 4 Yes Male No 16100 5 No Male No 15800 7 Yes Male No 27500 4 Yes Female No 13000 7 No Male Yes 68100 5 No Male Yes 18500 7 Yes Female No 27100 2 Yes Female No 25900 5 Yes Male No 18400 2 No Female No 59200 4 Yes Female No 67900 5 No Female No 36700 7 Yes Female No 32400 9 Yes Female Yes 10300 4 Yes Male No 39300 7 Yes Female No 13800 6 Yes Male No 11100 4 Yes Female No 28600 2 No Male No 22100 6 Yes Female No 16700 6 Yes Female Yes 19400 6 Yes Male Yes 54600 4 Yes Female Yes 41500 2 Yes Female No 23300 9 No Male No 29700 8 Yes Male Yes 33200 2 Yes Male Yes 56300 5 No Female No 25900 5 Yes Female Yes 63500 6 Yes Male Yes 18700 7 Yes ) Develop appropriate descriptive statistics to summarize the data. For quantitative variables, you should include sample size, mean, Standard Error of the Mean, Standard Deviation and Minimum and Maximum. For qualitative variables, you should include the sample size, response of interest, count of response, and proportion of response (I need this answered completely and step by step using minitab or excel)

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
Topic Video
Question

Case Problem 1Young Professional Magazine

Young Professional magazine was developed for a target audience of recent college graduates who are in their first 10 years in a business/professional career. In its two years of publication, the magazine has been fairly successful. Now the publisher is interested in expanding the magazine’s advertising base. Potential advertisers continually ask about the demographics and interests of subscribers to Young Professional. To collect this information, the magazine commissioned a survey to develop a profile of its subscribers. The survey results will be used to help the magazine choose articles of interest and provide advertisers with a profile of subscribers. As a new employee of the magazine, you have been asked to help analyze the survey results, a portion of which are shown in the following table.

Gender

Real Estate Purchases?

Value of Investments ($)

Number of Transactions

Broadband Access?

Female

No

12200

4

Yes

Male

No

12400

4

Yes

Female

No

26800

5

Yes

Female

Yes

19600

6

No

Female

Yes

15100

5

No

Male

No

39700

3

Yes

Male

Yes

21900

2

Yes

Female

Yes

41900

2

Yes

Male

Yes

16100

4

Yes

Female

Yes

18400

11

Yes

Female

No

33800

3

No

Female

Yes

15500

6

No

Female

No

17300

7

Yes

Male

No

47900

5

Yes

Female

No

28200

3

No

Male

Yes

19400

6

No

Male

Yes

31000

12

No

Male

No

21300

6

No

Female

No

21300

10

Yes

Female

No

21300

7

Yes

Female

No

34100

6

Yes

Male

No

32600

7

Yes

Male

Yes

0

10

Yes

Male

Yes

20800

10

Yes

Female

Yes

23100

6

Yes

Male

No

39800

9

Yes

Female

No

17900

2

No

Male

No

33300

2

No

Female

Yes

21800

8

Yes

Male

No

54000

7

Yes

Female

Yes

34800

12

No

Female

Yes

36100

7

Yes

Female

Yes

44300

5

Yes

Male

No

21400

5

No

Male

Yes

8600

6

Yes

Male

No

23200

3

No

Male

No

24800

4

No

Female

No

26600

5

Yes

Male

No

33100

8

No

Male

No

27000

4

No

Male

No

48700

6

No

Female

Yes

17100

4

No

Male

No

19900

6

No

Male

No

13200

9

No

Female

Yes

32400

6

No

Female

No

14200

5

Yes

Male

No

20100

5

No

Male

Yes

32000

5

Yes

Female

No

41900

3

No

Male

No

12000

3

No

Female

No

14000

6

No

Female

No

10000

4

Yes

Female

No

27200

5

Yes

Female

Yes

34500

4

Yes

Female

No

26000

6

Yes

Female

No

53400

3

Yes

Male

No

23100

7

Yes

Male

No

24900

5

No

Male

No

10900

10

Yes

Female

No

52500

2

Yes

Female

No

24600

16

Yes

Female

No

28800

6

No

Female

Yes

37300

11

Yes

Male

Yes

21100

9

Yes

Male

No

40900

3

No

Female

No

24700

7

Yes

Male

No

33600

8

Yes

Male

Yes

20000

6

No

Male

No

23900

2

No

Male

Yes

11700

8

No

Female

No

19200

5

Yes

Male

No

11900

6

No

Male

No

17700

8

Yes

Male

No

23900

6

Yes

Female

Yes

27500

4

Yes

Male

Yes

25300

4

No

Female

No

66900

5

No

Male

No

18800

5

Yes

Male

No

24400

3

Yes

Male

No

45500

9

Yes

Male

Yes

54700

3

Yes

Female

No

32200

4

No

Male

No

16200

3

Yes

Female

No

16000

9

No

Female

Yes

24000

3

No

Male

No

28800

3

Yes

Male

No

14100

5

Yes

Female

Yes

17700

11

Yes

Male

No

29800

7

Yes

Female

Yes

27200

3

Yes

Male

Yes

43000

2

No

Female

Yes

15500

7

Yes

Male

Yes

8700

6

No

Male

No

13900

14

Yes

Male

No

14200

6

Yes

Female

Yes

27100

3

No

Male

Yes

22300

3

No

Female

Yes

29500

4

Yes

Male

No

18800

2

Yes

Female

Yes

26400

9

Yes

Male

Yes

16400

5

Yes

Male

No

39500

3

Yes

Male

Yes

20900

6

Yes

Female

No

52800

5

Yes

Male

No

36500

4

Yes

Female

No

30400

11

Yes

Female

No

39800

7

No

Female

Yes

18100

9

No

Male

Yes

69500

7

No

Female

No

33000

5

Yes

Female

Yes

32100

3

No

Male

Yes

15200

8

No

Female

Yes

49800

3

Yes

Male

No

28100

6

No

Male

No

15200

6

Yes

Male

No

30800

3

Yes

Male

No

21200

3

No

Male

No

24600

4

Yes

Male

Yes

24700

9

Yes

Female

Yes

26300

16

No

Female

Yes

32200

6

No

Male

No

20300

6

Yes

Female

No

60900

6

Yes

Male

No

15800

11

Yes

Female

No

31700

6

Yes

Male

Yes

0

5

Yes

Female

Yes

20900

9

Yes

Female

No

37900

12

No

Male

Yes

22400

7

Yes

Male

No

26600

5

Yes

Male

Yes

20800

10

No

Male

No

31100

7

Yes

Male

No

31200

5

Yes

Male

No

0

2

No

Male

Yes

38900

7

Yes

Male

Yes

29500

4

Yes

Male

No

16100

5

No

Male

No

15800

7

Yes

Male

No

27500

4

Yes

Female

No

13000

7

No

Male

Yes

68100

5

No

Male

Yes

18500

7

Yes

Female

No

27100

2

Yes

Female

No

25900

5

Yes

Male

No

18400

2

No

Female

No

59200

4

Yes

Female

No

67900

5

No

Female

No

36700

7

Yes

Female

No

32400

9

Yes

Female

Yes

10300

4

Yes

Male

No

39300

7

Yes

Female

No

13800

6

Yes

Male

No

11100

4

Yes

Female

No

28600

2

No

Male

No

22100

6

Yes

Female

No

16700

6

Yes

Female

Yes

19400

6

Yes

Male

Yes

54600

4

Yes

Female

Yes

41500

2

Yes

Female

No

23300

9

No

Male

No

29700

8

Yes

Male

Yes

33200

2

Yes

Male

Yes

56300

5

No

Female

No

25900

5

Yes

Female

Yes

63500

6

Yes

Male

Yes

18700

7

Yes

  1. ) Develop appropriate descriptive statistics to summarize the data. For quantitative variables, you should include sample size, mean, Standard Error of the Mean, Standard Deviation and Minimum and Maximum. For qualitative variables, you should include the sample size, response of interest, count of response, and proportion of response

(I need this answered completely and step by step using minitab or excel)

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 10 steps

Blurred answer
Knowledge Booster
Data Collection, Sampling Methods, and Bias
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
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