Question
In: Accounting
HOUSE PRICE YRSOLD HSQFT LOTSFT YRBUILT PRICE_PER_SQFT NEB 1 $536,000 2009.00 1,500 4,000 1930 $357 WESTERLEIGH...
| HOUSE | PRICE | YRSOLD | HSQFT | LOTSFT | YRBUILT | PRICE_PER_SQFT | NEB |
| 1 | $536,000 | 2009.00 | 1,500 | 4,000 | 1930 | $357 | WESTERLEIGH |
| 2 | $498,000 | 2009.00 | 1,563 | 6,100 | 1950 | $318 | WESTERLEIGH |
| 3 | $506,500 | 2009.00 | 1,536 | 4,000 | 1950 | $329 | WESTERLEIGH |
| 4 | $630,000 | 2009.00 | 1,152 | 4,000 | 1949 | $546 | WESTERLEIGH |
| 5 | $455,000 | 2009.00 | 1,214 | 2,775 | 1925 | $374 | WESTERLEIGH |
| 6 | $265,000 | 2009.00 | 1,627 | 1,800 | 1985 | $190 | WESTERLEIGH |
| 7 | $347,500 | 2009.00 | 1,100 | 4,500 | 1950 | $315 | WESTERLEIGH |
| 8 | $320,000 | 2009.00 | 1,104 | 3,000 | 1925 | $289 | WESTERLEIGH |
| 9 | $535,000 | 2009.00 | 2,400 | 3,879 | 2000 | $222 | WESTERLEIGH |
| 10 | $456,300 | 2009.00 | 1,650 | 2,552 | 2007 | $277 | WESTERLEIGH |
| 11 | $440,000 | 2009.00 | 1,124 | 2,405 | 1930 | $391 | WESTERLEIGH |
| 12 | $413,000 | 2009.00 | 1,410 | 3,600 | 1955 | $292 | WESTERLEIGH |
| 13 | $320,000 | 2009.00 | 1,740 | 7,230 | 1950 | $183 | WESTERLEIGH |
| 14 | $270,000 | 2009.00 | 1,080 | 1,590 | 1925 | $250 | WESTERLEIGH |
| 15 | $375,000 | 2009.00 | 1,158 | 4,500 | 1920 | $323 | WESTERLEIGH |
| 16 | $485,000 | 2009.00 | 1,685 | 5,000 | 1925 | $287 | WESTERLEIGH |
| 17 | $448,000 | 2009.00 | 1,776 | 3,000 | 1915 | $252 | WESTERLEIGH |
| 18 | $425,000 | 2009.00 | 1,148 | 6,100 | 1955 | $370 | WESTERLEIGH |
| 19 | $376,500 | 2009.00 | 1,237 | 3,000 | 1920 | $304 | WESTERLEIGH |
| 20 | $350,000 | 2009.00 | 890 | 3,600 | 1920 | $393 | WESTERLEIGH |
| 21 | $470,000 | 2009.00 | 1,205 | 5,900 | 1955 | $390 | WESTERLEIGH |
| 22 | $420,000 | 2009.00 | 1,207 | 3,828 | 1945 | $347 | WESTERLEIGH |
| 23 | $410,000 | 2009.00 | 1,256 | 3,600 | 1930 | $342 | WESTERLEIGH |
| 24 | $440,000 | 2009.00 | 900 | 3,600 | 1960 | $488 | WESTERLEIGH |
| 25 | $395,000 | 2009.00 | 1,176 | 3,920 | 1930 | $335 | WESTERLEIGH |
| 26 | $355,000 | 2009.00 | 1,296 | 3,000 | 1940 | $304 | WESTERLEIGH |
| 27 | $415,000 | 2009.00 | 1,092 | 4,000 | 1960 | $380 | WESTERLEIGH |
| 28 | $495,000 | 2009.00 | 1,950 | 3,600 | 1920 | $253 | WESTERLEIGH |
| 29 | $355,425 | 2009.00 | 1,600 | 1,744 | 1993 | $222 | WESTERLEIGH |
| 30 | $410,000 | 2009.00 | 1,440 | 3,742 | 1965 | $284 | WESTERLEIGH |
| 31 | $447,500 | 2009.00 | 1,450 | 3,000 | 1970 | $308 | WESTERLEIGH |
| 32 | $420,000 | 2009.00 | 1,420 | 3,758 | 2006 | $296 | WESTERLEIGH |
| 33 | $455,000 | 2009.00 | 1,427 | 3,800 | 1920 | $318 | WESTERLEIGH |
| 34 | $380,000 | 2009.00 | 1,480 | 2,100 | 1970 | $256 | WESTERLEIGH |
| 35 | $400,000 | 2009.00 | 1,512 | 4,000 | 1960 | $264 | WESTERLEIGH |
| 36 | $310,000 | 2009.00 | 1,240 | 960 | 1993 | $250 | WESTERLEIGH |
| 37 | $365,000 | 2009.00 | 840 | 5,000 | 1955 | $434 | WESTERLEIGH |
| 38 | $370,000 | 2009.00 | 1,280 | 3,456 | 1965 | $289 | WESTERLEIGH |
| 39 | $415,000 | 2009.00 | 1,820 | 4,200 | 1960 | $228 | WESTERLEIGH |
| 40 | $419,796 | 2009.00 | 1,592 | 7,575 | 1930 | $263 | WESTERLEIGH |
| 41 | $380,000 | 2009.00 | 1,280 | 3,408 | 1965 | $296 | WESTERLEIGH |
| 42 | $410,000 | 2009.00 | 1,332 | 2,800 | 1970 | $307 | WESTERLEIGH |
| 43 | $435,000 | 2009.00 | 1,660 | 2,373 | 1995 | $262 | WESTERLEIGH |
| 44 | $515,000 | 2009.00 | 1,712 | 5,880 | 1930 | $300 | WESTERLEIGH |
| 45 | $370,000 | 2009.00 | 1,450 | 4,000 | 1955 | $255 | WESTERLEIGH |
| 46 | $429,000 | 2009.00 | 4,040 | 4,040 | 1950 | $106 | WESTERLEIGH |
| 47 | $295,000 | 2009.00 | 1,320 | 2,000 | 1940 | $223 | WESTERLEIGH |
| 48 | $520,000 | 2009.00 | 1,500 | 5,000 | 1960 | $346 | WESTERLEIGH |
| 49 | $410,000 | 2009.00 | 1,500 | 3,000 | 1925 | $273 | WESTERLEIGH |
| 50 | $379,000 | 2009.00 | 926 | 4,000 | 1955 | $409 | WESTERLEIGH |
| 51 | $487,500 | 2009.00 | 2,472 | 3,420 | 1970 | $197 | MARINER |
| 52 | $425,000 | 2009.00 | 2,400 | 3,800 | 1975 | $177 | MARINER |
| 53 | $370,000 | 2009.00 | 2,100 | 5,500 | 1935 | $176 | MARINER |
| 54 | $300,000 | 2009.00 | 1,870 | 2,500 | 1920 | $160 | MARINER |
| 55 | $385,000 | 2009.00 | 1,340 | 2,500 | 1925 | $287 | MARINER |
| 56 | $265,000 | 2009.00 | 1,992 | 3,591 | 1975 | $133 | MARINER |
| 57 | $300,000 | 2009.00 | 2,416 | 3,325 | 1980 | $124 | MARINER |
| 58 | $339,000 | 2009.00 | 1,820 | 2,850 | 1920 | $186 | MARINER |
| 59 | $350,000 | 2009.00 | 1,650 | 2,500 | 1903 | $212 | MARINER |
| 60 | $460,000 | 2009.00 | 1,744 | 4,419 | 2008 | $263 | MARINER |
| 61 | $214,200 | 2009.00 | 1,270 | 5,721 | 1925 | $168 | MARINER |
| 62 | $270,000 | 2009.00 | 2,200 | 1,512 | 1931 | $122 | MARINER |
| 63 | $220,000 | 2009.00 | 1,408 | 2,560 | 1901 | $156 | MARINER |
| 64 | $290,000 | 2009.00 | 1,540 | 4,950 | 1901 | $188 | MARINER |
| 65 | $335,000 | 2009.00 | 2,800 | 2,880 | 1920 | $119 | MARINER |
| 66 | $400,000 | 2009.00 | 2,052 | 5,900 | 1920 | $194 | MARINER |
| 67 | $485,000 | 2009.00 | 1,884 | 2,886 | 1975 | $257 | MARINER |
| 68 | $500,000 | 2009.00 | 2,080 | 4,326 | 1970 | $240 | MARINER |
| 69 | $414,726 | 2009.00 | 2100 | 3,594 | 2005 | $197 | MARINER |
| 70 | $415,740 | 2009.00 | 1,400 | 3,594 | 2005 | $296 | MARINER |
| 71 | $560,000 | 2009.00 | 2,568 | 4,000 | 1970 | $218 | MARINER |
| 72 | $390,100 | 2009.00 | 1,896 | 3,630 | 1970 | $205 | MARINER |
You have downloaded the MS_Excel file with data on the prices of homes in two neighborhoods around the City of New York. The data is taken from Staten Island.
Using the MS_Excel, calculate:
a. The Average and the Standard Deviation for Sale Price for houses in the two neighborhoods
and please post the excel chart you come up with thank you
Solutions
Expert Solution
The Average and the Standard Deviation for Sale Price for houses in the two neighborhoods is computed in the excel file are computed using the following examples :
To find mean, following formula is used
=Average (number1:number 50)
**instead of writing number 1 and number 50, you have to select the cell range of house price from house 1 to house 50
It will result in $414,850 (Mean of Westerleigh)
To find standard deviation , following formula is used
=STDEV.S(number 1: number 50)
**instead of writing number 1 and number 50, you have to select the cell range of house price from house 1 to house 50
It will result in 71,711.405 (Standard Deviation of Westerleigh)
Similarly Mean and Standard deviation of Mariner could be found.
The correct answer are :
Mean of Mariner = $371,648
Standard Deviation of Mariner = 93427.5069
**Plaese note, we are unable to attach excel files. I hope this would be helpful for you. Thanks!!
ekkarill92 answered 2 years agoRelated Solutions
HOUSE PRICE YRSOLD HSQFT LOTSFT YRBUILT PRICE_PER_SQFT NEB 1 $536,000 2009.00 1,500 4,000 1930 $357 WESTERLEIGH...
HOUSE
PRICE
YRSOLD
HSQFT
LOTSFT
YRBUILT
PRICE_PER_SQFT
NEB
1
$536,000
2009.00
1,500
4,000
1930
$357
WESTERLEIGH
2
$498,000
2009.00
1,563
6,100
1950
$318
WESTERLEIGH
3
$506,500
2009.00
1,536
4,000
1950
$329
WESTERLEIGH
4
$630,000
2009.00
1,152
4,000
1949
$546
WESTERLEIGH
5
$455,000
2009.00
1,214
2,775
1925
$374
WESTERLEIGH
6
$265,000
2009.00
1,627
1,800
1985
$190
WESTERLEIGH
7
$347,500
2009.00
1,100
4,500
1950
$315
WESTERLEIGH
8
$320,000
2009.00
1,104
3,000
1925
$289
WESTERLEIGH
9
$535,000
2009.00
2,400
3,879
2000
$222
WESTERLEIGH...
Curtain Co. paid dividends of $1,500; $3,000; and $4,000 during Year 1, Year 2, and Year...
Curtain Co. paid dividends of $1,500; $3,000; and $4,000 during
Year 1, Year 2, and Year 3, respectively. The company had 700
shares of 3.5%, $100 par value preferred stock outstanding that
paid a cumulative dividend. The amount of dividends received by the
common shareholders during Year 3 would be:
2,450.
$1,500.
$950.
$1,150.
1. The average price for a new car is $18,000 and the standard deviation is $1,500....
1.
The average price for a new car is $18,000 and the standard
deviation is $1,500. Calculate the z scores for the following
individual scores. SHOW YOUR WORK.If X = 19,000, z = _
2. Using z-scores. SHOW YOUR WORK
The percent of area beyond z = 1.44 is
3. Using z-scores. SHOW YOUR WORK
).The percent of area between the z = 1.40 and z = 1.49 is
________.
4. Using z-scores. SHOW YOUR WORK
The percent of TOTAL...
1. In 1975 the price of a new house was $50,000. In 2015 the price of...
1. In 1975 the price of a new house was $50,000.
In 2015 the price of a new house is $300,000.
How much has the price of housing increased over the entire 40
years in percentage terms?
A.5.00%
B.600%
C.4.58%
D.500%
2. The current cost of tuition is $12,000 per year.
The cost of tuition is rising at 5.00% per year.
At this rate of inflation, how much will the cost of tuition be in
20 years?
A.$31,840
B.$12,348
C.$31,203...
Ken and Barbie are renting an apartment for $1,500 a month and could rent a house...
Ken and Barbie are renting an apartment for $1,500 a month and
could rent a house similar to the one they want to buy for $2,000 a
month. They know the rule of thumb that says housing prices
increase, on average, over the long run at 3% a year but they also
know there are peaks and valleys within the long run and they are
not certain where the market stands just now. Interest rates have
been very low for...
You received invoices from Cisco Industries dated May 8th for $1,500, May 19th for $4,000, and...
You received invoices from Cisco Industries dated May 8th for
$1,500, May 19th for $4,000, and June 1st for $2,500. You have also
made payments of $1,200 on May 27th and $1,800 on May 30th. What
total amount must be paid on June 5 th to settle the remaining
balance on all the invoices with terms 2/10, n/30?
Please can I get a clear and easy solution so I can understand
thank:)
Question 1: Using 1 variable regression house price vs. number of rooms predict the price of a house with 4 rooms for your client.
Question 1: Using 1 variable regression house price vs. number of rooms predict the price of a house with 4 rooms for your client.You enhance the model by adding 2 more variables:Question 2: What is the predicted house price for a home based on the new model with 3 variables, given that the house has 5 rooms is 10 years old and is 2,000 Square feet?Question 3: Which coefficients are statistically significant at alpha (α) 5% in the model with...
Accounts payable 2,300 Accounts Receivable 1,500 Accumulated depreciation - Equipment 4,000 Cash 2,600 Common Stock 4,800...
Accounts payable
2,300
Accounts Receivable
1,500
Accumulated depreciation - Equipment
4,000
Cash
2,600
Common Stock
4,800
Equipment
7,500
Inventory
400
Land
10,000
Land held as long term investment
8,000
Notes payable (due in 5 Years)
6,000
Patent
2,500
Retained Earnings 1/1
16,000
Short- term investments
1,000
Wages Payable
400
Required: Calculate following amounts. Show all work.
Total Current Assets (in order of liquidity)
Total property, plant, and equipment
Total Assets
Total Current liabilities
Total Liabilities
Total Stockholders equity
Prove that...
1.) Find a house: House Price is ($350,000) 2.) Use interest rate of: 6% compounded monthly...
1.) Find a house: House Price is ($350,000)
2.) Use interest rate of: 6% compounded monthly for a 30 year
loan and 5.5% compounded monthly for a 15 year loan.
3.) Determine how much a monthly principal and interest payment
on your house would be if you financed it:
a. for 30 years
b. for 15 years
c. for 30 years with 20% down
d. for 15 years with 10% down
4.) How much would you pay for the home...
1.) What is the free cash flow of a firm with revenues of $357 million, operating...
1.) What is the free cash flow of a firm with revenues of $357
million, operating profit margin of 34%, tax rate of 32%,
depreciation and amortization expense of $22 million, capital
expenditures of $38 million, acquisition expenses of $6 million and
change in net working capital of $18 million? Answer in millions,
rounded to one decimal place (e.g., $245.63 = 245.6).
2.) You are valuing Soda City Inc. It has $139 million of debt,
$74 million of cash, and...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Assume that attributes with the same name in different relations represent the same domain and that...
- JAVA: Use existing Java Stack class to solve the "Balancing Symbols" problem. The symbols are (),...
- K-NN and Perceptron theory question If we don’t care about the size of the TRAINING SET...
- Make a C program that simulates time-sharing in the operating system. Please follow the instructions provided:...
- What are some current challenges faced by food companies in reducing food waste?
- Arthur buys $2,200.00 worth of stock. Six months later, the value of the stock has risen...
- The Following table is based on a time study for a metal working operation Obs (minutes...
ADVERTISEMENT