stat w 7

ItsTommy1995
Home>Homework Answsers>Mathematics homework help>Statistics homework help
mathstat
  • 2 years ago
  • 10
Report issue
files (3)

statw7.docx

Instructions

In this lesson, you will run a correlation between resting and after-exercising heart rates to determine if a linear relationship exists between the two variables and how strong the relationship is.

Steps

1. Open the  Heart Rate Data Set in Excel and identify the X-variable (resting heart rates for all 200 participants) and the Y-variable (after-exercise heart rates for all 200 participants).

2. Use the Scatter Plot function in the Insert Charts section of Excel to create a scatter plot of the X and Y variables.

3. Add a trendline to the scatter plot.

4. Use the Data Analysis tools in Excel to find the regression equation.

5. In a Word document, describe the relationship between the X-variable (resting heart rate)and the Y-variable (after-exercise heart rate).  

· Graph the scatter plot with a trend line. Does it appear there is a linear relationship?  What does this mean?

· Calculate the correlation coefficient r using Excel. Is this r (value) high compared to +1?  Based on the correlation coefficient, is the relationship strong?

· Use Excel to find the regression equation. Identify the slope.  What does it tell us in terms of our heart rate data?

Review these videos as needed to complete this assignment.

https://youtu.be/gBbGBrHTMrM

https://youtu.be/sGlsdHD-lcA

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

stat7rubric.docx

MA320 Unit 7 Assessment

MA320 Unit 7 Assessment

Criteria

Ratings

Pts

This criterion is linked to a Learning OutcomeContent

MA320-CO1; MA320-CO3

25 pts

Level 5

Expresses content knowledge with the assignment purpose in a complete, organized, clear, professional, and culturally respectful manner.

22.5 pts

Level 4

Expresses 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 pts

Level 3

Partially 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 pts

Level 2

Partially 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 pts

Level 1

Expresses limited content knowledge with the assignment purpose. Ideas are not expressed in a complete, organized, clear, professional, and/or culturally respectful manner.

0 pts

Level 0

The 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 instructions

25 pts

This criterion is linked to a Learning OutcomeAnalysis

30 pts

Level 5

Constructs 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 pts

Level 4

Constructs 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.

24 pts

Level 3

Constructs 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.

21 pts

Level 2

Constructs 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.

18 pts

Level 1

Constructs 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 pts

Level 0

The 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 pts

This criterion is linked to a Learning OutcomeTechnology

10 pts

Level 5

Manipulates multiple technological resources to effectively implement all assignment requirements.

8.75 pts

Level 4

Manipulates multiple technological resources to effectively implement most assignment requirements.

7.5 pts

Level 3

Manipulates multiple technological resources to effectively implement some assignment requirements.

6.25 pts

Level 2

Manipulates multiple technological resources for some assignment requirements.

5 pts

Level 1

Manipulates technological resources to minimally meet some assignment requirements.

0 pts

Level 0

The assignment was not completed or difficulties with technological manipulation were evident. The assignment submitted does not meet requriements.

10 pts

This criterion is linked to a Learning OutcomeWriting

5 pts

Level 5

The assignment exhibits a excellent command of written English language conventions. The assignment has no errors in mechanics, grammar, or spelling.

4.5 pts

Level 4

The 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 pts

Level 3

The 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 communication

3.5 pts

Level 2

The 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 pts

Level 1

The 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 pts

Level 0

The 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 pts

This criterion is linked to a Learning OutcomeAPA

5 pts

Level 5

In-text citations of sources and references in proper APA style are included with no errors.

4.5 pts

Level 4

In-text citations of sources and references in proper APA style are included but have 1-2 minor APA errors.

4 pts

Level 3

In-text citations of sources and references in proper APA style are included but have 3 - 4 minor APA errors.

3.5 pts

Level 2

In-text citations of sources and references in proper APA style are included but have more than 4 errors.

3 pts

Level 1

The errors demonstrate limited understanding of in-text citation and reference requirements

0 pts

Level 0

There are no in-text citations AND/OR references.

5 pts

Total Points: 75

Previous Next

HeartRateDataSetE5.xlsx
This file is too large to display.View in new window