1. A random sample of 100 traditional aged college students were asked whether they would turn to their father or mother for advise if they had a personal problem.   A second sample of 100 different traditional aged college students was asked the same question regarding an academic issue.   If 47 of the students in the first sample and 56 of the students in the second sample replied that they turned to their mother rather than their father for help, test the hypothesis of no difference in the proportions. Use ΅ = 0.05.

H0=

H1= Test Statistic =

Critical Value=                       or P- value=

Conclusion=

2. Using the information contained within the previous problem,

1. Construct a 95% confidence interval for p1 - p2.
2. Does the interval support the results determined in the previous problem? Explain

(Long-Term Productivity Growth) Suppose that two nations start out in 2016 with identical levels of output per work hour—say, $100 per hour. In the first nation, labor productivity grows by 1 percent per year. In the second, it grows by 2 percent per year. Use a calculator or a spreadsheet to determine how much output per hour each nation will be producing 20 years later, assuming that labor productivity growth rates do not change. Then, determine how much each will be producing per hour 100 years later. What do your results tell you about the effects of small differences in productivity growth rates?

A random sample of 100 students at a high school was asked whether they would ask their father or mother for help with a homework assignment in science. A second sample of 100 different students was asked the same question in history. If 46 students in the first sample and 47 students in the second sample replied that they turned to their mother rather than their father for help, test the claim whether the difference between the proportions is due to chance. Use α = 0.02. Identify the claim, state the null and alternative hypotheses, find the critical value, find the standardized test statistic, make a decision on the null hypothesis (you may use a P-Value instead of the standardized test statistic), write an interpretation statement on the decision.

Write a java program that prompts user to enter his name and KSU ID using format name-ID as one value, his gender as char, and his GPA out of 5. Then your program should do the following:

Print whether the ID is valid or not, where a valid ID should be of length = 9, and should start with 4.
Calculate the GPA out of 100 which is calculated as follows GPA/5 * 100.
Update the name after converting the first letter to uppercase.
Print “Mr.” before name if the gender is ‘M’, and print “Mrs.” before name if the gender is ‘F’. Otherwise print message “invalid gender” without name and GPA. Then print the new GPA.

Increase all of the listing prices by 5% for all listings under $500,000 and 10% for all listings $500,000 and higher. Update the listings table with the new prices.

update LISTING
set LISTING_PRICE = LISTING_PRICE +
case
  when LISTING_PRICE < 500000 then (LISTING_PRICE*5)/100
  when LISTING_PRICE >= 500000 then (LISTING_PRICE*10)/100
  else 0
end

-- Add 30 days to the date expires for all listings.

update LISTING set DATE_EXPIRES = DATEADD(dd, 30, DATE_EXPIRES)

-- Add "Listing updated on [current date]." to the remarks. Replace [current date] with the current systems date. Do not replace the remarks currently in the table. Add these remarks to the remarks already in the table.

update LISTING set REMARKS=CONCAT(REMARKS ," ","Listing updated on ",GETDATE())

-- Return the following information from the listings table from the stored procedure to display the information in the new real estate app: address, city, state, zip, updated listing price, updated date expires, and updated remarks.

CREATE PROCEDURE DISPLAYLISTING
AS
BEGIN
select ADDRESS,CITY,STATE,ZIP,LISTING_PRICE,DATE_EXPIRES,REMARKS from LISTING;
END;

-- Call and run the stored procedure to make the appropriate updates and return the proper results.

In order to execute the stored procedures we use the following SQL script :

EXEC DISPLAYLISTING;

We can update and display the information from the listings table using following stored procedure as :

CREATE PROCEDURE DISPLAYLISTING
AS
BEGIN

update LISTING
set LISTING_PRICE = LISTING_PRICE +
case
  when LISTING_PRICE < 500000 then (LISTING_PRICE*5)/100
  when LISTING_PRICE >= 500000 then (LISTING_PRICE*10)/100
  else 0
end;

update LISTING set DATE_EXPIRES = DATEADD(dd, 30, DATE_EXPIRES);
  
update LISTING set REMARKS=CONCAT(REMARKS ," ","Listing updated on ",GETDATE());

select ADDRESS,CITY,STATE,ZIP,LISTING_PRICE,DATE_EXPIRES,REMARKS from LISTING;

END;

For this lab exercise you will be working with and modifying the stored procedure you created in the last module. In your stored procedure, the first three requirements performed updates to your database and the last two requirements returned the data that was updated. Perform the following:

1. Enclose the code for the first requirement in its own single transaction with the proper commit and rollback functions.

2. Enclose the code for both the second and third requirements in one single transaction with the proper commit and rollback functions.

3. Call and run the stored procedure to make the appropriate updates and return the proper results. Take the appropriate screenshots to show this working and insert into your screenshot document.

4. In the second transaction you created that included the code for the second and third requirements - create an error in the middle of the transaction between the code for the two requirements. For example, you can add an insert or an update statement that uses a field that does not exist. This would cause an error. When you run it, the error should cause the entire transaction to rollback. Because of this error, no changes should be made by this transaction. This is one way of testing your rollback code.

5. Call and run the stored procedure a second time to make the appropriate updates and return the proper results. The first transaction should run without any issues but the second transaction should rollback any changes it made.

You are going to take the stored procedure you created in the lab exercise from the last module and create two transactions within it. The first transaction will contain the first requirement from that module's lab exercise. The second transaction will contain the second and third requirements from that module's lab exercise. You will run it and take screenshots to show it working properly. Then you will purposely insert code to create an error in the middle of the second transaction, in between the two items to cause the transaction to fail and rollback any changes. You will run it again and take screenshots to show your rollback working properly.

?Staton-Smith Software is a new? start-up company and will not pay dividends for the first five years of operation. It will then institute an annual cash dividend policy of ?$4.75 with a constant growth rate of 4?%, with the first dividend at the end of year six. The company will be in business for 25 years total. What is the? stock's price if an investor wants
a. a return of 12?%?
b. a return of 13?%?
c. a return of 24?%?
d. a return of 35?%?

A borrower is offered a 30 year, fully amortizing ARM with an initial rate of 3.2%. After the first year, the interest rate will adjust each year, using 1 yr LIBOR as the index, plus a margin of 175bp. The price of the property is $8,000,000 and the loan will have an initial LTV ratio of 75% At the first reset date, 1 year LIBOR is at 3%. What is the borrower’s payment during the 2nd year of the loan?

Staton-Smith Software is a new​ start-up company and will not pay dividends for the first five years of operation. It will then institute an annual cash dividend policy of $3.75 with a constant growth rate of 6​%, with the first dividend at the end of year six. The company will be in business for 25 years total. What is the​ stock's price if an investor wants

a.  a return of 10​%?

b.  a return of 15​%?

c.  a return of 23​%?

d.  a return of 35​%?

1. What price do farmers get for their watermelon crops? In the third week of July, a random sample of 41 farming regions gave a sample mean of  = $6.88per 100 pounds of watermelon. Assume that σ is known to be $1.98 per 100 pounds.

1(a) Find a 90% confidence interval for the population mean price (per 100 pounds) that farmers in this region get for their watermelon crop (in dollars). What is the margin of error (in dollars)? (For each answer, enter a number. Round your answers to two decimal places.)
lower limit     $______
upper limit     $ ______
margin of error     $ ______

1(b) Find the sample size necessary for a 90% confidence level with maximal error of estimate E = 0.45 for the mean price per 100 pounds of watermelon. (Enter a number. Round up to the nearest whole number.)
________ farming regions

1(c) A farm brings 15 tons of watermelon to market. Find a 90% confidence interval for the population mean cash value of this crop (in dollars). What is the margin of error (in dollars)? Hint: 1 ton is 2000 pounds. (For each answer, enter a number. Round your answers to two decimal places.)
lower limit     $ ________
upper limit     $_______
margin of error $______

2. Find the mean, median, and mode of the data set.

• 9   2   8   2   7

mean____ (Enter a number.)  
median _____(Enter an exact number.)  
mode ____(Enter an exact number.)  

3. Assume that x has a normal distribution with the specified mean and standard deviation. Find the indicated probability. (Enter a number. Round your answer to four decimal places.)

μ = 4; σ = 2

P(3 ≤ x ≤ 7) =_______

4. Sketch the area under the standard normal curve over the indicated interval and find the specified area. (Enter a number. Round your answer to four decimal places.)

The area to the left of z = 0.53 is ______