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)

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

) 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)