Question

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.

Answer 1

There is no data given in the question , however we can show how to get the descriptive analysis in excel

Please see the screenshots below

the results are

Var1		Var2		Var3		Var4		Var5
Mean	64.5	Mean	64.5	Mean	55.4375	Mean	58.8125	Mean	55.5625
Standard Error	6.077280093	Standard Error	7.140844955	Standard Error	6.292170234	Standard Error	6.043742	Standard Error	4.098748539
Median	68	Median	71.5	Median	55.5	Median	58.5	Median	52
Mode	50	Mode	95	Mode	#N/A	Mode	#N/A	Mode	42
Standard Deviation	24.30912037	Standard Deviation	28.56337982	Standard Deviation	25.16868093	Standard Deviation	24.17497	Standard Deviation	16.39499415
Sample Variance	590.9333333	Sample Variance	815.8666667	Sample Variance	633.4625	Sample Variance	584.4292	Sample Variance	268.7958333
Kurtosis	-0.298217956	Kurtosis	-0.951165912	Kurtosis	-1.103402622	Kurtosis	-0.77501	Kurtosis	-1.281591274
Skewness	-0.56728083	Skewness	-0.681371878	Skewness	0.062231355	Skewness	-0.02976	Skewness	0.31535365
Range	87	Range	82	Range	86	Range	85	Range	51
Minimum	12	Minimum	15	Minimum	12	Minimum	13	Minimum	31
Maximum	99	Maximum	97	Maximum	98	Maximum	98	Maximum	82
Sum	1032	Sum	1032	Sum	887	Sum	941	Sum	889
Count	16	Count	16	Count	16	Count	16	Count	16
Confidence Level(95.0%)	12.95341583	Confidence Level(95.0%)	15.22035066	Confidence Level(95.0%)	13.41144332	Confidence Level(95.0%)	12.88193	Confidence Level(95.0%)	8.73627567