|HOLMES INSTITUTE FACULTY OF HIGHER EDUCATION|
|Assessment Details and Submission Guidelines|
|Unit Title||Applied Quantitative Methods|
|Assessment Type||Assessment 2|
|Assessment Title||Group Assignment (Min of 2 and maximum of 4 members in a group. Please check the group self-enrollment guide in the assessment folder)|
|Purpose of the assessment (with ULO Mapping)||Students are required to understand the principles and techniques of business research and statistical analysis taught in the course.|
|Weight||40% of the total assessments|
|Due Date||Week 10 (27th of May 2022)|
|Submission Guidelines||All work must be submitted on Blackboard by the due date and a completed Assignment Cover Page.The assignment must be in MS Word format only, with no spacing, 12-pt Arial font and 2 cm margins on all four sides of your page with appropriate section headings and page numbers.Reference sources must be cited in the text of the report and listed appropriately at the end in a reference list using Harvard referencing style.|
Page 2 of 7
HA1011 Applied Quantitative Methods Group Assignment
This assignment aims at assessing students’ understanding of different qualitative and quantitative research
methodologies and techniques. Other purposes are:
- Explain how statistical techniques can solve business problems
- Identify and evaluate valid statistical techniques in a given scenario to solve business problems
- Explain and justify the results of statistical analysis in the context of critical reasoning for a business problem solving
- Apply statistical knowledge to summarise data graphically and statistically, either manually or via a computer package
- Justify and interpret statistical/analytical scenarios that best fit business solution
Assignment Structure should be as the following:
• Your assignment must be submitted in WORD format only.
- When answering questions, wherever required, you should copy/cut and paste the Excel output (e.g., plots, regression output etc.) to show your working/output. Otherwise, you will not receive the allocated marks.
• You must keep an electronic copy of your submitted assignment to resubmit if the original submission has failed and you are asked to resubmit.
- Please check your Holmes email before reporting your assignment mark regularly for possible communications due to failure in your submission.
|Important Notice: All assignments submitted undergo plagiarism checking; if found to have cheated, all involving submissions would be subject to penalties.|
HA1011 Applied Quantitative Methods
Page 3 of 7
Group Assignment Questions
Adila Group of Companies is a research firm established in Melbourne CBD. They mainly provide their service to real estate investors. Assume your group is the data analytics team on Adila Group of Companies. Based on that assumption, access any of the following websites to prepare a report based on the requirements listed below.
You are required to,
- Access rental property details from one of the above online sources, select a specific state (NSW, QLD, SA, TAS. VIC or WA), and prepare a data table with a minimum of 50 observations
- Weekly rent
- Number of bedrooms (minimum of 10 property details in each for houses with 1, 2, 3 and 4 bedrooms)
- Number of car space
- Number of bathrooms
- Date Available
- Hyperlink for the selected rental property
Note: You must use the most recent data, share the details on data sources and are not allowed to use hypothetical data.
- Perform descriptive statistical analysis and prepare a table with the following descriptive measures for the Weekly rent variable in your data set.
Mean, median, mode, variance, standard deviation, skewness, kurtosis, coefficient of variation.
- Critically review the descriptive statistics in part (2) and explain the nature of the distribution of those variables.
- Derive a suitable graph to represent the relationship between weekly rent and other variables in your data set.
(Relationship between weekly rent and no of bedrooms, the relationship between weekly rent and no of car space, the relationship between weekly rent and no of bathrooms)
- Based on the data set, perform a correlation analysis between Weekly rent, No of bedrooms, No of car space, and No of bathrooms.
- Comment on the observed trends between variables based on the answer for Q4 and Q5.
- Based on the data set, perform a simple regression analysis to assess whether no of bedrooms is a determinant of weekly rent and answer the questions below
- Derive the simple regression equation and Interpret the meaning of all the coefficients.
- Interpret the coefficient of determination.
HA1011 Applied Quantitative Methods
Page 4 of 7
- Based on your regression equation in (a), estimate the weekly rent of a house with four bedrooms
|Collection of the data set which meets the given guidelines (Q1)||5 marks|
|Preparation of descriptive statistical table for the weekly rental variable (Q2)||4 marks|
|A critical review of calculated descriptive statistics (Q3)||4 marks|
|Derive Suitable graphs for an analysis of the relationship between variables(Q4)||3 marks|
|Correlation analysis||3 marks|
|Critical review of relationship between variables based on answers in Q4 and Q5. (Q6)||3 marks|
|Deriving simple regression output using excel||3 marks|
|Deriving simple regression equation based on the regression output and interpretation of regression coefficients||5 marks|
|Interpretation of coefficient of determination.||4 marks|
|Use of regression for prediction||2 marks|
|Quality of the report||4 marks|
|TOTAL Weight||40 Marks|
|Assessment Feedback to the Student:|
HA1011 Applied Quantitative Methods
|Collection of data set||Demonstration of||Demonstration of||Demonstration of||Demonstration of||Demonstration of poor|
|which meets the given||outstanding knowledge||very good||good knowledge||basic knowledge on||knowledge on gathering|
|guidelines||on gathering data from||knowledge on||on gathering data||gathering data from||data from online sources.|
|online sources.||gathering data from||from online||online sources.|
|Performing descriptive statistical analysis based on manual or excel calculation||Demonstration of outstanding knowledge on descriptive measures||Demonstration of very good knowledge on descriptive||Demonstration of good knowledge on descriptive measures||Demonstration of basic knowledge on descriptive measures||Demonstration of poor knowledge on descriptive measures|
|Critical review of calculated descriptive statistics||Demonstration of outstanding knowledge on use of descriptive measures||Demonstration of very good knowledge on use of descriptive||Demonstration of good knowledge on use of descriptive measures||Demonstration of basic knowledge on use of descriptive measures||Demonstration of poor knowledge on use of descriptive measures|
|Deriving suitable graph to||Demonstration of||Demonstration of||Demonstration of||Demonstration of||Demonstration of poor knowledge on presentation of data using suitable chart types.|
|represent the relationship||outstanding knowledge||very good||good knowledge on||basic knowledge on|
|between variables||on presentation of data||knowledge on||presentation of||presentation of data|
|using suitable chart||presentation of data||data using suitable||using suitable chart|
|types.||using presentation of||chart types.||types.|
|data using suitable|
|Preforming Correlation analysis using excel and critical review of the correlation||Demonstration of outstanding knowledge on correlation analysis||Demonstration of very good knowledge on correlation analysis||Demonstration of good knowledge on correlation analysis||Demonstration of basic knowledge on correlation analysis||Demonstration of poor knowledge on correlation analysis|
|Deriving simple regression equation based on the regression output and interpretation of regression coefficients||Demonstration of outstanding knowledge on regression model||Demonstration of very good knowledge on regression model.||Demonstration of good knowledge on regression model.||Demonstration of basic knowledge on regression model.||Demonstration of poor knowledge on regression model.|
|Interpreting the coefficient of determination||Demonstration of outstanding knowledge on goodness of fit of the regression model||Demonstration of very good knowledge on goodness of fit of the regression model||Demonstration of good knowledge on goodness of fit of the regression model.||Demonstration of basic knowledge on goodness of fit of the regression model||Demonstration of poor knowledge on goodness of fit of the regression model|
|Use of regression for prediction||Demonstration of outstanding knowledge on usefulness of the regression model for prediction purposes.||Demonstration of very good knowledge on usefulness of the regression model for prediction purposes.||Demonstration of good knowledge usefulness of the regression model for prediction purposes.||Demonstration of basic knowledge on usefulness of the regression model for prediction purposes.||Demonstration of poor knowledge on usefulness of the regression model for prediction purposes.|
Holmes Institute is committed to ensuring and upholding Academic Integrity, as Academic Integrity is integral to maintaining academic quality and the reputation of Holmes’ graduates. Accordingly, all assessment tasks need to comply with academic integrity guidelines. Table 1 identifies the six categories of Academic Integrity breaches. If you have any questions about Academic Integrity issues related to your assessment tasks, please consult your lecturer or tutor for relevant referencing guidelines and support resources. Many of these resources can also be found through the Study Sills link on Blackboard.
Academic Integrity breaches are a serious offence punishable by penalties that may range from deduction of marks, failure of the assessment task or unit involved, suspension of course enrolment, or cancellation of course enrolment.
Table 1: Six categories of Academic Integrity breaches
|Plagiarism||Reproducing the work of someone else without attribution. When a student submits their own work on multiple occasions this is known as self-plagiarism.|
|Collusion||Working with one or more other individuals to complete an assignment, in a way that is not authorised.|
|Copying||Reproducing and submitting the work of another student, with or without their knowledge. If a student fails to take reasonable precautions to prevent their own original work from being copied, this may also be considered an offence.|
|Impersonation||Falsely presenting oneself, or engaging someone else to present as oneself, in an in-person examination.|
|Contract cheating||Contracting a third party to complete an assessment task, generally in exchange for money or other manner of payment.|
|Data fabrication and falsification||Manipulating or inventing data with the intent of supporting false conclusions, including manipulating images.|
Source: INQAAHE, 2020
Get expert help for HA1011 Applied Quantitative Methods and many more. 24X7 help, plag free solution. Order online now!