Excel Worksheet: http://sendanywhe.re/DHA1XELK

The Thomas Jefferson Nickel was first produced in 1938. The United States Mint produces all U.S. coins at their Philadelphia, Pennsylvania, and Denver, Colorado facilities. According to the US Code, nickel has a nominal specification weight of 5.00 grams and a tolerance of +|- 0.194 gram. A study was conducted for nickels produced from 1960 through 2013. The data were gathered by obtaining three randomly selected rolls of nickels from a bank clerk. Any nickels produced before 1960 may have significant wear and, therefore, were removed from the sample.

Each nickel was weighed using a digital scale calibrated to read grams to two decimal places, in increments of 0.01 grams.The scale was placed on a flat, balanced surface. To ensure the repeatability of the measuring process, an "X" was drawn on the platform of the scale, indicating where each nickel would be placed, and each nickel was weighed five times to verify the result. The weight was checked by a second person to verify reproducibility. Using the same measuring instrument and process, each nickel was again measured five times. The raw data are provided in the Excel Worksheet Data Set 1.

Task 1

1. Use Excel's Analysis Toolpak to compute descriptive statistics for the total sample, Denver, and Philadelphia samples. Populate columns B, C, and D in Worksheet "Descriptive Stats" in the Excel data file.
2. Use the bin values provided in columnFof the Descriptive Stats worksheet to create histograms, for: Total, Denver, and Philadelphia samples. Display the histograms on the same worksheet. Clearly Label each Histogramas: Total, Denver, Philadelphia.
3. Study the results of steps 1 and 2. Are there differences, by mint, that you could report descriptively?Insert your comment in cell G1 of the same worksheet.

Task 2

1. Stratify the data into two strata: a) Older coins, minted between 1963 - 1998, b) Newer coins, minted between 1999 - 2013.
2. Count frequency of Total, Older, and Newer samples. Also,compute the mean and standard deviation for each sample.
3. Using the government specifications, compute process capability indexes for Total Coins, Older Coins, and Newer Coins. How might the wear of circulated coins influence these indexes? Compare the process capability indexes of older coins with more recent ones.
4. Record the results of your analysis in the two tables on Worksheet Process Capability.
5. Interpret results and findings in the space provided on that worksheet.

Task 3

1. Usedata on Worksheet Data Set 2. It shows data from samples of 5 nickels from 1964 through 2013 (insufficient data were available for the year 2009 and for the years 1967 to 1969, which were grouped). Construct X-bar and R-charts using these samples. What can you conclude?
2. Populate your answers to question 1 into the two worksheets in the Excel file which are called X-bar chart and R-Chart. Don't forget to interpret your findings in the spaces provided on each worksheet.