MM5425 Business Analytics
- Individual Writing Assignment (30%) -
Sem 2, 2023-24
Q1: (10 points) Assuming that you have just started your new job at HKTVmall as a business analyst in the marketing division, you are asked to predict customer's responding behavior if they receive a coupon via online promotion. Please explain your approach to address this problem by following a data analytical process. In your answer, make sure to
· Define the target variable with as little ambiguity as possible.
· Explain what instance/example and what features maybe relevant in your data
· Explain what model(s) you would use
Your Answer:
Q2: (10 points) The manager of a grocery store has taken a random sample of 100 customers. The average length of check out waiting time of the customers in the sample was 2.9 minutes with a standard deviation of 0.5 minutes. The average waiting time for check out was 3 minutes. You need help the manager to determine whether or not the mean waiting time of all customers is significantly less than before. Use α = .05.
Write your Answer to the following steps:
Step 1: Determine the null and the alternative hypothesis:
Step 2: Calculate the test statistics
Step 3: Write down the corresponding p-value. You may calculate the p-value using the link: https://www.graphpad.com/quickcalcs/pvalue1.cfm
Step 4: What is your conclusion?
Q3: (10 points) Assume you are an HR analyst, and you've been given a file HRData.csv containing employee data for HR analytics. Using Power BI, you need generate a dashboard similar to the following sample:
In your work, note that you need:
· In the data view, add a new column, name it to be HiringYear
· In the new column, use formular HiringYear = Year(HRData[HiringDate].[Date]) to calculate the corresponding value.
· Add your real name on the top as part of the title
· Add the corresponding texts/charts/cards similar to the given sample. Make sure all charts visual border is on (Visualizations -> Format visual -> Format your visual -> General -> Effects – Visual border -on)
· Select Year 2018 in the slicer (note that for the slicer, you need change format -> Slicer Settings -> Style -> Tile)
· Snip a picture of your dashboard and paste it below:
SUBMISSION
· Due time: Mar 18th, 2024 (late submission penalty: 25% per day)
· Submit a softcopy via Blackboard – Individual Assignment Submission Link
Notes:
Please be precise and concise and organize your writing in a structured way, subtitles and key points are strongly recommended.
Please include any necessary appendix/references at the end. The references should follow a standard reference style (e.g., APA).
Please indicate any use of GenAI in your answer in the appendix/reference
Plagiarism check will be conducted by Turnitin report. Avoid high similarity in your Question 1 answer. Turnitin originality reports for the first submission of your paper will be generated around 15 to 30 minutes. However, it may take more than 24 hours to generate the reports again for re-submission. Make sure you have enough time to do it before the deadline.
Turnitin student guide: https://www.polyu.edu.hk/tlit/images/content/Turnitin/Turnitin_LTI_Student_Guide.pdf