the Heart Rate Dataset
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 Data Analysis tools of Excel 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, and briefly explain your calculated results.
Order from us and get better grades. We are the service you have been looking for.