Business Finance
Herzing University Effects of Gender on Heart Rate Worksheet & Discussion

Herzing University

Question Description

I need help with a Health & Medical question. All explanations and answers will be used to help me learn.

In this assignment, you will be required to calculate descriptive statistics for each numeric variable in the Heart Rate Dataset

Steps

  1. Open the Heart Rate Dataset in Excel
  2. Sort the quantitative variables by class (e.g., Male at-rest heart rate and Female at-rest heart rate)
  3. Use the Excel Data Analysis ToolPak* tools to calculate each of the following statistics:
    1. Mean of each quantitative variable
    2. Sample variance of each quantitative variable
    3. Sample standard deviation of each quantitative variable
  4. Create a table in Excel that summarizes the statistics for each variable.
  5. Transfer your summary results to Word.
  6. Interpret what the mean and standard deviation specifically tell you about the heart rates of males and females in the sample. Are the heart rates for males or females higher? Which data is more spread out and which is closest to the overall mean rate? Explain your responses.

In the topic "Measures of Center", you were provided directions on how to upload the Data Analysis ToolPak to Excel. If you have not yet uploaded the add-in Data Analysis ToolPak, please view the appropriate video and follow the instructions. You will not be able to complete this assignment without that add-in.

How to Install the Data Analysis ToolPac in Microsoft Excel

(Quantitative Specialists, 2013)
Estimated time to complete: 2 minutes

How to Add the Data Analysis ToolPak in Excel on Mac 2018

(Ben G. Kaiser, 2018)
Estimated time to complete: 2 minutes

Installing Excel Toolpak (Data Analysis) on Mac (versions other than 2018)

(Joseph C., 2016)
Estimated time to complete: 1 minute

For a review of how to use the Data Analysis ToolPak to create summary statistics

Review: Descriptive Statistics in Excel Mean, Median, Mode …

Directions: Review this video on how to use the Data Analysis ToolPak to create summary statistics.

(Joshua Emmanuel, 2017)

Estimated time to complete: 1 minute

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

References

Ben G Kaiser. (2018). How to add the Data Analysis ToolPak in Excel on Mac 2018 [Video]. Retrieved from

Joseph C. (2016). Installing Excel Toolpak (Data Analysis) on Mac [Video]. Retrieved from

Joshua Emmanuel. (2017). Descriptive statistics in Excel mean, median, mode, std. deviation… [Video]. Retrieved from /p>

Quantitative Specialists. (2013). How to install the Data Analysis ToolPak in Microsoft Excel [Video]. Retrieved from

Assignment Files

Heart Rate Data Set [Excel Document]

Rubric

MA320 Unit 3 Assessment

MA320 Unit 3 Assessment

CriteriaRatingsPts

This criterion is linked to a Learning OutcomeContentMA320-CO1

25.0 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.0 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.0 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.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.0 pts

This criterion is linked to a Learning OutcomeAnalysisMA320-CO1

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

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

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

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

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

25.0 pts

This criterion is linked to a Learning OutcomeTechnology

10.0 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.0 pts

Level 1

Manipulates technological resources to minimally meet some assignment requirements.

0.0 pts

Level 0

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

10.0 pts

This criterion is linked to a Learning OutcomeWriting

5.0 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.0 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.0 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.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.0 pts

This criterion is linked to a Learning OutcomeAPA

5.0 pts

Level 5

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

4.38 pts

Level 4

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

3.75 pts

Level 3

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

2.5 pts

Level 2

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

1.25 pts

Level 1

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

0.0 pts

Level 0

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

5.0 pts

Total Points: 70.0

PreviousNext

Student has agreed that all tutoring, explanations, and answers provided by the tutor will be used to help in the learning process and in accordance with Studypool's honor code & terms of service.

Final Answer

Attached.

Running Head: EFFECTS OF GENDER ON HEART RATE

Effects of Gender on Heart Rate

Student's name
Professor’s name

Course

1

2

EFFECTS OF GENDER ON HEART RATE
Descriptive statistics gives a summary representation of a dataset. In this exercise, we are
looking at the Heart rate of men and women before and after exercise. We expect women to have
a higher resting Heart rate compared to men. The resting heart rate increases with age in men and
women from 20s to 40s and then starts to decrease (McMullen, 2020). The mean, variance, and
standard deviation of men's and women's heart rate in rest and after exercise is summarized in
table 1 and table 2 below (Emmanuel, 2017).
Table 1. Descriptive statistics of Heart rate before and after exercise for the male quantitative variable .

Male = 0
Resting After Exercise
Mean

80.39

90.28

Sample Variance

49.74

61.15

7.05

7.82

Sample Standard deviation

Table 2. Descriptive statistics of Heart rate before and after exercise for the female quantitative variable.

Female = 1
Resting After Exercise
Mean

81.77

91.23

Sample Variance

39.30

34.96

6.27

5.91

Sample Standard deviation

The mean heart rate after exercise is higher than the mean heart rate at rest in men. The
variation and the standard d...

UIUC

Anonymous
The tutor was pretty knowledgeable, efficient and polite. Great service!

Anonymous
Heard about Studypool for a while and finally tried it. Glad I did caus this was really helpful.

Anonymous
Just what I needed… fantastic!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
Similar Questions
Related Tags