Join the Premium Student Club @Zero Cost!
Get Assignment Done by MAS Certified Experts
Flat 50% Off on Assignment Bookings
To: Director of Analytics,
From: Arjun Agarwal
Subject: Analysis of the provided data set
Sir,
As per the survey data provided, after analyzing data from different perspective and parameter is was found that average spending of the passengers of different age group is one of criteria which can help us in designing our packages for foods and other services, because their choices and spending depends on the age band. Following age bands are chosen for to analyses data:
Age Band |
Category |
No of observation |
Total Spending |
Average |
21-29 |
Young |
21 |
50,040.00 |
2,382.86 |
30-45 |
Core |
61 |
1,80,163.00 |
2,953.49 |
46-59 |
Prime |
54 |
1,62,567.00 |
3,010.50 |
60-69 |
Mature |
45 |
1,51,018.00 |
3,355.96 |
70 -95 |
Senior |
19 |
64,540.00 |
3,396.84 |
200.00 |
6,08,328.00 |
Customer Satisfaction is one of the areas which can help the company to grow and increase its revenue, and the aim of the company should be improve the services for the unsatisfied category, so to keep focus it is important to make this as part of dashboard and measure it on regularly and try to change the % of unhappy customers to happy customer quotient, and happy to delight.
% of unhappy Customer |
|
Unhappy: |
9% |
Unimpressed: |
22% |
Acceptable: |
20% |
Happy: |
20% |
Delighted: |
30% |
ONE priority area for the company to target for improvement should be unhappy Customers, and actions should be taken to fix problem areas. The company’s reputation will be affected by what passengers say about their experience. Part of the CEO’s task will be to identify which group of passengers are least happy with their experience and address the reasons. It can also be seen after analysis that top spending customers are much satisfied that lower spending customers.
Booking Type |
|||||
Solo: |
The Satisfaction Rating for the top 40% is… |
Acceptable to Delighted |
|||
Double: |
The Satisfaction Rating for the top 40% is… |
Happy to Delighted |
|||
Group: |
The Satisfaction Rating for the top 40% is… |
Happy to Delighted |
|||
Family: |
The Satisfaction Rating for the top 40% is… |
Acceptable to Delighted |
Hope the above analysis is satisfactory. Moreover, it has been also decided to circulate this Dashboard on weekly basis as attached with the mail.
Thanks and Regards,
Business Analyst
Remember, at the center of any academic work, lies clarity and evidence. Should you need further assistance, do look up to our Accounting and Finance Assignment Help
1,212,718Orders
4.9/5Rating
5,063Experts
Turnitin Report
$10.00Proofreading and Editing
$9.00Per PageConsultation with Expert
$35.00Per HourLive Session 1-on-1
$40.00Per 30 min.Quality Check
$25.00Total
FreeGet
500 Words Free
on your assignment today
Get
500 Words Free
on your assignment today
Doing your Assignment with our resources is simple, take Expert assistance to ensure HD Grades. Here you Go....