Hotel Sport is in the suburb of large metropolitan area near a sports complex that has a stadium suitable for baseball and soccer games. The 250-room independent hotel is a select-service property in the mid-range category. Its rate structure is simple:

Rack                                         $190

Weekend                                 $159

Low season/Government    $140

Groups (of 15+)                     $130

Best available rate                 $120

Late August is traditionally a slow season in the hotel and business picks up in September after area businesses and government offices are back in full gear. The sell rate in late August is the $140 low season rate. For the weekend of August 20 to 22 the forecasted occupancy is around 130 rooms. The reservations on the book are 90 guaranteed and 25 non-guaranteed reservations. The hotel expects 15 walk-ins.

Questions

1. It is July 29. What rate should the revenue manager approve to quote for reservation inquiries for the weekend of August 20–22?

2. Now it is July 30. One day later: The Major League Soccer Franchise of the city had just clinched a spot in the playoffs and the first game in the elimination round will be against a team from California, the L. A. Galaxy. They have the world’s most famous superstar, David Beckham, in its lineup on August 21. All the hotels in the city are filling up fast and phones with reservation inquiries are ringing off the hook at the Sport.

What rate should the revenue manager approve to quote now for group reservation inquiries for the weekend of August 20–22? Are there any stay control measures that should be considered?

The coach of a very popular men’s basketball team claims that the average distance the fans travel to the campus to watch a game is 35 miles. The team members feel otherwise. A sample of 16 fans who travel to games was randomly selected and yielded a mean of M= 36 miles and s= 5 miles. Test the coach’s claim at the 5% (.05) level of significance.

one-tailed or two-tailed test:

State the hypotheses:

df=

tα or t value for the critical region =

s_M =   

t (test statistic)=

Decision:

A tire manufacturer claims its tires will last for 80,000 miles on average when properly maintained. To investigate this claim, a retail tire store has surveyed 49 recent customers of that particular tire and determined those tires lasted for an average of 77,470 miles. The population standard deviation is known to be 7,700 miles. Compute the value of the appropriate test statistic to test this claim.

Enter your answer as a decimal rounded to two places. Indicate a negative value with a "–" sign directly before the value.

Test statistic =

During the year 2019, Ricki, who is not self-employed and does not receive employer reimbursement for business expenses, drove her car 5,600 miles to visit clients, 10,600 miles to get to her office, and 500 miles to attend business-related seminars. All of this mileage was incurred ratably throughout the year. She spent $390 for airfare to another business seminar and $230 for parking at her office. Using the automobile expense rates in effect for 2019, what is her deductible transportation expense?

My answer - $3928 = incorrect

A Ministry of Transportation investigation on driving speed and gasoline consumption for midsize vehicles (in miles per gallon), resulted in the following data:

Speed (Miles per Hour) 55       50      25      60      `25    30     55      40      50      30

Miles per Gallon             25      26      35      21       32    30     23      25      25      28

1. Compute the covariance. ________________
2. Compute the coefficient of correlation. __________________
3. Based on (a) and (b), what conclusion can you reach about the relationship between driving speed and fuel consumption?

1. A major automobile company claims that its New electric powered car has an average range of more than 100 miles. A random sample of 50 new electric cars was selected to test the claim. Assume that the population standard deviation is 12 miles. A 5% level of significance will be used for the test.

1. What would be the consequences of making a Type II error in this problem?

2. Compute the Probability of making a Type II error if the true population mean is 105 miles.

3. What is the maximum probability of making a Type I error in this problem?

A prototype automotive tire has a design life of 38,500 miles with a standard deviation of 2,500 miles. The manufacturer tests 60 such tires. On the assumption that the actual population mean is 38,500 miles and the actual population standard deviation is 2,500 miles, find the probability that the sample mean will be less than 36,000 miles. Assume that the distribution of lifetimes of such tires is normal.

(a) Let X = number of miles on a single tire. Write the question above in terms of this variable X.

(b) Using the software tool above, find the probability stated on part (a)

(c) Using the software tool above, graph the probability of stated on part (b)

2. An automobile battery manufacturer claims that its midgrade battery has a mean life of 50 months with a standard deviation of 6 months. Suppose the distribution of battery lives of this particular brand is approximately normal. On the assumption that the claims are true, find the probability that a randomly selected battery of this type will last less than 48 months. (Use the software link for every question)

(a) Let X = number of months a battery will last. Write the question above in terms of this variable X

(b) Find the probability that a single battery of this type will last less than 48 months.

(c) Find the probability that the mean of a random sample of 36 batteries will be less than 48 months.

(d) Why do you think the values from part (b) and part (c) are different? Explain.

The Fast Freight Shipping Company charges the followingrates:

Weight of Package(kilograms)         Rate per 500 miles shipped

2 kg orless                                                   $1.10

Over 2 kg but not more than6kg                   $2.20

Over 6 kg but not more than 10kg                $3.70

Over 10 kg but not more than 20kg              $4.80

Write a program that asks for the weight of the package andthe distance it is to be shipped, and then displays thecharges.

Input Validation: Do not accept values of 0 or less for theweight of the package. Do not accept weights of more than 20 kg. Do not accept distances of less than 10 miles or more than 3,000miles.

Can someone do this in PYTHON please!

Sample Outputs

3kg and 501 miles = $4.40

7kg and 501 miles = $7.40

11 kg and 501 miles = $9.60

I don't know how to get these outputs

I JUST NEED THE IF/ELIF STATEMENTS IN ORDER TO GE THESE OUTPUTS, I ALREADY HAVE THE RESTRICTIONS IN CODE

weight=int(input("enter weight"))
while weight>=21 or weight<=0:
      print("weight must be greater than 0 but less than 20 ")
      weight=int(input("enter weight"))

shippingDistance=int(input("Enter Shipping Distance"))
while shippingDistance >= 3001 or shippingDistance <= 9:
    print("Distance must be between 10 and 3000 miles")
    shippingDistance=int(input("Enter Shipping Distance"))

Using Python:

1. Compute the difference of differences between consecutive numbers of a series:

input 
ser = pd.Series([1, 3, 6, 10, 15, 21, 27, 35])
 
output:
[nan, 2.0, 3.0, 4.0, 5.0, 6.0, 6.0, 8.0]
[nan, nan, 1.0, 1.0, 1.0, 1.0, 0.0, 2.0]

2. Compute the euclidean distance between two series:

Input: 

p = pd.Series([1, 2, 3, 4, 5, 6, 7, 8, 9, 10])
q = pd.Series([10, 9, 8, 7, 6, 5, 4, 3, 2, 1])

Desired Output: 

18.165

The average annual wind speed in Rochester, Minnesota is 13.1 miles per hour. A sample of 100 days is used to determine the average wind speed. Find the 98% confidence interval of the mean. Assume the standard deviation was 2.8 miles per hour.