1. Determine the sample size to survey the customers of a store in a mall, if there are 500 customers out of 11,000 that are in the stores of the corporation. Assume that the confidence level is 95% and the accepted margin of error is 0.05.

2. Determine the sample size from the previous exercise, assuming that the customer sample was taken from department stores where there are a total of 200 customers.

A bank wonders whether omitting the annual credit card fee for customers who charge at leats $2500 in a year will increase the amount charged on its credit cards. The bank makes this offer to an SRS of 200 of its credit card customers. It then compares how much these customers charge this year with the amount that they charged last year. The mean increase in the sample is $346, and the standard deviation is $112. Give a 99% confidence interval for the mean amount charges would have incremented if this benefit had been extended to all such customers.
Z* for 99% confidence is 2.58.

ESLA manufactures solar engines for tractor-trailers. Given the fuel savings available, new orders for 105 units have been made by customers requesting credit. The variable cost is $8,400 per unit, and the credit price is $10,250 each. Credit is extended for one period. The required return is 1.2 percent per period. If TESLA extends credit, it expects that 20 percent of the customers will be repeat customers and place the same order every period forever and the remaining customers will be one-time orders.

Grunewald Industries sells on terms of 3/10, net 60. Gross sales last year were $4,916,500 and accounts receivable averaged $480,500. Half of Grunewald's customers paid on the 10th day and took discounts. What are the nominal and effective costs of trade credit to Grunewald's nondiscount customers? (Hint: Calculate daily sales based on a 365-day year, calculate the average receivables for discount customers, and then find the DSO for the nondiscount customers.) Do not round intermediate calculations. Round your answers to two decimal places.

Nominal cost=

Effective cost=

Grunewald Industries sells on terms of 1/10, net 30. Gross sales last year were $4,342,000 and accounts receivable averaged $475,000. Half of Grunewald's customers paid on the 10th day and took discounts. What are the nominal and effective costs of trade credit to Grunewald's nondiscount customers? (Hint: Calculate daily sales based on a 365-day year, calculate the average receivables for discount customers, and then find the DSO for the nondiscount customers.) Do not round intermediate calculations. Round your answers to two decimal places.

Cost of Trade Credit

Grunewald Industries sells on terms of 3/10, net 60. Gross sales last year were $4,385,500 and accounts receivable averaged $466,000. Half of Grunewald's customers paid on the 10th day and took discounts. What are the nominal and effective costs of trade credit to Grunewald's nondiscount customers? (Hint: Calculate daily sales based on a 365-day year, calculate the average receivables for discount customers, and then find the DSO for the nondiscount customers.) Do not round intermediate calculations. Round your answers to two decimal places.

Do consumers spend more on a trip to Target compared to Walmart? Suppose researchers interested in this question collected a random sample from 80 Target customers and 85 Walmart customers by asking customers for their purchase amount as they left the stores. The 80 Target customers have the mean purchase amount $53 and the standard deviation $19. The 85 Walmart customers have the mean purchase amount $45 and the standard deviation $21.

1. [2 points] Is the data collected from independent samples or dependent samples?

2. [2 points] Is the relevant test statistic z-stat or t-stat?

3. [4 points] Write down the hypotheses of the test.

4. [4 points] The p-value is calculated to be 0.0056. Write down the conclusion of the test. Assume an α=0.05 level of significance.

A banking executive studying the role of trust in creating customer advocates has determined that 41 % of banking customers have complete​ trust, 45 % of banking customers have moderate​ trust, and 14 % have minimal or no trust in their primary financial institution. Of the banking customers that have complete​ trust, 69 % are very likely to recommend their primary financial​ institution; of the banking customers that have moderate​ trust, 18 % are very likely to recommend their primary financial​ institution; and of the banking customers that have minimal or no​ trust, 3 % are very likely to recommend their primary financial institution. Complete parts​ (a) and​ (b) below. a. Compute the probability that if a customer indicates he or she is very likely to recommend his or her primary financial​ institution, the banking customer also has complete trust.

Write and run SQL statements to complete the following tasks

1. Show the details of the employees who are located in area code 901 and their manager employee number is 108.
2. Show the details of the employees who are also mangers.
3. Show the details of the customers whose balance is greater than 220 but less than 500.
4. Show the details of the customers whose balance is highest.
5. Show customer 10014’s name and the product’s descriptions which he/she purchased and the number of units of each.
6. List the names of customers and the number of invoices each customer has generated.
7. Show the codes and names of the customers who have not generated any invoice.
8. Add a new attribute (column) engaged varchar(3) to the customer table and update the engaged attribute for the customers who have not generated any invoice to ‘No’.