Need help? We are here

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

Instructions
In this assignment, you will be required to calculate descriptive statistics for each numeric variable in the Heart Rate Dataset.
Steps
Open the Heart Rate Dataset in Excel
Sort the quantitative
variables by class
(e.g., Male at-rest heart rate and Female at-rest heart rate)
Use the Excel Data Analysis ToolPak* tools to calculate each of the following statistics:
Mean of each quantitative variable
Sample variance of each quantitative variable
Sample standard deviation of each quantitative variable
Create a table in Excel that summarizes the statistics for each variable.
Transfer your summary results to Word.
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
Your assignment should be typed into a Word or other word processing document,
formatted in APA style.
The assignments must include
A title page with
Assignment 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 https://youtu.be/HJay_paA6T4
Joseph C. (2016). Installing Excel Toolpak (Data Analysis) on Mac [Video].  Retrieved from https://youtu.be/mtmrAXwLcuU
Joshua Emmanuel. (, 2017). Descriptive statistics in Excel mean, median, mode, std. deviation… [Video]. Retrieved from https://youtu.be/qJR8OMQP3vw/p>
Quantitative Specialists. (, 2013). How to install the Data Analysis ToolPak in Microsoft Excel [Video]. Retrieved from https://youtu.be/_yNxLFagKgw
Assignment Files
Heart Rate Data Set
[Excel Document]

Pages (275 words)
Standard price: \$0.00

### Latest Reviews

Impressed with the sample above? Wait there is more

Related Questions

### Identify an academic, peer-reviewed journal article from the TNCC library

Premium Paper Help is a professional writing service that provides original papers. Our products include academic papers of varying complexity and other personalized services, along

### PLEASE READ ENTIRELY>>  2 PARTS!!!!!!!!!!!!   For the Video Argument Presentation, you

PLEASE READ ENTIRELY>>  2 PARTS!!!!!!!!!!!!   For the Video Argument Presentation, you have two audiences who will view and review your presentation: your instructor and

### Compare the Economy Growth of Russia and Singapore

Topic Select two economies from the same continent and consider the time period 2016 to 2018. Compare the key drivers of growth for these two

### Suppose you are a real estate agent and you were

Suppose you are a real estate agent and you were asked by a client about the “typical” home in a subdivision. Being the astute agent

### Turkish airlines food and beverages: Turkish airlines food: Turkish airlines

Turkish airlines food and beverages: Turkish airlines food: Turkish airlines in all actuality do offer complimentary food and beverages. But you would adore the

### Limits of scientific thinking and research.

This assignment is intended to assist you to critically think about issues, examine underlying assumptions that influence your own perspective on matters. As you

### consider how the categories of “youth” and “childhood” vary over

consider how the categories of “youth” and “childhood” vary over time and across cultures. To do this, you will answer a series of questions

### 1. Give a 3-4 lines detailed summary of the 6

1. Give a 3-4  lines detailed summary of the 6 articles attached . TOPIC: PREVENTION OF FALLS IN THE ELDERLY IN THE HEALTHCARE SETTING 1A.

### Please reply to this student post 3 small paragraphs. APA. less than 20 % similarity. There are four level of measurement that are nominal, ordinal, interval, and ratio. Nominal is considered the lowe Nursing Assignment Help

Please reply to this student post 3 small paragraphs. APA. less than 20 % similarity. There are four level of measurement that are nominal, ordinal,

### Information about ICD 10 CM and ICD 10 PCS Discussion Nursing Assignment Help

Expert Solution Preview Introduction: As a medical professor responsible for creating assignments and examinations for medical college students, my goal is to ensure that students

### Clearly describing your duties and responsibilities and document with great

Clearly describing your duties and responsibilities and document with great specificity what those duties and responsibilities were. In addition, document in your report your regular

### What ethical obligations do employees have in commenting about their employer on social mediaWhat ethical obligations do employers have concerning

What ethical obligations do employees have in commenting about their employer on social media?What ethical obligations do employers have concerning their empoyees privacy on social

New questions

### SU HCA Healthcare Financial Condition Questions Nursing Assignment Help

For the Week 3 Assignment, you will be expected to investigate the financial condition of a health services organization (HSO) of your choosing. In preparation

### SU Health & Medical The Most Important Financial Ratios Nursing Assignment Help

I’m working on a health & medical discussion question and need the explanation and answer to help me learn. Discussion – Ratio Analysis There are

### SU Health & Medical Reimbursement & Value Based Payment Nursing Assignment Help

I’m working on a health & medical discussion question and need the explanation and answer to help me learn. Discussion – Reimbursement For medical professionals

### SU Leveraging Cost Volume Profit Analysis Discussion Nursing Assignment Help

I’m working on a health & medical discussion question and need the explanation and answer to help me learn. How do you leverage the information

### NYU Group Psychotherapy Pros Cons and Ground Rules Nursing Assignment Help

I’m working on a health & medical question and need the explanation and answer to help me learn. Discuss the pros and cons of group