Graphics and Summary Statistics

The data set called"Exercise versus Life Expectancy". A simple random sample of 10 counties from Mississippi with an exercise rate of 13.5%, 10 counties from Oklahoma with an exercise rate of 19%, and 10 counties from Colorado with a 32.5% exercise rate were selected. The male life expectancies for the 30 counties were recorded.onePDF document that contains both the write-up and the appendix, you will need to cut and paste your graphs and tables from SPSS into word, complete the write-up and then convert the document into a PDF.

First appendix by cutting and pasting the following output into a word document.

1. A histogram for the male life expectancies(only use the"Expectancy"variable of the data setwhen creatingthis histogram).Make sure you use a lower class limit of 66 with a class width of 2.
2. A boxplot for the expectancies(only use the"Expectancy"variable of the data setwhen creatingthis histogram).
3. The "Descriptives" chart which is found by selecting "Analyze - Descriptives - Explore" (This chart shows the IQR, median, mean and standard deviation in addition to lots of other information.)Againonly use the "Expectancy" variable.
4. The table showing the percentiles (only use the"Expectancy"variable of the data setwhen creatingthis chart). You can select to get this chart when you chose "Analyze - Descriptives - Explore"
5. A pie graph showing the proportion of data that was collected from the three states (only use the"State"variable to create the pie chart).

You need to make sure you titleALLyour graphs and tables as follows:

Graph A: Histogram ofthe Male Life Expectancy for a Sample of Counties in MS, CO and OK

Table A:Descriptives of the Male Life Expectancy for a Sample of Counties in MS, CO and OK

(Each table and graph should have a title!)

Make sure that none of your tables are half on one page and half on another page of the document.

Write-up:

The write up should be brief and includeonlythe answers to the questions below. Make sure you answer the questions in order!The write-up should not be inlist format, but rather in paragraph form.When describing agraph in the write-up, refer to the graph in your appendix that you are describing as follows: "The histogram shows the distribution of...............(Graph A)".When giving avalue takenfrom one of your tables in the write-up, you need to refer to the table in your appendix from which you obtained the number(s) as follows: "The mean and standard deviation for....... are ...... and ..... respectively(Table A)".Your typed write-up will be separate from your appendix, but in thesamedocument.Put the appendix first followed by the write-up or visa versa.The write-up should include

1. a sentence describing the distribution of your data as shown in the histogram.
2. a sentence explaining whether you have any outliers based on the boxplot.If there are outliers, which state(s) they correspond to.
3. a sentence explaining what the pie graph is showingin terms the data.
4. several sentences reporting the mean, standard deviation, median, IQR, and five number summary for the data on number of male life expectancies (round all numbers to one decimal place).

Critical Thinking Question

1. Write sentence explaining which measure of center and spread should be usedfor the data on the male life expectancies and why they would be best.
2. Why is the mean only slightly higher for this data set?

For example, to say "The histogram is ..........." gives me a lot less information about the data than saying "The distribution ofthe data on male life expectancies is ..........."

Here are the data set:

Expectancy: State

73.5 1

70.5. 1

72.4. 1

69.7 1

72.2. 1

70.9 1

70.6 1

67.1 1

70.3 1

69.7. 1

69.2 2

70.4 2

70.9 2

72.2 2

75.7. 2

71.8 2

72.2. 2

73.6 2

74.5 2

70.8 2

75.1 3

81.8 3

78.2 3

77.7 3

75.8 3

78.2 3

78.2 3

79.0 3

74.5 3

73.4 3