ITEC 601 Exam 4

ITEC 601 Exam 4 | Assignment Help | Kogod School Of Business American University 

Exam 4

1)      The following is a list of prices (in dollars) of birthday cards found in various drug stores:

a.       Using Excel find the mean, median, mode, range, variance and standard deviation of the data. Attach your output from Excel.

b.      Using Excel, construct a frequency histogram of the data set. Use the guidelines in the class notes. Provide all the details (interval, width, etc.) on how you constructed the histogram. Make sure that you attach the histogram created by Excel. Comment on the shape of the frequency distribution (e.g., is the distribution skewed? Is the distribution approximately mound-shaped and symmetric?) for the data set based on your histogram.

c.       Based on the results in part a, construct the intervals  , 2± ±x s x s  and 3±x s  for the data set. Be sure to show your interval below. Based on the results in part b what percentage of the measurements for the data set falls in each interval? Answer: The intervals are .85 – 1.56 (40% of data), 1.56 – 2.22 (20% of data), 2.22 – 2.99 (40% of data)

2)      A semiconductor manufacturer produces printed circuit boards that are sampled to determine the thickness of their copper plating. The following statements create a data set named Trans, which contains the plating thicknesses (Thick) of 50 boards:

a.       Using Excel find the mean, median, mode, range, variance and standard deviation of the data. Attach your output from Excel.

b.      b. Based on the results in part a, construct the intervals  , 2± ±x s x s  and 3±x s  for the data set. Be sure to show your interval below. What percentage of the measurements for the data set falls in each interval? Compare the intervals  , 2 , and± ±x s x s  3±x s  . Explain why the results are different.