M Case Study Working Professional College magazine was developed for a target audience of recent college graduates who are in theirrst 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 Working Professional. To collect this information, the magazine commissioned a survey to develop a prole of its subscribers. The survey results will be used to help the magazine choose articles of interest and provide advertisers with a prole 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. - Working Professional.>clsx i, Directions Respond in detail to each question. Review the rubric prior to responding. Prepare a managerial report summarizing the results of the survey. In addition to statistical summaries, discuss how the magazine might use these results to attract advertisers. You might also comment on how the survey results could be used by the magazine's editors to identify topics that would be of interest to readers. Your report should address the following issues, but do not limit your analysis to just these areas. 1. Add an additional 10 rows of data to the existing table prior to your analysis. 2. Develop appropriate descriptive statistics to summarize the data. 3. Develop 95% confidence intervals for the mean age and household income of subscribers. 4. Develop 95% confidence intervals for the proportion of subscribers who have broadband access at home and the proportion of subscribers who have children. 5. Would Working Professional be a good advertising outlet for online brokers? Justify your conclusion with statistical data. 6. Would this magazine be a good place to advertise for companies selling educational software and computer games for young children? 7. Provide a comparison and contrast as to the types of articles you believe would and would not be of interest to readers of Working Professionals