RC Confidence Intervals & Heart Rate Analysis Through Correlation Discussion
InstructionsIn this assignment, you will calculate confidence intervals for the quantitative variables in the Heart Rate Dataset.StepsOpen the Heart Rate Dataset in Excel and identify the quantitative variablesMake sure the data is sorted by category (e.g.male-at-rest, female at-rest, etc.)Use the Data Analysis tools of Excel to construct 95% and 99% confidence intervals for all 8 categories of the sorted quantitative variables. Excel will calculate the margin of error given as the “confidence interval” in the output. Use this margin of error to create your 8 confidence intervals by both adding and subtracting it from the sample mean (calculated in unit 3). This creates a range of values that is the confidence interval.Create a Word document, and use your calculated results to explain what the confidence intervals tell us. What do these confidence intervals tell us about our heart rate data? How would you interpret the 95% and 99% intervals for resting heart rate?Compare the 99% and 95% intervals and explain why one is larger than the other even though we use the same sample mean value.Additional Instructions:Your assignment should be typed into a Word or other word processing document, formatted in APA style. The assignments must includeRunning headA title page withAssignment nameYour nameProfessor’s nameCourseRubricMA320 Unit 5 AssessmentMA320 Unit 5 AssessmentCriteriaRatingsPtsThis criterion is linked to a Learning OutcomeContentMA320-CO2; MA320-CO325.0 ptsLevel 5Expresses content knowledge with the assignment purpose in a complete, organized, clear, professional, and culturally respectful manner.22.5 ptsLevel 4Expresses content knowledge with the assignment purpose in a complete, organized, clear, professional, and culturally respectful manner with minor weaknesses in one or more of the areas.20.0 ptsLevel 3Partially expresses content knowledge with the assignment purpose. Expresses ideas in a complete, organized, clear, professional, and culturally respectful manner with weaknesses in these area.17.5 ptsLevel 2Partially expresses content knowledge with the assignment purpose. Ideas are partially expressed in an organized, professional, and culturally respectful manner with major weaknesses in these areas.15.0 ptsLevel 1Expresses limited content knowledge with the assignment purpose. Ideas are not expressed in a complete, organized, clear, professional, and/or culturally respectful manner.0.0 ptsLevel 0The assignment was not completed or there are no constructed concepts that demonstrate analytically skills and no evidences to support the content does not align to the assignment instructions25.0 ptsThis criterion is linked to a Learning OutcomeAnalysis30.0 ptsLevel 5Constructs concepts related to course content, demonstrating strong analytical skills with strong evidence to support professional and personal subject knowledge through details, supporting evidence, and idea differentiation.27.5 ptsLevel 4Constructs concepts related to course content, demonstrating strong analytical skills with evidence to support professional and personal subject knowledge through details, supporting evidence, and idea differentiation.25.0 ptsLevel 3Constructs concepts related to course content, demonstrating analytical skills with some evidence to support professional and personal subject knowledge through details, supporting evidence, and idea differentiation.22.5 ptsLevel 2Constructs concepts related to course content, demonstrating weak analytical skills with minimal evidence to support professional and personal subject knowledge through details, supporting evidence, and idea differentiation.20.0 ptsLevel 1Constructs concepts related to course content, demonstrating inadequate evidence of analytical skills. There is minimal or no evidence to support professional and personal subject knowledge through details, supporting evidence, and idea differentiation.0.0 ptsLevel 0The assignment was not completed or there was no evidence of constructed concepts that are supported by professional and personal subject knowledge through details, supporting evidence, and idea differentiation.30.0 ptsThis criterion is linked to a Learning OutcomeTechnology10.0 ptsLevel 5Manipulates multiple technological resources to effectively implement all assignment requirements.9.0 ptsLevel 4Manipulates multiple technological resources to effectively implement most assignment requirements.8.0 ptsLevel 3Manipulates multiple technological resources to effectively implement some assignment requirements.6.0 ptsLevel 2Manipulates multiple technological resources for some assignment requirements.4.0 ptsLevel 1Manipulates technological resources to minimally meet some assignment requirements.0.0 ptsLevel 0The assignment was not completed or difficulties with technological manipulation were evident. The assignment submitted does not meet requriements.10.0 ptsThis criterion is linked to a Learning OutcomeWriting5.0 ptsLevel 5The assignment exhibits a excellent command of written English language conventions. The assignment has no errors in mechanics, grammar, or spelling.4.5 ptsLevel 4The assignment exhibits a good command of written English language conventions. The assignment has no errors in mechanics, or spelling with minor grammatical errors that impair the flow of communication.4.0 ptsLevel 3The assignment exhibits a basic command of written English language conventions. The assignment has minor errors in mechanics, grammar, or spelling that impact the flow of communication3.5 ptsLevel 2The assignment exhibits a limited command of written English language conventions. The assignment has frequent errors in mechanics, grammar, or spelling that impede the flow of communication.3.0 ptsLevel 1The assignment exhibits little command of written English language conventions. The assignment has errors in mechanics, grammar, or spelling that cause the reader to stop and reread parts of the writing to discern meaning.0.0 ptsLevel 0The assignment does not demonstrate command of written English language conventions. The assignment has multiple errors in mechanics, grammar, or spelling that cause the reader difficulty discerning the meaning.5.0 ptsThis criterion is linked to a Learning OutcomeAPA5.0 ptsLevel 5In-text citations of sources and references in proper APA style are included with no errors.4.5 ptsLevel 4In-text citations of sources and references in proper APA style are included but have 1-2 minor APA errors.4.0 ptsLevel 3In-text citations of sources and references in proper APA style are included but have 3 - 4 minor APA errors.3.5 ptsLevel 2In-text citations of sources and references in proper APA style are included but have more than 4 errors.3.0 ptsLevel 1The errors demonstrate limited understanding of in-text citation and reference requirements0.0 ptsLevel 0There are no in-text citations AND/OR references.5.0 pts