***Need Excel document showing work and formulas as well*** Finer Suit Company sells suits in the US and the European Union.

Finer Suit Company sells suits in the US and the European Union. The company monitors its suit sales by collecting randomly chosen data from store locations throughout the US. They record list price (in dollars), sale price (in dollars), and number of days it takes to sell each suit. Data was collected from 200 suits sold in the US and 200 in the EU region. The complete data set is in the file named Suits.

Managerial Report

Prepare a report (see Module folder) that summarizes your assessment of the nature of the suit market in each region. Be sure to include the following seven items in your report.

1. Descriptive statistics (mean, median, range, standard deviation, and coefficient of variation) to summarize each of the three variables for the all US suits. Use z-scores to determine if there any outliers in the data set for any of the three variables. If there are any outliers in any category, please list them and state for which category they are an outlier. If a result is an outlier, state whether it is below or above the mean.
2. Descriptive statistics (mean, median, range, standard deviation and coefficient of variation) to summarize each of the three variables for the all EU suits. Use z-scores to determine if there any outliers in the data set for any of the three variables. If there are any outliers in any category, please list them and state for which category they are an outlier. If a result is an outlier, state whether it is below or above the mean.
3. Compare your summary results from #1 and #2. Discuss any specific statistical results that would help Finer Suits understand its business.
4. Develop a 99% confidence interval estimate of the population mean sales price and population mean number of days to sell for US suits. What is the Margin of error? What are the lower (or left) and upper (or right) endpoints of the confidence interval? Interpret your results.
5. Develop a 99% confidence interval estimate of the population mean sales price and population mean number of days to sell for EU suits. What is the Margin of error? What are the lower (or left) and upper (or right) endpoints of the confidence interval? Interpret your results.
6. Assume the Finer Suit Company requested estimates of the mean List Price for the US suits with a margin of error of $600 and the mean List Price of EU suits with a margin of error of $600. Using 99% confidence, how large should the sample sizes be for each?
7. Suppose a US suit has a list price of $1,500 and a EU suit has a list price of $1,200. What is your estimate of the final selling price (based on the percent difference for the sale and list price) and number of days required to sell each of these suits?