代写SEHH1071 Computational Tools for Statistics (Semester 2, 2024/25)调试数据库编程

SEHH1071 Computational Tools for Statistics (Semester 2, 2024/25)

Group Project & Individual Assignment

Intended Learning Outcome of the Group Project & Individual Assignment

Ø Apply statistical concepts in data analysis and problem solving.

Ø Present the analyse data using basic statistical techniques.

Ø Analyse large data sets with the use of computer software.

Ø Formulate a mathematical and/or statistical solution for real life problems

Project Description

DPM Travel is an upcoming travel booking website. The group has recruited your team as the consultant to find out the customers’ behaviors and preferences on travel booking for bettering targeting in future market expansion. Your team had set up an online questionnaire to collect responses from a group of randomly selected customers who had used the website before. The response period was from 12 to 22 August 2024. 1019 responses were obtained and saved in the Excel file named “Travel.xlsx”

Your team are required to:

- Carry out data cleaning and processing to the dataset

- Provide descriptive analysis on behaviors and preferences on the Travel booking website

Each team member is required to

- Test the independence of specific variables using the Chi-square independence tests

- Carry out specific regression analysis

Project Objective

- Make the dataset available for analysis through data cleaning and processing

- Provide descriptive analyses to a large dataset (over 1000 of customers) using the Software (e.g. Excel, SPSS and/or R)

- Choose appropriate data analysis tools and apply relevant statistical concepts to a real-life problem (using behaviors and preferences on travel booking website and services data for descriptive analysis)

- Convert the problem behaviors and preferences on hotel) into mathematical solution (Regression models and Chi-Square independence tests)

- Present the result in an appropriate manner (report and presentation)

Project Requirement

Group Project

1. Project Member List among the team members

- You are required to form. a team of 6 (can be across tutorials)

- The list and the group name are to be submitted by the team leader

2. Interim Report

- The interim report should include

n Work Assignment

n Team Schedule (e.g. progress or completed task(s) by week)

n A brief description on the data cleaning and processing

n A brief description on the proposed descriptive analyses with explanation (can be calculation, charts, table….)

3. Final Report

- The final report should include

n Cover Page

u Title of the Course

u Group member names

n Table of Content

u Headings and sub-headings of various sections

u Page numbers

n Introduction

u A brief description on the background of the study (e.g. the travel booking market)

u Specific objective(s) of the project (determined by your group)

u Tasks allocation

n Data Processing and cleaning

u Detailed descriptions about the tasks that your group has carried out (e.g. missing data treatment, problematic data…)

n Descriptive Analysis

u Various types of charts and tables

u Statistical analyses on qualitative, quantitative and demographic variables in general sense (e.g. sample composition, average score on various preference criteria…)

Individual Assignment

After and based on the data cleaned and processed as well as the descriptive analyses conducted by the group, each member should then select one of the following tasks (not to be repeated in the same group).

Consultant	Task
A	Qualitative: 1. Last Booking x Type of Booking 2. Last Booking x Booking time before the trip  Quantitative: Maximum companion in a booking
B	Qualitative: 1. Channel knowing the website x Type of Booking 2. Booking time before the trip x Type of Booking Quantitative: Average spending per booking (HKD$)
C	Qualitative: 1. Booking time before the trip x Channel knowing the website 2. Type of Booking x Education level Quantitative: Probability to book a trip in the next month
D	Qualitative: 1. Form x Booking time before the trip  2. Last Booking x Education level Quantitative: Average confirmation time (in minutes)
E	Qualitative: 1. Type of Booking x Payment Type  2. Booking time before the trip x Payment Type Quantitative: Maximum time that can accept for confirmation (hours)
F	Qualitative: 1. Payment Type x Last Booking 2. Channel knowing the website x Payment Type  Quantitative: Maximum queue time that can tolerate under promotion (in minutes)

You need to write a report to include:

- Cover page

u Title of the Course

u Student name

u Title of the project

u Consultant Role (A-F, not to be repeated within the group)

u 

- Complete analysis on the following:

u For Qualitative analysis, you need to

l Carry out Chi-square independent test for each combination of variables

l Full steps as stated in the lecture and lab notes

l One p-value approach and one critical value approach with level of significance = 0.05

u For Quantitative analysis, you need to

l Carry out the regression analysis with level of significance = 0.05 (1 F-test and 1 t-test)

l Conduct assumption tests and report what assumption(s) are is/are not fulfilled (if any)

(Note: At least 2 out of the 5 independent variables being significant)

u Recommendation

l Based on the facts and results obtained in the analyses

Presentation Slides

- The presentation slides will be prepared by each group but assessed in an individual manner based on each member’s own dedicated contribution

u The presentation should include the following section

l Introduction

l Data cleaning and processing (Very brief)

l Descriptive Analysis (Very brief)

l Interpretation of the Regression models and Chi-square tests (to be conducted by each member)

Project Timeline

Date (Sunday 23:59)	Group Project Task	Individual Assignment Task
Week 3	Group Enrollment
Week 8	By Group Leader Interim Report - No more than 3 pages (docx)
Week 12	By Group Leader Final Report - no more than 15 pages (docx)	By individual Final Report - no more than 8 pages (docx)
Week 13	Presentation Slides (Submitted by Group Leader but evaluated individually) - no more than 30 pages (pptx) (according to the number of students submitting the individual assignment	Peer Evaluation Form (only if you think it is necessary)