90.2K

Verified Solution

Link Copied!

help me pls solve on excel and show formula as well .. thanks solve all parts

4. Use the RANDBETWEEN function to generate random numbers between 40% more than the UCL and 40% less than the LCL. Your table will generate random and different numbers but should look like the following table. However, in your case, there must be 20 samples, not 5 . 5. Use two digits for all numbers. 6. Calculate each sample's mean and standard deviation using the proper MS Excel 4. Use the RANDBETWEEN function to generate random numbers between 40% more than the UCL and 40% less than the LCL. Your table will generate random and different numbers but should look like the following table. However, in your case, there must be 20 samples, not 5 . 5. Use two digits for all numbers. 6. Calculate each sample's mean and standard deviation using the proper MS Excel commands (AVERAGE and STDEV). 7. Draw the x-chart by using the randomly generated data. Show data, UCLx and LCLx, on the same chart. 8. Calculate the UCLr and LCLR for the R chart. 9. Draw the R chart. Show data, UCLR and LCLR on the same chart. 10. Make sure the charts are automatically updated every time you click F9. 4. Use the RANDBETWEEN function to generate random numbers between 40% more than the UCL and 40% less than the LCL. Your table will generate random and different numbers but should look like the following table. However, in your case, there must be 20 samples, not 5 . 5. Use two digits for all numbers. 6. Calculate each sample's mean and standard deviation using the proper MS Excel 4. Use the RANDBETWEEN function to generate random numbers between 40% more than the UCL and 40% less than the LCL. Your table will generate random and different numbers but should look like the following table. However, in your case, there must be 20 samples, not 5 . 5. Use two digits for all numbers. 6. Calculate each sample's mean and standard deviation using the proper MS Excel commands (AVERAGE and STDEV). 7. Draw the x-chart by using the randomly generated data. Show data, UCLx and LCLx, on the same chart. 8. Calculate the UCLr and LCLR for the R chart. 9. Draw the R chart. Show data, UCLR and LCLR on the same chart. 10. Make sure the charts are automatically updated every time you click F9

Answer & Explanation Solved by verified expert

See Answer