You are an Industrial Engineer at Mason Products, and as your boss, I have asked

Question

You are an Industrial Engineer at Mason Products, and as your boss, I have asked you to conduct a work measurement analysis to determine the set-up time required to produce a batch of dessert jars. At our large processing plant, the set-up ti batches were recorded. The data are shown in the table below. mes (in minutes) for the last 20 128 119 95 97 124 128 74 98108 120 113 109 124 132 97 138 133 136 120 112 Record your final answers in the spaces provided, but SHOW YOUR WORK ON A SEPARATE SHEET OF PAPER, AND STAPLE TO THE BACK OF THIS HANDOUT a) Compute the mean, median, and mode of the data set. Mean:_ Median:_ Mode: b) Find the range, variance, and standard deviation of the data set. Standard dev.: Range: Variance:_ ± 2s, and ± 3s. Count the number of observations c) Construct the interval ± s, that fall within each interval, and find the corresponding proportions. # obs: ]#o ] #obs. Proportion of obs: bs:Proportion of obs: n of obs: ±2s = [ ,

Explanation / Answer

First enter Data into EXCEL

a)

We have to find the sample mean.

Excel command is =AVERAGE(Select data)

sample mean = 115.25

We have to find the median

Excel command is =MEDIAN(Select data)

Median = 119.5

We have to find the sample mode

Excel command is = MODE(Select data)

Mode =128

mean = 115.25 , Median = 119.5 , Mode =128

b)

We have to find the Range

Largest Value = 138

Smallest Value =74

Range = Largest Value - Smallest Value

Rang = 138-74

Range = 64

We have to find the sample variance

Excel command is =VAR(Select data)

Variance = 277.0395

Now we have to find sample standard deviation.

Excel command is =STDEV(Select data)

standard deviation = 16.6445

Range = 64 , Variance = 277.0395 , standard deviation = 16.6445

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.