statistics project

Statistics

Project Chapters 2 & 3 (combined)

1) Collect the actual maximum temperature for each day of your birthday month for the past 10 years in any two locations of your choice. Your first data set will consist of the maximum temperatures the past ten years in your first location and the second data set will consist of maximum temperatures from the past ten years in your second location. You will get this information from the website www.weatherunderground.com. At the top, in the search box type the location of your choice, this will give you the weather information from today. Then choose “History” and “Monthly”. This will give you a list of the actual maximum temperatures for each day of the month in that year. Then you can skip to the next year, by choosing that year at the top of the calendar. I want you to collect the actual maximum (not mean) temperature in degrees Fahrenheit for each day of your birthday month (approximately 30 each year, for a total of approximately 300 - 30 days * 10 years for each data set). If there is no maximum temperature for a specific date then just skip that day. If there are no maximum temperatures listed, you will need to choose a different location. Try a larger city if this occurs. List your data sets in an Excel file under different tabs, be sure to title each tab with the location. (20)

2) Sort your data in increasing order.

3) Have Excel construct a frequency table with 6 classes and a histogram for each data set. Be sure to rename the title and axes on your histogram with the correct labels. (20)

4) Have Excel construct the summary statistics for each data set. (20)

5) Type a 1-2 page paper (double spaced) comparing/contrasting the data from each set. The paper should be set up as follows: (40)

Paragraph 1 – Introduction

Paragraph 2 – compare/contrast measures of center (mean, median, mode) of each data set

Paragraph 3 - compare/contrast measures of variation (range and standard deviation) of each data set

Paragraph 4 – compare/contrast the distribution (normal, uniform or skewed) of each data set

Paragraph 5 – Closing

Do not explain to me how to compute different values instead analyze and interpret what the different values mean with regard to each data set.

.

Directions for Excel:

1) Put data in ascending order:

a. Highlight column

b. DATA – SORT – A-Z

2) To construct the histogram you will need to add-in the analysis toolpak. To do this choose file in the upper left corner, then choose Options on the lower left. Next choose add-ins on the left, then choose Analysis Toolpak and click Go at the bottom.

3) Before constructing your histogram you will need to determine your lower and upper class limits for your 6 classes.

Class width = (high – low)/# classes

(be sure to round up – even if it’s a whole number)

4) Frequency Table & Histogram:

a. Indicate upper class limits in a column

b. DATA – DATA ANALYSIS – HISTOGRAM

i. Be sure to check SHOW CHART

5) Summary Statistics:

a. DATA – DATA ANALYSIS – DESCRIPTIVE STATISTICS – SUMMARY STATISTICS