How many calls were made by each of these customers

Assignment Help Management Information Sys
Reference no: EM13761873

Questions: For the following questions you should use the - Help_Desk_Spreadsheet_December_Only.xls

Excel file that I have placed on Blackboard. You will create pivot tables using this data to answer the following questions:

1. How many separate customer companies did our help center service? How many calls were made by each of these customers?

2. For all of the calls, for each customer, how many calls were made for each application and what was the average service time for each of the customers for each application? Is there anything interesting that you can see in these results? That is, are there any customers or applications that look different from the others?

3. Next you need to look at a combination of the different applications, the complexity of the problem and the different customers as characteristics and the number of calls and the average service time as key figures. Use this pivot table to answer the following questions:

a. Looking at all companies at once (that is, don't separate out each company), analyze the complexity of the calls and the number of calls and the average service time. Are there any conclusions you can come to?

b. Again, looking at all of the companies at once (i.e. don't separate them), analyze the complexity of the calls for each of the applications and analyze the number of calls and average service time. Are there any conclusions you can come to?

c. Now do the analysis in a and b above for each of the companies. That is for each company answer parts a and b above. Are there any conclusions you can come to? How useful is the data shown in part 3c-b?

Attachment:- help_desk_spreadsheet_december_only-1.xlsx

Reference no: EM13761873

Previous Q& A

  What is intermodulation distortion

What is intermodulation distortion? What sorts of signals are susceptible to this form of distortion?In addition, identify two situations in which error-free transmission is crucial to business processes. Instructions:•Your research essay should be ..

  Paper discussing scope involving project management

Write 3 to 4 page paper discussing scope involving Project management with a few resources

  What is a generic subprogram in java

How do you describe as a type in C++ a pointer to a function that takes two ints as arguments and returns a double. What is a generic subprogram in Java. What are its advantages

  Specific challenges with overlapping of jurisdictions

Identify the specific challenges with overlapping of jurisdictions and propose solution(s) for overcoming these challenges

  Discuss call centre work in relation to key issues

Discuss call centre work in relation to key issues about workers in the knowledge economy and management innovations.

  Frequent shopper program

Hardware platform: Describe the hardware environment to support the development and production of this system.

  Variables into a regression equation

An example of an imaginary quantitative nursing study you would design that would use regression analysis.

  Describe the tax benefits offered in conducting business

From the e-Activity, describe the tax benefits offered in conducting business internationally for the corporation selected. Recommend at least one (1) tax benefit that the U.S. could offer corporations to transfer business back to the U.S. to help..

  Which emerging it trend is currently impacting business

Which emerging IT trend is currently impacting your business or could impact your business in the future? should your organization respond by being an early adopter or wait to see what transpires

  Prepared from calcium phosphate by the reaction

The molar mass for each reactant is shown below the reactant, and the mass of each reactant for this problem is given above. Which reactant is the limiting reagent?

Reviews

Write a Review

 

Similar Q& A

  A key concept in information systems

A Key Concept in Information Systems- Present an overview of the origin and history of the concept that you have chosen

  It governance archetypes and cloud computingwhy can an it

it governance archetypes and cloud computingwhy can an it governance archetype be good for one type of is decision but

  Team issues rigidity and level of boundaries connections in

team issues rigidity and level of boundaries connections in teams boundary spanner use of technology1. examine how

  Supply chain management powerpointafter the initial report

supply chain management powerpointafter the initial report the owners of stone horse supply company john and michael

  How has e-commerce revolutionized commerce

How has e-commerce revolutionized commerce and What is social commerce?

  Differences between an outpatient and an inpatient record

Compare and discuss the differences between an outpatient and an inpatient record. In your discussion, identify the differences in content and explain why these differences are necessary

  Question about information systems managementexplain the

question about information systems managementexplain the concept of web services. how will they effect businesses in

  How ericsson benefitted from amazon web services

Cloud Computing - Assess how Ericsson benefitted from Amazon Web Services (AWS) in terms of cost reduction, automated software updates, remote access, and on-demand availability.

  Develop internally all technology needed for this product

Develop internally all the technology needed for this product that would allow the firm to license it to other industries and Hire an outside design engineering firm to develop the technology needed.

  Show employee development plans

Employee Development Plans: Go Live System, Inc - The new team of developers has been hired, and part of their New Employee Orientation is to meet with you and review their employee development plans. The problem is, you don't have one!

  Ethical issues in information systems

Ethical Issues in Information Systems- Choose one (1) ethics issue, You may also use the Internet or the Strayer Library to research articles on ethical issues in information systems and choose one (1) ethics issue of interest to you

  Write an is plan for njit purpose of the plan and their

write an is plan for njit purpose of the plan and their current it infrastructurewrite an is plan for one of the

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd