Question: Joeys Salsa Company is considering using a new container for its salsa. According to their research, the glass containers for the salsa should have a
Joeys Salsa Company is considering using a new container for its salsa. According to their research, the glass containers for the salsa should have a strength between LSL = 185 psi and USL = 325 psi. Joeys vendor has provided the following data for evaluation
| Sample # | |||||
| 1 | 265 | 205 | 263 | 307 | 220 |
| 2 | 268 | 260 | 234 | 299 | 215 |
| 3 | 197 | 286 | 274 | 243 | 231 |
| 4 | 267 | 281 | 265 | 214 | 318 |
| 5 | 346 | 317 | 242 | 258 | 276 |
| 6 | 300 | 208 | 187 | 264 | 271 |
| 7 | 280 | 242 | 260 | 321 | 228 |
| 8 | 250 | 299 | 258 | 267 | 293 |
| 9 | 265 | 254 | 281 | 294 | 223 |
| 10 | 260 | 308 | 235 | 283 | 277 |
| 11 | 200 | 235 | 246 | 328 | 296 |
| 12 | 276 | 264 | 269 | 235 | 290 |
| 13 | 221 | 176 | 248 | 263 | 231 |
| 14 | 334 | 280 | 265 | 272 | 283 |
| 15 | 265 | 262 | 271 | 245 | 301 |
| 16 | 280 | 274 | 253 | 287 | 258 |
| 17 | 261 | 248 | 260 | 274 | 337 |
| 18 | 250 | 278 | 254 | 274 | 275 |
| 19 | 278 | 250 | 265 | 270 | 298 |
| 20 | 257 | 210 | 280 | 269 | 251 |
a) Establish and charts (i.e. calculate the control limits) for (breaking) strength quality characteristic and draw (using Excel) the control charts. Is there evidence that the process is in control? b) Estimate the process average and process standard deviation .
c) Is the process capable of producing jars with a breaking strength between 185 and 325 psi? In other words, calculate the potential capability of the process p and the actual process capabilities Cpu, Cpl and Cpk Comment on the results.
PLEASE SHOW HOW I WOULD INSERT THE XCHART AND RCHART ON EXCEL. THANK YOU
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
