should be structured as typed report with your full name and title that includes the relevant da any graphs/charts (pasted from your Excel work) that you feel is appropriate to visually support answers. The management report should not include the raw data and calculations as these di be in your Excel file. You may use the same type of table used for Chapter 8 lab that follows with appropriate calcw however you cannot use Excel's Descriptive Statistic Tool. Descriptive Statistic Total Responses (count) Count Male Count Female Proportion Male Proportion Female Age Income Mean Mode Median Standard Deviation Confidence Coefficient Alpha Margin of Error Point Estimate Lower Limit Upper Limit Children Broadband Count Proportion Confidence Coefficient Alpha/2 NORMSINVI 1-(alpha/2)) Chapters A A A ? Managerial Report Prepare a managerial report ( summarizing the results of the survey. In addition to statistical A-Z 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. Develop appropriate descriptive statistics to summarize the data. 2. Develop 95% confidence intervals for the mean age and household income of summarize the data. 2. Develop 95 % confidence intervals for the mean age and A-Z rn household income of subscribers. Prc 3. Develop 95% confidence intervals for the proportion of Edi ctie subscribers who have Internet tio access at home and the proportion of subscribers who have children. e of ents 4. Would Young Professional be a good advertising outlet for online brokers? Justify your 12 12 26 conclusion with statistical data. 196 151 5. Would this magazine be a good 397 place to advertise for 219 companies selling educational software and computer games for young children? 4190 161C 1840 3380 al 6. Comment on the types of 1550 articles you believe would be of interest to readers of Young Professional. 1730C 47900 28200 19400 31000 21300 should be structured as typed report with your full name and title that includes the relevant da any graphs/charts (pasted from your Excel work) that you feel is appropriate to visually support answers. The management report should not include the raw data and calculations as these di be in your Excel file. You may use the same type of table used for Chapter 8 lab that follows with appropriate calcw however you cannot use Excel's Descriptive Statistic Tool. Descriptive Statistic Total Responses (count) Count Male Count Female Proportion Male Proportion Female Age Income Mean Mode Median Standard Deviation Confidence Coefficient Alpha Margin of Error Point Estimate Lower Limit Upper Limit Children Broadband Count Proportion Confidence Coefficient Alpha/2 NORMSINVI 1-(alpha/2)) Chapters A A A ? Managerial Report Prepare a managerial report ( summarizing the results of the survey. In addition to statistical A-Z 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. Develop appropriate descriptive statistics to summarize the data. 2. Develop 95% confidence intervals for the mean age and household income of summarize the data. 2. Develop 95 % confidence intervals for the mean age and A-Z rn household income of subscribers. Prc 3. Develop 95% confidence intervals for the proportion of Edi ctie subscribers who have Internet tio access at home and the proportion of subscribers who have children. e of ents 4. Would Young Professional be a good advertising outlet for online brokers? Justify your 12 12 26 conclusion with statistical data. 196 151 5. Would this magazine be a good 397 place to advertise for 219 companies selling educational software and computer games for young children? 4190 161C 1840 3380 al 6. Comment on the types of 1550 articles you believe would be of interest to readers of Young Professional. 1730C 47900 28200 19400 31000 21300