{"id":521,"date":"2015-07-21T22:39:10","date_gmt":"2015-07-21T12:39:10","guid":{"rendered":"http:\/\/casestudyhelp.com\/sample-questions\/?p=521"},"modified":"2025-03-05T18:15:47","modified_gmt":"2025-03-05T07:15:47","slug":"business-analysis-assignment-help","status":"publish","type":"post","link":"https:\/\/casestudyhelp.com\/sample-questions\/business-analysis-assignment-help\/","title":{"rendered":"BUSINESS ANALYSIS ASSIGNMENT HELP"},"content":{"rendered":"

Foundations of Business Analysis<\/strong><\/p>\n

Assignment 2 :-<\/strong>Weight: 50% (<\/strong>Total Marks: 100)<\/strong>\u00a0<\/strong><\/p>\n

Submission instructions:<\/strong><\/p>\n

    \n
  1. Maximum word length: 3000 words (excluding references, tables and figures).<\/li>\n
  2. Submit a soft copy in Word format on dashboard portal (with an assignment cover sheet).<\/li>\n
  3. Assignments submitted by other means (e.g. email) or forms (scanned copy, Excel document)<\/li>\n<\/ol>\n

    will attract no marks.<\/p>\n

    Case Study \u2013 Computers R Us<\/strong><\/p>\n

    Computers R Us, a computer manufacturer and retailer has recently launched a service and repair<\/p>\n

    division, CompleteCare, for its portable\/laptop\/notebook computers. This division promises to<\/p>\n

    provide a rapid response to customer technical enquiries and warranty repairs.<\/p>\n

    However, the division is experiencing:<\/p>\n

    – a shortage of trained technical operators in its telephone centre;<\/p>\n

    – distribution problems; and<\/p>\n

    – parts availability problems.<\/p>\n

    As a result, Computers R Us has received multiple complaints about Complete Care at the Computers<\/p>\n

    R Us call centre.<\/p>\n

    To address these issues, a research proposal was prepared (Assignment 1) and the research<\/p>\n

    overseen by the management of Computers R Us. It was found that customer satisfaction was a<\/p>\n

    contributing factor to the issues experienced in the Complete Care division. Consequently, the<\/p>\n

    management of Computers R Us have developed several possible initiatives to improve customer<\/p>\n

    satisfaction to a minimum level of 7 out of 10. These initiatives include: decreasing response times in<\/p>\n

    the Complete Care division, training and continuous education for staff on products and services to<\/p>\n

    assist customers, increasing methods of communication between Computers R Us and its customers<\/p>\n

    and a new loyalty rewards program. Management is interested to know which of these strategies is<\/p>\n

    considered the most effective by Computers R Us customers.<\/p>\n

    A member of your team has already collected data that can be used for this analysis. To collect this<\/p>\n

    data, a simple random sample of 500 customers was selected. Of the 500 customers to whom<\/p>\n

    surveys were sent, 420 responded. The survey used to collect this data is provided below and the<\/p>\n

    survey responses have been collated in the Complete Care.xls Excel file. You are required to write a<\/p>\n

    report after performing an analysis on the data collected from the customers of Computers R Us.<\/p>\n

    A member of your team has suggested that, when you perform this analysis, you should undertake a<\/p>\n

    series of hypothesis tests to examine the following:<\/p>\n

      \n
    1. Does the current level of customer satisfaction differ from management\u2019s goal of 7 out of\u00a010?<\/li>\n<\/ol>\n
        \n
      1. Is there any difference between the overall satisfaction of male and female customers at\u00a0Computers R Us?<\/li>\n<\/ol>\n
          \n
        1. Are there any differences in overall customer satisfaction across the following age groups:<\/li>\n<\/ol>\n

          20 and below, 21\u201330, 31\u201340, 41\u201350, 51 and over?<\/p>\n

            \n
          1. Is there any difference in customer satisfaction between responses to the initiatives of<\/li>\n<\/ol>\n

            \u2018decreasing response times in the CompleteCare division\u2019 and the \u2018new loyalty rewards\u00a0program\u2019?<\/p>\n

              \n
            1. Are any of the initiatives proposed by management related to the overall satisfaction of\u00a0Computers R Us customers?<\/li>\n<\/ol>\n

              \"Hire<\/a><\/p>\n

              Required:<\/strong><\/p>\n

              Write a data analysis report that provides the results to each of the five hypothesis tests above and<\/p>\n

              make overall recommendations to Computers R Us that management can use for future business<\/p>\n

              decision-making. Based on your analysis relating to these hypotheses, your report should focus on<\/p>\n

              two key issues: the current degree of customer satisfaction and the strategy or strategies that would<\/p>\n

              be most effective to increase customer satisfaction.<\/p>\n

              Customer Satisfaction Survey\u00a0<\/strong>\u00a0<\/strong><\/p>\n

              Section 1: Personal information<\/strong><\/p>\n

              Please complete the following information about yourself.<\/p>\n

              Question 1 <\/strong>\u2013 What is your gender?<\/p>\n

              Male Female<\/p>\n

              Question 2 \u2013 <\/strong>Please check the box that indicates your age group.<\/p>\n

              20 years and below<\/p>\n

              21\u201330 years<\/p>\n

              31\u201340years<\/p>\n

              41\u201350 years<\/p>\n

              51 and over<\/p>\n

              Section 2: Current Customer Satisfaction<\/strong>\u00a0<\/strong><\/p>\n

              Question 3 \u2013 <\/strong>Have you experienced any problems with the Complete Care division? Yes No<\/p>\n

              Question 4 <\/strong>\u2013 Overall, I am satisfied as a customer of Computers R Us.<\/p>\n

              Please circle the number that corresponds with your level of agreement with the statement below.<\/p>\n

              Strongly Disagree = 1 and Strongly Agree = 10<\/p>\n

              1 2 3 4 5 6 7 8 9 10<\/p>\n

              Section 3: Determinants of Customer Satisfaction<\/strong><\/p>\n

              Please circle the number that corresponds with your level of agreement with statements below.<\/p>\n

              Strongly Disagree = 1 and Strongly Agree = 10<\/p>\n

              Question 5 <\/strong>\u2013 I am satisfied with the response time of the Complete Care division.<\/p>\n

              1 2 3 4 5 6 7 8 9 10<\/p>\n

              Question 6 <\/strong>\u2013 I am satisfied with the level of advice Complete Care staff provide on Computers R Us<\/p>\n

              products and services.<\/p>\n

              1 2 3 4 5 6 7 8 9 10<\/p>\n

              Question 7 <\/strong>\u2013 I am satisfied with the level of communication with staff and management at<\/p>\n

              Computers R Us.<\/p>\n

              1 2 3 4 5 6 7 8 9 10<\/p>\n

              Question 8 <\/strong>\u2013 I am satisfied with the loyalty rewards program at Computers R Us.<\/p>\n

              1 2 3 4 5 6 7 8 9 10<\/p>\n

              Report Structure<\/strong>\u00a0<\/strong><\/p>\n

              Executive Summary<\/strong><\/p>\n

              This section should provide a brief overview of the data analysis report. You should discuss the<\/p>\n

              subject matter, the method of analysis, the findings and recommendations and any limitations of the<\/p>\n

              report. It is suggested that the Executive Summary should be the last section that you write.<\/p>\n

              Introduction<\/strong><\/p>\n

              Provide a brief background to the case to put your analysis in context. Provide a discussion of the<\/p>\n

              objectives of your analysis.<\/p>\n

              Research Design<\/strong><\/p>\n

              Discuss the data collection process and the sampling procedures that were applied. In this section,<\/p>\n

              you should also outline the ethical considerations that would have been taken into account when<\/p>\n

              collecting data from this survey and reporting your results. This section should include references<\/p>\n

              from at least three credible sources, such as textbooks or journal articles.<\/p>\n

              Analysis<\/strong><\/p>\n

              Synthesis the hypothesis test results as they relate to the two key research questions. Report the<\/p>\n

              conclusions that can be derived from this analysis.<\/p>\n

              Recommendations<\/strong><\/p>\n

              Briefly summarize your results and provide recommendations to Computers R Us. Bullet points can<\/p>\n

              be used for the recommendations.<\/p>\n

              Referencing style<\/strong><\/p>\n

              American Psychological Association (APA) 6th Edition. You can find helpful examples of APA 6th ed.<\/p>\n

              citation in pp 27\u201341 of the 2015 NBS Postgraduate Student Manual as well as at<\/p>\n

              https:\/\/www.apastyle.org\/index.aspx.<\/span><\/p>\n

              Appendix: Hypothesis Testing<\/strong><\/p>\n

              For each hypothesis you should:<\/p>\n

                \n
              1. a) State the null and alternative hypotheses.<\/li>\n
              2. b) Select an appropriate statistical test and briefly justify your selection.<\/li>\n
              3. c) Perform the appropriate test using Microsoft Excel.<\/li>\n
              4. d) Report the results of your analysis (including test statistic and p-value).<\/li>\n
              5. e) Provide a brief interpretation (both statistical and non-statistical) of the results.<\/li>\n<\/ol>\n

                An example is provided below.<\/p>\n

                Hypothesis Testing Example<\/strong><\/p>\n

                Question: How much are potential patrons willing to pay for the entr\u00e9es? Is the $18 amount from<\/p>\n

                the forecasting model the correct value to use when setting food prices?<\/p>\n

                Appendix 1: Average patron expenditure<\/strong><\/p>\n

                H0: The average amount patrons are willing to spend on the entr\u00e9e course is equal to $18<\/p>\n

                HA: The average amount patrons are willing to spend on the entr\u00e9e course is not equal to $18<\/p>\n

                A one-sample t<\/em>-test is used, as this is the appropriate test to compare the difference between one<\/p>\n

                variable and a pre-determined mean (Zikmund, Babin, Carr, & Griffin, 2012, p. 520). The results from<\/p>\n

                this one-sample t-test <\/em>are shown below:<\/p>\n

                Table 1: One-sample t-test for difference in patron expenditure<\/strong><\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
                <\/td>\nVariable 1<\/em><\/td>\nVariable 2<\/em><\/td>\n<\/tr>\n
                Mean<\/td>\n20.14118<\/td>\n18<\/td>\n<\/tr>\n
                Variance<\/td>\n91.85022<\/td>\n0<\/td>\n<\/tr>\n
                Observations<\/td>\n340<\/td>\n340<\/td>\n<\/tr>\n
                Hypothesized Mean<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
                Difference<\/td>\n0<\/td>\n<\/td>\n<\/tr>\n
                Df<\/td>\n339<\/td>\n<\/td>\n<\/tr>\n
                t Stat<\/td>\n4.119569<\/td>\n<\/td>\n<\/tr>\n
                P(T<=t) one-tail<\/td>\n2.39E-05<\/td>\n<\/td>\n<\/tr>\n
                t Critical one-tail<\/td>\n1.649361<\/td>\n<\/td>\n<\/tr>\n
                P(T<=t) two-tail<\/td>\n4.77E-05<\/td>\n<\/td>\n<\/tr>\n
                t Critical two-tail<\/td>\n1.966986<\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

                 <\/p>\n

                From Table 1, it is evident that we can reject that null hypothesis that the average patron is willing to<\/p>\n

                pay $18 for their entr\u00e9e (p-value 0.0000477). As the average expenditure is greater than $18<\/p>\n

                ($20.14), this value should be used when pricing food in the restaurant.<\/p>\n

                Word count (excluding tables): 107<\/p>\n

                References<\/strong><\/p>\n

                Zikmund, W., Babin, B., Carr, J., & Griffin, M. (2012). Business research methods <\/em>(9th ed.): Cengage<\/p>\n

                Learning.<\/p>\n

                 <\/p>\n

                To get solution chat with online assignment adviser<\/strong><\/p>\n

                \"Order<\/a><\/p>\n

                Ask Your Assignment Help for Financial Statement Analysis<\/a>\u00a0?<\/strong>
                \nCheck out our\u00a0                Corporate Finance Assignment Help Service<\/a><\/strong>
                \nFind Your\u00a0                Assignment Experts for MBA<\/a><\/strong><\/p>\n