QTS0109 Business Statistics Individual Continuous Assessment 1 | SIM

QTS0109 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 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 assignment by the due date to through theirstudent portal account. After the due date, students’ submissions will not be entertained.

Students should a keep a copy of 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 offence, and all cases will be referred to the administration. Grades will be withheld if the submission is suspected for plagiarism or collusion till investigations are completed.

QTS0109 Continuous Assessment 1

Answer ALL questions in Sections A and B

Submit an Excel answer file in Canvas:

1. Use Section A sheet in the Excel data template provided in Canvas to answer questions from Section A.
2. Use 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 2200 guests for the past one year. The hotel manager decides 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, the 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]

(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 hospital are having high blood pressure.
(c) In a survey of 200 students who are studying in SMI bachelor programme,10% said that they would like to continue to pursue the master degree.

(5) A restaurant carried out a customer satisfaction survey in view of the restaurant food quality, cleanness, 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 $50 voucher to all of the staffs.

(7) Jeff collected the age 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?
(b) What is the range of the staffs’ age?
(c) What is the mode staff age?
(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?
(e) The company has decided to give the young staff job rotation opportunity.

Young staff are defined as the age below 30. What percent of the staff qualify for have this opportunity?

Section B (50 Marks)

You are the Manager of Malvas 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 has tried the food for more than 4 types?

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