STAT help needed for excel lab work

You must do your own work. If you work with a partner, turn in separate copies.

Use the data set called “Female_pulse_rates.xlsx,” consisting of pulse rates for 40 females.

Follow the “Using Excel to Construct a Frequency Distribution” instructions, shown below, to construct the frequency distribution.

If your version of Excel doesn’t have the “Data Analysis” menu item, refer to the instructions given by Mi- crosoft here:

https://office.microsoft.com/en-us/excel-help/load-the-analysis-toolpak-HP010021569.aspx

Then, very carefully follow the second set of “Using Excel” instructions to create the histogram. Your output should look like the third histogram at the very end of the lab, and should include the bin and frequency table. You do not need to include the data in your report. Try to make your output fit on a single page. Turn in the printed copy.

Lab 2: Frequency Distribution and Histogram

Stat 243 Spring 2015 due May 4