Excel Assignment #1 (SRT 2)

Directions:

• Download the file downld08.txt from the SMA website, found at http://scienceandmathacademy.com/weather/summary.html and labeled at “Data for the past week.”

·         Create 2 high quality charts in Excel that show a relationship between two variables in the data set.

·         Below each chart, place a textbox that explains your interpretation of the two variables. Include mathematics, previous knowledge, and common sense in your explanations.

·         Format the charts and textboxes to fit on one printed page.

·         Set your name as the header, with it right justified.

·         Set the class period as the footer, with it centered.

·         Print the one page.

• Download the “Effects of Increase of Minimum Wage” data set from http://www.stat.ucla.edu/datasets/browse.php.

·         Use Excel to conduct appropriate t-tests, by comparing each variable before and after the minimum raise increase.

·         On the back of your printed sheet, state 2 variables that you found to be statistically different.

·         Use mathematics to justify your conclusions. State the null hypothesis, the probability that the 2 variables are equal, and your conclusions.

• Due: 40 minutes into class on September 4, 2007.