Posted: May 20th, 2022

# Excel Project for Business Statistic class

Don't use plagiarized sources. Get Your Custom Essay on
Excel Project for Business Statistic class
Just from \$13/Page

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.

(the items in parenthesis are examples, you do NOT have to do that particular analysis)

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 I3 in which you create hypothesis tests of two means appropriate for this data (e.g.  determine if the average price by location is different in two zip codes)

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)

Remember to include all steps, including the hypothesis and conclusion.

The file attached  with the attachment.

### Expert paper writers are just a few clicks away

Place an order in 3 easy steps. Takes less than 5 mins.

## Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
\$0.00

Order your essay today and save 15% with the discount code WELCOME