please answer Q 4 and 5

Optional (if it possible for you please do all question in excel and show all of the formula)

Boston Silicon Chip Manufacturing records data on average chip weight every 25 business days. The Quality Assurance Technician is on vacation. You have been hires to assist in the interpretation of the silicon chip weight distributions. The average weight of a silicon chip is .50 mm or approximately 1.9685 inches. We will use the following data: Mean =1.9865 Range of = 25. All other Excel data should remain unchanged. 1. What is the (x-bar) value? 2. What is the upper control limit? 3. What is the lower control limit? 4. What is the R-bar value? What does this reveal about the process variability? 5. Identify the proper conclusion regarding the data? , the While the process mean dispersion a. remained constant, has shifted b. has shifted, remained constant Boston Silicon Chip Manufacturing records data on average chip weight every 25 business days. The Quality Assurance Technician is on vacation. You have been hires to assist in the interpretation of the silicon chip weight distributions. The average weight of a silicon chip is .50 mm or approximately 1.9685 inches. We will use the following data: Mean =1.9865 Range of = 25. All other Excel data should remain unchanged. 1. What is the (x-bar) value? 2. What is the upper control limit? 3. What is the lower control limit? 4. What is the R-bar value? What does this reveal about the process variability? 5. Identify the proper conclusion regarding the data? , the While the process mean dispersion a. remained constant, has shifted b. has shifted, remained constant