biam 510 week 5 case study

Get perfect grades by consistently using Place your order and get a quality paper today. Take advantage of our current 20% discount by using the coupon code GET20

Order a Similar Paper Order a Different Paper

You will need to complete the following items before you start your five tasks for this case study. An example of a a completed case study is attached.

  • Check out Figure 10-3 – attached.
  • Read attached pages 363–363.
  • Print out Figure 10-3, and find the estimated median tenure. (Hint: See Figure 10-2 on the previous page.)

Task 1: (a) What is your estimated median tenure? (b) How did you generate it? (c) How long has our longest tenured customer been with the company? (d) What would you tell a senior manager with little or no statistical background is its meaning (three or four sentences at most)?

Task 2: Satisfy yourself that the original distribution data should be approximately as follows. Percent Survival Tenure (Years)

100 0
87 1
75 2
68 3
60 4
55 5
53 6
50 7
49 8
47 9
45 10
45 11
45 12

Describe the method used to satisfy yourself.

Task 3: Reread the paragraph above Figure 10-4. The author talks about the 10-year average lifetime of each group as being 6.1 and 3.7 years. It might appear that he just pulled the numbers out of the air, but he actually described how to calculate them earlier in the paragraphs above and below Figure 10-3. We are going to duplicate this approach using Excel. Use the Excel file tenure.xlsx in Files. Check out the first set of columns. It represents the curve in Figure 10-3. Using the same method you used to satisfy yourself in Task 2, fill in the two empty columns and compute the average customer lifetime during the first 10 years. Don’t worry if you did not get exactly the same numbers as the author. Your method was an approximation. Note that the units in Figure 10-4 are not really months (that’s just a label) but are in fact years. You might find Figure 10-2 easier to work with than Figure 10-4.

Task 4: Generate a chart with both survival curves (high end and regular) on it, and embed it in your Word document.

Task 5: Write a paragraph describing these results that your senior manager mentioned above would understand.

"Is this question part of your assignment? We can help"


Need help with an assignment? We work for the best interests of our clients. We maintain professionalism and offer brilliant writing services in most of the fields ranging from nursing, philosophy, psychology, biology, finance, accounting, criminal justice, mathematics, computer science, among others. We offer CONFIDENTIAL, ORIGINAL (Turnitin & SafeAssign checks), and PRIVATE services using the latest (within 5 years) peer-reviewed articles. Kindly click on ORDER NOW to receive an A++ paper from our masters- and doctorate-prepared writers. Thank you in advance!

Get a 15% discount on your order using the following coupon code SAVE15

Order a Similar Paper Order a Different Paper