Read an Excel worksheet and solve the problem below
We will write a
specifically for you for only
805 certified writers online
Specifically, download the Excel data file (HOUSES_WESTERL1BA). The file has data on the characteristics of house in selected Staten Island neighborhoods. The variables that represent these characteristics are (1) The Price of the house (PRICE), the year the house was sold (SOLDATE), the number of bedrooms in the house (BDRMS), the number of bathrooms in the house (BTHRMS), the amount of Living Space in Square Feet (HSQFT), the size of the lot or land on which the house is built (LTSFT), the year the house was built (YRBLT), the Price per Square foot of living space (PPSFT), the neighborhood where the house is located (NEB). Neighborhood is entered in codes. Harbor =1, Wersterleigh = 2 and Westcot = 3
- Using the Excel command, calculate the Average AGE of houses in each neighborhood and save the new file.
- John Carlos argues that houses in these Staten Island neighborhoods sell at about the same average price. What do you think? Please present your results properly.
- Would you rather say to Carlos that the Price per Square Foot is about the same, regardless of neighborhood?