In recent years, there has been a great deal of interest in the ads that appear during a widely watched sporting event. These ads vary in length with most lasting 30 seconds or 60 seconds. The data table available below contains the ad length and ad scores (based on a 10-point maximum) from a recent event. Complete parts (a) through (e) below.

a. For the 30-second ads and the 60-second ads separately, construct a 95% confidence interval estimate for the population mean ad score.

The 95% confidence interval estimate for the population mean ad score for 30-second ads is __

B.)The 95% confidence interval estimate for the population mean ad score for 60-second ads is __

Just need questions A and B answered with excel formulas and explanations, please. Thank you!

Brand Advertised	Time of Ad (sec)	Score
Brand 1	60	7.24
Brand 2	30	6.94
Brand 3	30	6.89
Brand 4	30	6.78
Brand 5	30	6.76
Brand 6	30	6.76
Brand 7	60	6.53
Brand 8	60	6.47
Brand 9	60	6.44
Brand 10	30	6.38
Brand 11	60	6.33
Brand 12	60	6.29
Brand 13	60	6.09
Brand 14	30	6.07
Brand 15	30	6.02
Brand 16	30	5.97
Brand 17	60	5.83
Brand 18	30	5.74
Brand 19	60	5.63
Brand 20	30	5.63
Brand 21	30	5.59
Brand 22	60	5.46
Brand 23	30	5.45
Brand 24	30	5.45
Brand 25	30	5.45
Brand 26	30	5.38
Brand 27	60	5.35
Brand 28	30	5.33
Brand 29	30	5.19
Brand 30	30	5.15
Brand 31	30	5.13
Brand 32	60	5.09
Brand 33	30	5.08
Brand 34	60	4.98
Brand 35	30	4.97
Brand 36	30	4.92
Brand 37	30	4.75
Brand 38	30	4.73
Brand 39	30	4.68
Brand 40	30	4.64
Brand 41	30	4.63
Brand 42	30	4.61
Brand 43	30	4.57
Brand 44	30	4.45
Brand 45	30	4.33
Brand 46	60	4.07
Brand 47	30	3.97
Brand 48	30	3.87
Brand 49	30	3.86
Brand 50	30	3.65
Brand 51	30	3.58
Brand 52	30	3.47
Brand 53	30	3.19
Brand 54	30	3.15
Brand 55	60	3.04
Brand 56	60	2.78
Brand 57	60	2.73