Unit 5 Assignment Calculating Confidence Intervals

profilebrandon282011

 

Instructions

Use: Data Tools to Construct Confidence Intervals

Evaluation Title: Calculating Confidence Intervals

In this assignment, you will calculate confidence intervals for the quantitative variables in the Heart Rate Dataset.

Steps

  1. Open the Heart Rate Dataset in Excel and identify the quantitative variables
  2. Make sure the data is sorted by category (e.g.male-at-rest, female at-rest, etc.)
  3. Use the Data Analysis tools of Excel to construct 95% and 99% confidence intervals for all of the sorted quantitative variable.  Please note that the statistic being used in the confidence interval of the means, which requires the use of the Standard Error of the mean (not the standard deviation).
  4. Create a Word document, and use your calculated results to describe the expected value and range for each of the variables.
  5. Make sure you note and explain any differences in the means of the variables, and any effect you observed after changing the level of confidence.

Additional Instructions:

Your assignment should be typed into a Word or other word processing document, formatted in APA style. The assignments must include

  • Running head
  • A title page with
    • Assignment name
    • Your name
    • Professor’s name
    • Course

Estimated time to complete: 3 hours

Assignment Files

Heart Rate Data SetPreview the document [Excel Document]

Confidence Interval CalculatorsPreview the document [Excel Document]

  • 5 years ago
  • 15
Answer(3)

Purchase the answer to view it

blurred-text
NOT RATED
  • attachment
    confidence_interval_-_APA_frmat.docx

Purchase the answer to view it

blurred-text
NOT RATED

Purchase the answer to view it

blurred-text
NOT RATED
  • attachment
    CalculatingConfidenceIntervals.docx