The group project is worth 20% of your final grade and is compulsory which means you must undertake the assessment or you shall receive zero marks (0) for this assessment. Note that this is a group assessment and you must work in a group of 3-4 students. The deadline for submitting the assignment is 4pm, 27th May 2016.
Assignment submission consists of the submission of both a written report and an excel file showing all of your calculations. Your written report should take the form of a concise professional report and apply the following page set up and formatting:
Font: 12pt Times New Roman.
Margins: 2.5cm in all sides.
Line spacing: 1.5 lines.
Length: maximum 12 pages including any tables, graphs, appendices and references.
Failure to follow any of the above formatting instructions will result in an immediate penalty of 2 marks (out of 20). Markers will not read material beyond the 12-page limit.
There are no specific formatting requirements for the excel file apart from that all calculations used for the written report must be clearly presented and labelled according to the section of the written report for which the output was used.
There are two parts to be included in the written report:
Part A: Quantitative analysis
Part B: Group organisation and contribution
Both are described in detail below.
Part A: Quantitative analysis (out of 100)
The data file “sales.xlsx” contains information on the purchase value of the last transaction for 900 customers from a sportswear retailer in Australia, along with a range of other potential explanatory variables. The variable names along with their definitions are given in the table below:
ID | Variable Name | Description |
1 | birth_year | Birth year of the customer |
2 | gender | Customer’s gender |
3 | first_transaction_year | First transaction year |
4 | online-trans? | A dummy variable representing existence of an online transaction |
5 | avg_retail_value_per_trans | Average retail value per transaction |
6 | avg_days_between_trans | Average days between two consequent transactions |
7 | weekend-or-weekday? | Day of the week when last sales transaction was done |
8 | value-of-last-purchase | Value of the last sales transaction |
The company is examining the relative importance of variables 1 to 7 as determinants for the value of customer’s purchase (For all the tests use α=5%).
Age |
life-time |
Gender |
avg_days_between_trans |
Hint: Use a mean hypothesis test on “avg_days_between_trans”.
age |
life-time |
Gender |
avg_retail_value_per_trans |
weekend-or-weekday? |
Estimate the regression model and report your estimated regression equation including the standard errors and R2. Interpret the regression coefficients and examine the normality of the regression residuals.
Hint: You will need to replace some variables with appropriate dummy variables for the both the analysis here and below.
age |
birth_year
gender |
life-time |
online-trans? |
avg_retail_value_per_trans |
avg_days_between_trans |
weekend-or-weekday? |
If you want to model the dependent variable value-of-last-purchase within a multivariable regression framework, are there any variables that cannot be used together as explanatory variables? Why or why not?
Age |
Gender |
life-time |
online-trans? |
avg_retail_value_per_trans |
weekend-or-weekday? |
And the third alternative is a regression model using the following explanatory variables:
Age |
Gender |
life-time |
online-trans? |
avg_retail_value_per_trans |
avg_days_between_trans |
weekend-or-weekday? |
Analyse these three options and choose your preferred model. Motivate your choice.
Note: A further 10 marks will be allocated to assessing your overall presentation and the Excel file containing your calculations.
Part B: Group organisation and contribution
Provide an outline of the contribution of each member of the group and a score out of 10 for their level of effort along with supporting evidence in the form of a record of meetings and progress. If a member is not included as part of the submission, it is assumed that they have not made a contribution and this will result in a mark of zero (0) for that student. Make sure to bring to our attention all cases of unfair contribution, preferably with supportive documentation.
Part B should be no more than one page. Material that spans longer than one page will be ignored. A template example on how to present the required information is provided below.
Example of one-page support information
Name and SID | Brief description of contribution | Score (out of 10) |
1. C Li (123456789) | Introduction/Executive Summary | 5 |
2. A Kim (789123456) | Descriptive Statistics, graphs and formatting/editing | 8 |
3. G Schmidt (369852741) | Regression model set up and hypothesis testing | 10 |
4. J Bow (400019952) | Hypothesis tests and interpretation of regression | 10 |
Summary of Meetings (extract)
Date/time of meeting | Initials of attendees | Discussions held and decisions made |
7/04/2016 | CL, AK, GS | Initial allocation of duties – to inform JB accordingly. AK to work on data description, GS on regression, CL and JB on hypothesis test and forecasts |
12/04/2016 | CL, AK, GS, JB | Initial data description discussed, … |
Marking Criteria
You will be assessed on your ability to:
We value our customers, and so ensure that our papers are 100 percent original. Our Team of professionals does not miss the mark; they ensure that step by step each paper is written uniquely. We never duplicate or work as we compare papers rest assured. We deliver our work a day before time to ensure that you don’t miss your deadlines. It is not only doing the work but delivering it at the right time. We capture the consequences of late remittances. .
We value customer satisfaction here at popularessaywriters.com and make sure that you get the best value for your Money. It happens that sometimes you can pay twice for your order or may want to cancel it, or you feel that it doesn’t meet your requirements; our money back guarantee will give you the opportunity to get back your money. We will also refund 100% of money paid double. In case your paper does not satisfy your requirements , we request that you notify us via writing within 2 days otherwise on the third day we will assume that you have been satisfied. Do all your correspondences through our email address popularessaywriters@gmail.com.
Read moreAt popularessaywriters.com, our professional writers know the consequence plagiarism does for our clients. We have updated software’s such as article checker and copyscape to check for originality of the custom papers before submission of the final paper to the you. Our guarantee to the customer is that we will write 100% original papers for them that are quality, timely and of low cost. We have experienced professional and competent PhD writers who will write quality custom papers for you..
Read more. At popularessaywriters.com, we are proud to provide top-quality Essay writing service to our esteemed customers. We are ready to take up that challenging academic assignment that is giving you sleepless nights and simplify it for you according to your desired requirements. We are willing to revise your paper if it does not meet your requirements. At popularessaywriters.com, we do not compromise with quality; thus, we offer unlimited free revisions until the customer is satisfied with their custom paper. Our unlimited free revision services are provided under the following terms:.. .
Read morePopularessawriters.com knows that client’s information is an essential tool for our company. It means that whatever the client requests from our service is kept strictly confidential. It means that whoever writes for this company understands the terms and conditions hence you should not be worried because you will never see your work somewhere else...
Read moreRest assured that we will always be attentive to your needs and requirements. We belief in the phrase treat your neighbour as you would want them to treat you. We leave nothing to chance and always look forward to a good interaction with each other.. .
Read more