PART I

For this part, use the female variable . (CHOL for the female ) .

1. Determine the center of the data using the mean, mode, and median.
2. Determine measures of variation (range, standard deviation and variance).
3. Determine the quartiles.
4. Determine the IQR (Inner Quartile Range) and any outliers in the data.
5. Create the modified boxplot of the data showing any outliers. (You may need to draw this using MS Word tools.). Make sure that your boxplot has a proper scale.
6. Using Excel, group the data into 6 to 10 groups and create a histogram for the data. (Excel uses bins to group the data. See the attached worksheet for instructions on creating the histogram.)
7. Based on the information in the steps above determine if this sample came from a normal population distribution.

PART II

Draw inferences from the data. (

1. Use the sample data to construct a 98% confidence interval for the mean of all males or females.
2. Use the sample data to construct a 90% confidence interval for the mean of all males.
3. Use the sample data to construct a 90% confidence interval for the mean of all females.
4. Using the two 90% confidence intervals determine if the mean of all males is equal to the mean of all females? Explain your reasoning on this answer. (For this part of this section you will need to use both male and female data for your variable.)

PART III

** Write a formal paper incorporating and explaining the results in PART I and PART II.

The paper must follow the guidelines and contain the following information.

1. Include an introduction, body, and conclusions.
2. Describe how you would collect the sample data you are using. Be sure to use the sampling methods you have learned in your discussion as well as the random process in Excel.
3. Include an explanation of any problems that might occur when collecting this data. (E.g., if the data was "finger length" you might discuss which finger is chosen, whether to include the nail and knuckle, rounding errors, etc.)
4. Describe and give the measures of the center and explain which measure best fits this data set.
5. Describe and give the measures of variation.
6. Include the boxplot, showing outliers, with an explanation of how outliers are determined. Give the quartiles and IQR in this explanation.
7. Discuss the standard deviation of the data set.
   · Determine the ACTUAL percent of your data set that is within one, two, and three standard deviations of the sample mean.
   · Compare these results to Chebyshev's rule.
   · Compare these results to the empirical rule.
   · Explain any conflict with your data and both of these two rules.
8. Include the histogram of the data and a description of the shape of the distribution.
9. Include the boxplot along with an explanation of what it tells you about the distribution of your data.
10. Include the two confidence intervals.
    · Explain the purpose of a confidence interval.
    · Include the requirements check.
    · Explain which interval is larger and why.
    · Interpret the results of both intervals.
11. Conduct a test of the hypothesis that the mean of all males is the same as the mean of all of all females for your variable.
    · Include the two hypotheses.
    · Explain how the requirements are met.
    · Give the level of significance used, the test statistic, and the p-value.
    · State the decision.
    · Interpret the results.
12. A conclusion stating what you have learned by completing this project.

· Put your data (both sets) in appendix A. Remember to document your sources.

Price: $18.3

Solution: The downloadable solution consists of 11 pages, 730 words and 9 charts.
Deliverable: Word Document