90.2K

Verified Solution

Link Copied!

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. The publisher is interested in expanding the magazines advertising base. Potential advertisers are interested in 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. Some of the survey questions include: 1. What is your age? 2. What is your gender? 3. Do you plan to make any real estate purchases in the next two years? (Yes/No) 4. What is the approximate total value of financial investments, exclusive of your home, owned by you or members of your household? 5. How many stock/bond/mutual fund transactions have you made in the past year? 6. Do you have broadband access to the Internet at home? (Yes/No) 7. What was your total household income last year? 8. Do you have children? (Yes/No) The file Professional.xlsx contains the responses to these questions. As a new employee in the advertising team at the magazine, you have been asked to help analyze the survey results. Your assignment: Prepare a formal report summarizing the results of the survey. Explain how the magazine might use these results to attract advertisers. Comment on how the survey results could be used by the magazines editors to identify topics that would be of interest to readers. Your report should also include the following items: a. A summary of the data using appropriate descriptive statistics. Use a table. b. 95% confidence intervals for the mean age and household income of subscribers c. 95% confidence intervals for (1) the proportion of subscribers who have broadband access at home, and (2) the proportion of subscribers who have children d. Would Young Professional be a good advertising outlet for online brokerage firms? Justify your conclusion using the statistical data provided

CIS370 Business Analytics e. Would Young Professional be a good place to advertise for companies selling educational software and computer games for young children? Again, justify your conclusion using the statistical data provided. f. What other specific companies do you think should advertise in Young Professional? Dont repeat your answers from parts d and e above. Use the statistical data provided to support your recommendation. g. What other articles or topics might be of interest to the readers of Young Professional? Dont repeat your answers from parts d and e above. Use the statistical data provided support your recommendation. The report should be written with complete sentences and follow standard APA style, with 1.5 line spacing, 11-point font (Times New Roman preferred) and one-inch margins. Figures, tables and other exhibits (if used) should be clearly labeled and referenced. The report should also conform to standard spelling, grammar, and punctuation. Suggestions regarding readability: Include tables, graphs, illustrations, maps, etc. as appropriate to aid understanding Tables and other exhibits can be placed at the end of the paper, or embedded in the main text (your choice) Use headings and sub-headings to break-up the body of the main text Use bold, italic, or underlined fonts to highlight important concepts Use bullets or numbered lists to summarize information as appropriate

Sample of full excel sheet:

Age	Gender	Real Estate Purchases?	Value of Investments ($)	Number of Transactions	Broadband Access?	Household Income ($)	Have Children?
38	Female	No	12200	4	Yes	75200	Yes
30	Male	No	12400	4	Yes	70300	Yes
41	Female	No	26800	5	Yes	48200	No
28	Female	Yes	19600	6	No	95300	No
31	Female	Yes	15100	5	No	73300	Yes
32	Male	No	39700	3	Yes	123400	Yes
32	Male	Yes	21900	2	Yes	73900	Yes
26	Female	Yes	41900	2	Yes	54300	Yes
26	Male	Yes	16100	4	Yes	93100	No
34	Female	Yes	18400	11	Yes	60100	No
33	Female	No	33800	3	No	48600	No
35	Female	Yes	15500	6	No	43500	No
28	Female	No	17300	7	Yes	73600	Yes
30	Male	No	47900	5	Yes	68200	Yes

Answer & Explanation Solved by verified expert

See Answer