The table below gives the average high temperatures in January and July for 12 random cities in a region with 192 192 cities. Write a 99 99​% confidence interval for the mean temperature difference between summer and winter in the region.

Mean High Temperatures ​( degrees °​F)

City A B C D E F G H I J K L

July 73 71 78 74 91 88 71 87 74 65 74 85

Jan. 35 37 40 37 56 53 39 45 46 43 19 36

The confidence interval is left parenthesis nothing comma nothing right parenthesis . , . ​(Round to one decimal place as​ needed.)

Assignment Description: In this assignment, a script file should be created to contain a set a SQL statements for the Pretty Prints Company to better manage their business. Use the database created for Pretty Prints in Assignment 2. Include the SQL statements to satisfy the following queries.

The following queries should be included in the script:

1. Create a view named Under_100. It consists of the item_id, title, artist, unit_price and order_qty for every print with a unit_price under 100 dollars.
2. Create a view named Allen. It consists of the customer_id, customer_name, customer_phone, title, and artist of each print ordered.
3. Create a view named orders. It consists of the item_id, title, artist, unit_price and order_qty for every print ordered in the range of 2014-01-01 and 2014-02-28.
4. Create a view named zip_27. It consists of the customer_name, customer_phone, title, artist and date_shipped of each print ordered by a customer whose zip code begins with 27.
5. Create the following indexes. Use the indicated index name.
   1. Create an index named customer_id on the customer_id field in the customers table.
   2. Create an index named name on the customer_name field in the customers table.
   3. Create an index named shipped on the customer_id and ship_date in the orders table.
6. Drop the name index.
7. Specify the integrity constraint that the unit_price of any print must be more than $35.
8. Create the following foreign keys within the prints database.

    a. customer_id is a foreign key in the orders table.

b. Item_id is a foreign key in the orderline table.

9. Add to the items table a new character field named type that is one character in length.

10. Change the type field in the items table to M for the print titled Skies Above.
11. Change the length of the artist field in the items table to 30.
12. What command would you use to delete the orders table from the prints database? (Do not delete the orders table.)

HERE IS DATABASE CREATED IN ASSIGNMENT 2:

USE PrettyPrints;

SELECT customer_name, customer_add, customer_city, customer_state, customer_zip FROM customers;
SELECT customer_name, customer_phone FROM customers WHERE customer_state = 'GA';
SELECT customer_name, customer_zip FROM customers WHERE customer_state = 'NC' OR customer_state = 'SC';
SELECT title, artist, order_date, ship_date FROM items,orders,orderline WHERE orders.order_id = orderline.order_id AND items.item_id = orderline.item_id;
SELECT * FROM items ORDER BY unit_price ASC;
SELECT * FROM items WHERE unit_price > 100.00;
SELECT * FROM items WHERE on_hand > 300;
SELECT title, unit_price, unit_price * 2 AS retail_price FROM items;
SELECT title, order_qty FROM items,orderline WHERE items.item_id = orderline.item_id;
SELECT title FROM items WHERE unit_price BETWEEN 40 AND 100;
Select customer_name, title, artist, sum (order_qty) from customers left outer join orders on customers.customer_id = orders.customer_id join orderline on orders.order_id = orderline.order_id join items on orderline.item_id = items.item_id group by items.artist order by items.artist;

SELECT c.customer_name, c.customer_phone FROM customers c LEFT OUTER JOIN orders o ON c.customer_id = o.order_id WHERE YEAR(o.ORDER_DATE) = '2014';

SELECT customer_name, sum(unit_price * 2) AS total_revenue FROM customers join orders on customers.customer_id = orders.customer_id join orderline on orders.order_id = orderline.order_id join items on orderline.item_id = items.item_id group by customer_name;
SELECT customer_state, COUNT(DISTINCT customer_name) AS number_of_customers FROM customers GROUP BY customer_state;

1. The faculty of a university mathematics department is concerned about the performance of students in the introductory calculus offered by the department and required of all science and engineering majors. Historically, class averages on the test have been about 75, a passing grade but indicative that students may not be learning the material as well as they need to in order to go on to the next course. The chair would like to raise the average to at least 80. The department decides to implement a tutoring program in which each section of the course has assigned to it an advanced student who has done very well in the course previously. That student attends the section assigned and is available for student consultation 10 hours each week outside of class. A random sample of 50 students from the first semester of the program is selected and the test score for each student in the sample is recorded. The sample of scores is provided below.

78      75      74      73      70      75      70      71      77      78

74      77      81      76      78      72      73      73      75      77

72      82      80      74      72      77      77      73      79      75

74      80      78      76      79      81      75      71      74      78

75      71      75      77      72      74      77      75      77      78

What do these 50 scores suggest about the chair’s concern? Be specific about assumptions, hypotheses being tested, test statistic used, and the critical region for your test. Interpret the results of your test in regard to the concerns of the chair. (You may do this test by hand or get SPSS to do it for you. If you use SPSS, please provide the output it produces along with your interpretation of the results.) As in problem 2, you need not consider any confidence intervals.

1. Among other things, the Container Store has grown and flourished because of strong customer relationships, which include listening to customer needs, containing products that meet customer needs, having salespeople who understand both customer needs and the products, and creating a store environment that is customer friendly both in layout and in culture. Suppose company management wants to formally measure customer satisfaction at least once a year and develops a brief survey that includes the following four questions. Suppose that the survey was administered to 115 customers with the following results. Use techniques presented in this chapter to analyze the data to estimate the population responses to these questions.

2. The Container Store is well known as a great company to work for. In addition, company management states that their employee is their number one stakeholder. Suppose in spite of their history as an employee-friendly company, management wants to measure employee satisfaction this year to determine if they are maintaining this culture. A researcher is hired by the company who randomly selects 21 employees and asks them to complete a satisfaction survey under the supervision of an independent testing organization. As part of this survey, employees are asked to respond to questions by providing a score of from 0 to 50 along a continuous scale, where 0 denotes no satisfaction and 50 denotes the utmost satisfaction. Assume that the data are normally distributed in the population. The questions and the results of the survey are shown below. Analyze the results by using techniques from this chapter. Discuss your findings.

Chamberlain Enterprises Inc. reported the following receivables in its December 31, 2021, year-end balance sheet:

Additional Information:

1. The notes receivable account consists of two notes, a $55,000 note and a $225,000 note. The $55,000 note is dated October 31, 2021, with principal and interest payable on October 31, 2022. The $225,000 note is dated June 30, 2021, with principal and 6% interest payable on June 30, 2022.
2. During 2022, sales revenue totaled $1,360,000, $1,290,000 cash was collected from customers, and $24,000 in accounts receivable were written off. All sales are made on a credit basis. Bad debt expense is recorded at year-end by adjusting the allowance account to an amount equal to 10% of year-end accounts receivable.
3. On March 31, 2022, the $225,000 note receivable was discounted at the Bank of Commerce. The bank's discount rate is 8%. Chamberlain accounts for the discounting as a sale.

Required:
1. In addition to sales revenue, what revenue and expense amounts related to receivables will appear in Chamberlain’s 2022 income statement?
2. & 3. What amounts will appear in the 2022 year-end balance sheet for accounts receivable and Calculate the receivables turnover ratio for 2022.

Chamberlain Enterprises Inc. reported the following receivables in its December 31, 2021, year-end balance sheet:

Additional Information:

1. The notes receivable account consists of two notes, a $55,000 note and a $225,000 note. The $55,000 note is dated October 31, 2021, with principal and interest payable on October 31, 2022. The $225,000 note is dated June 30, 2021, with principal and 6% interest payable on June 30, 2022.
2. During 2022, sales revenue totaled $1,360,000, $1,290,000 cash was collected from customers, and $24,000 in accounts receivable were written off. All sales are made on a credit basis. Bad debt expense is recorded at year-end by adjusting the allowance account to an amount equal to 10% of year-end accounts receivable.
3. On March 31, 2022, the $225,000 note receivable was discounted at the Bank of Commerce. The bank's discount rate is 8%. Chamberlain accounts for the discounting as a sale.

Required:
1. In addition to sales revenue, what revenue and expense amounts related to receivables will appear in Chamberlain’s 2022 income statement?
2. & 3. What amounts will appear in the 2022 year-end balance sheet for accounts receivable and Calculate the receivables turnover ratio for 2022.

Chamberlain Enterprises Inc. reported the following receivables in its December 31, 2018, year-end balance sheet: Current assets: Accounts receivable, net of $26,000 in allowance for uncollectible accounts $ 228,000 Interest receivable 7,850 Notes receivable 280,000 Additional Information: The notes receivable account consists of two notes, a $55,000 note and a $225,000 note. The $55,000 note is dated October 31, 2018, with principal and interest payable on October 31, 2019. The $225,000 note is dated June 30, 2018, with principal and 6% interest payable on June 30, 2019. During 2019, sales revenue totaled $1,360,000, $1,290,000 cash was collected from customers, and $24,000 in accounts receivable were written off. All sales are made on a credit basis. Bad debt expense is recorded at year-end by adjusting the allowance account to an amount equal to 10% of year-end accounts receivable. On March 31, 2019, the $225,000 note receivable was discounted at the Bank of Commerce. The bank's discount rate is 8%. Chamberlain accounts for the discounting as a sale.

Required: 1. Not including sales revenue, what revenue and expense amounts related to receivables will appear in Chamberlain’s 2019 income statement? 2. & 3. What amounts will appear in the 2019 year-end balance sheet for accounts receivable and Calculate the receivables turnover ratio for 2019.

Chamberlain Enterprises Inc. reported the following receivables in its December 31, 2018, year-end balance sheet: Current assets: Accounts receivable, net of $42,000 in allowance for uncollectible accounts $ 308,000 Interest receivable 15,200 Notes receivable 440,000 Additional Information: The notes receivable account consists of two notes, a $90,000 note and a $350,000 note. The $90,000 note is dated October 31, 2018, with principal and interest payable on October 31, 2019. The $350,000 note is dated June 30, 2018, with principal and 8% interest payable on June 30, 2019. During 2019, sales revenue totaled $1,520,000, $1,370,000 cash was collected from customers, and $40,000 in accounts receivable were written off. All sales are made on a credit basis. Bad debt expense is recorded at year-end by adjusting the allowance account to an amount equal to 10% of year-end accounts receivable. On March 31, 2019, the $350,000 note receivable was discounted at the Bank of Commerce. The bank's discount rate is 8%. Chamberlain accounts for the discounting as a sale. Required: 1. Not including sales revenue, what revenue and expense amounts related to receivables will appear in Chamberlain’s 2019 income statement? 2. & 3. What amounts will appear in the 2019 year-end balance sheet for accounts receivable and Calculate the receivables turnover ratio for 2019.

Chamberlain Enterprises Inc. reported the following receivables in its December 31, 2018, year-end balance sheet:

Additional Information:

The notes receivable account consists of two notes, a $60,000 note and a $200,000 note. The $60,000 note is dated October 31, 2018, with principal and interest payable on October 31, 2019. The $200,000 note is dated June 30, 2018, with principal and 6% interest payable on June 30, 2019.

During 2019, sales revenue totaled $1,340,000, $1,280,000 cash was collected from customers, and $22,000 in accounts receivable were written off. All sales are made on a credit basis. Bad debt expense is recorded at year-end by adjusting the allowance account to an amount equal to 10% of year-end accounts receivable.

On March 31, 2019, the $200,000 note receivable was discounted at the Bank of Commerce. The bank's discount rate is 8%. Chamberlain accounts for the discounting as a sale.

Required:
1. Not including sales revenue, what revenue and expense amounts related to receivables will appear in Chamberlain’s 2019 income statement?
2. & 3. What amounts will appear in the 2019 year-end balance sheet for accounts receivable and Calculate the receivables turnover ratio for 2019.

Chamberlain Enterprises Inc. reported the following receivables in its December 31, 2021, year-end balance sheet:

Additional Information:

1. The notes receivable account consists of two notes, a $55,000 note and a $225,000 note. The $55,000 note is dated October 31, 2021, with principal and interest payable on October 31, 2022. The $225,000 note is dated June 30, 2021, with principal and 6% interest payable on June 30, 2022.
2. During 2022, sales revenue totaled $1,360,000, $1,290,000 cash was collected from customers, and $24,000 in accounts receivable were written off. All sales are made on a credit basis. Bad debt expense is recorded at year-end by adjusting the allowance account to an amount equal to 10% of year-end accounts receivable.
3. On March 31, 2022, the $225,000 note receivable was discounted at the Bank of Commerce. The bank's discount rate is 8%. Chamberlain accounts for the discounting as a sale.

Required:
1. In addition to sales revenue, what revenue and expense amounts related to receivables will appear in Chamberlain’s 2022 income statement?
2. & 3. What amounts will appear in the 2022 year-end balance sheet for accounts receivable and Calculate the receivables turnover ratio for 2022.