Chapter 2, Problem 3P

The file MidCity Download MidCitycontains data on 128 recent sales in Mid City. For each sale, the file shows the neighborhood (1, 2, or 3) in which the house is located, the number of offers made on the house, the square footage, whether the house is made primarily of brick, the number of bathrooms, the number of bedrooms, and the selling price. Neighborhoods 1 and 2 are more traditional neighborhoods, whereas neighborhood 3 is a newer, more prestigious neighborhood. PROBLEM 1: Construct 3 different confidence intervals. Part A) Sort and filter the data from the MidCity file so that you only consider the data from neighborhood 1.  Construct a 99% confidence interval for the square footage of all homes in neighborhood 1.  Make sure you list the specific equations you are using, ALL variables, show ALL work etc., in your report.  You can use Excel to complete all computations. Remember to interpret these confidence intervals in the context of this problem.  Use one Excel spreadsheet…

Slamet is a young entrepreneur who started his business by opening 5 “Bebek Mas Slamet” restaurants in different locations, namely in Blok S, Blok M, Blok A, Senayan, and Depok areas. Because it is still in its infancy, Slamet still frequently observes data on the number of sales portions of Fried Duck which is the mainstay of the restaurant "Bebek Mas Slamet". The following data shows the total sales of Bebek Goreng for the last two days for the time of day, afternoon, and evening that Slamet is observing from the four restaurant locations  Penjualan Siang Sore Malam Blok S 40 41 30 32 43 43 Blok M 36 40 35 33 45 46 Blok A 40 45 39 48 46 50 Senayan 34 37 36 35 45 44 Depok 36 40 37 34 47 48 Help Slamet to analyze the data on the sales of fried duck over the past two days by answering some of the questions in this question. Some of the results of the calculation of the sum of squares…

In Delphi, there are three processing plants. The pay information for the representatives of these production lines is as per the following:   No.of Employees Average income Total income Factory A 100 $8000 $800000 Factory B 80 $5000 $400000 Factory C 20 $20000 $400000 What is the normal pay of the assembly line laborers of Delphi?