Need it in 8 hours

hw_3.xlsx

Home >Business & Finance homework help >Economics homework help >Need it in 8 hours

take-home problems for Test #3

>> Neither give nor receive assistance on these problems.
>> A printout (via File/Print) of this worksheet/page is due at the beginning of class on Friday July 25.
>> Place all your answers in the boxes provided.
1.[16] Below, for a sample of 20 production runs for making a particular replacement part for refrigerators, are given:
X = the lot size (number of parts made in the run) and Y = labor hours (total labor hours to complete the run)
	Lot Size	Labor Hours		(a) Create a scatter diagram of the 20 data points, and superimpose on
	415	80		on the scatter diagram the best-fitting line.
	121	30		Be sure to provide an appropriate label for each of the horizontal and vertical axes.
	221	50
	376	90
	361	70
	224	60
	546	120
	352	80
	353	100
	157	50
	160	40
	252	70
	389	90
	113	20
	435	110
	420	100
	212	20
	268	50
	377	90
	421	110		(b) Use an Excel statistical function to determine the
				correlation (coefficient) between lot size and labor hours.
				(c) What type of relationship (choices: direct linear; inverse linear; non-linear; none)
				between lot size and and labor hours is suggested by your scatter diagram?
2.[16] Locate the requested data at the indicated website.
(a)	www.census.gov		In 2012, in Cobb County, Georgia, what estimated percentage of the civilian employed population
			16 years and over were employed in manufacturing?
(b)	www.census.gov		In 2012, in the Atlanta-Sandy Springs-Marietta metropolitan statistical area, what estimated percentage
			of all housing units were vacant?
(c)	www.stlouisfed.org		What was the price of one barrel of crude oil of the West Texas Intermediate variety
			on July 14, 2014? Note: Crude oil is considered a commodity.
(d)	www.worldbank.org		In 2011, what percentage of the land area of the United States was arable land?