Statistical Applications Question 1 To improve the service of Colonial Hotel, management collected complaints

Statistical Applications

Question 1

To improve the service of Colonial Hotel, management collected complaints from customers over a one-year time period. The table below lists the complaints. (20 points)

Type of Complaints	Number of Customer with This Complaint	Relative Frequency
Room not clean enough	80
Room not ready on time	40
Items missing in the room	10
Noises from other rooms	100
Problems with room service	5
Bell boys not helpful	30
Problems with final bill	10
Ice machine not working probably	5
Other	20

Are these data values discrete or continuous? Why?
Determine the relative frequency (on the right column) and interpret guest dissatisfaction at this hotel.

Que stion 2

Each salesperson at Cherry Tree Hospitality Service is rated either below average, average, or above average with respect to sales ability. Each salesperson is also rated with respect to his or her potential advancement – either fair, good, or excellent. These traits for the 500 salesperson in this large corporation were cross-classified into the following table. You must show your work for this problem (15 points)

Potential for Advancement
Sales Ability Fair Good Excellent

Below average 16 12 22
Average 45 60 45
Above average 93 72 135

What is the probability a salesperson selected at random will have above
average sales ability and excellent potential for advancement?
What is the probability a salesperson selected at random is rated with

average sales ability or fair potential for advancement?

Question 3

The Dow Jones Industrial Average has reached 11000 points last week. An investment advisor specialized in sport company stocks predicts that the stocks of five sport companies she is following will continue to grow in the next 18 months. From this advisor’s records on stock picks, 40 percent of the stocks she recommends are profitable ( 20 points )

Required:

What is the probability that exactly two of the five stocks are profitable?
What is the probability that at least three of the five stocks are profitable?

Question 4

Seven food experts rated a newly developed fast food menu on a scale of 1 to 50. Their ratings were: 34, 41, 26, 29, 32, 36, 40. (20 points)

Require:

a. What is the mean rating?

b. What is the standard deviation?

c. A second group of experts rated the same fast food menu. The mean was 35.7, and the standard deviation 6.3. Compare the ratings with those of the first group of experts. What conclusion can you draw from the ratings by the two groups of experts regarding their opinions of this new fast food menu?

Question 5

Creek Ratz is a very popular restaurant located along the coast of Northern Florida. They serve a variety of steak and seafood dinners. During the summer beach season, they do not take reservations or accept "call ahead" seating. Management of the restaurant is concerned with the time a patron must wait before being seated for dinner. Listed below is the wait time in minutes, for the 25 tables seated last Saturday night: You must show your work for this problem (25 points)

28 39 23 67 37 28 56 40 28 50 51 45 44 65 61 27 24 61 34 44 64 25 24 27 29

Solve the following problems by hand and show all your work.

What is the mean number of wait time?
What is the median?
What is the sample variance
What is the sample standard deviation

e Write a paragraph to discuss the summary statistics you computed and any

recommendation you want to offer to the management.

Question 6

Solve the following problem by SPSS and interpret the results . (25 points)

In a recent study on tourist demographics, a research firm compiled the following data:

Traveler	Gender	Children at home	Respondent’s age	Vacations per year
1	m	Y	25	1
2	m	N	52	5
3	f	N	34	4
4	f	Y	33	1
5	f	Y	51	5
6	f	Y	29	0
7	m	Y	35	2
8	f	N	27	3
9	m	Y	46	4
10	m	N	30	3
11	f	N	45	6
12	m	Y	38	3
13	F	Y	42	4
14	F	Y	35	2
15	m	N	28	1

a. Develop a scatter diagram for the age and number of vacations taken per year.

b. What is the relationship between age and number of vacations taken per year?

c. Determine and interpret the regression equation. If age has been increased by 6 years,

how many vacations will be increased?

d. Report and interpret the coefficient of determination.

Question 7

SPSS work_Data is posted under Midterm Section of Bb : In fall semester 2003, graduate students in TSTD 277 and 251 courses conducted a research project for the Washington Convention and Tourism Corporation (WCTC). They did a survey of visitors who came to visit the Blues and Dreams program in D.C. organized by the local tourism industry, and then compiled the data with SPSS program. The data file is listed with this exam and also in the Project section of Blackboard, under the title of Exam 2 Data. Use this data file, create a table to compare the visitations to the 10 venues by local residents and out of town visitors. The table should include the following statistics for comparison:

Residency

Venue

Mean

Variance

Std. Deviation

Visitor residency (second variable resident : 0=non local resident, 1=local resident from the DC metro area)
Venue (the first variable venue with 10 venues listed on the Values column in Variable View

Write a paragraph to discuss your findings ( 25 points)

Note: The Blues and Dreams Celebration was a cultural program sponsored at ten venues in D.C. in fall 2004 (see variable 1 for the 10 venues participating in this program). It lasted for more than a month and celebrated African American culture and art.

Price: $31.89

Solution: The downloadable solution consists of 19 pages, 1289 words and 9 charts.
Deliverable: Word Document