Problem 4 (20 pt.)
Given the following dataset:

Supposethatyouwanttoclassifyanobservation?=(?.?, ?.?, ?.?)using?-NearestNeighbors with Euclidean distance as the proximity metric. Answer the following questions:

1. (8 pts.) What is the distance between ? and every observation in the dataset?

2. (3 pts.) What is the predicted class label for ? if ? = ??

3. (3 pts.) What is the predicted class label for ? if ? = ??

4. (3 pts.) What is the predicted class label for ? if ? = ??

5. (3 pts.) What is the predicted class label for ? if ? = ??

Let x be a random variable that represents the weights in kilograms (kg) of healthy adult female deer (does) in December in a national park. Then x has a distribution that is approximately normal with mean μ = 70.0 kg and standard deviation σ = 7.3 kg. Suppose a doe that weighs less than 61 kg is considered undernourished.

(a) What is the probability that a single doe captured (weighed and released) at random in December is undernourished? (Round your answer to four decimal places.)


(b) If the park has about 2650 does, what number do you expect to be undernourished in December? (Round your answer to the nearest whole number.)
does

(c) To estimate the health of the December doe population, park rangers use the rule that the average weight of n = 45 does should be more than 67 kg. If the average weight is less than 67 kg, it is thought that the entire population of does might be undernourished. What is the probability that the average weight

x

for a random sample of 45 does is less than 67 kg (assuming a healthy population)? (Round your answer to four decimal places.)


(d) Compute the probability that

x

< 71.2 kg for 45 does (assume a healthy population). (Round your answer to four decimal places.)

Let x be a random variable that represents the weights in kilograms (kg) of healthy adult female deer (does) in December in a national park. Then x has a distribution that is approximately normal with mean μ = 60.0 kg and standard deviation σ = 8.4 kg. Suppose a doe that weighs less than 51 kg is considered undernourished.

(a) What is the probability that a single doe captured (weighed and released) at random in December is undernourished? (Round your answer to four decimal places.)

(b) If the park has about 2350 does, what number do you expect to be undernourished in December? (Round your answer to the nearest whole number.)

(c) To estimate the health of the December doe population, park rangers use the rule that the average weight of n = 50 does should be more than 57 kg. If the average weight is less than 57 kg, it is thought that the entire population of does might be undernourished. What is the probability that the average weight x for a random sample of 50 does is less than 57 kg (assuming a healthy population)? (Round your answer to four decimal places.)

(d) Compute the probability that x < 61.2 kg for 50 does (assume a healthy population). (Round your answer to four decimal places.)

Most armadillos of the genus Dasypus give birth to four monozygotic young (i.e., identical quadruplets).

Which statement is correct?

A random variable that could be studied while monitoring this species could be the number of male young born.

Because there are four babies, the probability of four males or four females must be 1/4 .

Because the young are all identical, there is no randomness.

In the long run, an equal number of males and females will be born.

----------------------------------------------------------------------------------------------

Parking is often a challenge, and it is also expensive to park on many college campuses. It is very tempting to park without paying, but there is a risk of getting a ticket. Based on empirical data, here is a probability table that quantifies the chances of various outcomes.

Which statement is not true?

Suppose you park for two days and that the probability above is the same for both days and each day’s outcome does not affect the other day’s outcome. The probability that you will have no ticket over this two‑day period is 0.36.

You parked on campus from Monday to Thursday and did not receive a ticket. Then the probability of no ticket on Friday (assuming each day’s events are independent) is still 0.40.

The probability of being towed is 0.10.

The probability that you will be fined or towed is 0.20.

Over the past six months, Six Flags conducted a marketing study on improving their park experience. The study cost $3.00 million and the results suggested that Six Flags add a kid's only roller coaster.

Suppose that Six Flags decides to build a new roller coaster for the upcoming operating season. The depreciable equipment for the roller coaster will cost $50.00 million and an additional $5.00 million to install. The equipment will be depreciated straight-line over 20 years.

The marketing team at Six Flags expects the coaster to increase attendance at the park by 5%. This translates to 110,199.00 more visitors at an average ticket price of $39.00. Expenses for these visitors are about 11.00% of sales.

There is no impact on working capital. The average visitor spends $20.00 on park merchandise and concessions. The after-tax operating margin on these side effects is 38.00%. The tax rate facing the firm is 38.00%, while the cost of capital is 9.00%.

What is the project cash flow for year 0? (answer in terms of MILLIONS)

What is the project cash flow for year 1? (express answer in millions)

What is the NPV of this coaster project if Six Flags will evaluate it over a 20-year period? (Six Flags expects the first year project cash flow to grow at 5% per year, going forward)
(Express answer in millions)

Jose and Emily work as auditors for the state of Texas. They have been assigned to the audit of the Lone Star School District. There have been some problems with audit documentation for the travel and entertainment reimbursement claims of the manager of the school district. The manager knows about the concerns of Jose and Emily, and he approaches them about the matter. The following Conversations takes place:

Manager: Listen, I've requested the documentation you asked for, but the hotel says it's no longer in its system.

Jose: Don't you have the credit card receipt or credit card statement?

Manager: I paid cash.

Jose: What about a copy of the hotel bill?

Manager: I threw it out.

Emily: That's a problem. We have to document all your travel and entertainment expenses for the city manager's office.

Manager: Well, I can't produce documents that the hotel can't find. What do you want me to do?

Questions: Multiple Choice

The manager seems to be failing in regard to which Pillar of Character?

A. Caring

B. Respect

C. Responsibility

D. Fairness

If Jose and Emily decide to report this incident to the school, they would be operating under which Pillar of Character?

A. Caring

B. Respect

C. Responsibility

D. Fairness

1. You have been provided information on summary statistical data for two neighborhoods. Specifically, you have been provided calculations on the Average Price Per Square Foot, Average Age and Average, and the Average Prices for houses in the two neighborhoods and the Standard Deviation of each variable. Apply the method of Confidence Intervals at (97%) to Estimate answer the question whether:
   1. Average Age of House in each neighborhood is significantly different from 60 years
   2. Average Price of Houses in each neighborhood is significantly different from $415,000
   3. List at least two reasons that you think that the Average Price of houses and the Average Age of Houses in one neighborhood will be different from the other neighborhood in the file (You may use personal knowledge of the neighborhoods).

      Comparative Descriptive Statistics – Arocher vs Borough Park Average Price per Square Foot, Average Age of House & Average Price of House
      Neighborhood and Sample Size (n)	Average	Standard Error	Standard Deviation
      Average Age of House
      Staten Island, Arocher (40)	39.4250	4.48128	28.34213
      Brooklyn, Borough Park (49)	91.6939	2.04233	14.29628
      Average Price of House
      Staten Island, Arocher (40)	$396,374.30	$14,930.990	$94,431.873
      Brooklyn, Borough Park (49)	$696,638.78	$24,093.715	$168,656.005

Database Management System

Complete the following exercises in Connolly & Begg:

4.8 The following tables from part of a database held in a relational DBMS

Hotel (hotelNo, hotelName, city)

Room (roomNo, hotelNo, type, price)

Booking (hotelNo, guestNo, dateFrom, dateTo, roomNo)

Guest (guestNo, guestName, guestAddress)

a) Identify the foreign keys in this schema.

b) Explain how the entity integrity rule and the referential integrity rule apply to these relations.

5.8 Describe the relations that would be produced by the following relational algebra operations. In your description, make clear what attribute your relations have, and explain what each relation represents in the real world.

a) π_hotelNo(σ_{price > 50}(Room))

b) σ_{Hotel.hotelno = Room.hotelNo}(Hotel × Room)

c) π_hotelName(Hotel ⨝ _{Hotel.hotelNo = Room.hotelNo}(σ_{price > 50}(Room)))

The following tables form part of a Library database held in an RDBMS:

Book (ISBN, title, edition, year)

BookCopy (copyNo, ISBN, available)

Borrower (borrowerNo, borrowerName, borrowerAddress)

BookLoan (copyNo, dateOut, dateDue, borrowerNo)

Formulate the following queries in relational algebra:

5.24 List all book titles

5.25 List all book titles published in the year 2012.

5.27 List all copies of book titles that are available for borrowing.

5.30 List the names of borrowers with overdue book.s

Pacific Hotels operates a centralized call center for the reservation needs of its hotels. Costs associated with use of the center are charged to the hotel group (luxury, resort, standard, and budget) based on the length of time of calls made (time usage). Idle time of the reservation agents, time spent on calls in which no reservation is made, and the fixed cost of the equipment are allocated based on the number of reservations made in each group. Due to recent increased competition in the hotel industry, the company has decided that it is necessary to better allocate its costs in order to price its services competitively and profitably. During the most recent period for which data are available, the use of the call center for each hotel group was as follows: Division Time Usage(thousands of minutes) Number of Reservations (thousands) Luxury 220 104 Resort 110 143 Standard 440 273 Budget 330 780 During this period, the cost of the call center amounted to $870,000 for personnel and $660,000 for equipment and other costs.

Required: a. Determine the allocation to each of the divisions using the following:

1. A single rate based on time used. (Do not round intermediate calculations.)

2. Dual rates based on time used (for personnel costs) and number of reservations (for equipment and other cost). (Do not round intermediate calculations.)

Pacific Hotels operates a centralized call center for the reservation needs of its hotels. Costs associated with use of the center are charged to the hotel group (luxury, resort, standard, and budget) based on the length of time of calls made (time usage). Idle time of the reservation agents, time spent on calls in which no reservation is made, and the fixed cost of the equipment are allocated based on the number of reservations made in each group. Due to recent increased competition in the hotel industry, the company has decided that it is necessary to better allocate its costs in order to price its services competitively and profitably. During the most recent period for which data are available, the use of the call center for each hotel group was as follows:

During this period, the cost of the call center amounted to $890,000 for personnel and $630,000 for equipment and other costs.

Required:

a. Determine the allocation to each of the divisions using the following:

1. A single rate based on time used. (Do not round intermediate calculations.)

2. Dual rates based on time used (for personnel costs) and number of reservations (for equipment and other cost). (