Based on data provided I need you to complete an x chart for me with the requirements below. It needs to be in excel with formulas in the boxes not just numbers. My data is regarding number of incoming calls at my job. Here are the dates and numners 11/29- 12/1-37, 12/2-32, 12/3-22, 12/4-16, 12/5-11, 12/6-54, 12/7-32, 12/8-29, 12/9-25, 12/10-15, 12/11-18, 12/12-9, 12/13-43, 12/14-39, 12/15-32, 12/16-33, 12/17-44, 12/18-23, 12/19-14, 12/20-67, 12/21-60, 12/22-51, 12/23-26.
Calculate the control limits.
- Determine if any points are out-of-control.
- If so, remove those data points and recalculate the limits.
- These become your established limits and will not change when you add the additional 5 data points.
3. Once you have established your limits, collect five more data points to “test” these limits. Do not recalculate the limits based on the additional data points. The idea is that once limits are established they will not change unless the process changes.
Take these data points from dates 12/19-12/23.
Attached is an example chart
What Students Are Saying About Us.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐
"Honestly, I was afraid to send my paper to you, but you proved you are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"
.......... Customer ID: 11***| Rating: ⭐⭐⭐⭐⭐
"This company is the best there is. They saved me so many times, I cannot even keep count. Now I recommend it to all my friends, and none of them have complained about it. The writers here are excellent."