ALSO FIND TEST STATISTIC

PLEASE COMPLETE IN EXCEL SHOWING EXCEL FUNCTION THANK U

Problem 1. Social media users use a variety of devices to access social networking; mobile phones are increasingly popular. However, is there a difference in the various age groups in the proportion of social media users who use their mobile phone to access social networking? A study showed the following results for the different age groups, assume that 200 social media users for each age group were surveyed. Phone to Access AGE social media 18-34 35-64 65+ YES 59% 36% 13% NO 41% 64% 87% a. At the .05 level of significance, is there evidence of a difference among the age groups with respect to use of mobile phone for accessing social networking? b. Determine the p-value in (a) and interpret its meaning. c. If appropriate, use the Marascuilo procedure and alpha=.05 to determine which age groups differ with respect to use of a mobile phone for accessing social networking. d. Discuss the implications of (a) and (c). How can marketers this information to improve their sales return on investment