Note. Jennifer Nguyen, a Humber College Healthcare Management program graduate who always hadonly perfect marks in statistics, was hired by the famous Healthy Life medical insurance company.Jennifer is assigned to conduct statistical analysis of medical and financial data. In problems 2-6, statehypotheses H0 and H1 and provide detailed conclusions (based on -values or critical values/teststatistics) together with the Excel output.

1. Jennifer's manager Dr. Jonathan Steinberg, who has degrees and publications in bothmathematical statistics and medical science, asked her to find estimates of the average dentalclaim reimbursement for 2022. As Healthy Life has many thousands of clients it is virtuallyimpossible to calculate the population mean. Using the Excel Random Number Generatorfunction, Jennifer found a random sample of 52 dental claims submitted to Healthy Life. Theamounts covered by insurance you can see in the Major Assignment Data file. Please helpJennifer Nguyen to construct 90%, 95%, and 99% confidence intervals for the trueaverage reimbursement. Make sure that t-distribution is applicable: build a histogram withthe bin values, for example, $100, $200, $300, $400, and $500, and check whether it isapproximately symmetric and bell-shaped. Then, use Descriptive Statisticsfunction from Data Analysis. Constructing confidence intervals. Round values to at least twodecimal places.

Dental Claim Number	Amount Covered		Bin
1	$210.50		$100
2	$210.50		$200
3	$368.00		$300
4	$217.75		$400
5	$242.75		$500
6	$112.75
7	$393.25
8	$397.75
9	$210.50
10	$417.75
11	$247.75
12	$262.75
13	$167.75
14	$267.75
15	$267.75
16	$357.75
17	$243.25
18	$174.00
19	$317.75
20	$367.75
21	$452.75
22	$210.50
23	$210.50
24	$267.75
25	$242.75
26	$407.75
27	$207.75
28	$267.75
29	$267.75
30	$267.75
31	$367.75
32	$115.75
33	$422.75
34	$312.75
35	$222.75
36	$247.75
37	$262.75
38	$467.75
39	$267.75
40	$267.75
41	$357.75
42	$243.25
43	$210.50
44	$210.50
45	$267.75
46	$342.75
47	$367.75
48	$357.75
49	$212.75
50	$402.75
51	$116.75
52	$499.75