statistics

In this week’s assignment, you will answer the following questions using both Excel and SPSS software. Results from these programs should be copied and pasted into a Word document for submission.

For Questions 1 and 2 you will need to input the data provided below into both Excel and SPSS. For Questions 3 and 4 you will use the dataset files provided in the resources for this week (Descriptive statistics, n.d.-a, n.d.-b).

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.

 

“Get 20% OFF on a Similar Assignment!! Place Your Order and Use this Coupon Code: SUPER20”

---

statistics was first posted on March 29, 2020 at 8:06 am.
©2020 “Buy Custom Essays“. Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement. Please contact me at ukbestwriting@gmail.com