In: Statistics and Probability
"Data 2 below (a sample from your production line) and Data 4 (sample test data, which you received from your competitor). Calculate the P-value when comparing the population variances of these two groups."
Please include excel calculations.
Data 2
| Strength | ||||||
| 255 | 262 | 268 | 271 | 279 | 282 | 287 | 
| 256 | 263 | 268 | 272 | 279 | 282 | 289 | 
| 259 | 264 | 268 | 273 | 279 | 283 | 261 | 
| 260 | 266 | 269 | 274 | 279 | 283 | 217 | 
| 260 | 266 | 269 | 274 | 280 | 283 | 247 | 
| 261 | 267 | 269 | 275 | 280 | 284 | 238 | 
| 261 | 267 | 270 | 276 | 280 | 287 | 220 | 
| 261 | 267 | 270 | 277 | 281 | 287 | 235 | 
Data 4
| Strength | ||||||
| 234.4 | 253.2 | 259 | 253.9 | 209.6 | 251.4 | 247.5 | 
| 248.6 | 254.6 | 229.7 | 264.8 | 240.4 | 271.6 | 246 | 
| 245.9 | 270.3 | 278.9 | 252 | 241.7 | 261.6 | 253.9 | 
| 278.6 | 263 | 288.6 | 294.6 | 280.5 | 256.8 | 233.1 | 
| 270.9 | 242.7 | 266.1 | 250.6 | 281.6 | 254.4 | 241.9 | 
| 248.2 | 271.4 | 254.9 | 235.3 | 272.3 | 269.5 | 257.5 | 
| 296.8 | 270.6 | 266.6 | 263.6 | 243.6 | 251.9 | 278.3 | 
Here is the output from excel:

Calculations:



and the output:

Let me know in the comments if anything is not clear. I will reply ASAP! Please do upvote if satisfied!