Graduate Learning Outcomes and related Unit Learning Outcomes

Appendix: Explanatory Notes

 

To accomplish allocated tasks, you need to examine and analyse the dataset (Furphy.xlsx) thoroughly. Below are some guidelines to follow:

 

Task 1 – Summarising Dependent Variables

 

The purpose of this task is to analyse and explore key features of these two variables individually. At the very least, you should thoroughly investigate relevant summary measures of these two variables. Proper visualisations should be used to illustrate key features.

 

Your technical report should describe ALL key aspects of each variable.

 

Task 2.1. – Identifying relevant factors for predicting repurchasing intention

 

Analyse the relevant dependent variable against other variables included in the dataset. Your job is to decide which variables to include here. Use an appropriate technique to identify important relationships.

The outcome of this task is a list of variables that should be included in the subsequent analysis. Your  technical  report  should  describe  why  some  variables  were  selected while  others  were

dropped from subsequent analyses.

 

Task 2.2. – Model building (predicting repurchasing intention)

 

You should follow a model building process. All steps of the model building process should be included in your analysis. You can have as many Excel worksheets (tabs) as you require to clearly demonstrate different iterations of your predictive model (i.e., 2.2.a., 2.2.b., 2.2.c. etc.).

 

Your technical report should clearly explain why the model may have undergone several iterations. Also, you must provide a detailed interpretation of ALL elements of the  final model.

 

Task 2.3. – Interaction effect

 

To accomplish this task you need to develop a regression model using  ONLY the factors discussed in the meeting (Task 2.3). In other words, this section of analysis is separate from the regression model constructed in Task 2.2.

 

Your technical report should clearly explain the role of each variable included in the model. A proper visualisation technique should be used. Make sure you interpret all relevant outputs in detail and provide managerial recommendations based on the results of your analysis.

 

Task 3.1. – Model building (likelihood of recommending Furphy)

 

You should follow a model building process. All steps of the model building process should be included in your analysis. You can have as many Excel worksheets (tabs) as you require to clearly demonstrate different iterations of your predictive model (i.e., 3.1.a., 3.1.b., 3.1.c. etc.).

 

Your technical report should clearly explain why the model may have undergone several iterations. You must provide a detailed interpretation of ALL elements of the  final model.

 

Task 3.2. – Visualising and interpreting predicted probabilities

 

Your technical report must include the predicted probability visualisation and be supplemented by practical recommendations to Furphy’s Management. These recommendations should answer the following question:

 

“How change in perceptions of quality (scores from 0 to 10) and brand image (scores of 0, 5, and 10) may affect the predicted probability of recommending Furphy by two customer segments (i.e. those purchasing directly, and those purchasing through sales representative)”

 

Task 4. – Forecasting production

 

Furphy’s quarterly beer production from the second quarter of 2008 until the end of the 2017

Financial Year are given in the Furphy_Product worksheet. Your job is to develop a proper forecasting model to predict turnover for the next four quarters.

 

In your technical report, you must explain the reason for selecting the forecasting method to predict future beer production. The report also must include a detailed interpretation of the  final model (e.g. a practical interpretation of the time-series model, choices about smoothing techniques etc.).

 

Task 5. – Technical report

 

Your technical report must be as comprehensive as possible. ALL aspects of your analysis and final outputs must be described/interpreted in detail. Remember, your audience are well-experienced in analytics and expect nothing but perfection from your report. Perfection means  quality content

(demonstrated attention to details) as well as an aesthetically appealing report.

 

Note: The use of technical terms is acceptable in this assignment.

 

Your report should include an introduction as well as a  conclusion. The introduction begins by highlighting the main purpose(s) of analysis and concludes by explaining the structure of the report (i.e., subsequent sections). The conclusion should highlight the key findings and explain the main limitations.

Submission Guide

 

The assignment consists of two parts: 1) Analysis and 2) Technical Report. You are required to submit both your technical report (Word.docx document only) and the analysis (Excel.xlsx file only).

 

1)   Analysis (excel.xlsx)

 

The analysis should be submitted in the appropriate worksheets in the Excel file. Each step in the model buildings should be included in a separate tab (e.g. 2.2.a., 2.2.b., …; and 3.2.a. 3.2.b., …). If you need more worksheets, then add them.

 

Before submitting your analysis make sure it is logically organised and any incorrect or unnecessary output has been removed. Marks will be deducted for poor presentation or disorganised/incorrect results. Your worksheets should follow the order by which tasks are allocated in the minutes of the meeting document.

 

Note: Give the Excel file the following name A2_YourStudentID.xlsx (use a short file name while you are doing the analysis.

 

2)   Technical Report (word.docx)

 

Your technical report consists of four sections: Introduction, Main Body, Conclusion, and Appendices. The report should be approximately 2,500 (± 300) words.

 

Use proper headings (i.e., 1., 2.1., 2.2., …) and titles in the main body of the report. Use sub-headings where necessary.

 

Your report may include relevant excel outputs including tables, charts, and graphs but ONLY as Appendices (appendices are not included in the word count). Make sure these outputs are visually appealing; have  consistent formatting style and  proper titles (title, axes titles etc.); and are  numbered correctly. Where necessary, refer to these outputs in the main body of the report.

 

Note: Give the report the following name A2_YourStudentID.docx.

 

 

5

 

 

 

 

3

 

Sample Rubric

 

Criteria Name

Criteria Weight

Not Attempted

Needs Improvement

Satisfactory

Good

Very Good

Exemplary

Analysis

(35%)

 

GLO1

 

GLO

 

 

Task 1

 

 

5%

Does NOT use any appropriate descriptive analysis tool.

Use irrelevant or inappropriate descriptive analysis tool.

Use appropriate descriptive analysis tool BUT there are errors in the analysis.

Most relevant descriptive analysis tools are used BUT there are minor errors in the analysis.

All relevant descriptive analysis tools are used with minor

errors in the analysis.

Skilful and comprehensive descriptive analysis of all relevant variables using variety of techniques.

 

 

 

 

 

 

Task 2

 

 

 

 

 

 

10%

Does NOT use any appropriate bivariate exploratory data analysis tool.

Use irrelevant or inappropriate bivariate analysis tool.

Use appropriate bivariate analysis tool to identify IVs, BUT there are errors in the analysis.

Appropriate bivariate analysis tool is used, BUT NOT all relevant IVs are identified.

All relevant IVs are identified using proper bivariate analysis technique, BUT minor issues noted.

Skilful and comprehensive analysis of bivariate relationships is presented and all relevant IVs are identified.

Either inappropriate predictive model is developed and/or analysis lacks All steps of mode- building process missing.

Relevant IVs are included in the predictive model, BUT some steps of model-building process missing.

A predictive model is developed with All model-building steps included, BUT the final model is incorrect and/or there are many errors in the analysis.

An appropriate predictive model is developed with All model-building steps presented BUT there are minor errors in the analysis.

The final model includes those IVs that have predictive power with All steps in model-building process clearly presented.

Model-building process is presented in logical/comprehensive manner AND the final model is correct.

Interaction analysis is missing.

Interaction analysis is incorrect.

Analysis of interaction effects is presented BUT there are many errors.

Interaction analysis is done correctly BUT wrong visualisation technique is used.

Interaction analysis is presented accurately with proper visualisation technique BUT with minor errors.

Masterful analysis of interaction effects supplemented by a correct visualisation.

 

 

 

 

Task 3

 

 

 

 

10%

Either inappropriate predictive model is developed and/or analysis lacks All steps of mode- building process missing.

Relevant IVs are included in the predictive model, BUT some steps of model-building process missing.

A predictive model is developed with All model-building steps included, BUT the final model is incorrect and/or there are many errors in the analysis.

An appropriate predictive model is developed with All model-building steps presented BUT there are minor errors in the analysis.

The final model includes those IVs that have predictive power with All steps in model-building process clearly presented.

Model-building process is presented in logical/comprehensive manner AND the final model is correct.

Predicted probabilities are not calculated and/or a visualisation is missing.

Not All Predicted probabilities are calculated and/or a visualisation is missing.

All predicted probabilities are calculated and a visualisation is presented BUT there are many errors in the analysis.

All predicted probabilities are calculated and a visualisation is presented BUT there are minor errors in the analysis.

All predicted probabilities are calculated correctly and a proper visualisation is presented.

A skilful and comprehensive analysis of predicted probabilities is presented along with a well- structured visualisation.

 

 

Task 4

 

 

10%

Does not use any appropriate time-series techniques.

Uses irrelevant or inappropriate techniques to analyse the time-series and/or there are many errors in the analysis.

A relevant time-series model developed but there are many errors in the analysis.

A relevant time-series model is developed and but there are minor errors in the analysis.

Time-series model is developed correctly and relevant measure(s) for evaluating the model quality is presented.

Time-series model developed correctly and presented in a clear and logical fashion including relevant visualisations.

Interpretation

GLO1

 

GLO

 

 

-

 

 

60%

Does not communicate any of the main findings of the analysis in an accurate or meaningful way.

Interpretation and communication of findings is at a basic level or does not adequately explain the main findings of the analysis.

Explains the main findings of the analysis accurately and enables reader to draw some reasonable conclusions.

Provides an accurate description of the most - BUT NOT ALL - important features of the analysis, with appropriate conclusions.

Provides very detailed and accurate descriptions of the most important features of the analysis.

Provides an outstanding description and conclusion of All relevant analysis/visualisation outputs. Interpretation of results are novel and insightful.

Technical

Report

GLO1

 

GLO

 

 

 

-

 

 

 

5%

The technical report is poorly structured and/or few sections missing with a poor use of technical language.

The technical report is poorly structured. Only few analysis outputs are presented in appendix. Language is

difficult to follow with many grammatical errors noted.

The technical report is well- structured with All required sections included. Most relevant analysis outputs are included in appendix. Communication is NOT clear throughout the report and grammatical errors noted.

The technical report is well- structured with All sections included. All relevant analysis outputs are included in appendix. Communication is clear with NO grammatical errors noted.

The technical reports on par with a professional report. All relevant analysis outputs are presented in appendix in a logical order. Written communication is clear, easy to follow and has a structure.

The technical report is masterfully structured. All relevant analysis outputs are included in appendix. Outputs are visually appealing,

and follow a consistent

formatting style. Language is truly

professional and easy to follow

OVERALL                 100%

(Equivalent of 35 Marks)

 

0-29%

 

30%-49%

 

50%-59%

 

60%-69%

 

70%-79%

 

80%-100%

Overall Description

Fail (N)

Pass (P)

Credit (C)

Distinction (D)

High Distinction (HD)

 

Solution

High quality administrations being provided by assignmenthelp4me make it one of the highest rated online task help websites.

ORDER NOW

Assignmenthelp4me.com is online assignment assistance Provider Company with a difference. As we are in this field for several years, we have matured our processes over the period of time, to ensure delivery of high quality assignments with consistency. Our success in touching high quality levels and positive feedback from the customers has given us confidence to expand ourselves into new geographies. As a result, we have been innovative and creative in getting clients’ delight and establishing good customer relationship.