Young Professional Magazine 1 Young Professional Mogazine was developed for a target audience of recent college graduates who are in their 2 first 10 years of 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 34 continually asks obout the demographics and interests of subscribers to Young Professional. To collect this 35 information, the magazine commissioned a survey to develop a profile of its subscribers. The survey results will 36 be used to help the magazine choose articles of interest and provide advertisers with a profile of subscribers. 37 As a new employee of the magazine, you have been asked to analyze the survey results, a portion of which 38 are shown in the tab Young Professional (first 25 responses). 39 40 Perform the following: 41 Develop appropriate descriptive statistics to summarize the data (quantitative and categorical). 42 Based on the results, answer the following questions: 43 (a) Would Young Professional be a good advertising outlet for online brokers and why? 44 (b) Would Young Professional be a good place to advertise for companies selling educational software and computer games for young children and why? Quantitative (Use various descriptive statistics formulas on age, investments, H of transactions, and household income). 48 Cotegorical (Use COUNTIF to determine male vs. female, yes vs. no plan real estate purchase, yes vs. no 49 broodband access, yesvs. no children / split into \%s). 50 Alternatively, consider using the Data Analysis pack within Excel