A national bank that is developing very rapidly will impose a new mechanism in customer service. For this reason, trials were conducted at several branch offices. If from the trial it turns out consumers are more satisfied then the new mechanism will be applied to all of its branch offices. 24 customers were chosen to be asked for their opinion on the new mechanism. Their answer is to compare to various elements of the new mechanism with existing ones. There are 3 elements assessed, namely ease, speed, and convenience of the transaction. In each element there are several measurement measures. The various assessment measures of the 3 elements are combined into a single ordinal scale that shows the comparison of the quality of service, between new and existing ones. The scale value ranges from -7 to +7. The greater number indicates the assessment of the quality of the new mechanism which is better than the existing method. A zero value means there is no difference between the two service mechanisms. The following data is from a trial customer:

Based on the sample data, test that customers tend to prefer new mechanisms over existing ones, using a confidence level of 98%.

All questions in this assignment refer to the “om” database (or Schema) that you will find in your MySQL Workbench program if you have run the sample database install script.

Please save all of your answers in one script (.sql) or type all your answers into Notepad++ and submit them as a single .sql file. You are encouraged to test your SQL statements in Workbench, and please use the ‘tidy’ tool to properly format your SQL before you save it as a Script from Workbench or Notepad++. Use comments to indicate the question number for each answer. Please give all code. Don't give same like other code. Please do with error free.

1. Write a SELECT statement that returns the title, artist and unit_price columns from the items table. Return only those items that have a unit_price of at least $16, but less than $17.50

2. Write a SELECT statement to return all columns from the customers table where the customer’s state is Ohio (OH). Sort the results by last name in descending order.

3. Write a SELECT statement to return all columns from the customers table whose zip code begins with a “9”

4. Write a SELECT statement to return the order_id from the orders table where the number of days between the order_date and the shipped_date is less than 6

5. Expand the statement in question 4 to include the number of days between order and ship date as a column alias called ‘processing_days’ and sort the results by that column in ascending order

Oxnard Petro, Ltd., has three interdisciplinary project development teams that function on an ongoing basis. Team members rotate from time to time. Every 4 months (three times a year) each department head rates the performance of each project team (using a 0 to 100 scale, where 100 is the best rating). Are the main effects significant? Is there an interaction?

(a-1) Choose the correct row-effect hypotheses.

• a

• b

(a-2) Choose the correct column-effect hypotheses.

• a

• b

(a-3) Choose the correct interaction-effect hypotheses.

• a

• b

(b) Fill in the missing data. (Round your Table of Means values to 1 decimal place, SS and F values to 2 decimal places, MS values to 3 decimal places, and p-values to 4 decimal places.)

(c) Using α = 0.05, choose the correct statement.

• The main effects of department and year are significant, but there is not a significant interaction effect.

• The main effect of department is significant; however, there is no significant effect from year or interaction between department and year.

• The main effect of year is significant; however, there is no significant effect from department or interaction between department and year.

(d) Interpret the p-values carefully.

The p-values range from highly significant (Department) to insignificant (Year). The interaction effect, if any, is  (Click to select)  weak  strong  since about  (Click to select)  71  90  39  samples in 100 would show an F statistic this large in the  (Click to select)  presence  absence  of interaction.

Problem 5-41 (Algorithmic)
Absorption Costing vs. Variable Costing: Benefits and Calculation of Net Operating Income

Safety Shoes, Inc. produces a variety of products for the manufacturing industry. Hiking-style steel toe boots are among its most popular products. The company's controller spoke to the company's president at a meeting last week and told her that the company was doing well, but that the financial picture depended on how product costs and net operating income were calculated. The president did not realize that the company had options with regard to calculating these numbers, so she asked the controller to prepare some information and be ready to meet with her to talk more about this issue. In preparing for the meeting, the controller accumulated the following data:

Beginning inventory 27,000

Units produced 101,000

Units sold 112,000

Fixed manufacturing overhead $380,000

Direct materials per unit $22.00

Direct labor per unit $33.00

Variable manufacturing overhead per unit $15.00

A. Compute the cost per unit, using absorption costing. (Answer is 74)

B. Compute the cost per unit, using variable costing. (Answer is 70)

C. Compute the difference in net operating income between the two methods. If there is no difference in net income, enter "0". Do not round your interim calculations.

D. Assume that production was 101,000 units and sales were 70,000 units. What would be the difference in net operating income between the two methods? If there is no difference in net income, enter "0". Do not round your interim calculations.

Important: please show work for each question. Thank you!

In a previous section of PSY230, the second exam was worth 80 points. The scores from that class were normally distributed with a mean (μ ) of 65 and a standard deviation (σ) of 5. If the exam scores were converted to a Z distribution, the distribution would form a perfect bell shape. The following questions require locating individual exam scores on the Z distribution and examine the percentage (or proportion) of cases above or below a score.

Hints: It helps to draw a Z distribution (bell curve) and place John’s and Tom’s Z scores on the distribution for answering the questions. Use the Z table for converting between Z score and area (percentage) of the distribution.

1. John obtained a score of 74. What is John’s z score?

2. What is the percentage of the students that scored higher than John?

3. If 50 students were in that class, about how many of them scored lower than John’s score? (You can round your answer to the nearest whole number.)

4. Tom obtained a score of 59. What is Tom’s z score?

5. What is the percentage of students that scored between John and Tom?

6. There are 50 students in the class, so about how many of them would likely score lower than Tom? (You can round your answer to the nearest whole number.)

7. Anna only knows that she scores at 87^th percentile on this exam, what is her z score?

8. Based on the result of the previous question, what would be Anna’s actual score on the exam?

Identify and briefly discuss three different debt products appropriate for different situations. What is the difference between secured and unsecured debt? IN DEPTH ANSWER PLEASE. TYPED ANSWER 500-800 words

A 2m long string is stretched between two supports with a tension that produces a wave speed equal to vw = 35 m/s. What are the wavelength and frequency of the first three modes that resonate on the string?

In San Francisco, 30%of workers take public transportation daily. In a sample of 10 workers, what is the probability that between three workers (inclusive) to seven workers (inclusive) take public transportation daily?

Are all liquid crystal polymers? What are thermotropic and lyotropic liquid crystals? What is the difference between nematic, smectic and cholesteric liquid crystals? Are those three the only possible liquid crystal phases?

1. IDENTIFY THREE THINGS THIS NURSE SHOULD HAVE DONE TO BREAK THE CHAIN OF INFECTION; AND NOTE WHERE IN THE CYCLE THESE SHOULD HAVE TAKEN PLACE. (i.e. between the portal of exit and mode of transmission).