You are on the financial planning team for monitoring a high-spending segment of a credit card. You know that customers tend to spend more during December before the holidays, but you're not sure about the pattern of spending in months after the holidays. It contains monthly credit card spending of 1200 customers during the months, January, February, and March. Report on the spending differences between the months. If you'd failed to realize that these are paired data, what difference would that have made in your reported confidence intervals and tests?

PLEASE SHOW HOW TO SOLVE IN EXCEL, THANK YOU

Data

December	January	February	March	April
185.86	49.09	35	0.61	320
2380.32	979.05	2244.96	1227.3	1599.4
12.06	6.03	4.46	573.86	273.9
59.7	86.19	52.41	103.07	314.85
506.92	399.27	1206.95	451.93	739.42
439.3	517.52	715.69	547.53	1952.89
2065.13	543.77	1107.4	1071.37	1256.06
570.19	804.17	639.43	971.52	565.06
682.33	365.1	263.15	800.72	177.38
148.17	154.79	144.99	141.53	148.15
23.9	147.85	123.96	808.33	402.32
14.95	41.97	2351.51	9.95	0
942.8	896.44	596.42	91.92	0
1407.52	716.13	328.94	211.04	1850.7
27.85	105.76	46.79	-67.3	-216.95
1265.77	1128.82	765.81	1489.83	911.01
22.07	39.83	21.8	-13.78	0
2177.82	1763.56	2280.02	2049.17	-80.57
817.54	154.92	447.78	1062.71	663.84
771.69	1076.04	630.48	123.62	152.18
263.68	502.98	484.33	329.21	314.73
30.33	28.5	75.63	81.63	74.72
138.36	50.18	-22.92	22.92	-0.14
24.26	25.25	23.61	22.94	23.91
665.16	383.36	1637.08	691.52	516.2
931.69	936.09	1249.41	413.41	636.05
384.34	53.61	666.08	172.13	0
504.35	121.05	106.6	463.54	118.91
2071.75	599.39	2156.12	1334.55	909.96
52.39	165.73	52.19	88.28	87.75
1375.89	218	1790.65	665.46	1141.6
224.8	372.28	728.11	393.74	93.86
419.83	382.93	1279.89	1105.67	817.08