Question

In: Statistics and Probability

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


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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT