QTS0109 BUSINESS STATISTICS
CONTINUOUS ASSESSMENT 1
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 Canvas Help and then email queries via your student portal.
Students are to upload their assignment by the due date to 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 offence, 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.
Due date: 24 Jan 2024 (Wednesday), 11.59 am
Penalty Marks for Late submission of Assignment
Within 24 hours: 20% to be deducted from total marks.
More than 24 hours: submission will be graded zero.
CA Submission
CAs must be submitted online via student portal. Please read through instructions in your student portal, CA outline and Canvas carefully before submitting. If you have further queries, please read the Canvas Help. If after you have read the Canvas Help,you need assistance on Canvas submission, please email to [email protected] or call 6248 9393. For non-Canvas issues please email [email protected]. Please email using your student portal accounts. Email from other addresses will not be entertained. If issues raised are covered, you will be directed to read through instructions first. Please take time to read through before raising issues.
CONTINUOUS ASSESSMENT 1 - INDIVIDUAL ASSIGNMENT [30%]
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 using the prescribed format QTS0109yourname e.g.QTS0109johntan.xls)
Answer Section A and B based on the following survey questions and survey results in Appendix 1
The National Health Promotion Board launches a 2024 healthy lifestyle campaign. In a road show held recently at the Marina Bay Sands Centre, 50 working executives were invited to participate in a survey. A $10 food voucher was given for each survey form completed.
The questionnaire being used to collect the data is shown below:
|
Healthy Lifestyle Survey Q1. Age: years Q2a. Height: m Q2b. Weight: kg Q3. Gender: (1) Female (2) Male Q4. Your most preferred way for staying healthy: (1) Eat healthily. (2) Consume health supplements. (3) Do general individual exercise. (4) Take part in group fitness classes and events. Q5. People sometimes make less healthy food choices. What would you say is your main reason for making less healthy food choice? (1) Healthy foods are more expensive. (2) Need comfort food for stress relief. (3) Less healthy food tastes better. (4) Lack of healthy options. Q6. On average, how many times do you exercise per week? times Q7. Activity tracking apps motivate me to keep healthy. |
||||||||||||||||||
|
1 Strongly disagree |
2 Disagree |
3 Neutral |
4 Agree |
5 Strongly agree |
||||||||||||||
|
Provide your rating for each of the statements stated below: (1)=Never (2) Seldom (3)Sometimes (4) Often (5)= Always
|
||||||||||||||||||
The detailed data collected from 50 respondents are shown in Appendix 1 (Page 7).
Requirements:
Section A (50 marks)
(1) For each of the following variables, state the Level of Measurement (Nominal, Ordinal, or Ratio).
|
Variable (refer to questionnaire and data provided in Appendix 1) |
Level of Measurement |
|
Q2a. Height |
|
|
Q3. Gender |
|
|
Q4. Preferred way of staying healthy |
|
|
Q7. Usefulness of activity tracking apps |
|
(8 marks)
(2) For each variable listed below, state the variable type:
Qualitative, Quantitative (Discrete) or Quantitative (Continuous)
|
Variable (refer to questionnaire and data provided in Appendix 1) |
Variable Type |
|
Q2b. Weight |
|
|
Q5. Reason for less healthy food choice |
|
|
Q6. Number of times exercise per week |
|
(6 marks)
(3) The $10 food voucher was given to improve the response rate. However, the survey
may still be prone to non-response bias. Explain what non-response bias is and why such bias maybe present here. (4 marks)
(4) State and explain whether the statements below refer to descriptive or inferential statistics.
(a) Pharmacy chains in Singapore estimated that the demand for health supplements would increase by 20% next year. (3 marks)
(b) In a survey of 400 working adults, 100 cited busy work schedules as the main reason for not exercising regularly. (3 marks)
(c) From the 50 participants in a survey, 25% of participants eat less than 3 meals a day. (3 marks)
(5a) Explain what is meant by the statement “There is only one true population parameter
whereas the value of a statistic is sample dependent” . (4 marks)
(5b) For the value highlighted in bold in the statements below, explain whether it is a
Parameter or a Statistic.
(i) In a random survey of a sample of 100 men who were overweight, 40 of them stated that they would exercise more every week. (3 marks)
(ii) 90% of all the employees in National University Hospital did a health screening in the last two years. (3 marks)
(6) The following stem and leaf diagram shows a sample of the amount spent on health supplements per week for 30 respondents in a survey:
(Stem Unit =$10 and Leaf Unit =$1)
(a) Find the median, maximum and minimum values. (3 marks)
(b) Would you expect the median to be higher than the mean? Describe the distribution of the stem and leaf diagram. (4 marks)
(c) State one advantage of a stem and leaf diagram over a histogram. (2 marks)
(d) Based on the stem and leaf diagram, what percent of the respondents spent more than $100 per week. (2 marks)
(e) Calculate the standard deviation. (2 marks)
Use the data provided by Excel datafile to carry out relevant computations and analyses for Questions 7 to 13. You are required to use the relevant Excel formula to compute the answers.
(7) A BMI (Body Mass Index) is provided where BMI = Weight in kg/Height in metre2. Create a frequency distribution for the variable BMI provided.
|
BMI |
Frequency |
Relative frequency |
|
15 up to 20 |
|
|
|
20 up to 25 |
|
|
|
25 up to 30 |
|
|
|
30 up to 35 |
|
|
(a) Use COUNTIFS function to compute the frequency count. Calculate the relative frequency and comment on the frequency distribution.
[Note: BMI (below 20) = Underweight; BMI (20 up to 25) = Normal weight; BMI (25 up to 30) = Overweight; BMI (30 or more) = Obese)] (7 marks)
(b) Based on the results from Part (7a), create a histogram for the variable BMI. Label all axes clearly. Describe the shape of the distribution. (5 marks)
(8) The following frequency table on the Health Supplement Expense per month for a sample of 50 respondents was provided to you:
|
Health Supplement Expense ($) |
Frequency |
|
0 up to 100 |
7 |
|
100 up to 200 |
13 |
|
200 up to 300 |
25 |
|
300 up to 400 |
5 |
You are required to calculate the grouped mean and grouped sample standard deviation based on the frequency distribution table above. (4 marks)
(9) Calculate the mean and standard deviation for Q6 (Number of times exercise per week). Tabulate your statistics as follows:
|
|
Male |
Female |
|
Mean |
|
|
|
Median |
|
|
|
Standard Deviation |
|
|
Based on the statistics obtained, discuss your findings. [Format answers to 2 dec places] (10 marks)
(10) Create a scatter plot using Q1 (Age) on the horizontal axis and BMI on the vertical axis.
State the direction of relationship between the variables. Explain why you think Q1 (Age) should be on the horizontal axis and BMI on the vertical axis. (6 marks)
(11) Create a contingency table with variable Q5 (Main reason for less healthy food choice)
as the Row variable and variable Q3 (Gender) as the column variable. Comment on the results obtained. (4 marks)
(12) For variable “Q8 Mindful of food intake” group Choices 1 and 2 as “Foodie”, Choices 3 and 4” as “Moderate eater” and Choice 5 as “Health nut”. Create and label a pie chart. (6 marks)
(13) Summary (maximum: 150 words):
Based on the results generated, provide a summary of the key findings of the survey. Suggest some strategies that the National Health Promotion Board can adopt to promote healthy lifestyle amongst working adults.
[Note: You may create more charts based on the data provided for additional analysis]
(8 marks)
Appendix 1
Note : Please retrieve a copy of this Excel datafile from Canvas for your Section A and Section B analysis. You are NOT required to do input of above data into Excel.