{"id":5279,"date":"2023-02-25T21:45:17","date_gmt":"2023-02-25T21:45:17","guid":{"rendered":"https:\/\/www.goodacademic.com\/blog\/questions\/case-study-survey-analysis\/"},"modified":"2023-02-25T21:45:17","modified_gmt":"2023-02-25T21:45:17","slug":"case-study-survey-analysis","status":"publish","type":"questions","link":"https:\/\/www.goodacademic.com\/blog\/questions\/case-study-survey-analysis\/","title":{"rendered":"Case study \u2013 Survey Analysis"},"content":{"rendered":"

 <\/p>\n

This case study will grant you the opportunity to utilize your critical thinking and data analysis skills. In business, surveys are often a common way to gauge consumer sentiment. In the provided data set, you will analyze Excel data gathered from a customer satisfaction survey for those who completed a rebate program. You will analyze the data collected using the Excel skills that we have been cultivating in our course.<\/p>\n

Instructions:<\/h1>\n
    \n
  1. Open the Excel file Case Study.xlsx<\/u><\/a> Download Case Study.xlsx<\/a>.<\/li>\n
  2. Calculate the frequencies for all the respondents for each question (column B to N).\n
      \n
    1. For categorical data, use the countif or filter function compute (i.e. gender, marital status, etc).<\/li>\n<\/ol>\n<\/li>\n
    2. Create a separate chart demonstrating the survey responses for each question<\/strong><\/u> (Column B to N). Sample charts may include pie charts, bar charts, column charts, and line charts.<\/li>\n
    3. For the age question (Column D), compute the average, minimum, and maximum ages of respondents.<\/li>\n
    4. For column I, the likelihood to recommend the program to a friend, compute the average, median, minimum, and maximum values for customer rankings for respondents.<\/li>\n
    5. For column J, the likelihood to participate in another rebate program, compute the average, median, minimum, and maximum values for customer rankings for respondents.<\/li>\n
    6. For column K, the likelihood of purchase without the rebate program, compute the average, median, minimum, and maximum values for customer rankings for respondents.<\/li>\n
    7. Provide a detailed report in Microsoft PowerPoint or Microsoft Word enumerating your findings. Your analysis must contain the below details:\n
        \n
      1. Identify in your report appropriate charts and graphs showing the results.<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n
          \n
        • What conclusions can you draw from the existing rebate programs? (Example: Do you find any similarity in age groups or their educational background making any significant impact on their rebate usage?)\n
            \n
          1. How can the programs improve? (Is there a group that doesn\u2019t show much interest in the program? Can you think of a way to grab their attention?)<\/li>\n
          2. What recommendations do you have for the company offering rebates?<\/li>\n<\/ol>\n<\/li>\n<\/ul>\n

            You should target this report to be around ten to twelve pages\/slides with appropriate graphs. Please make sure that you are succinct in your report.<\/p>\n

              \n
            1. Submit your Excel file with the calculations for 1-7 of the instructions, and your report in PowerPoint or Word on Canvas.<\/li>\n
            2. Please note that this is an individual effort and is not to be done in teams.<\/li>\n<\/ol>\n

              Rubric<\/h1>\n
                \n
              1. Frequency calculations (1 pt per question 13 points)<\/li>\n
              2. Chart per question (13 questions)<\/li>\n
              3. Age calculations (4 points one point per calculation)<\/li>\n
              4. Columns I, J, and K calculations (12 points, one per calculation)<\/li>\n
              5. Report & Discussion (Findings \u2013 30 points, Recommendations \u2013 38 points) (68 points)<\/li>\n<\/ol>\n

                Total Points: 110<\/p>\n","protected":false},"excerpt":{"rendered":"

                  This case study will grant you the opportunity to utilize your critical thinking and data analysis skills. In business, surveys are often a common way to gauge consumer sentiment. In the provided data set, you will analyze Excel data gathered from a customer satisfaction survey for those who completed a rebate program. You will […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":[],"disciplines":[188],"paper_types":[],"tagged":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/questions\/5279"}],"collection":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/questions"}],"about":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/types\/questions"}],"author":[{"embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/comments?post=5279"}],"version-history":[{"count":0,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/questions\/5279\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/media?parent=5279"}],"wp:term":[{"taxonomy":"disciplines","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/disciplines?post=5279"},{"taxonomy":"paper_types","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/paper_types?post=5279"},{"taxonomy":"tagged","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/tagged?post=5279"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}