Homework Help-Excel project for Business Statistic
The project is to “use the data file provided to prepare a statistical analysis of single-family home values currently in three zip codes in West County St. Louis.
ProjectRealEstateData.xlsx
Create a worksheet called I1 in which you create a few confidence intervals for the mean values of quantitative characteristics (e.g. average list price in each zip code)
Create a worksheet called I2 in which you create a number of confidence interval for the proportion of a categorical (qualitative) characteristic (e.g. % of homes with four bedrooms or more)
Create a worksheet called I4 in which you create hypothesis tests of more than two means (Single Factor ANOVA) appropriate for this data (e.g determine if the average price if different in n different school districts – LOCATION variable)
