A city in Texas wants to know the relationship between house size and the number of residents living in the house. The city has sampled 15 houses. Table below presents the number of residents and the house size. Obtain a regression equation and predict the house size required for a family of 5 residents?
|
Number of Residents |
House size (Sq. ft) |
|
3 |
1992 |
|
3 |
1754 |
|
3 |
1766 |
|
5 |
2060 |
|
6 |
2293 |
|
6 |
2139 |
|
3 |
1836 |
|
4 |
1924 |
|
6 |
2321 |
|
4 |
2060 |
|
3 |
1769 |
|
4 |
1955 |
|
5 |
2309 |
|
4 |
1857 |
|
4 |
1972 |
Let the number of residents be defined by x and house size by y
Let the Regression line be y = bo + b1x
where,
bo = ( Σy Σx2 - Σx Σxy ) / ( nΣx2 - (Σx)2 )
b1 = ( nΣxy - ΣxΣy ) / ( nΣx2 - (Σx)2 )
| Residents (x) | House Size (y) | x2 | xy | |
| 3 | 1992 | 9 | 5976 | |
| 3 | 1754 | 9 | 5262 | |
| 3 | 1766 | 9 | 5298 | |
| 5 | 2060 | 25 | 10300 | |
| 6 | 2293 | 36 | 13758 | |
| 6 | 2139 | 36 | 12834 | |
| 3 | 1836 | 9 | 5508 | |
| 4 | 1924 | 16 | 7696 | |
| 6 | 2321 | 36 | 13926 | |
| 4 | 2060 | 16 | 8240 | |
| 3 | 1769 | 9 | 5307 | |
| 4 | 1955 | 16 | 7820 | |
| 5 | 2309 | 25 | 11545 | |
| 4 | 1857 | 16 | 7428 | |
| 4 | 1972 | 16 | 7888 | |
| Σ | 63 | 30007 | 283 | 128786 |
bo = ( 30007*283 - 63*128786 ) / ( 15*283 - 632 ) = 1371.24
b1 = ( 15*128786 - 63*30007 ) / ( 15*283 - 632 ) = 149.82
=> y = 1371.24 + 149.82x
when x = 5, y = 1371.24 + 149.82*5 = 2120.34
A city in Texas wants to know the relationship between house size and the number of...
A realtor studies the relationship between the size of a house (in square feet) and the property taxes owed by the owner. He collects the following data on six homes in an affluent suburb 60 miles outside of New York City. Use Table 2. Square Feet Property Taxes ($) Home 1 4,015 12,522 Home 2 2,798 9,332 Home 3 5,184 22,706 Home 4 2,259 6,487 Home 5 1,531 5,201 Home 6 3,301 7,878 Click here...
A realtor studies the relationship between the size of a house (in square feet) and the property taxes owed by the owner. He collects the following data on six homes in an affluent suburb 60 miles outside of New York City. Use Table 2. Square Feet Property Taxes ($) Home 1 4,152 12,143 Home 2 2,759 9,141 Home 3 5,054 22,715 Home 4 2,151 6,369 Home 5 1,530 5,249 Home 6 3,360 7,885 Picture Click here for the Excel Data...
A realtor studies the relationship between the size of a house
(in square feet) and the property taxes (in $) owed by the owner.
The table below shows a portion of the data for 20 homes in a
suburb 60 miles outside of New York City. [You may find it
useful to reference the t table.]
Property Taxes
Size
21809
2498
17409
2460
18203
1841
15606
1063
43981
5615
33626
2564
15203
2231
16775
1925
18257
2049
16775
1398
15164...
A sociologist was hired by a large city hospital to investigate the relationship between the number of unauthorized days that employees are absent per year and the distance (miles) between home and work for the employees. A sample of 6 employees was chosen, and the following data were collected. Distance to work (miles) 1 3 4 6 8 10 Number of days absent 8 5 8 7 6 3 a. Which variable is the independent variable? Which variable is the...
1. Suppose you were asked to analyze each of the situations described below. (NOTE: Do not answer these problems!) For each, indicate which procedure you would use (pick the appropriate number from the list), the test statistic (z.2 or ), and the number of degrees of freedom A procedure may be used more than once. 1. difference of proportions test Type zx/t? df 2. difference of means test a. 3. paired means test 4. goodness of fit test 5. homogeneity/independence...
Using data from the Southwest case, create a chart that plots
the relationship between each airline’s market share, in terms of
revenue or airline seat miles flown, and its profitability for two
periods: 1995-2000 and 2001-2005. Does your analysis suggest that
market share is correlated with profitability in this industry? If
you exclude Southwest Airlines and Jet Blue airlines from the
analysis (companies that use “point-to-point” route structure
rather than a “hub and spoke” route structure), how well does
market...
The Language Is SQL
The language is SQL
13- List full details of agents with first names having exactly three or four letters sorted by the state attribute. 14- List the first name, the last name, the address, the city, the state, the branch number, and the email of agents working in the branch 8005 and having email addresses from yahoo.com. 15-List the first name, the last name, the address, the city, the state, the branch number, and the email...
Write MySQL query statements for the questions below including
the output that proves the accuracy of your solution. Your answers
should be stored in a text file that captures your interaction with
MySQL.
1. Find the movieID, title, year and DVDPrice of all movies
where the DVD-Price is equal to the discountPrice.
2. Find the actorID, lastName, firstName, middleName, and suffix
of all actors whose middleName is not NULL.
3. Suppose you remember a movie quote as “Play it again,...
1. When it comes to financial matters, the views of Aristotle can be stated as: a. usury is nature’s way of helping each other. b. the fact that money is barren makes it the ideal medium of exchange. c. charging interest is immoral because money is not productive. d. when you lend money, it grows more money. e. interest is too high if it can’t be paid back. 2. Since 2008, when the monetary base was about $800 billion,...