Write a data analysis report

Assignment Help Management Theories

Reference no: EM131142178 , Length: word count:2500

Foundations of Business Analysis Assignment

Case Study - Computers R Us

Computers R Us, a computer manufacturer and retailer has recently launched a service and repair division, CompleteCare, for its portable/laptop/notebook computers. This division promises to provide a rapid response to customer technical enquiries and warranty repairs.

However, the division is experiencing:

-a shortage of trained technical operators in its telephone centre;

-distribution problems; and

-parts availability problems.

As a result, Computers R Us has received multiple complaints about CompleteCare at the Computers R Us call centre.

To address these issues, a research proposal was prepared and the research overseen by the management of Computers R Us. It was found that customer satisfaction was a contributing factor to the issues experienced in the CompleteCare division. Consequently, the management of Computers R Us have developed several possible initiatives to improve customer satisfaction to a minimum level of 7 out of 10. These initiatives include: decreasing response times in the CompleteCare division, increasing methods of communication between Computers R Us and its customers, the level of advice CompleteCare staff provide on Computers R Us products and services, and a new loyalty rewards program. Management is interested to know which of these strategies is considered the most effective by Computers R Us customers.

A member of your team has already collected data that can be used for this analysis. To collect this data, a simple random sample of 500 customers was selected. Of the 500 customers to whom surveys were sent, 420 responded. The survey used to collect this data is provided below and the survey responses have been collated in the CompleteCare.xls Excel file. You are required to write a report after performing an analysis on the data collected from the customers of Computers R Us.

A member of your team has suggested that, when you perform this analysis, you should undertake a series of hypothesis tests to examine the following:

1. Does the current level of customer satisfaction differ from management's goal of 7 out of 10?

2. Is there any difference between the satisfaction of male and female customers with the level of communication with staff and management at Computers R Us?

3. Are there any differences in the overall customer satisfaction across the following age groups: 1, 2, 3, 4 and 5?

4. Is there any difference in customer satisfaction between responses to the initiatives of 'decreasing response times in the CompleteCare division' and 'the loyalty rewards program at Computers R Us'?

5. Do any of the initiatives of 'decreasing response times in the CompleteCare division', 'the level of advice CompleteCare staff provide on Computers R Us products and services', 'the level of communication with staff and management' and 'new loyalty rewards program' influence the overall satisfaction of Computers R Us customers?

Required: Write a data analysis report that provides the results to each of the five hypothesis tests above and make overall recommendations to Computers R Us that management can use for future business decision-making. Based on your analysis relating to these hypotheses, your report should focus on two key issues: the current degree of customer satisfaction and the strategy or strategies that would be most effective to increase customer satisfaction.

Attachment:- Assignment.rar

Reference no: EM131142178

Questions Cloud

What conclusions can be drawn from these data as to the comp : What conclusions can be drawn from these data as to the company's ability to meet its currently maturingdebts?

Determine equilibrium flows and travel times : Determine equilibrium flows and travel times before and after reconstruction begins - User equilibrium conditions exist before and during reconstruction.

Draw the production possibilities curves for the two region : Assume each region has 240,000 worker hours to divide between producing cars and television shows. Initially, assume workers are divided equally between producing cars and television shows.

Write a justification for capital purchase to your president : Write a justification for capital purchase (750-1,000 words) to your vice president as to why this would be a good investment for the hospital.

Write a data analysis report : Write a data analysis report that provides the results to each of the five hypothesis tests above and make overall recommendations to Computers R Us that management can use for future business decision-making

What will the total person hours of travel : What will the total person hours of travel be if the lane and open to vehicles with 3 or more occupants only?

How would you expect the price elasticity of demand : How would you expect the price elasticity of demand for health care to vary with health status? Would the demand for health care increase or decrease with an improvement in educational attainment in the community?

Which country has a comparative advantage in wine : If you continue with the example of Problem 1, which country has an absolute advantage in wine? in wool? Which country has a comparative advantage in wine? in wool?

Discuss team-based approaches to delivery of health services : Write a paper of 1,200-1,500 words that discusses the team-based approaches to the delivery of health services. The focus of the paper should be one type of health care environment.

User Account

All Pages