Please do not waste my time if you do not know statistics.

This is part one of the homework. I will attach the file for the full homework.

CARS: A sample of 20 cars, including measurements of fuel consumption (city mi/gal and highway mi/gal), weight (pounds), number of cylinders, engine displacement (in liters), amount of greenhouse gases emitted (in tons/year), and amount of tailpipe emissions of NO_x (in lb/yr).

 

CAR	CITY	HWY	WEIGHT	CYLINDERS	DISPLACEMENT	MAN/AUTO	GHG	NOX
Chev. Camaro	19	30	3545	6	3.8	M	12	34.4
Chev. Cavalier	23	31	2795	4	2.2	A	10	25.1
Dodge Neon	23	32	2600	4	2	A	10	25.1
Ford Taurus	19	27	3515	6	3	A	12	25.1
Honda Accord	23	30	3245	4	2.3	A	11	25.1
Lincoln Cont.	17	24	3930	8	4.6	A	14	25.1
Mercury Mystique	20	29	3115	6	2.5	A	12	34.4
Mitsubishi Eclipse	22	33	3235	4	2	M	10	25.1
Olds. Aurora	17	26	3995	8	4	A	13	34.4
Pontiac Grand Am	22	30	3115	4	2.4	A	11	25.1
Toyota Camry	23	32	3240	4	2.2	M	10	25.1
Cadillac DeVille	17	26	4020	8	4.6	A	13	34.4
Chev. Corvette	18	28	3220	8	5.7	M	12	34.4
Chrysler Sebring	19	27	3175	6	2.5	A	12	25.1
Ford Mustang	20	29	3450	6	3.8	M	12	34.4
BMW 3-Series	19	27	3225	6	2.8	A	12	34.4
Ford Crown Victoria	17	24	3985	8	4.6	A	14	25.1
Honda Civic	32	37	2440	4	1.6	M	8	25.1
Mazda Protege	29	34	2500	4	1.6	A	9	25.1
Hyundai Accent	28	37	2290	4	1.5	A	9	34.4

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Part I

Generally the first step to analyze a dataset that is given to you is to identify the type of data, and picture the data using graphs etc. Use the data set above to answer the following questions:

 

 

1.      Assume that the car column represents all car models. Use the random number Table B, to generate a simple random sample of 15 car models from the set above.

 

 

 

2.      Classify all the columns: car, city, HWY, weight, cylinders, displacement man/auto GHG NOX according to the following:

i.                    Categorical or quantitative

ii.                  Discrete or continuous or none

iii.                Levels of measurement: nominal, ordinal, interval or ratio.

 

 

3.      Make a frequency distribution for MAN/AUTO

4.      Make a frequency distribution for DISPLACEMENT. (also include the column for cumulative frequency)

5.      Make a bar graph or pie chart for MAN/AUTO.

6.      Make a histogram for DISPLACEMENT.

i.                    Determine the type of skewness- left, right, symmetric or none.

ii.                  Determine the variability-high or low.

7.      Make a stemplot for CITY

i.        Determine the type of skewness- left, right, symmetric or none.

ii.      Determine the variability-high or low or none.

 

8.      Make a dotplot for CYLINDER.

i.                    Determine the type of skewness- left, right , symmetric or none.

 

ii.                  Determine the variability-high or low, or none.

The Balance Sheet provides a snapshot of the financial condition of a company at the end of an accounting period. It shows the assets, liabilities, and owner’s equity in the business.

 

1. 1.  Identify each of the following as an asset (A), contra asset (C), liability (L), or equity (E). Insert the appropriate letter in each field

 

A	cash
C	depreciation
C	equipment
A	inventory
L	loan

E	paid in capital
C	prepaid insurance
E	retained earnings
L	taxes owed
A	utility deposit

                                                                                             

 

 

 

 

 

1. 2.  In early December, Alice and Bob decided to open the Sample Cafe with $15,000 of their own money and $20,000 borrowed from a friend. They have spent $12,000 on equipment and furniture, and purchased $3,000 worth of inventory. Having put down a $2,500 deposit for a location on Main St., they will pay the first month’s rent when they open their doors on January 1st. HINT: Consider the change in each asset account, given the transactions above. Total Assets has been included as a second hint.

 

Create a balance sheet showing the financial position of the Sample Cafe as of December 31^st Use the data above. Remember, Assets must equal Total Liabilities + Equity.

 

SampleCafeBalanceSheet As of December 31, 20xx
Assets			Liabilities
Cash	$15,000		Loans	$20,000
Deposits	$2,500		Total Liabilities	$20,000
Furniture & Equip.	$12,000
Depreciation	$2,500		Equity
Inventory	$3,000		Owner’s Equity	$15,000
			Total Equity	$15,000
Total Assets	$35,000		Total Liab. & Equity	$35,000

 

 

1. 3.  The Sample Café nearly broke even in the first month of business. Below is a summary of revenue and expenses for January. Starting with the balance sheet from December 31st, use the results to create an updated balance sheet for January 31st. HINT: Remember, Net Income is added to Owner’s Equity; Net Loss is subtracted from Owner’s Equity. Total Assets has been added as a hint.

 

 

Sample Café Income StatementSummaryMonth Ended January31,20xx
Revenue	$30,000
Cost of Goods Sold	$3,500	$1,000 from inventory
Total Expenses	$27,000	Includes equipment depreciation of $200.
Net Income	($500)

 

SampleCafeBalanceSheet As of December 31, 20xx
Assets			Liabilities
Cash	$30,000		Loans	$20,000
Deposits	$2,500		Total Liabilities	$20,000
Furniture & Equip.	$0
Depreciation	$1,000		Equity
Inventory	$1,000		Owner’s Equity	$14,500
			Total Equity	$14,500
Total Assets	$34,500		Total Liab. & Equity	$34,500

 

1. 4.  What is the book value of the equipment at the end of January?

 

1. 5.  Alice and Bob had a small loss for the month. What happened to cash? Explain.