Given a rate of 2.5%, a term of 15 years, a mortgage amount of $135,000, and a monthly payment amount of $900.16, calculate the first two lines of the corresponding mortgage amortization schedule.

Math 110 Exam 2

1.(10 points.) For the equation, y= 10 + 2x, complete the following:
(a) Find the x-intercept
(b) Find the y-intercept
(c) Find the slope
(d) Graph the line

2. Suppose you are a very diligent saver and you deposit $1200 in an account at the end of each month. Suppose further that the account earns a generous 6.5% interest annually. What will this account be worth if you continue with your deposits for 20 years? (10 points.) 

3. Given a rate of 2.5%, a term of 15 years, a mortgage amount of $135,000, and a monthly payment amount of $900.16, calculate the first two lines of the corresponding mortgage amortization schedule. (10 points.)

Complete all of your work on a separate sheet of paper (no need to print this page) and email a photograph of the page to rrtromacek@dmacc.edu with the subject ”Math 110 Exam 2”.

Explain why such a cut-off effect is happening? Write MATLAB® code, which simulates numerically the motion of a single electron emitted from the cathode and plot its trajectory between the electrodes. Use given in (a) values for constants 𝑉𝑎, 𝑉𝑐, 𝑐 and 𝑎.

Math/Physic/Economic/Statistic Problems

 

Question 1: Electric field of a dipole Total: 25 marks
Two electric charges 𝑞1 and 𝑞2 of the opposite polarity are positioned along 𝑥-axis at 𝑥1 and 𝑥2 respectively.
a) Find analytically1 the location(s) (𝑥0,𝑦0) where the electric field 𝐄 due to these charges is exactly zero2. Provide a line plot of 𝐄(𝑥) which shows found location of 𝐸 =0 in relation to the charges. (8 marks)
b) Using MATLAB calculate numerically the distribution of the electric field 𝐄(𝑥,𝑦) and electric potential 𝑉(𝑥,𝑦) in a rectangular domain3. Provide the plot of the unit vectors of the resulting vector field 𝐄(𝑥,𝑦) overlaid onto
the filled colour contour plot 𝑉(𝑥,𝑦). Denote the location of the charges 𝑞1 and 𝑞2 on the plot with small coloured circles. Use reasonable resolution of the numerical grid, which provides clear representation of the electric field vectors as well as smooth contours of 𝑉. (15 marks)

c) Confirm the result of part (a) by clearly denoting the location(s) of (𝑥0,𝑦0) found in (a) on your plot from part (b) with a small marker. (2 marks)

Individual inputs for this question:

a) Take your Student ID number, e.g. SID=1234567
b) Add first 4 digits of SID together, keep adding until you end up with a single digit, i.e.
1+2+3+4=10=>1+0=1, assign this number to 𝐴
c) Add last 4 digits of SID together, keep adding until you end up with a single digit, assign it to 𝐵, i.e. 𝐵 =4+5+6+7=22→2+2=4. If you are ended up with 𝐴=𝐵, take 𝐵 =𝐴+1.
d) Now find 𝐶 by dividing (𝐴−𝐵) by its modulus: 𝐶 =𝐴−𝐵/|𝐴−𝐵|, e.g. 𝐶 =1−4/|1−4|=−1;
e) Your values for Question 1 are: 𝑞1 =𝐶×𝐵×10−9 , 𝑞2 =−4𝑞1 Coulombs; 𝑥1 =−𝐴, 𝑥2 =𝐵 metres.

1 computer algebra, such as symbolic mathematics toolbox of MATLAB, can be used if necessary. 2 besides the infinite distance away from the charges. 3 choose the size of the domain to include the location of (𝑥0,𝑦0) and cover some reasonable space around the charges: your plot should give a good presentation of the electric field vectors and contours of the potential.
This document is for Coventry University students for their own use in completing their assessed work for this module and should not be passed to third parties or posted on any website. Any infringements of this rule should be reported to facultyregistry.eec@coventry.ac.uk.

Question 2: Nodal analysis Total: 25 marks
In the circuit below (Fig.1), the electric potentials 𝑉1…𝑉10 at the corresponding nodes “1…10” are measured with respect to the common node “1”. Assume the batteries have no internal resistance and their e.m.f. are 𝜀1 =10 and 𝜀2 =12 Volts.

To assign the values to resistors R, take first seven digits of your Student ID number, say ABCDEFG, and use the following values, in Ohms:
R1 = A + 3, R2 = B + 1, R3 = C + 4, R4 = D + 2, R5 = E + 2, R6 =F + 2, R7 = G + 1, R8 = A + B + 3, R9 = C+D+1, R10 = B+D+1, R11 = G+F+3, R12 = 2*R1+2, R13 = E+F+2.

 

Applying the Nodal Analysis and using the same nodes’ numbers as in Fig.1:

a) use Kirchhoff’s 1st rule and write the system of nodal equations for this circuit. Show assumed directions of the currents through batteries 𝜀1 and 𝜀2 (respectively 𝐼14 and 𝐼12) on the circuit (Fig.1). (5 marks)
b) Represent the problem in matrix form: show the system of equations in matrix form, including vector of unknowns, matrix of coefficients, vector of RHS. (5 marks)

Using MATLAB:

c) Solve the system of equations (b) using a matrix method of your choice, hence find the values of all nodal potentials 𝑉1…𝑉10 and the currents 𝐼12 and 𝐼14 through the batteries. (5 marks)
d) Find all individual currents through each of 15 elements of the circuit, denoting currents 𝐼1…𝐼13 through resistors 𝑅1…𝑅13 respectively. Show the correct directions of these currents on the sketch of the circuit with arrows. (5 marks)
e) Show that for the currents found in (d), the 1st Kirchhoff’s rule is satisfied at each node of the circuit. (5 marks)

This document is for Coventry University students for their own use in completing their assessed work for this module and should not be passed to third parties or posted on any website. Any infringements of this rule should be reported to facultyregistry.eec@coventry.ac.uk.

Question 3: Motion of an electron in a magnetron Total: 25 marks
Consider a cross-section of two conducting coaxial cylinders in vacuum centred at the origin (Fig.2). The electric potential difference Δ𝑉 = 𝑉𝑎 − 𝑉𝑐 is applied between them: the inner cylinder (the cathode) of radius 𝑐 has potential 𝑉𝑐 and the outer cylinder (the anode) of radius 𝑎 has potential 𝑉𝑎. External magnetic field 𝐁, parallel to the axis of both cylinders is applied everywhere in space. From the surface of the cathode free electrons with charge −𝑒 (where 𝑒 > 0), and negligible initial kinetic energy are continuously emitted.
a) Starting from Laplace’s equation in polar coordinates, find the distribution of the electric potential 𝑉(𝑟,𝜃) in the gap between the cylinders analytically (neglect the electric field of free electrons) and plot it with respect to the relevant coordinate(s) for 𝑉𝑎 =2000V, 𝑉𝑐 =−200 V, 𝑐 =0.02 m, 𝑎=0.2m. (5 marks)
b) Assume the electron is at the distance 𝑟 from the centre (𝑐 ≤ 𝑟≤ 𝑎), has velocity vector 𝐮. Using your result from part (a), find the expression(s) for the full electromagnetic force acting on the electron of mass 𝑚𝑒 and charge −𝑒. (5 marks)
c) The electric current through such a device is the amount of charge transferred from the cathode to the anode per unit of time. For a given non-zero voltage Δ𝑉, there is a certain threshold value of the magnetic field 𝐵 =𝐵𝑚𝑎𝑥 (“Hull cut-off” value, in Tesla), above which the current stops flowing: 𝐵𝑚𝑎𝑥 =√8 Δ𝑉 𝑚𝑒/𝑒 𝑎(1−𝑐2 𝑎2).
Explain why such a cut-off effect is happening? (5 marks)
d) Write MATLAB® code, which simulates numerically the motion of a single electron emitted from the cathode and plot its trajectory between the electrodes. Use given in (a) values for constants 𝑉𝑎, 𝑉𝑐, 𝑐 and 𝑎.

i. Provide the code. (7 marks)
ii. Provide three plots of the electron’s trajectory corresponding to three values of magnetic field 𝐵 =  0.5𝐵𝑚𝑎𝑥,1.02𝐵𝑚𝑎𝑥,3𝐵𝑚𝑎𝑥 (e.g. below, slightly above and way above the threshold 𝐵𝑚𝑎𝑥). Your results must
demonstrate the cut-off effect described above. Electrodes must be visible on the plots and the shape of the trajectories
must not be distorted. (3 marks)

This document is for Coventry University students for their own use in completing their assessed work for this module and should not be passed to third parties or posted on any website. Any infringements of this rule should be reported to facultyregistry.eec@coventry.ac.uk.

Question 4: Magnetic field due to a spherical coil Total: 25 marks

Besides a very long solenoid, there are few designs of magnetic induction coils aimed to produce more or less homogeneous magnetic field inside them: e.g. a pair of “Helmholtz coils” or a set of three “Maxwell coils”. But what about a coil in a shape of a sphere? Let’s take a sphere of radius 𝑅 =0.2 m centred at (0,0,0) with its axis being 𝑧-axis, so that the poles of the sphere are at 𝑧=±𝑅 (Fig.3). Now, beginning from the top pole (𝑧=𝑅) we will wrap a single layer of 𝑁 =51 turns of thin wire with constant pitch4 along 𝑂𝑧 around the sphere in the azimuthal direction (i.e. putting turns counter clockwise along the latitude of the sphere) and finish wrapping at the lower (“south”) pole (𝑧=−𝑅) so that
the surface of the sphere is uniformly covered with 𝑁 turns of the wire. Then we connect the ends of the wire to a source of the current 𝑖, hence the total electric current in the coil is 𝐼 =𝑖𝑁 [Ampere-turns] is flowing counter-clockwise
(shown in Fig.3 with the arrow). Alternatively, instead of wrapping a wire, you can imagine that the sphere has a thin conductive surface which carries almost purely azimuthal uniform current 𝐼. It is suggested that the magnetic field inside such a “spherical coil” is constant and uniform, like the field inside a very long solenoid. Your objective is to provide an evidence that this suggestion is correct or wrong. You can assume, for simplicity, that each of 𝑁 turns of a wire in the coil is  separate circular loop in 𝑂𝑥𝑦 plane5 carrying the current 𝑖. Complete the following tasks:

a) Find analytically6 the distribution of magnetic field 𝐁(𝑧) along the axis of the sphere 𝑂𝑧, both inside and outside of it, i.e. for |𝑧|<𝑅 and for |𝑧|≥ 𝑅. The result should be the line plot of 𝐵(𝑧) for e.g. −5𝑅≤𝑧≤5𝑅 and 𝐼 =103Ampere-turns. You can assume here that 𝑁 →∞ (i.e. the wire is very thin and is fully covering the surface of the sphere). (8 marks)

b) Using MATLAB, write a code, which utilising Biot-Savart law calculates numerically the magnetic field vectors in 𝑂𝑥𝑧 plane both inside and outside such a spherical coil, e.g. on a rectangular grid −3𝑅≤𝑥,𝑧≤3𝑅.
Take the total current to be 𝐼 =10𝑁 [Ampere-turns]. (8 marks)

c) From your results of part (b) provide the plot of 𝐁(𝑥,𝑧) showing vectors of 𝐁 over the contours of |𝐁| on the same plot. (4 marks)
d) Produce the line plot of 𝐁(𝑧) distributions along the axis of the sphere, similar to the one from part (a), but using your numerical results from (b). While keeping the same value of the total current 𝐼 =103 [Ampere-turns], show several results of 𝐁(𝑧) for different number of turns 𝑁, e.g. 𝑁 = 5,10,50,100 on the same line plot. Compare with analytical solution from (a) by also plotting it in the same plot. Comment on your results.

Explain the difference between mean and median. Is mean always larger than median? Explain the difference between µ and x . How do you determine which is appropriate to use in a problem?

STATS

Chapter 1
1. Explain the difference between a population and a sample (from a statistical point of view). (4pts)
2. Explain the difference between quantitative variable and qualitative variable. (4pts)
3. Explain the difference between descriptive statistics and inferential statistics. (4pts)

Chapter 2
1. For a dataset, without constructing of the frequency distribution table; how to obtain the class width of frequency distribution table if the number of classes is given? (2pts)

Note: Use the formula in the slides; here frequency distribution table is not provided.

2. Explain the difference between a frequency distribution table and a relative frequency distribution table (4pts)

Chapter 3
1. Explain the difference between mean and median. Is mean always larger than median? (4pts)
2. Explain the difference between µ and x . How do you determine which is appropriate to use in a problem? (4pts)
3. Explain the difference between σ and s. How do you determine which is appropriate to use in a problem? (4pts)
4. What is the relationship between variance and standard deviation? (2pts)
5. Explain the difference between range and interquartile range. (4pts)
6. Explain what the coefficient of variation is. What is the advantage of using it compared to standard deviation? (4pts)

Chapter 4
1. Explain the meaning of “Event with equally likely outcomes”. (4pts)
2. Explain the difference between joint(nonexclusive) events and disjoint(mutually exclusive) events. (4pts)
3. Explain the difference between P(A) and P(A|B). What does it mean if they are equal in value? What does it mean if they are unequal in value? (4pts)
4. Explain the difference between P(A|B) and P(B|A). Must they be equal in value? (4pts)
5. Explain the difference between Permutation and Combination. (4pts)

Chapter 5
1. Explain what a discrete random variable is. List examples.(4pts)
2. What are the requirements for a discrete probability distribution? (4pts)
3. Explain what binomial probability distribution is.
Hint: list requirements in slides.(4pts)

Chapter 6
1. Explain what a continuous random variable is. List examples. (4pts)
2. Explain some basic characteristics of Normal Distribution. (4pts)
3. What is the standard Normal Distribution? (2pts)
4. Explain the difference between a raw score (x value) and a standard score(z value). (4pts)
5. How to convert a raw score to a standard score; and how to convert a standard score to a raw score? (4pts)
6. Explain how to use Table 2 for each of the following intervals:
a) z < a (less than)
b) z > a (more than)
c) a < z < b (between)
Here a and b are constant z units. b is larger than a Describe the strategies we mentioned in class for theses 3 cases (6pts)
7. Explain what the Inverse Normal Distribution is. How would you figure out whether a problem is Normal Distribution type or Inverse Normal type? (4pts)

Draw the iterates f (x), f 2(x), . . . for λ = 0.683 and λ = 0.809 for an arbitrary initial value of x ∈ [0, 1]. Verify that the reached asymptotic states are very different for the two figures.

 

Math/Physic/Economic/Statistic Problems


Process and energy department
Assignment week 1 CHAOS, 2021/2022

The route to chaos via period doublings
Write a small report about the assignments listed below (could be hand-written, could be typewritten). Add the computer scripts as an appendix. The answer to assignment 1 is always a picture.

1. The logistic map

Write a computer program (in Matlab) to reproduce the following figures from Chapter 2 of the Lecture Notes:
(a) Figure 2.2: Draw the iterates f (x), f 2(x), . . . for λ = 0.683 and λ = 0.809 for an arbitrary initial value of x [0, 1]. Verify that the reached asymptotic states are very different for the two figures. To get you started, the matlab code (LOGISTIC map.m) is provided. In fact, you must now put in code what you have already done on paper during last week’s lecture.

(b) Figure 2.4 and figure 2.6: Show repeated iterations of the function f (x) = 4λx(1 x) where the value of λ is increased step by step. At each λ you can start with an arbitrary value of x, N (many) times to let transients die, and then
iterate N times while drawing them. Already read the next question; it is about the “many” times.

(c) Say “something” about the following: Near a bifurcation value λn it takes forever (long) for iterates to reach the asymptotic state. To be more precise, the time T (that is, number of iterates) diverges as T ∝|λ λn|1/2. Can you argue this dependence ? (Of course, it must be related to the quadratic nonlinearity).

(d) Figure 2.7 and 2.8: Plot f 2n (λn, x) for the given n and λ in the Lecture notes to reproduce the sequence of the limit functions gr(x). The key point is that these figures should be the same (around x = 1/2) up to rescaling. Rescaling means enlarging horizontal and vertical axies of your figure. From this (that is trying…), estimate the universal number α. In fact, this is exactly what threnormalization argument does for you.

(e) Figure 2.12: Show the evolution of the spectrum via period doublings for n = 3, n = 4 and n = 12. For figure (d) set the non-linearity parameter λ just beyond
λ = 0.8924 . . ..
About spectra. You feed a time series of iterates I[i], i = 1, . . . , N to MAT-LAB’s FFT function. The function provides two arrays, the real part Re[i] of the Fourier transform, and the imaginary part Im[i]. Actually, your initial times series is overwritten by the real part. Due to Nyquist, only Re[i], Im[i], i =1, . . . , N/2 makes sense. For this assignment you plot the modulus of the Fourier transfom, (Re[i]2 + Im[i]2)1/2. Of course, most of this you already knew.

2. An experiment

The picture below is the first claim to see the universal route to period doublings in an experiment. This is a heat convection experiment, with the (reduced) Rayleigh number R/Rc as nonlinearity parameter. (Convection first happened at Rc). see: A. Libchaber, C. Laroche and S. Fauve, J. Physique, 43, L-211 (1982).

(a) From the (reduced) Raleigh numbers in pictures (B, C), make a prediction for the Rayleigh number R/Rc of picture D. Discuss why this does not work equally well for predicting the Rayleigh number R/Rc in picture C from those in A, B.

(b) The universal constant α is related to the amplitude of the subharmonics. The scaling of the subharmonics in the spectrum is a mixture of α and α2, as in the following expression
μ = 1
4
(
2α2 + 2α4)1/2
.
Think about the quadratic map, and explain why this is a mixture α and α2 (and ignore the numerical prefactors).

With α = 2.5029 . . ., the value μ = 0.15211 . . .. In power spectra, a decibel is 20 log10 A, where A is the amplitude ratio. Is this consistent with the observed spectra ?

3. Numerics of superstable cycles

Let λn denote the value of λ at which the logistic map, f (x, λ) = λx(1 x) has a superstable cycle of period 2n.
(a) Write an implicit but exact formula for λn in terms of the point x = 1 2 and the function f (x, λ) = λx(1 x). (You will find lots of inspiration in the lecture notes, if not this very equation).

(b) Using a computer and the result of part (a), find λ2, λ3, …, λ7 to three significant digits. Hint: formulate the problem as one where you have to find the zero of a function. Alternatively, you could make pictures, zoom in, and find those zeros by hand.

(c) Evaluate (λ3 λ2)/(λ4 λ3). This will approximate the other universal constant of the period-doubling route to chaos. The problem is that success of this assignment depends a little on success of the previous one. If necessary, you
could revert to (λ2 λ1)/(λ3 λ2). Be practical, this you would typically face in an experiment.

Who will benefit from the service you’re providing? What percentage of the population of your city will benefit? What is the criteria for participating?

Percentages and Budgets

Report on an actual percentage of people (or animals) benefiting from the current program, a new percentage of volunteers needed for the program in the future, and new budget percentages for the program for the upcoming fiscal year.

Paragraph 1: Introduction – What is the program?

Paragraph 2: Budget Information – What’s the budget? List percentages and actual amounts for each category in your budget.

Paragraph 3: Volunteers – How many do you need and what percentage of the population is that? Do they need any special training? Where might you find volunteers?

Paragraph 4: Beneficiaries – Who will benefit from the service you’re providing? What percentage of the population of your city will benefit? What is the criteria for participating?

Paragraph 5: Conclusion – What are the goals for the project? What is the overall effect on the community?

The price of an item is reduced by 20% in a sale. Two weeks later the price is increased to 20% more than the sale price. Do you think that the item has been restored to its original price? If not, do you think its price is now higher or lower than the original price? Explain your thinking.

Math writing assignment : Unit 2

1. A student wanted to estimate 21.5 × 0.0079 by first rounding each number. He solved the problem as follows:
21.5 × 0.0079 is approximately equal to 20 × 0.008, which is equal to 0.016. So he estimated the answer as 0.016.
Do you agree with the answer? If not, explain where the student went wrong and give the correct answer.

2. In triangle A, the longest side is twice as long as the shortest side. In triangle B, the longest side is also twice as long as the shortest side. If this is the only information you have about the two triangles, can you conclude that they must be similar? Explain your answer.

3. The price of an item is reduced by 20% in a sale. Two weeks later the price is increased to 20% more than the sale price. Do you think that the item has been restored to its original price? If not, do you think its price is now higher or lower than the original price? Explain your thinking.

You go to the bank to cash three checks. The checks are for $40.81, $134.93, and $84.30. You are given $260.04 by the teller. Estimate to see if the amount given you seems to be correct. Does $260.04 seem to be correct? Explain your answer.

Math writing assignment : Unit 1

1. You go to the bank to cash three checks. The checks are for $40.81, $134.93, and $84.30. You are given $260.04 by the teller. Estimate to see if the amount given you seems to be correct. Does $260.04 seem to be correct? Explain your answer.

2. Susan drives a tour bus to Springfield to see a local production of West Side Story. The fares were $6 for senior citizens, $8 for people age 12 to 64, and $3 for children under 12. Yesterday she took the trip with seven senior citizens, eight people age 12 to 64, and nine children under 12. What was the total amount she needed to collect in fares?

3. During the 1998 major league baseball season, Mark McGwire of the St. Louis Cardinals hit 70 homeruns. Of these, 34 went to left field, 30 went to left center field, 13 went to center field, and 3 went to right center field. None went to right field. What fraction of his homeruns went to either left field or left center field? Answer the question, simplifying all fractions.

Would using the normal distribution would be advantageous for the company? Why or why not? What are some ethical ramifications of designing products using information based on the normal distribution?

Company use demographics to produce products

Can you think of examples where a company would use information based on income, height, weight, age, or other demographics to produce products? Select an industry, company, or product that you think uses (or should use) the normal distribution to aid in the design or marketing of a product. Do some research on the industry, company, or product if needed.

Identify the industry, company, or product you selected, and then discuss the following in your initial response.

Would using the normal distribution would be advantageous for the company? Why or why not?
What are some ethical ramifications of designing products using information based on the normal distribution?

Explain the Aggregate Planning (AP) in detail. Discuss the importance of AP for operations management? Calculate Forward, Backward, Slack, CPM (show the CPM path) (9p/25). List the all paths and calculate durations for each of them. (6p/25).

Operations managment

Q1. Explain the Aggregate Planning (AP) in detail. Discuss the importance of AP for operations management? (15 points)

Q2. Answer the following questions with given project network data below (25 points).

A) Draw the network diagram (Use the data box for each activity) (10p/25)
B) Calculate Forward, Backward, Slack, CPM (show the CPM path) (9p/25)
C) List the all paths and calculate durations for each of them. (6p/25)

Q3. Answer the following questions for location decisions (20 points).
A) A company is planning on expanding and building a new store in a given region. The operations manager charged with making the decision, has determined key success factors to evaluate alternative places. He uses factor rating method given below (10p/20)

a) Which region should be selected for the new location?
b) Factor ‘Legal issues” in Location-B changes as the score of 82, does your conclusion change?
c) What if ‘Infrastructure’ in Location-A score drops even further to 67, so the decision has change or not?

B) Which location has the best option for a company in terms of cost? (Output levels are 7650, 7400, 7200, 7100, 7500 units per year for each location) (5p/20)

 

C) A Logistic service company wants to extend the operation locations in the region. As given data for alternative locations below, calculate the center of gravity and find out the appropriate location for them. (5p/20)
Location (x, y) Weekly Quantity
L1 4 7 850
L2 7 7 900
L3 6 7 950
L4 9 6 1030

Q4. Answer the problem solving questions below. (20 points)
A) A Studio-A orders 525 box printing paper for its services monthly at 7.5 KWD each (paper box price). Ordering costs are 32 KWD, and annual carrying costs are 30 percent of the paper box price. Compute the EOQ and Total Cost. (7p/20)

B) The clinic periodically place orders for medical cream (skin care product) to sell to their customers. The operations manager of the clinic knows that they use cream at an amount of 440 packages each month, and it costs 52 USD per year to carry per package of creams in inventory. He also knows that the order costs for cream are 93 USD per order, and that the lead time for delivery is (4) days. (13p/20)
⦁ What is the Economic Ordering Quantity (EOQ)? (4p)
⦁ How many times in a year should she reorder based on EOQ? (2p)
⦁ What is the length of an order cycle? (2p)
⦁ What is the reorder point (ROP)? (assume 320 days in a year) (2p)
⦁ What will be the total inventory cost if the items are ordered based on EOQ? (3p)

Q5. Read and analyze the academic article “Why locate manufacturing in a high-cost country? A case study of 35 production location decisions” on Moodle page (24-30 October, Week 5). The requirements for analysis should be covered as problem definition and scope/aim of the paper, methods used, summary of findings and discussions with your own understandings/your comments. (20 points).

What are some potential drivers of the decreased customer satisfaction and increased call volume? What data supports these findings and how did you come to these conclusions? What are some potential recommendations to improve these issues? What are the benefits of implementing your recommendations?

Data Analysis Case study

The Chief Operating Officer of a wireless phone company, TelCo Inc., has noticed that the company’s customer satisfaction scores have been dropping. Additionally, the call volume in their customer service center has been increasing, which is driving increased operating costs.

They have asked you to analyze their current operations to see if there is anything driving these issues. The following sections contain the information you will need to complete their request.

Data
Attached is a workbook with four pieces of data:
Customer Satisfaction Results: After each contact with TelCo, customers are asked to take a customer satisfaction survey. The information on this tab corresponds to the survey questions below:
Considering everything from the time you placed your call until this call was completed, how would you rate your overall contact experience? Please use a scale of 1 to 5, where 5 is excellent and 1 is poor, and you may use any number between 1 and 5.
Now that we’ve gotten your feedback about your overall experience, we’d like you to think now JUST about the service provided by the person who assisted you. Thinking about the LAST person who handled your call, how would you rate that service professional on the following aspects, using the same scale of 1 to 5, where 5 is excellent and 1 is poor.
The overall quality of the service provided by that particular service professional
Ability to resolve your issue
Being courteous
Being knowledgeable about products and services
NPS question scale 0-10 How likely are you to recommend Telco inc to a friend ?
0-6 detractors
7&8 Passives
9&10 Promoters
Verbatim Comments – Customers opinion of the service they received
Account Interactions: Provides information on the interactions that take place in the customer service centers.
Agent Information: Provides information on the customer service agents who handled the account interactions.
Definitions: Defines the terms used in the above data sheets

Use this data to analyze the situation and answer the questions in the results section below.

Results
After conducting your analysis, please complete a presentation to cover at least the following:
What are some potential drivers of the decreased customer satisfaction and increased call volume?
What data supports these findings and how did you come to these conclusions?
What are some potential recommendations to improve these issues?
What are the benefits of implementing your recommendations?
are there any potential service level impacts?
What is the overall NPS score ?
How could the overall TCO be reduced?
Build a Hypothetical Action Plan to improve Performance
Also include a slide on what you think the challenges the Telco industry are facing and how these could impact the overall CX