Questions
The data in the attached excel file comes from Consumer Reports and was collected over a...

The data in the attached excel file comes from Consumer Reports and was collected over a two-year period. It gives the average mpg over a 195-mile trip, the weight of the vehicle (pounds), engine displacement (liters), number of cylinders, horsepower, type of transmission (0 = manual, 1 = automatic), the number of gears and whether the car was foreign (1) or domestic (0).

Part a: Build a model for predicting the average mpg based on the data in the attached excel spread sheet. Show and annotate your work in the excel spread sheet. Include an interpretation of the final model.

Part b: Using your final model from part a, construct an interval estimate of the average mpg of a vehicle which weighs 3000 pounds, with an engine displacement of 2.5 liters, 4 cylinders, 150 hp, manual transmission, 5 gears and is a domestic car. Explain what this means.

CASE TRIP MPG WEIGHT DISPLACE NO CYL HP TRANS GEARS FOR/DORM
1 32 2365 1.6 4 113 0 5 1
2 33 2430 1.6 4 108 0 5 1
3 42 1895 1.3 4 60 0 4 1
4 36 2320 1.6 4 74 1 3 0
5 32 2330 1.6 4 82 1 3 1
6 34 2255 1.5 4 68 1 3 1
7 36 2350 1.6 4 74 1 3 1
8 41 1635 1.3 4 58 0 4 1
9 36 2070 1.6 4 82 0 4 1
10 34 2115 1.5 4 68 0 4 1
11 35 1840 1.1 4 52 0 4 1
12 43 1970 1.5 4 78

0

4 1
13 51 1575 1.0 3 48 0 5 1
14 37 2185

1.5

4 68 0 4 1
15 36 2115 1.8 4 81 0 4 1
16 28 3040 2.2 4 145 1 4 1
17 34 2620 2.0 4 108 1 3 1
18 25 3230 3.0 6 142 1 4 1
19 29 2745 2.0 4 102 1 4 1
20 28 2573 1.9 4 110 1 4 1
21 27 2802 2.3 4 100 1 3 0
22 31 2699 2.0 4 90 1 3 0
23 36 2695 2.2 4 110 0 5 0
24 31 2885 2.5 4 100 0 5 0
25 23 3310 5.0 8 225 1 4 0
26 23 3430 5.0 8 170 1 4 0
27 29 2670 2.2 4 97 1 3 0
28 35 2925 2.0 4 115 1 4 1
29 28 2735 2.5 4 98 1 3 0
30 29 3155 3.0 6 140 1 4 0
31 30 2995 3.0 6 150 1 4 0
32 27 3150 3.0 6 136 1 3 0
33 29 2950 2.8 6 125 1 3 0
34 26 3295 3.8 6 140 1 4 0
35 28 2915 2.5 4 100 1 3 0
36 29 3220 2.8 6 125 1 4 0
37 26 2900 2.2 4 146 1 3 0
38 27 3205 2.5 4 153 1 4 1
39 26 2930 2.2 4 103 1 3 0
40 25 3320 3.0 6 157 1 4 1
41 26 3080 2.3 4 114 1 4 1
42 24 3625 3.0 6 136 1 3 0
43 23 3665 3.0 6 145 1 4 0
44 22 3625 2.4 4 106 1 4 1
45 23 3415 2.4 4 107 1 4 1

In: Statistics and Probability

Comparing accrual and cash-basis accounting, preparing adjusting entries, and preparing income statements [15-25 min] Sweet Catering...

Comparing accrual and cash-basis accounting, preparing adjusting entries, and preparing income statements [15-25 min] Sweet Catering completed the following selected transactions during May, 2012: May 1 Prepaid rent for three months, $1,500. 5 Paid electricity expenses, $400. 9 Received cash for meals served to customers, $2,600. 14 Paid cash for kitchen equipment, $2,400. 23 Served a banquet on account, $3,000. 31 Made the adjusting entry for rent (from May 1). 31 Accrued salary expense, $1,400. 31 Recorded depreciation for May on kitchen equipment, $40. Requirements 1. Prepare journal entries for each transaction. 2. Using the journal entries as a guide, show whether each transaction would be handled as a revenue or an expense using both the cash and accrual basis by completing the following table. Amount of Revenue (Expense) for May Date Cash-Basis Amount of Accrual-Basis Amount of Revenue (Expense) Revenue (Expense) 3. After completing the table, calculate the amount of net income or net loss for Sweet Catering under the accrual and cash basis for May. 4. Considering your results from Requirement 3, which method gives the best picture of the true earnings of Sweet Catering? Why?

In: Accounting

In 2007, France's GDP totaled $1.9 trillion and in 2006 GDP was $1.8 trillion. The total...

In 2007, France's GDP totaled $1.9 trillion and in 2006 GDP was $1.8 trillion. The total amount spent on new capital each year was $357 billion (2007) and $335 billion (2006). To calculate the amount of net investment in France for these years, you need to know:

A) The amount of financial capital available,

B) Saving,

C) The aggregated production function,

D) Depreciation.

In: Finance

Course: Theory of Interest (Actuarial Science) Chapter: Yield Rates Problem: On 1/1/2006, Anthony deposits $90 into...

Course: Theory of Interest (Actuarial Science)
Chapter: Yield Rates

Problem:

On 1/1/2006, Anthony deposits $90 into an investment account. On 4/1/2006 when the amount in the account is $x, a withdrawal of $W is made. The dollar-weighted rate of return is 20%. The time-weighted rate of return is 16%. Find W and x.
Answer: W = 24, x = $104.4

In: Finance

"A company bought a machine for $138,000. The machine was depriciated using a 5 year MACRS...

"A company bought a machine for $138,000. The machine was depriciated using a 5 year MACRS approach. After 3 years, the machine was sold at a salvage value of $83,500. Assuming a tax rate of 27%, what are the net proceeds from the sale of the machine?
(Hint: You will want to take your salvage values and add/subtract gains due to the sale.)"

In: Economics

Synovec Co. is growing quickly. Dividends are expected to grow at a rate of 27 percent...

Synovec Co. is growing quickly. Dividends are expected to grow at a rate of 27 percent for the next 3 years, with the growth rate falling off to a constant 7 percent thereafter.

  

If the required return is 14 percent and the company just paid a $2.20 dividend. what is the current share price?

Multiple Choice

  • $54.72

  • $51.68

  • $49.01

  • $53.62

  • $55.81

In: Finance

Elena filed her Form 1040, U.S. Individual Income Tax Return, for the 2006 taxable year on...

Elena filed her Form 1040, U.S. Individual Income Tax Return, for the 2006 taxable year on April 15, 2007. On May 15, 2007, the IRS assessed the $10,000 of tax reported by Elena on her 2006 Form 1040. Elena did not make any mistakes on her 2006 Form 1040; however, Elena did not pay the $10,000 tax liability reported on the Form 1040. On January 2, 2010, the IRS filed a Notice of Federal tax Lien against Elena, which attached to all Elena's property. On January 8, 2010, Elena requested for a Collection Due Process hearing before the IRS's Appeals Office. The Appeals Officer ruled against Elena, and Elena did not petition any court to review the Appeals Officer's determination. Assume that the Collection Due Process hearing process ended on February 10, 2010. Question: when did the statute of limitations on collection of Elena's 2006 income tax liability expire?

June 16, 2015.

April 15, 2017.

May 18, 2017,

June 17, 2017.

None of the above.

In: Accounting

1. What is the relationship between productivity and the standard of living? 2. What is the...

1. What is the relationship between productivity and the standard of living?

2. What is the difference between absolute advantage and comparative advantage?

3. List two factors that affect people's buying plans that lead to changes in demand (shifts in the demand curve.)

4. Did the four hurricanes in Florida in 2004 lead to a decrease in the quantity of orange juice supplied or a decrease in the supply of orange juice?

In: Economics

1. What accounting standard in 2004 caused stock options to decline as the primary source of...

1. What accounting standard in 2004 caused stock options to decline as the primary source of non-cash compensation? Why?

2. Does compensation expense from stock options meet the definition of an expense as discussed in SFAC 6? Why?

3. Do you think compensation expense from stock options should be recognized as an expense? Choose one position, and support it.

In: Accounting

Which one of the following statements is most correct about eurocurrencies? They are traded primarily outside...

Which one of the following statements is most correct about eurocurrencies?

They are traded primarily outside of Europe.

They are traded within the country of their denomination.

They are always issued in euros.

They are traded primarily in Europe.

They are traded outside the country of their denomination.

Which one of the following statements is correct about reinvoicing centers?

They are commonly used by small firms

They are subsidiaries of muntinational corporations and they consolidate currency hedging

They add a mark-up to customer deliveries

They are illegal in most countries

They are subsidiaries of muntinational corporations created to increase sales

Toyota Motors of Japan has outsourced some of its business operations to TCS of India. This is an example of

A licensing agreement

A foreign direct investment

An export agreement

A joint venture

A managerial contract

In: Finance