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)
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 includesample 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)
Trending now
This is a popular solution!
Step by step
Solved in 10 steps