Question Details

[solution] » Please see the PART 1 instructions and the grading rubic at the

Brief item decscription

Step-by-step solution file


Item details:

Please see the PART 1 instructions and the grading rubic at the
More:

Please see the PART 1 instructions and the grading rubic at the end of the document.  The instructor has chosen BMI as my variable and I'm female.  Please use the excel data provided.  WE ARE ONLY DOING PART 1 AT THIS POINT.  Please follow the instructions and the grading rubic and use excel to get the information and copy and paste to a word document.  Please use www.Alcula.com to create the boxplox.


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

 







About this question:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Feb 21, 2020

PRICE: $24

Solution~00066042261.zip (18.37 KB)

Buy this answer for only: $24

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free copy (Deadline assured. Flexible pricing. TurnItIn Report provided)

Pay using PayPal (No PayPal account Required) or your credit card. All your purchases are securely protected by PayPal.
SiteLock

Need a similar solution fast, written anew from scratch? Place your own custom order

We have top-notch tutors who can help you with your essay at a reasonable cost and then you can simply use that essay as a template to build your own arguments. This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student. New solution orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

Order Now