Get Help With Your Essay

"Place your order now for a similar assignment and have exceptional work written by our team of experts, guaranteeing you A results."

For This or a Similar Paper Click To Order Now

 

for Questions 1 and 2 you will need to input the data provided below into both Excel and SPSS. 1. Suppose that a quality assurance manager took a random sample from a thread-cutting machine. The sample consisted of 18 bolts and the manager tested their tensile strengths. Results from the sample, in tons of force required for breakage, are given below:
2.20 1.95 2.15 2.08 1.85 1.92
2.23 2.19 1.98 2.07 2.24 2.31
1.96 2.30 2.27 1.89 2.01 1.93
a. Use Excel to calculate the mean, median, and standard deviation for these data.
b. Use SPSS to calculate the mean, median, and standard deviation for these data.
c. Use SPSS to create a histogram of these data.
d. Interpret these results and explain any differences you find between the two software tools (Hint. The results should be identical).
2. A manager of a food manufacturing company wants to estimate the percentage of fat in one of its salad dressings. A sample of 20 bottles was taken and the results are given below.
15.88 19.88 21.16 20.37 22.77 20.65
18.60 18.91 21.77 21.64 18.62 18.41
20.15 17.07 19.91 21.07 16.49 21.21
17.98 20.22
a. Use Excel to calculate the mean, median, and standard deviation for these data.
b. Use SPSS to calculate the mean, median, and standard deviation for these data.
c. Use SPSS to create a histogram of these data.
d. Interpret these results and explain whether or not it is honest for the

Get Help With Your Essay

"Place your order now for a similar assignment and have exceptional work written by our team of experts, guaranteeing you A results."

For This or a Similar Paper Click To Order Now