Assessment Overview
This assignment requires a substantial amount of computer work and written comment. You may need to seek guidance from your tutor along the way.
Some Hints & Tips about the questions and presentation are given below.
Make sure you read and follow these carefully.
Assessment Guideline
- Title Page – Make sure the front page of your assignment includes both your name, your student number, campus and signature
- The questions in this assignment are numbered. Your answers should also be numbered and written under the data analysis section in your report. Please follow this numbering.
- Recall that just because data for a variable is numerical does not mean that it is quantitative!
AssessmentBackground:
We have collected, edited, coded and tabulated the data collected on the questionnaire administered to the employees and customers from the Australian Tourism Industry in five Australian cities:
- Adelaide
- Brisbane
- Gold Cost
- Melbourne
- Sydney
As part of this assessment you will help us analyse this secondary data obtained to interpret the results.
We are assuming that there are these variables and 30 rows of data that you have to use to calculate your answers (based on the content covered from week 6-9)
| Column | Variable Name | Description |
| A | Customer ID | Customer Number |
| B | Gender | 1, 2 (male, female) |
| C | Age (Years) | Customer Age (years) |
| D | Hotel Type (Star Number) | 2,3,4 and 5 Star Hotels |
| E | Hotel Location | Adelaide, Brisbane, Gold Coast, Melbourne, Sydney |
| F | Room Type | 1, 2 and 3 (Standard, Medium and deluxe) |
| G | Low Season-Room Cost | Low Season-Room Cost $/Night |
| H | High Season-Room Cost | High Season-Room Cost $/Night |
| I | Low Season-Room Profit | Low Season-Room Profit $/Night |
| J | High Season-Room Profit | High Season-Room Profit $/Night |
| K | Staying Period (Nights) | Number of Nights |
| L | Customer Annual Income | Customer Income $/year |
| M | Other Costs $/Night | $/Year |
| N | Employee Average Annual Salary | $/Year |
| O | Customer Satisfaction | 5 very satisfied, 1 very dissatisfied |
| P | Employee Work Load & Satisfaction (1-5) | 5 very satisfied, 1 very dissatisfied |
Report –
- INTRODUCTION
- IDENTIFICATION OF THE VARIABLES – 3 MARKS
| No (Marks Allocated) | Questions |
| 2.1 Summary Table (3 Marks) | Provide a summary table listing each variable with information under the following column headings: Variable Name, Variable Description (see the information in the above table) and Variable Type (qualitative or quantitative). If the variable is quantitative you need to state whether it is discrete or continuous. |
- QUESTIONNAIRE (2 MARKS)
Write the questions that you think were asked in the questionnaire for collecting the information on each of these heads.
| No | Questions Heads | Relevant Questions |
| 1 | Gender | |
| 2 | Age (Years) | |
| 3 | Hotel Type (Star Number) | |
| 4 | Hotel Location | |
| 5 | Room Type | |
| 6 | Low Season-Room Cost | |
| 7 | High Season-Room Cost | |
| 8 | Low Season-Room Profit | |
| 9 | High Season-Room Profit | |
| 10 | Staying Period (Nights) | |
| 11 | Customer Annual Income | |
| 12 | Other Costs $/Night | |
| 13 | Employee Average Annual Salary | |
| 14 | Customer Satisfaction | |
| 15 | Employee Work Load & Satisfaction (1-5) |
- Data Analysis (Answers and Comments) – 17 Marks
| NO (MARKS ALLOCATED) | ACTIVITIES |
| 4.1 Data Count (1 Mark) | Count the data under each of the categories under Hotel Location using the COUNTIFfunction of excel. |
| 4.2 Bar Chart- Location (2 Marks) | Make a bar chart to representing the Hotel location data graphically. Comment on the results. |
| 4.3 Bar Chart – Satisfaction (3 marks) | Make a bar chart for the Customer Satisfaction (1-5 scaled) in your data.Comment on your findings |
| 4.4 Pie Diagram (2 Marks) | Produce a Pie diagram representing the data on Room type. Comment on the results. |
| 4.5 Central Tendencies (2 Marks) | Calculate the central tendencies for one of the columns of quantitative data from the data sheet Mean Median Mode Range Analyse and Comment on results. |
| 4.6 Histogram (3 marks) | Produce a histogram showing the distribution of the Customer Age in your data sample and provide your comments on the shape. |
| 4.7 Summary Table (2 Marks) + (2 Marks) | Prepare a single summary table that shows Average employee Annual Salary according Hotel Type, Hotel Location. Think carefully about the layout of rows and columns of your table. Provide your comments on both analysis results. |
5.0 Findings of the Survey: (3 Mark)
Interpreting the information based on your analysis provide your comments on the findings of this survey.
6.0 Conclusion
7.0 Reference (APA Style)
The post Assessment 2 Research Project- Data Analysis appeared first on My Assignment Online.