| QTS0109 Business Statistics |
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.
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)]
| Variable | Variable Variable Type |
| Time spent to finish continuous assignment | |
| Calculator brands | |
| Number of modules take per term | |
| Nationality of athletes |
(2) For each of the following variables, state the Level of Measurement (Nominal, Ordinal or Ratio).
| Variable | Level of Measurement |
| Different programmes (e.g. Master course, diploma course, bachelor course etc) | |
| Number of seats in one classroom | |
| Lecturers’ evaluation score on a scale of 1 to 5(1= Excellent to 5= Poor) | |
| Yearly Income ($) | |
| Color of cars (1= red; 2 = yellow; 3 = silver and so on) |
(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]
(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 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.
(9 marks)
(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.
(4 marks)
(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?
(2 marks)
(b) What is the range of the staffs’ 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 job rotation opportunity.
Young staff are defined as the age below 30. What percent of the staff qualify
for have this opportunity?
(3 marks)
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)]
| Statement | SD (1) |
D (2) |
N (3) |
A (4) |
SA (5) |
| Q5a. The price of the buffet is reasonable. | |||||
| Q5b. The location of the restaurant is very convenient. | |||||
| Q5c. I am satisfied with the environment of the restaurant. | |||||
| Q5d. I am satisfied with the service in the restaurant. | |||||
| Q5e. I am satisfied with the restaurant food. | |||||
| Q5f. In general, I am satisfied with eating in the restaurant. |
The detailed data collected from 50 respondents are shown in Appendix 1.
Buy Custom Answer of This Assessment & Raise Your Grades
Get A Free Quote
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:
| Days of Stay | Frequency | Relative Frequency (%) |
| 1 up to 3 | ||
| 3 up to 5 | ||
| 5 up to 7 | ||
| 7 up to 9 | ||
| Total | 50 |
What percentage of customers has 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 restaurant put in per quarter and revenue (‘000) made quarterly. The following data were collected:
(a) Input above data in an excel worksheet.
(2 marks)
(b) Construct a scatter diagram using Advertising fee on the horizontal axis and Revenue on the vertical axis. State the direction of 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
finalanswers 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)
