Statistical Concepts | MATH215-V3WW-F16 Part 1 Data Analysis & Inferenc... Start Date: Mon, Sep 19 Due Date: Sun, Oct 9 Points Points available: 20 Not yet graded. Part 1: Data Analysis and Inference Project This week you will start working on the Data Analysis and Inference Project. This project consists of three parts. You need to complete Part 1: Descriptive Statistics. Data Analysis and Inference Project Outline Name Part 1: Descriptive Statistics Part 2: Inferential Statistics Part 3: Writing the Final Report Start Week 3 Week 9 Week 12 Finish Week 5 Week 12 Week 14 Total Project Score Score 20 points 20 points 20 points 60 points Purpose To assess your ability to: define and apply basic terms commonly used in statistics create and interpret various graphical and tabular representations of data compute the measures of the center of a data set compute the measures of variation in a data set use the five-number summary and the box plot to analyze a data set identify outliers in the data set construct and interpret confidence intervals for means and proportions conduct hypothesis tests for means or proportions and interpret the results compare the results of the hypothesis test and confidence interval Overview This project will give you the opportunity to apply what you have learned throughout the course in a very true-to- life situation. You will be given real data on male and female health, taken from the website for Centers for Disease Control and Prevention. You will use these data to do descriptive statistics to analyze the data (Part I), and then you will need to do inferential statistics to draw some conclusions (Part II). Lastly, you will put your findings into a formal statistical report (Part III). To thoroughly understand the expectations for this report, please view the attached document, Requirements of Statistical Report, which discusses the requirements for a statistical paper. You will use the data sets, which are given below in the form of Excel spreadsheets: Male-HealthData Female-HealthData These data sets have thirteen variables each. Check the course page for a posting from your instructor titled "Assignment of Variable" to see which one of the thirteen variables your instructor has assigned to you. If you have not been assigned a variable, please email your instructor to ask him/her to assign one to you. You will need to use both the male and female data for this one variable. In Part I, you will analyze the given data set. Using Excel, you will find measures of center, measures, variation, and other descriptive statistics to describe the data. You will represent the data visually with a modified boxplot and a histogram, page 1 of 3 - 10/06/2016 and you will need to explain what they tell you. In Part II, you will draw inferences from the data. Using the information from the sample data, you will do estimations by confidence intervals and also compare two groups by hypothesis testing and confidence intervals. You will then draw conclusions based on your findings. In Part III, you will put together all of the results from the previous parts of the assignment in the form of a formal statistical report. This report must contain an introduction, a body, conclusions, and APA-formatted citations. Material that is used from the text must be cited. The body should describe the data (use your findings from Part I), the tests you ran on that data, and your results (use your findings from Part II). There also needs to be a conclusion that summarizes your results and includes a statement of what you learned by completing this project. Do not put the raw data into the body of the paper but do put your raw data into an appendix for your paper. (You may copy and paste the data from Excel into the Word document. Do not include extraneous cells.) Graphs and charts should appear in the body of the paper and be accompanied by an explanation of what the graph or chart shows. In order to receive credit, you must submit the final report to TurnItIn.com prior to submitting it to your instructor. Part 1: Descriptive Statistics Action Items I. Analyze the data set. For this part, if you are male, use the male variable; if you are female, use the female variable. Using Microsoft Excel, complete the following: 1. Determine the measures of center for the data (mean, median, and mode). 2. Determine measures of variation (range, standard deviation, and variance). 3. Determine the quartiles and the IQR (Inner Quartile Range). 4. Explain the method of determining outliers in the data and list any outliers. 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 how to create histograms using Excel.) II. Present your results in a Word document. In this document, please include the following: Any graphs, charts, or tables from Excel (These should be cut and pasted into this document.) Your explanations about your findings. Raw data for the project (Include the data for YOUR VARIABLE only. This should be cut and pasted at the end of this document.) DO NOT SUBMIT ANY EXCEL FILES. Keep in mind that you will use these results later when you write your final report at the end of the term. Therefore, the more detailed and accurate your Part 1 explanation is, the more help it will be for you when you start writing your report. Submission Instructions Submit one Word document. (Do not submit any Excel worksheets). Upload your Word document using the Submit tool (located in the tool box above). Grading Rubric Criteria Score The assigned variable is used and all relevant data is included at the 0-2 end of the document. No points will be awarded for the project if the points assigned data set is not used. 0-2 Measures of the center are given and explained. points 0-2 Measures of variation are correct and explained. points 0-3 Quartiles and IQR are included. points Method of determining outliers is explained and any outliers are 0-3 flagged. points 0-3 Modified boxplot is included. points 0-5 Histogram is complete and information is properly labeled. points Time Estimation page 2 of 3 - 10/06/2016 Estimated time for completion: 1.0 hour(s) Attachment: Male-HealthData.xls;Female-HealthData.xls;CreateHistogramsUsingExcel.docx;RequirementsOfStatisticalReport.docx; page 3 of 3 - 10/06/2016 FEMALE 295 2739 2992 3745 4486 4488 4878 4880 4881 4835 4842 6225 8680 8681 12348 14651 16767 17765 19377 19378 19382 20278 21626 32233 33104 33106 33334 33335 34779 35035 35272 35273 35505 35506 35507 35984 35988 36115 36502 38089 BMI 19.6 23.8 19.6 29.1 25.2 21.4 22.0 27.5 33.5 20.6 29.9 17.7 24.0 28.9 37.7 18.3 19.8 29.8 29.7 31.7 23.8 44.9 19.2 28.7 28.5 19.3 31.0 25.1 22.8 30.9 26.5 21.2 40.6 21.9 26.0 23.5 22.8 20.7 20.5 21.9 Notes: Age in years HT: height in inches WT: weight in pounds WAIST: waist circumference in cm PULSE: pulse rate in beats per minute SYS: systolic blood pressure in mmHg DIAS: diastolic blood pressure in mmHg CHOL: cholesterol in mg BMI: body mass index LEG: upper leg length in cm ELBOW: elbow breadth in cm WRIST: wrist breadth in cm ARM: arm circumference in cm Credit: U.S. Department of Health and Human Services. National Center for Health Statistics Third National Health and Nutrition Examination Survey. ***delete the first column of ID numbers***