Statistical Tests

I need to know the thinking process and how to solve the problem using Excel.

PART I: Is there a keyboard configuration that is more efficient than the one that most of us now use? The traditional keyboard configuration is called QWERTY (letters on the top of the row) it was designed to force people type slower to avoid machine jamming, The Dvorak keyboard supposedly provides a more efficient arrangement by positioning the most used keys on the middle row. In a magazine article that suggested that you can measure the ease of typing by using this point rating system: Count each letter on the middle row as 0, count each letter on the top row as 1, count each letter on the bottom row as 2, Using this rating system with each of the 52 words in the Preamble to the Constitution, we get the rating values shown below:

[see attachment]

Based on above info answer the following questions:

(a.) Using the given sample data with the methods from chapter seven, show that the Dvorak configuration has significantly lower ratings than the QWERTY, indicating that the Dvorak is easier to use. [Hint: use confidence intervals]

(b.) Is there anything about the rating system or the choice of words for the sample that might affect the conclusion about which keyboard configuration is easier to use?

(c.) Write a brief report of your findings and conclusions.

(d.) If the Dvorak keyboard is actually easier to use, why is it not being adopted by almost everyone who now uses a keyboard? How might that change?

PART II:

(1.) Below is a set of scores compiled from one particular on-line IQ test.

101, 93, 122, 88, 99, 96, 100, 127, 99, 93, 116, 162, 78,119, 83

(a) Using the IQ test data, test the hypothesis that the mean IQ is 100.
(b) Test the hypothesis that the standard deviation in IQ is 15 points. Summarize your results using a 0.05 level of significance.

(2.) In the last half of the 19th century, A.A. Michelson collected 100 experimental measurements of the speed of light through air. Modern day methods estimate the value Michelson should have observed to be 299,734.5 km/s (as opposed to the speed of light in a vacuum, which is accepted as 299,792.5 km/s.) Michelson's original measurements can be found by going to http://lib.stat.cmu.edu/DASL/Datafiles/Michelson.html. Note that 299,000 has been subtracted from each data point.

Formulate and conduct a hypothesis test that determines whether Michelson's speed of light measurements were in the ballpark of the true value. That is, that the set of 100 measurements reflects a true value of 299,734.5 km/s with measurement error.