A study was conducted to determine whether the final grade of a student in an introductory psychology course is linearly related to his or her performance on the verbal ability test administered before college entrance. The verbal scores and final grades for 1010 students are shown in the table below.

Find the following:

(a) The correlation coefficient: r=

(b) The least squares line: y^=

(c) Calculate the residual for the first student:

Income statements under absorption and variable costing Shawnee Motors Inc. assembles and sells snowmobile engines. The company began operations on August 1 and operated at 100% of capacity during the first month. The following data summarize the results for August: Sales (3,000 units) $570,000 Production costs (4,000 units): Direct materials $281,200 Direct labor 134,800 Variable factory overhead 67,600 Fixed factory overhead 44,800 528,400 Selling and administrative expenses: Variable selling and administrative expenses $81,900 Fixed selling and administrative expenses 31,700 113,600 a. Prepare an income statement according to the absorption costing concept. b. Prepare an income statement according to the variable costing concept.

1. Using the alter table command, add a new column named gender making sure that only values of M, F or O are allowed.

2. Modify the data in the customers table to change the state for customers with ID number 2, 4, and 5 to NV.

3. Create a sequence that starts with -100 and increments by 10. Show the first value of the sequence.

4. Create a table named MYDATA with the following columns: id (primary key) and name. Use your sequence created in question 28 to insert 2 rows for the table. Make up your own data for name.

5. Create an index on the CANDIDATE table on the upper-case values of the last name column.

The Sanding Department of Quik Furniture Company has the following production and manufacturing cost data for March 2020, the first month of operation.

Production: 6,940 units finished and transferred out; 3,000 units started that are 100% complete as to materials and 20% complete as to conversion costs.

Manufacturing costs: Materials $38,766; labor $20,500; overhead $43,213.

Prepare a production cost report. (Round unit costs to 2 decimal places, e.g. 2.25 and other answers to 0 decimal places, e.g. 125.)

Rebecca Company acquired an equipment on a 10-year non‑cancelable lease on January 1, 20X1. There were annual lease payments of $100 at the end of each of the ten years. The market interest rate was 10% compounded annually. Assume that the lease year coincides with the fiscal year. Present value of $1 annuity (n=10, i=10%) = 6.1446. Note that the useful life of the equipment is 12 years.

1. According to GAAP, is the above lease a capital or an operating lease? Why?
2. Irrespective of your answer to part 1, assume that the lease is a capital lease. Show the entries that the company will make at the inception of the lease and during the first two years of the lease term. (Use straight-line amortization method)

Fifty new computer chips were tested for speed in a certain application. The average speed, in Mhz, for the new chips was 495.6 and the standard deviation was 19.4.  

1. Compute a 95% confidence interval for the average speed using the sample of 50 computer chips.
2. An older version of the chips had a speed of 481.2 Mhz. Can you conclude that the mean speed for the new chips is greater than the average speed of 481.2 Mhz of the old chips?
3. A second sample of 100 new chips were selected and tested. The observed average computer speed was 500.3 mhz with standard deviation equal to 20.3. Can you conclude that the results from the first study are consistent with the second larger study?

Provide three examples of a biological organism converting one form of energy into another*.  For each example, include:

1.What form of energy do you start with and what form of energy is it converted into?
2.What does this allow the organism to do?

Finally, answer: is this conversion 100% efficient, and why or why not?

*Note: do not re-use the same forms of energy in the same order. For example, if your first example involves the conversion of chemical energy into mechanical energy, your second example can include the conversion of chemical energy into some other form of energy, or the conversion of some other form of energy into mechanical energy, but cannot be the conversion of chemical into mechanical again.

1. Recall from chapter 2 that the file of Supermarket Transactions.xlsx contains over 14,000 transactions made by supermarket customers over a period of approximately two years. To understand which customers purchase which products, use pivot tables to create a crosstabs and an associated column part for each of the following. For each, express the counts as percentages so that for any value of the first variable listed, the percentages add to 100%. Do any patterns stand out? a. State or Province versus Product Department b. Marital Status versus Product Category c. Annual Income versus Product Category

How do you do this using the most recent version of excel?

A standard electric motor is rated at 10 horsepower (HP) and costs $800. Its fullload

efficiency is specified to be 92%. A newly designed, high efficiency motor of

the same size has an efficiency of 95%, but costs $1,200. It is estimated that the

motors will operate at a rated 10-HP output for 2,000 hours a year, and the cost of

energy will be $0.07 per kilowatt-hour. Each motor is expected to have 12-year

life. At the end of 12 years, the first motor will have a salvage value of $50, and

the second motor will have a salvage value of $100. Consider the MARR to be

8%. (Note: 1HP = 0.7457 KW)

What is the net present value (NPW) of the cash flows associated with the high

efficiency motor?