QTS0109 BUSINESS STATISTICS CONTINUOUS ASSESSMENT 1

Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit

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

Q8.

I am very mindful of food intake, watching portion sizes and food type.

1

2

3

4

5

Q9.

I am happy with my current health condition.

1

2

3

4

5

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)

Section B (50 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.


2024-01-24