You wish to take an Excel course. You may enroll at one within your school or you may take a community class at the local library. You've gathered the following information to aid in your decision-making process.

Required:

a. Indicate in the table above which costs are relevant and which are not relevant in the choice between these two alternatives.

b. What is the differential cost between the two alternatives?

SHOW ALL WORK AND CALCULATIONS!

Match each scenario below with the most appropriate inferential technique. Group of answer choices

We want to test if at least half of students at a university feel as if the dorms need to be renovated.

We want to estimate the average number of calories in a combo meal at fast food restaurants.

The population standard deviation is unknown.

We want to test if the average number of miles that motorists drive between oil changes is greater than the recommended 3000 miles while assuming a population standard deviation of 1000 miles.

We want to test if high school marching bands are equally made up of freshmen, sophomores, juniors, and seniors.

We want to test if the average starting salary of software engineers out of college is greater than \$70,000. The population standard deviation is unknown. We want to estimate the proportion of people who speak more than one language fluently.

According to a recent government survey, the daily one-way commuting distance of U.S. workers averages 13 miles with a standard deviation of 13 miles. An investigator wishes to determine whether the national average describes the mean commute distance for all workers in the Chicago area. Commute distances are obtained for a random sample of 168 workers from this area, and the mean distance is found to be 10.5 miles. Test the null hypothesis at the.05 level of significance.

a. state the null hpothesis

b. state the alternative hypothesis

c. is this a one or two tail test? why?

d. will you conduct a t-test or z-test? why?

e. what is (are) the critical value (s)?

f. What is the decision rule?

g. calculate the statistic

h. what is your decision rule regarding null hypothesis and why?

i. interpretation of the results

The data in the table represent the weights of various domestic cars and their miles per gallon in the city for the 2008 model year. For these​ data, the​ least-squares regression line is ModifyingAbove y with -0.006x + 42.216. A twelfth car weighs 3,425 pounds and gets 12 miles per gallon.

​(a) Compute the coefficient of determination of the expanded data set. What effect does the addition of the twelfth car to the data set have on Rsquared​? ​

(b) Is the point corresponding to the twelfth car​ influential? Is it an​ outlier?

Car, Weight (pounds) x, Miles per Gallon y
1 3766 20
2 3989 21
3 3532 20
4 3170 22
5 2575 28
6 3735 20
7 2605 27
8 3772 18
9 3310 19
10 2993 26
11 2755 25

Suppose that wages in Miami among the immigrant population are $20,000 a year and everywhere else outside the United States they are $10,000. Suppose the cost of migrating to Miami is proportional to how far someone must travel.   The cost of migrating is M=$36,000+ 20m, where m is the number of miles an immigrant’s origin country is from Miami. Please use this information to answer the following questions.

1. If Colombia is 1,500 miles from Miami, what is the maximum subjective discount factor that a Colombian migrant would have and still choose to immigrate to Miami?

2. If Cuba is 200 miles from Miami, what is the maximum subjective discount factor that a Cuban migrant could have and still choose to immigrate to Miami?

3. Based on the prior two questions should we see more migrants from Cuba or Colombia come to Miami?

Select one:

a. Cuba

b. Columbia

A certain region would like to estimate the proportion of voters who intend to participate in upcoming elections. A pilot sample of 25 voters found that 15 of them intended to vote in the election. Determine the additional number of voters that need to be sampled to construct a 98​% interval with a margin of error equal to 0.06 to estimate the proportion.

The region should sample _______________ additional voters. ​(Round up to the nearest​ integer.)

________________________________________________________________________________________________

A tire manufacturer would like to estimate the average tire life of its new​ all-season light truck tire in terms of how many miles it lasts. Determine the sample size needed to construct a 96​% confidence interval with a margin of error equal to 3,200 miles. Assume the standard deviation for the tire life of this particular brand is 7,000 miles.

The sample size needed is____ . ​(Round up to the nearest​ integer.)

Using the Java programming language: Create and implement a class Car that models a car. A Car is invented to have a gasoline tank that can hold a constant max of 12.5 gallons, and an odometer that is set to 0 for a new car. All cars have an original fuel economy of 23.4 miles per gallon, but the value is not constant.

Provide methods for constructing an instance of a Car (one should be zero parameter, and the other should take one parameter, namely a value for the fuel efficiency). Additional method simulates the car traveling a given number of miles (at the end of traveling that user-specified distance, the odometer is updated and the gas tank level is reduced by an elementary calculation using the miles driven and fuel efficiency), to fill a given number of gallons to the tank, to get the odometer reading, and to get the gas tank level in gallons. (Test case that makes sure the tank isn’t already at capacity)

Java Program. !ONLY USING WHILE LOOPS!

(Completed but with errors, wanted to revise could anyone re-create this?)

Write a program to keep track of the number of miles you have driven during an extended vacation and the number of gallons of gasoline you used during this time, recorded at weekly intervals. This vacation will last over several weeks (the precise number of weeks while making the program is unknown to the coder). Ask the user to enter the number of miles driven afterward ask them how many gallons of gasoline they purchased for each week of the vacation. If the user enters -99 when asked for the number of miles driven, the vacation is over and the program will end by printing "Vacation Over!".   Express all numeric values rounded to the nearest hundredth.  

The task is to create this in Java using only while loops.

Thank you.

In the following, S0 is the stock price in dollars as of today, K is the strike price in dollars, r is the continuously-compounded risk-free interest (as a decimal), q is the continuous dividend yield (as a decimal), sigma is the volatility (as a decimal) and T is the time to maturity in years. Compute option prices in dollars for the following types of options and the following parameter values with a three step binomial tree.

A. S0 = 100, K = 100, r = 0.07, q = 0.05, sigma = 0.3, T = 1. European call. What is the price in dollars today?

B. S0 = 100, K = 100, r = 0.07, q = 0.05, sigma = 0.3, T = 1. European put. What is the price in dollars today?

C. S0 = 100, K = 100, r = 0.07, q = 0.05, sigma = 0.3, T = 1. American call. What is the price in dollars today?

D. S0 = 100, K = 100, r = 0.07, q = 0.05, sigma = 0.3, T = 1. American put. What is the price in dollars today?

We define the “Early exercise premium” to the difference between the American option price and the corresponding European option price. For the case of call options, and S0 = 100, r = 0.07, q = 0.05, sigma = 0.3, T = 1.

E. What is the Early exercise premium when K = 100?

F. What is the Early exercise premium when K = 125?

G. What is the Early exercise premium when K = 75?

H. What is the Early exercise premium when K = 60?

I. In the case that S0 = 100, r = 0.07, q = 0.05, sigma = 0.3, T = 1, and for an American call option with strike K = 60, what is the price in dollars today?

J. In the case that S0 = 100, r = 0.07, q = 0.05, sigma = 0.3, T = 1, and for an American call option with strike K = 60, at what time would a holder of the option optimally exercise?

All the questions above set the dividend yield to q = 0.05. Change the dividend yield to q = 0.10 and answer the questions corresponding to questions E, F, G and H above.

K. What is the Early exercise premium when the dividend yield q = 0.10 and K = 100?

L. What is the Early exercise premium when the dividend yield q = 0.10 and K = 125?

M. What is the Early exercise premium when the dividend yield q = 0.10 and K = 75?

N. What is the Early exercise premium when the dividend yield q = 0.10 and K = 60?

Now set the dividend yield q = 0.10 and the strike K = 75. . For the case of the European call, q = 0.10 and K = 75, what is the Delta (position in stock to make portfolio of the stock and a short position in one option riskless).

P. For the case of the American call, q = 0.10 and K = 75, what is the Delta (position in stock to make portfolio of the stock and a short position in one option riskless).

Heating, Ventilating and Air Conditioning (HVAC) Systems create and maintain the levels of comfort required by guests and employees. HVAC systems must be properly selected, operated and maintained if they are they are to provide an appropriate level of comfort.

How do you think a hotel building stays cool?