Xbart Chart-Missing Data(correct sum) Question

Good Morning,

I'm in a business statistics course and I understand how to make a xbar and rchart in excel when all the data is available to me, but I just can't seem to figure out the problem below. Any help would be much appreciated! Thank you!!

Here's the question:

Using the data below, determine the trial central line and trial control limits for the Xbar chart. Subgroup size is 5. For the R chart, the trial central line is 0.11, the UCL is 0.23, and LCL is 0. Note not all of the subgroups are included in the data; however, the sums are correct.

Subgroup X-Bar R
1 2.08 .05
2 2.09 .24
3 2.08 .10
4 * *
* * *
* * *

25 2.09 .11
Sum =52.0 Sum =2.75[/HTML][/HTML]