I just want to know how to do this. Any help would be great appreciated:)

M N o The data below shows monies collected from New York City parking meters from May 1977 to March 1981. Most of these collections were made by contractors, with a small "control group" of meters around city hall collected by city employees. From May 1978 to April 1980 (in orange) contractor collections were made by Brink's Inc. In 1983 the city presented evidence in court that Brink's employees has been stealing parking meter moneys - delivering to the city less than the total collections. The court was satisfied that theft has taken place, but the actual amount of shortage was in question. Assume that the population of money collected is normally distributed, but that the standard deviation is unknown. 1. Confidence Interval Assume that there was no theft before or after Brink's tenure and estimate the monthly shortage with a 84% confidence interval. 1.a Describe how you are going to accomplish this. Month May 1977 June 1977 July 1977 August 1977 September 1977 October 1977 November 1977 December 1977 January 1978 February 1978 March 1978 April 1978 May 1978 June 1978 July 1978 August 1978 September 1978 October 1978 November 1978 December 1978 January 1979 February 1979 March 1979 April 1979 May 1979 June 1979 Collections $2,224,277.00 $1,892,672.00 $1,668,074.00 $1,618,966.00 $1,509,195.00 $1,511,014.00 $1,506,977.00 $1,520,443.00 $1,270,936.00 $1,379,419.00 $1,602,841.00 $1,246,483.00 $1,330,143.00 $1,525,370.00 $1,312,257.00 $1,494,717.00 $1,385,822.00 $1,457,598.00 $1,469,066.00 $1,547,011.00 $1,565,671.00 $1,124,576.00 $1,773,806.00 $1,652,490.00 $1,644,558.00 $1,678,286.00 Control $6,729.00 $5,751.00 $6,711.00 $7,069.00 $7,134.00 $5,954.00 $5,447.00 $6,558.00 $5,222.00 $4,150.00 $6,765.00 $6,681.00 $7,016.00 $7,440.00 $6,264.00 $7,337.00 $7,271.00 $6,694.00 $5,795.00 $7,105.00 $6,613.00 $5,258.00 $7,664.00 $6,716.00 $7,614.00 $7,652.00 1.b Carry out your computations. Functions like AVERAGE, STDEV, TDIST, and TINV may be helpful. Label intermediate computations and expand the yellow area if you need more room. E G H K M N B March 1979 April 1979 May 1979 June 1979 July 1979 August 1979 September 1979 October 1979 November 1979 December 1979 January 1980 February 1980 March 1980 April 1980 May 1980 June 1980 July 1980 August 1980 September 1980 October 1980 November 1980 December 1980 January 1981 February 1981 March 1981 D $1,773,806.00 $1,652,490.00 $1,644,558.00 $1,678,286.00 $1,636,597.00 $1,738,847.00 $1,576,383.00 $1,746,508.00 $1,746,899.00 $1,685,611.00 $1,694,467.00 $1,595,017.00 $1,671,626.00 $1,566,107.00 $1,972,964.00 $1,934,369.00 $1.881,303.00 $1,733,339.00 $1,825,021.00 $1,918,247.00 $1,764,116.00 $1,941,848.00 $1,619,657.00 $1,648,605.00 $1,837, 134.00 F $7,664.00 $6,716.00 $7,614.00 $7,652.00 $7,513.00 $7,862.00 $6,543.00 $6,855.00 $7,182.00 $6,830.00 $6,552.00 $7,318.00 $6,679.00 $6,637.00 $7,912.00 $7,319.00 $7,803.00 $8,126.00 $7,489.00 $7,986.00 $6,020.00 $6,442.00 $7,937.00 $6,685.00 $7,470.00 2. Hypothesis Test Test the claim that the control group of meters had the same average monthly collection during Brink's tenure as they did before and after. Use the 0.04 significance level. 2.a Describe how you are going to accomplish this. 2.b Perform the hypothesis test. In addition to the functions above, TTEST may be useful. Label your computations and state your conclusion