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

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:

Average Age of House in each neighborhood is significantly different from 60 years
Average Price of Houses in each neighborhood is significantly different from $415,000

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 - t_crit * Standard Error, Average + t_crit * 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.

Rahul Sunny answered 1 year ago

Next > < Previous

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

QUESTION FOUR You have been provided with the following information for a small private company, Formosa...

QUESTION FOUR 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...

Subjects