About Rides Per Week

Rides Per Week: Business Statistics Assignment Answers | GreenMove Survey

Section A

• For each variable listed below, state the variable type.

[Qualitative, Quantitative (Discrete) or Quantitative (Continuous)]

Variable	Variable Type
Number of items purchased in a supermarket transaction
Preferred food delivery platform
Time spent on revision for exam
Number of courses taken in a semester

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

Variable	Level of Measurement
Customer satisfaction rating (1= Very Poor to 5= Excellent)
Monthly expenditure on groceries ($)
Type of transport used (Bus, MRT, Taxi, Private Car)
Ranking of service quality (1st, 2nd, 3rd)
Size of apartment (square meters)

• A retail chain, UrbanMart Pte Ltd, operates multiple outlets across Singapore and maintains a database of 8,000 loyalty programme members. Management intends to sample 200 members to conduct a survey to evaluate customer satisfaction with pricing and product variety.
• Describe how a simple random sample may be selected.
• State and briefly explain whether the statements below refer to descriptive or inferential statistics.
• The average monthly sales revenue of a café last quarter was $52,000.
• Based on a survey of 150 households, 40% prefer online grocery shopping. The analyst concludes that 40% of all households prefer online grocery shopping.
• A survey of 500 employees found that 68% are satisfied with their work-life balance.
• A company is conducting a customer satisfaction survey to evaluate its products and services. Instead of selecting respondents randomly, the company only selects its VIP members to be included in the final dataset. Identify the main type of research bias that is likely to occur in this situation and explain clearly why this type of bias arises.
• For each of the following situations stated below identify which refers to a population and which refers to a sample.
• A survey is conducted on 400 randomly selected shoppers from several major shopping malls to gather information about their purchasing habits.
• The research study includes all registered members of a nationwide retail loyalty programme, covering every individual in the database.
• The weekly working hours of employees in a small firm are summarized in the stem-and- leaf diagram below.

3 | 5 8 9

4 | 0 2 4 6 8

5 | 1 3 3 7

6 | 0 2

• Determine the total number of employees.
• What is the range of working hours?
• What is the mode working hours?
• If the minimum required working hours is 40 hours, calculate the percentage of employees below this threshold.
• If a new employee working 30 hours is added, explain how the mean will be affected.

Section B

GreenMove Mobility Pte Ltd specialises in shared electric mobility solutions, including electric scooters and bicycles, designed to support sustainable urban transportation. The company operates across multiple locations in the city, providing users with convenient access to short- distance travel options through a mobile application that enables vehicle location, booking, unlocking, and payment.

In recent years, GreenMove has experienced rapid growth due to increasing environmental awareness and demand for alternative transport modes. Management recognises that user satisfaction and retention are critical to long-term success. In particular, the company seeks to better understand customers’ perceptions of key service dimensions such as application usability, vehicle availability, pricing transparency, safety, and responsiveness of customer support.

To support continuous improvement and data-driven decision-making, GreenMove conducted a User Experience Survey aimed at evaluating overall customer satisfaction and identifying areas for enhancement. A total of 50 users were randomly selected from the company’s registered user database and invited via email to participate in the survey. The use of random sampling helps ensure that the data collected is reasonably representative of the broader user population, thereby enabling meaningful statistical analysis.

The questionnaire used to collect the data is shown below:

Using EXCEL, carry out relevant analyses to answer the following questions:

(8a)      Create a frequency distribution for the variable Q3 (Months of using GreenMove) as follows:

Months of membership			Frequency	Relative frequency (%)
2	up to	5
5	up to	8
8	up to	11
11	up to	14
14	up to	17
Total			50

What percentage of users have been using GreenMove for at least 11 months?

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

• Calculate the following statistics for Q3 (Months of using GreenMove) for the two genders (variable Q4). Tabulate your statistics as follows:

Gender	Mean	Median	Standard Deviation
Male
Female

Discuss your results.

• GreenMove is interested in examining whether more frequent usage leads to higher customer satisfaction. The following data were collected:

Number of Rides Per Week	1	2	2	3	4	5	5	6	6	7
Satisfaction Scores	50	55	58	62	68	72	75	80	83	88

• Input above data in an excel worksheet.
• Construct a scatter diagram using “ Number of Rides Per Week” on the horizontal axis and “Satisfaction Scores” on the vertical axis. State the direction of relationship.
• Explain why “Number of Rides Per Week” is plotted on the horizontal axis.

Using EXCEL, carry out relevant analyses to answer the following questions:

(8a)      Create a frequency distribution for the variable Q3 (Months of using GreenMove) as follows:

Months of membership			Frequency	Relative frequency (%)
2	up to	5
5	up to	8
8	up to	11
11	up to	14
14	up to	17
Total			50

What percentage of users have been using GreenMove for at least 11 months?

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

• Calculate the following statistics for Q3 (Months of using GreenMove) for the two genders (variable Q4). Tabulate your statistics as follows:

Gender	Mean	Median	Standard Deviation
Male
Female

Discuss your results.

• GreenMove is interested in examining whether more frequent usage leads to higher customer satisfaction. The following data were collected:

Number of Rides Per Week	1	2	2	3	4	5	5	6	6	7
Satisfaction Scores	50	55	58	62	68	72	75	80	83	88

• Input above data in an excel worksheet.
• Construct a scatter diagram using “ Number of Rides Per Week” on the horizontal axis and “Satisfaction Scores” on the vertical axis. State the direction of relationship.
• Explain why “Number of Rides Per Week” is plotted on the horizontal axis.

For further reading, see this external resource.

You can also explore more resources on our website.