Part a The Deli University Gift Shop purchases sweatshirts emblazoned with the school name and logo from a vendor in Spain Town at a cost of $2,000 each. The annual holding cost for a sweatshirt is calculated as 1.5% of the purchase cost. It costs the Gift Shop $500 to place a single order. The Gift Shop manager estimates that 900 sweatshirts will be sold during each month of the upcoming academic year

i) Determine the highest number of shirts that should be purchased by the Gift Shop in order to minimize stock administration costs.

ii) What is the number of orders to be placed each year?

iii)Compute the average annual ordering cost

iv) Compute the average annual carrying cost

v) Compute the total stock administration cost

Part b The maximum sale for the Gift Shop for any one week is 300 sweatshirts and minimum sales 150 sweatshirts. The vendor takes anywhere from 2 to 4 weeks to deliver the merchandise after the order is placed. Using the EOQ policy, determine the re-order level, minimum inventory level and maximum inventory level for the business.

Q: Let’s say you have an unordered list of numbers and you wanted to put them in order from lowest to highest value. How would you do that? You’re probably thinking that you would just look at all the numbers, find the lowest number and put it at the beginning of your list. Then you would find the next largest number and put it in the second spot in the list, and so on until you’ve ordered the entire list of numbers. It’s simple, basic, and not very exciting. Now, let’s say that instead of ordering the list yourself, you decide it’s a better idea to write a computer program to order the list for you. Now you don’t have to deal with moving the numbers around, you just need to tell your program how to move the numbers, and then let the program handle any list you give it.Identify all possible ways of telling your program how to move the numbers, where each way provides the required result.

(Note: The program code is preferred to be in Java)

9. Discrete probability distributions #1

A study conducted by three law school professors found that asylum seekers in the United States face broad disparities in the nation’s immigration courts. The professors discovered that 54% of refugees who ask for asylum in the San Francisco immigration court win asylum, but only 12% are granted asylum in the Atlanta immigration court. [Source: Julia Preston, “Wide Disparities Found in Judging of Asylum Cases,” The New York Times, May 31, 2007.]

Select the appropriate distribution in the Distributions tool to help answer the questions that follow.

0123BinomialPoisson

Select a Distribution

You randomly select 20 refugees who are asking for asylum in the San Francisco immigration court. Let X denote the number of asylum seekers who win their cases.

The probability that exactly 11 asylum seekers are granted asylum is   .

The probability that at least seven asylum seekers are granted asylum is   .

The expected value of X is   , and the standard deviation of X is

10. Discrete probability distributions #2

The Geminids is an annual meteor shower that appears every December. Under a clear, dark sky, an observer of the Geminids would see an average of 20 meteors per 10-minute period (if the meteors’ emanation point were directly overhead).

Select the appropriate distribution in the tool to help answer the following questions. (Note: You will need to read the questions first to determine the appropriate distribution.)

0123BinomialPoisson

Select a Distribution

It’s December and you host a Geminids party on the peak night of the meteor shower. The sky is clear and dark, and the meteors’ emanation point is directly overhead. You and your friends watch the sky for 10 minutes. The probability that you see exactly 20 meteors is0.0888   .

The probability that you see more than 16 meteors while watching the night sky for 10 minutes is   .

Select the appropriate distribution in the tool below to help answer the following questions. (Note: You will need to read the questions first to determine the appropriate distribution.)

0123BinomialPoisson

Select a Distribution

After going inside for a midnight snack, you and your friends go back outdoors for a 25-minute sky-gazing session. The probability that you observe no more than 48 meteors during this sky-gazing session is   .

The number of meteor sightings over 20 minutes has an expected value of    and a standard deviation of   

The daily exchange rates for the​ five-year period 2003 to 2008 between currency A and currency B are well modeled by a normal distribution with mean 1.814 in currency A​ (to currency​ B) and standard deviation 0.035 in currency A. Given this​ model, and using the​ 68-95-99.7 rule to approximate the probabilities rather than using technology to find the values more​ precisely, complete parts​ (a) through​ (d).

Question: ​a) What would the cutoff rate be that would separate the highest 2.5​% of currency​ A/currency B​ rates? The cutoff rate would be ___________ (type an integer or a decimal rounded to the nearest thousandth as needed)

Question: What would the cutoff rate be that would separate the highest 50% ? The cutoff rate would be _______________

Question: What would the cutoff rate be that would separate the middle 68% ? The lower cutoff rate would be ____________

Question: The upper cutoff rate would be ? ____________________

Question: What would the cutoff rate be that would separate the highest 16%? ________________

BTN 15-9 Samsung, Apple, and Google are competitors in the global marketplace. Following are selected data from each company.

Page 661

Required

Compute Samsung’s return on total assets, and its components of profit margin and total asset turnover, for the most recent two years using the data provided.

Which of these three companies has the highest return on total assets? Highest profit margin? Highest total asset turnover? Interpret these results for the (a) current year and (b) prior year.

Q) Find the instructor earning the second highest salary. (Don’t use ORDER BY and LIMIT in your solution.) in MySQL

here is the table I am using named Instructor with the following 4 attributes:
Instructor(ID, name, dept_name, salary)

ID is the primary key

I am supposed to report the answer with the name, ID and salary of the second highest salaried instructor.

I know how to do it if I only needed to report the second highest salary, but I am having trouble getting it with the corresponding name and id as well. This is what I am trying:

Select ID, name, max(salary) as salary
From instructor
Where salary < (select max(salary)
               From instructor);


but it is saying "Error Code: 1140. In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'database.instructor.ID'; this is incompatible with sql_mode=only_full_group_by"


Any help is appreciated!

1. a) Submit a copy of your dataset along with a file that contains your answers to all of the following questions.

b) What the mean and Standard Deviation (SD) of the Close column in your data set?

c) If a person bought 1 share of Google stock within the last year, what is the probability that the stock on that day closed at less than the mean for that year? Hint: You do not want to calculate the mean to answer this one. The probability would be the same for any normal distribution. (5 points)

2. If a person bought 1 share of Google stock within the last year, what is the probability that the stock on that day closed at more than $950? (5 points)
3. If a person bought 1 share of Google stock within the last year, what is the probability that the stock on that day closed within $50 of the mean for that year? (between 50 below and 50 above the mean) (5 points)
4. If a person bought 1 share of Google stock within the last year, what is the probability that the stock on that day closed at less than $800 per share. Would this be considered unusal? Use the definition of unusual from the course textbook that is measured as a number of standard deviations (5 points)
5. At what prices would Google have to close in order for it to be considered statistically unusual? You will have a low and high value. Use the definition of unusual from the course textbook that is measured as a number of standard deviations. (5 points)
6. What are Quartile 1, Quartile 2, and Quartile 3 in this data set? Use Excel to find these values. This is the only question that you must answer without using anything about the normal distribution. (5 points)
7. Is the normality assumption that was made at the beginning valid? Why or why not? Hint: Does this distribution have the properties of a normal distribution as described in the course textbook? Real data sets are never perfect, however, it should be close. One option would be to construct a histogram like you did in Project 1 to see if it has the right shape. Something in the range of 10 to 12 classes is a good number. (5 points)

DATA SET- Closed stock prices

need this in C++

Start

Declarations

number currentTuition

number futureTuition

number interestRate

number numYears

number year

output "Please enter current tuition: "

input currentTuition

output "Please enter interest rate (e.g. 9.0 for 9 percent): "

input interestRate

output "Please number of years for tuition: "

input numYears

output “Tuition at year 1 is “, currentTuition

futureTuition = currentTuition

for year = 2 to numYears

futureTuition = futureTuition * (1 + interestRate/100)

output “Tuition at year “, year ,”is “, futureTuition

endfor

Stop

Win/Loss and With/Without Joe: Joe plays basketball for the Wildcats and missed some of the season due to an injury. The win/loss record with and without Joe is summarized in the contingency table below.

Observed Frequencies: O_i's

The Test: Test for a significant dependent relationship between the outcome of the game (win/lose) and whether or not Joe played. Conduct this test at the 0.05 significance level.

(a) What is the null hypothesis for this test?

H₀: The outcome of the game and whether or not Joe plays are dependent variables.

H₀: The outcome of the game and whether or not Joe plays are independent variables.     

H₀: The probability of winning is dependent upon whether or not Joe plays.

(b) What is the value of the test statistic? Round to 3 decimal places unless your software automatically rounds to 2 decimal places.

χ² =  

(c) USE SOFTWARE to get the P-value of the test statistic. Round to 4 decimal places unless your software automatically rounds to 3 decimal places.
P-value =  

(d) What is the conclusion regarding the null hypothesis?

reject H₀

fail to reject H₀    

(e) Choose the appropriate concluding statement.

We have proven that Joe causes the team to do better.

The evidence suggests that the outcome of the game is dependent upon whether or not Joe played.    

There is not enough evidence to conclude that the outcome of the game is dependent upon whether or not Joe played.

We have proven that the outcome of the game is independent of whether or not Joe played.

Win/Loss and With/Without Joe: Joe plays basketball for the Wildcats and missed some of the season due to an injury. The win/loss record with and without Joe is summarized in the contingency table below.

Observed Frequencies: O_i's

The Test: Test for a significant dependent relationship between the outcome of the game (win/lose) and whether or not Joe played. Conduct this test at the 0.05 significance level.

(a) What is the null hypothesis for this test?

H₀: The outcome of the game and whether or not Joe plays are dependent variables.

H₀: The probability of winning is dependent upon whether or not Joe plays.       

H₀: The outcome of the game and whether or not Joe plays are independent variables.

(b) What is the value of the test statistic? Round to 3 decimal places unless your software automatically rounds to 2 decimal places.

χ²

=  

(c) Use software to get the P-value of the test statistic. Round to 4 decimal places unless your software automatically rounds to 3 decimal places.
P-value =  

(d) What is the conclusion regarding the null hypothesis?

reject H₀

fail to reject H₀     

(e) Choose the appropriate concluding statement.

We have proven that Joe causes the team to do better.The evidence suggests that the outcome of the game is dependent upon whether or not Joe played.     

There is not enough evidence to conclude that the outcome of the game is dependent upon whether or not Joe played.

We have proven that the outcome of the game is independent of whether or not Joe played.