Question

In: Economics

You have been provided information on summary statistical data for two neighborhoods. Specifically, you have been...

  1. You have been provided information on summary statistical data for two neighborhoods. Specifically, you have been provided calculations on the Average Price Per Square Foot, Average Age and Average, and the Average Prices for houses in the two neighborhoods and the Standard Deviation of each variable. Apply the method of Confidence Intervals at (97%) to Estimate answer the question whether:
    1. Average Age of House in each neighborhood is significantly different from 60 years
    2. Average Price of Houses in each neighborhood is significantly different from $415,000
    3. List at least two reasons that you think that the Average Price of houses and the Average Age of Houses in one neighborhood will be different from the other neighborhood in the file (You may use personal knowledge of the neighborhoods).

      Comparative Descriptive Statistics – Arocher vs Borough Park

      Average Price per Square Foot, Average Age of House & Average Price of House

      Neighborhood and

      Sample Size (n)

      Average

      Standard Error

      Standard Deviation

      Average Age of House

      Staten Island, Arocher (40)

      39.4250

      4.48128

      28.34213

      Brooklyn, Borough Park (49)

      91.6939

      2.04233

      14.29628

      Average Price of House

      Staten Island, Arocher (40)

      $396,374.30

      $14,930.990

      $94,431.873

      Brooklyn, Borough Park (49)

      $696,638.78

      $24,093.715

      $168,656.005

Solutions

Expert Solution

The formula for Confidence Interval is important here: [Average - tcrit * Standard Error, Average + tcrit * Standard Error].

The value that we are testing for, through the Null Hypothesis, if does not lie in the range, we reject the Null Hypothesis. If we reject the Null Hypothesis, that means the average is significantly different from the value that we are testing for.

The t critical value can be found from the table or also using the formula in Excel: =T.INV.2T(Level of Significance, degrees of freedom)

Degrees of Freedom: Sample size - 1.

The Solution has been provided below.

​​​​​​​


Related Solutions

The following data have been provided to you: (all amounts are in dollars)            ...
The following data have been provided to you: (all amounts are in dollars)                                                                   April   May Sales 150,000 157,500 Merchandise purchases 107,000 112,400 Operating expenses:              Payroll 13,600         14,280      Advertising 5,400           5,700      Rent 2,500           2,500      Depreciation 7,500           7,500 End of April balances:              Cash 30,000          Bank loan payable     26,000 Additional data: Sales are 40% cash and 60% on...
Suppose you have been approached to design a survey, collect data and then do a statistical...
Suppose you have been approached to design a survey, collect data and then do a statistical analysis from the collected data in any of the public or private sectors in the economy of the Sultanate of Oman. Group the variables (and the hypothesized relationships of those variables) in three sets so that within each set there is a relationship among the variables you are interested to investigate. The grouping of variables in those three sets should be done in such...
You have been provided the following data on the securities of three firms and the market:...
You have been provided the following data on the securities of three firms and the market: Security E[Rj] sj rjM bj Firm A 0.13 .12 ? .90 Firm B 0.16 ? 0.40 1.10 Firm C 0.25 0.24 0.75 ? Market 0.15 0.10 1 1 Risk-free 0.05 0 0 0 Assume the CAPM holds true. Fill in the missing values in the table. 0.9 = (rjM)(0.12) / 0.10 ri,m= .75 bj     = (rjM)(sj) / sm = .4 (sj) / .10...
You have been provided the following data on the securities of three firms, the market portfolio,...
You have been provided the following data on the securities of three firms, the market portfolio, and the risk-free asset: a. Fill in the missing values in the table. (Leave no cells blank - be certain to enter 0 wherever required. Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) Security Expected Return Standard Deviation Correlation* Beta Firm A .105 .36 .80 Firm B .145 .55 1.35 Firm C .165 .60 .40 The market...
You have been provided the following data on the securities of three firms, the market portfolio,...
You have been provided the following data on the securities of three firms, the market portfolio, and the risk-free asset: a. Fill in the missing values in the table. (Leave no cells blank - be certain to enter 0 wherever required. Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) Security Expected Return Standard Deviation Correlation* Beta Firm A .104 .35 .81 Firm B .144 .54 1.36 Firm C .164 .61 .39 The market...
Refer to the ‘Data Task A’ sheet in the accompanying Excel workbook. You have been provided...
Refer to the ‘Data Task A’ sheet in the accompanying Excel workbook. You have been provided the most recent Profit and Loss Statement for T&K Solutions that shows the bookkeeping service is losing money. Using the proforma in ‘Schedule 1’, re-calculate the 2017 profit for T&K Solutions without the bookkeeping service. Be careful to take into account all additional information provided in the ‘Data Task A’ worksheet. DATA FOR TASK A: 2017 Profit and Loss Statement for T&K Solutions: Taxation...
You have been provided the following data on the securities of three firms, the market portfolio,...
You have been provided the following data on the securities of three firms, the market portfolio, and the risk-free asset: a. Fill in the missing values in the table. (Leave no cells blank - be certain to enter 0 wherever required. Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) Security Expected Return Standard Deviation Correlation* Beta Firm A .101 .32 _____ .84 Firm B .141 _____ .51 1.39 Firm C .161 .64 .36...
You have been provided with the following data about the securities of three firms, the market...
You have been provided with the following data about the securities of three firms, the market portfolio, and the risk-free asset: Security Expected return Standard deviation Correlation with the market portfolio Beta Firm A 0.10 0.31 ? (a) 0.85 Firm B 0.14 ?(b) 0.50 1.40 Firm C 0.16 0.65 0.35 ?(c) The market portfolio 0.12 0.20 ?(d) ?(e) The risk-free asset 0.05 ?(f) ?(g) ?(h) Fill in the missing values in the table. Show your work please. Is the stock...
You have been provided the following information inc. debt: the market value is 50000 the bonds...
You have been provided the following information inc. debt: the market value is 50000 the bonds are currently yielding 9% and have a coupon rate of 8%. common: 2000 shares outstanding, selling for $60 per share; the beta is 1.2 stock: preferred 500 shares of preferred stock outstanding, currently selling for $75 per share Stock: that pays 7.5 in dividends per year per share market: 8 percent market risk premium and 3.4 percent risk-free rate. 1. compute the capital structure...
You have been provided with the following information for a small private company, Formosa Pty Ltd,...
You have been provided with the following information for a small private company, Formosa Pty Ltd, whose competitors are predominately large public companies. 2017 2018 2019 Industry average 2019 Net profit margin 8.2% 7.5% 6.8% 8.0% Return on equity 13.1% 12.3% 11.1% 13.5% Current ratio 1.8 2.1 2.4 2.0 Quick ratio 1.2 1.1 0.9 1.2 Receivables turnover 12.2 12.6 13.0 13.0 Inventory turnover 4.7 4.5 4.2 4.8 REQUIRED: Comment on the trend of each of the six ratios for Formosa...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT