QTS0109:Comprehensive Statistical Analysis and Insights on Customer Satisfaction and Resurant Performanceta, CA1 Singapore

Individual Assignment 100 marks (30%)

Read the instructions in your course documents, in your student portal, Course Outline, CA outline and Canvas portal carefully. You will be penalized with a marks deduction if the instructions are not strictly followed. If you have queries, read the Canvas Help and then email queries via your student portal.

Students are to upload their assignments by the due date through their student portal account. After the due date, students’ submissions will not be entertained.

Students should keep a copy of the assignment submitted. All workings must be shown. The submitted report must show evidence that this is students’ own work. Write your FULL Name AND your student ID as in the register on the answer script. Please be reminded that plagiarism and collusion is a serious offences, and all cases will be referred to the administration. Grades will be withheld if the submission is suspected of plagiarism or collusion till investigations are completed.

Continuous Assessment 1

Answer ALL questions in Sections A and B
Submit an Excel answer file in Canvas:

(1) Use the Section A sheet in the Excel data template provided in Canvas to answer questions from Section A.
(2) Use the Section B sheet in the Excel data template provided in Canvas to answer questions from Section B.

(Save your Excel file using the prescribed format QTS0109yourname e.g. QTS0109johntan.xls)

Section A (50 marks)

(1) For each variable listed below, state the variable type.
[Qualitative, Quantitative (Discrete) or Quantitative Continuous)]

(2) For each of the following variables, state the Level of Measurement (Nominal, Ordinal or Ratio).

(3) MDS hotel has had 2200 guests for the past year. The hotel manager decided to take a sample of 200 guests to assess their satisfaction with the services provided by the hotel. The hotel has information about the guests’ age, gender, nationality, the type of rooms that they booked and the duration of staying.

(a) Describe how a simple random sample may be selected.
(b) Describe how a stratified sample may be selected.
[Use your own words. Do not copy from any sources]
(8 marks)

(4) State and briefly explain whether the statements below refer to descriptive or inferential statistics.
(a) The median monthly household income for 2023 in the country is $10869.
(b) You survey 100 patients who go to CG hospital about whether they have high blood pressure. 10 of the 100 say they are suffering from high blood pressure. You infer that 10% of the patients who go to the hospital have high blood pressure.
(c) In a survey of 200 students who are studying in the SMI bachelor programme,
10% said that they would like to continue to pursue the master’s degree.
(9 marks)

(5) A restaurant carried out a customer satisfaction survey given the restaurant’s food quality, cleanliness, price and so on. The management team has put a bar code on the cashier desk for customer to scan. Many customers just simply pay the bill and rush away without scanning the code. What is the main type of research bias that can occur here? Explain the bias stated.

(6) For each of the following situations stated below identify which refers to a population and which refers to a sample.
(a) 600 students from five Singapore universities who volunteer for a new
medicine experiment.
(b) The company has decided to give a $50 voucher to all of the staff.
(4 marks)

(7) Jeff collected the ages of all the staffs in his department. The values in years of old are shown in the stem and leaf diagram below.

(a) How many staff were being measured by Jeff?
(2 marks)
(b) What is the range of the staff’s age?
(2 marks)
(c) What is the mode staff age?
(2 marks)
(d) Jeff forgot to include the age of himself, who has an age of 60 years old. If
Jeff includes himself in the data, how will it affect the mean age?
(3 marks)
(e) The company has decided to give the young staff a job rotation opportunity.
Young staff are defined as those aged below 30. What per cent of the staff qualify
for have this opportunity?
(3 marks)

Section B (50 marks)

You are the Manager of Malva’s restaurant which is a very famous buffet restaurant that offers cuisines from around the world, including Chinese, Western, Japanese, and more. As the restaurant manager, you place great importance on customer reviews and feedback. Therefore, you have decided to conduct an independent Customer Satisfaction Survey to further improve
the quality and service level of the restaurant based on the survey results this month.
The questionnaire used to collect the data is shown below:

Survey of Customers

Q1. Would you recommend this restaurant to your friends or family members?

Yes

No

Q2. How likely are you to visit this restaurant again when you come to Singapore?

Likely

Unlikely

Q3. How many types of food did you try in the restaurant (e.g., 3 types)?

Q4. Visiting purpose:

Family gathering

Friends or colleagues gathering

Please select your level of agreement for the following statements:

[5=Strongly Agree (SA), 4=Agree (A), 3=Neutral (N), 2=Disagree (D), 1=Strongly Disagree (SD)]

The detailed data collected from 50 respondents are shown in Appendix 1.

Using EXCEL, carry out relevant analyses to answer the following questions:
(8a) Create a frequency distribution for the variable Q3 (types of food) as follows:

What percentage of customers have tried the food for more than 4 types?

(6 marks)

(8b) Based on the results from Part (8a), create a histogram for variable Q3 (types of food). Label all axes clearly.
(4 marks)

(9) Calculate the following statistics for Q3 (types of food) for the two types of
purposes (variable Q4). Tabulate your statistics as follows:

Discuss your results.

(10) You would like to look at the relationship between the advertising fee the restaurant puts in per quarter and revenue (‘000) made quarterly. The following data were collected:

(a) Input the above data in an Excel worksheet.

(2 marks)
(b) Construct a scatter diagram using Advertising Fees on the horizontal axis and Revenue on the vertical axis. State the direction of the relationship.
(4 marks)
(c) Explain why “Advertising fee” is plotted on the horizontal axis.
(2 marks)

(11) Given the following frequency distribution of final revenue (‘000) for a sample of 20 quarters.

Calculate the grouped mean and grouped sample standard deviation. (Format
final answers to 2 decimal places)

(12) Create a contingency table with Q2 (Visit the restaurant again when coming to Singapore) as the row variable and Q1 (Recommend restaurant) as the column variable. Label clearly and comment on the results.
(6 marks)

(13) Create a pie chart for the variable Q5e (Satisfied with the restaurant food). Label your chart clearly.
(4 marks)

(14) Summary (maximum: 150 words):
Using appropriate Excel analysis, discuss the overall satisfaction of customers in this restaurant suggesting areas that the restaurant may wish to address. [Hint: You may wish to analyze Q5a to Q5f or other suitable variables]
(8 marks)