1.Use the below data to find (using an interval of 5 or 6 = class width of 5 or 6 = bin width of 5 or 6):Use the data below only and use your choice of software to do the Histogram - You can use any Histogram tool whether it is Excel or another application from the Internet.Be sure that the Histogram shows the classes and frequencies. The below data are samples of heart rates.A) Paste the Histogram in this document below and answer. Put a title on the histogram....B) Describe what the Histogram means in relation to the data below & what does it tell you about the data and how can you use it to analyze the data?

females

76 72 88 60 72 68 80 64 68 68 80 76 68 72 96 72 68 72 64 80

64 80 76 76 76 80 104 88 60 76 72 72 88 80 60 72 88 88 124 64

2.Use the below data to develop (using an interval of 5 or 6 = class width of 5 or 6 = bin width of 5 or 6) a frequency distribution chart - Use Excel or any other application to develop your Frequency Distribution Chart.A) Paste the Frequency Distribution Chart below and then answer.... B) Describe what the Frequency Distribution Chart is telling you about the Test scores and how can you use this data.Note: please use all four rows of data.

Test Scores

76 72 88 60 72 68 80 64 68 68 80 76 68 72 96 72 68 72 64 80

64 80 76 76 76 80 104 88 60 76 72 72 88 80 60 72 88 88 124 64

68 64 88 72 64 72 60 88 76 60 96 72 56 64 60 64 84 76 84 88

72 56 68 64 60 68 60 60 56 84 72 84 88 56 64 56 56 60 64 72

3.Using the Descriptive Statistics Tool in Data Analysis in Excel using the Test Score data belowA) copy the output from the Descriptive Statistics and highlight Mean, Median, and Standard Deviation and copy it below and then answer.... B) Define & Describe what the Mean, Median, and Standard Deviation mean in relation to the Test Score data below