© 2016 Microsoft Corporation. All Rights Reserved. 1. Use the data in the file Stock.xlsx to generate descriptive statistics for Intel and GE stock. 2. Use your answer to problem 1 to compare the monthly returns on Intel and GE stock. 3. City Power & Light produces voltage-regulating equipment in New York and ships the equipment to Chicago. A voltage regulator is considered acceptable if it can hold a voltage of 25–75 volts. The voltage held by each unit is measured in New York before each unit is shipped. The voltage is measured again when the unit arrives in Chicago. A sample of voltage measurements from each city is given in the file Citypower.xlsx. •Using descriptive statistics, comment on what you have learned about the voltage held by units before and after shipment. •What percentage of units is acceptable before and after shipping? •Do you have any suggestions about how to improve the quality of City Power & Light’s regulators? •Ten percent of all New York regulators have a voltage exceeding what value? •Five percent of all New York regulators have a voltage less than or equal to what value? 4. In the file Decadeincome.xlsx, you are given a sample of incomes (in thousands of 1980 dollars) for a set of families sampled in 1980 and 1990. Assume that these families are representative of the whole United States. Some Republicans claim that the country was better off in 1990 than in 1980 because the average income increased. Do you agree? 5. Use descriptive statistics to compare the annual returns on stocks, T-bills, and corporate bonds. Use the data contained in the file Historicalinvest.xlsx. 6. In 1969 and 1970, eligibility for the US armed-services draft was determined on the basis of a draft-lottery number. The number was determined by birth date. A total of 366 balls, one for each possible birth date, were placed in a container and shaken. The first ball selected was given the number 1 in the lottery, and so on. Men whose birthdays corresponded to the lowest numbers were drafted first. The file Draftlottery.xlsx contains the actual results of the 1969 and 1970 drawings. For example, in the 1969 drawing, January 1 received the number 305. Use Page 17 2/24/2017 • Each high school had two outliers (on the high side) on English test scores. • Columbus North students tend to perform the best on each test, and Bloomington North students tend to perform the worst on each test. • For each test, it appears that all the schools have boxes and whiskers of similar length, indicating the variability of scores on each test is consistent across schools. Problems
© 2016 Microsoft Corporation. All Rights Reserved.
You've reached the end of your free preview.
Want to read all 19 pages?
- Summer '16
- naveen rathi
- Standard Deviation, Mean