Please give step by step excel instructions for this problem.

The quality department of Travel Essentials uses control charts to monitor the charging capacity of their portable chargers. The quality manager has collected 25 random samples of 5 units each. Here is the data the charging capacity in hours for the portable chargers.

Sample #	Observation
1	2	3	4	5
1	21.45	22.80	25.20	29.92	21.50
2	27.64	20.65	17.30	21.36	21.58
3	23.89	22.76	29.11	22.01	21.86
4	18.70	16.09	19.01	23.98	27.88
5	19.38	24.21	24.90	28.46	21.86
6	22.28	22.27	23.70	20.93	21.46
7	25.34	22.25	29.18	21.25	21.15
8	27.75	26.85	21.06	27.63	19.00
9	26.09	31.13	13.76	30.35	22.98
10	24.96	18.66	22.57	35.20	24.10
11	24.07	19.32	22.07	29.18	34.09
12	20.08	19.22	21.03	18.80	17.79
13	27.28	27.64	23.07	15.82	19.07
14	12.79	19.53	24.59	24.99	14.81
15	14.05	22.91	18.06	27.25	15.23
16	21.29	23.54	21.85	28.95	19.98
17	25.32	22.22	19.75	19.86	25.82
18	17.88	25.51	30.71	23.71	20.04
19	27.41	23.59	28.94	29.74	21.68
20	22.08	20.94	26.01	22.96	30.05
21	28.04	22.36	25.87	23.79	21.64
22	25.11	25.05	21.32	26.37	29.12
23	23.57	28.17	17.55	26.92	19.83
24	26.59	22.54	29.03	26.64	18.40
25	21.31	23.44	21.06	23.32	26.62

a. Copy the table into Excel and use this data to calculate 3-Sigma control limits for X-bar and R charts.

b. Plot the sample means on the X-bar chart for each of the samples. Also add the centerline and the UCL and LCL for the average mean charging capacity.

c. Plot the sample ranges on R-chart for each of the samples. Also add the centerline and the UCL and LCL for the sample ranges.

d. Do the X-bar and R charts indicate that the process is in control? Why or why not?