To determine if the amount a family spends on their home depends on their income, a...

To determine if the amount a family spends on their home depends on their income, a social researcher collects the Median Household Income (in $1,000) and Median Home Prices (in $1,000) for 34 U.S. cities. The data appear in the HomePrice worksheet of the Simple Regression work sheet below..

a) Draw a scatter plot of the data. Does there appear to be a linear association between Household Income and Home Price?

b) Fit the simple linear regression model using Home Price as the dependent or Y variable and Household Income as the dependent or X variable. Is the model significant at  = 0.05?

c) What percentage of the variation in Home Price has been explained by the linear relationship with Household Income?

d) Provide the equation of the fit line. Interpret the parameter estimates in the context of the problem.

e) Use a hypothesis test to determine if the increase in house price is less than $4,000 for a $1,000 in household income, i.e., test the hypothesis null hypothesis Beta1 >or= to 4.0 versus the alternative Beta1 < 4.0 using alpha 0.05.

g) Provide a point prediction and a 95% confidence interval for the median house price for cities with a median household income of 100.

City	Income	Home
Alexandria, VA	59.976	290
Bernards Twp., NJ	112.435	279.9
Brentwood, TN	107.866	338.25
Bridgewater, NJ	93.484	316
Cary, NC	77.091	207
Centreville, VA	77.243	250
Chantilly, VA	94.864	320
Chesapeake, VA	53.758	150
Collierville, TN	85.716	230
Columbia, MD	77.033	199
Coral Springs, FL	62.632	218.5
Dranesville, VA	109.502	290
Dunwoody, GA	86.971	315
Ellicott City, MD	83.583	248
Franconia, VA	84.537	290
Gaithersburg, MD	64.944	220
Hoover, AL	64.431	170.45
Hunter Mill, VA	93.987	290
Lower Makefield Twp., PA	102.997	205
Manalapan Twp., NJ	91.245	410
Marlboro Twp., NJ	108.759	379.975
Matoaca, VA	65.149	135
Newtown, CT	97.723	358.5
North Andover, MA	79.169	342.5
Oakton, VA	90.824	341
Olney, MD	100.716	287.45
Peachtree City, GA	79.805	214.5
Ramapo, NY	64.954	330.875
Randolph Twp., NJ	104.121	444.5
Reston, VA	85.264	240
Roswell, GA	76.53	226.45
Sugarland Run, VA	103.35	278.25
Sully, VA	92.942	290
Wellington, FL	76.076	230

Solutions

Expert Solution

orchestra answered 1 year ago

Next > < Previous

Related Solutions

You are trying to estimate the average amount a family spends on food during a year....

You are trying to estimate the average amount a family spends on food during a year. In the past the standard deviation of the amount a family has spent on food during a year has been approximately $1000. If you want to be 99% sure that you have estimated average family food expenditures within (error) $50, how many families do you need to survey? Round your answer to a whole number

Princess Foods wants to determine if there is a relationship in the amount a household spends...

Princess Foods wants to determine if there is a relationship in the amount a household spends on prepared foods to family size and income. Parthika: Well, we still have data collected from a previous marketing study. Let’s use that. We have an Excel file. I am sure we can find the spreadsheet. It should have the exact information we need. Liwei: Yes, this could be interesting. We may find enough evidence to rethink the meal preparation kits again. Bonnie: Great...

The Jones family always spends 20 percent of its income on food, and the remainder on...

The Jones family always spends 20 percent of its income on food, and the remainder on other goods and services. Measure the quantities of food as well as other goods and services in dollars (with their respective prices normalized to equal 1). Suppose that the low level of income the family earns, $15,000 per year, makes it eligible for government assistance. a. Suppose that the family receives an income grant of $5,000 per year. How much food will it consume...

Suppose that you are interested in determining whether "consumption depends on income" or whether "income depends...

Suppose that you are interested in determining whether "consumption depends on income" or whether "income depends on consumption." Which of the following would be most relevant? Group of answer choices t-test F-test Chi-square test double-blind test Granger test

SA 1.(5 marks) Bob supports his family with monthly income of $500. Currently, he spends $200...

SA 1. Bob supports his family with monthly income of $500. Currently, he spends $200 on food and the remaining $300 on composite goods. Under the new income assistance program to be implemented next year, Bob will become eligible to receive food vouchers. Those vouchers provide Bob with $300 worth of free food every month. However, they cannot be sold or exchanged for other goods. True or False: Assuming that food is an inferior good for Bob, he will be...

A sociologist conducted a study to determine whether there is a linear relationship between family income...

A sociologist conducted a study to determine whether there is a linear relationship between family income level (in thousand of dollars) and percent of income donated to charities. Income level 42 48 50 59 65 72 (in 1000’s of $) Donating percent 9 10 8 5 6 3 A) Calculate the correlation coefficient B) Using = 0.05 is there enough evidence to conclude that there is a significant linear correlation between the income level and the donating percent?...

How should the owner of a detached home determine the amount of coverage to purchase in a homeowners' policy?

How should the owner of a detached home determine the amount of coverage to purchase in a homeowners' policy?a.Based on the replacement cost of the house.b.Based on the market value of the house.c.Based on the actual cash value of the house.d.Based on the owners' annual income.

For each of the following scenarios, determine the amount included in the taxpayer’s gross income for...

For each of the following scenarios, determine the amount included in the taxpayer’s gross income for 2019: Office Supplies, Inc., an accrual basis taxpayer, leases a copying machine to a new customer on December 23, 2019. The machine was to rent for $250 per month for a period of 24 months beginning January 1, 2020. The customer was required to prepay 2 months’ rent at the time the lease was signed on December 23,2019. The customer was also required to...

Determine the amount of the Earned Income Credit in each of the following cases. Assume that...

Determine the amount of the Earned Income Credit in each of the following cases. Assume that the person or persons are eligible to take the credit. Calculate the credit using the formulas. A single person with earned income of $7,554 and no qualifying children. A single person with earned income of $22,500 and two qualifying children. A married couple filing jointly with earned income of $34,190 and one qualifying child.

A survey conducted by the American Automobile Association showed that a family of four spends an...

A survey conducted by the American Automobile Association showed that a family of four spends an average of $215:60 per day while on vacation. Suppose a sample of 64 families of four vacationing at Niagara Falls resulted in a sample mean of $252:45 per day and a sample standard deviation of $74:50. Using a 98% confidence interval estimate, you wish to determine whether the average amount a family of four will spend when vacationing at Niagara Falls per day is...

Subjects