WorksheetsHMPE 211- DATA ANALYTICS IN HOSPITALITY INDUSTRY BSHM 2A
Total questions: 41
Worksheet time: 1hrs 5mins
Refers to the process of examining datasets to draw conclusions about the information they contain.
First-party data
Data Analytics
Second-party data
Third-party data
Aggregated data a company buys from a marketplace
Data Analytics
First-party data
Second-party data
Third-party data
Data a company collects about its own customers.
Data Analytics
First-party data
Second-party data
Third-party data
Data a company obtains from a known organization that collected .
Data Analytics
First-party data
Second-party data
Third-party data
Knowing exactly how much your facilities are being used helps to better understand maintenance needs.
Problem identification
Maintenance
New offerings
Correction of errors can only occur if you look at the data.
Maintenance
New offerings
Problem identification
New products, start new activities, enter new markets, and create new offers for your guests to broaden revenue streams.
New offerings
Maintenance
Problem identification
Is a computer program used to create electronic spreadsheets.
MS office
Excel
Graphs
Charts
Represent variations in values of data points over a given duration of time.
Graphs
Table
Charts
Excel
Is a powerful feature to group your data together in Excel.
Graphs
Excel
Charts
Table
Is a graphical representation of data, in which “the data is represented by symbols, such as bars in a bar chart, lines in a line chart, or slices in a pie chart.
Table
Excel
Charts
Graphs
Is the middle number in a sorted, ascending or descending, list of numbers and can be more descriptive of that data set than average.
Mean
Median
Mode
Standard deviation
Is the average or norm.
Mean
Median
Mode
Standard deviation
This is just as simple as it sounds; it is a count how many items or “observations’ you have.
Frequency
Counts
Mode
Mean
Is the number of occurrences of a repeating event per unit of time and how often something happens.
Counts
Frequency
Mode
Mean
It is the most frequent value.
Mean
Median
Mode
Standard deviation
Is a statistics that measures the dispersion of a datasets relative to its mean and is calculated as the square root of the variance.
Mean
Median
Mode
Standard deviation
Is a convenient program because it allow user to create large spreadsheets, reference information, and it allows for better storage of information.
Mode
Mean
MS office
Excel
Are used to describe the basic features of the data in a study. They provide simple summaries about the sample and the measures.
Inferential statistics
Descriptive statistics
Data analytics
Standard deviation
Psychologist known for developing four levels of measurement
Stanley Smith
Paul Smith
Clifford Smith
Sam Smith
A sub-type of nominal scale with only categories (e.g. male/female)
Descriptive
Inferential
Dichotomous
Ordinal scale
Are typically measures of non-numeric concepts like satisfaction, happiness, discomfort, etc.
Ratio scales
Interval scales
Nominal scales
Ordinal scales
Are the ultimate nirvana when it comes to data measurement scales because they tell us about the order, they tell us the exact value between units.
Ratio scales
Interval scales
Nominal scales
Ordinal scales
Are numeric scales in which we know both the order and the exact differences between the values. The classic example of an interval scale is Celsius temperature because the difference between each value is the same.
Nominal scales
Ordinal scales
Ratio scales
Interval scales
Are used for labeling variables, without any quantitative value and could simply be called “labels.”
Ordinal scales
Interval scales
Nominal scales
Ratio scales
Find the mean of 8,5,7,10,15,21
11
12
13
14
Find the median of the set of numbers: 1,2,3,4,5,6,7,8,9 and 10.
55
10
1
5.5
Find the mode from these test results: 90,80,77,75,66,43,65,90,75
80
77 and 66
75 and 90
65 and 90
Find the mean of these set of numbers: 100, 1050, 600, 320 and 150
333
444
440
320
Find the mean of 2+2+3+5+5+7+8
4.52
4.75
4.57
4.79
Find the mode of the set of numbers: 8, 5, 15, 18, 13, 20
5
18
13
no mode
Calculate the standard deviation of the following set of numbers: 88, 98, 93, 82 and 89.
5.985
5.958
6.958
6.895
Find the mode of the set of numbers: 3, 7, 5, 13, 3 , 9, 3, 7 and 4
3
7
4
13
Find the median of 1, 3, 3, 6, 7, 9, 8
8
7
6
3
These numbers are taken from the number of people that attended a particular church every Friday for 7 weeks: 62, 18, 39, 13, 16, 3, 25. Find the mean.
25
210
62
30
The following numbers represent the ages of guests on a birthday party in a hotel: 3, 6, 27, 13, 6, 8, 12, 20, 5, 10. Find the mean.
11
6
9
110
Find the mode for the following series of numbers:
2, 3, 6, 8, 11, 9, 8, 15, 6, 11, 16 and 6.
8
11
6
16
It is easy to remember because is sounds like “order” and that’s the key to remember with –it is the order that matters.
Nominal
Ordinal
Interval
Ratio
Types of Level of Measurement. (4 points)
Applications of Data Analytics in Hospitality Industry.
(5 points)
Give at least 3 examples of the key benefits of real-time data analytics for the hospitality industry. (3 points)
