This assignment is to be done using Excel. Bianca Frantini, a Humber College graduate who always had only perfect marks in statistics, was hired by the famous Healthy Life medical insurance company. Bianca is assigned to conduct statistical analysis of medical and financial data. As Bianca is on probation, please help her to complete the following six tasks. In problems 2-6 state hypotheses H0 and H1, and provide detailed conclusions (based on P-values or critical values/test statistics) together with the Excel output. For your convenience the data are given in Major Assignment Data file. 1. Bianca's manager Dr. Bennet Klein, who has degrees in both mathematics and medicine, asked her to find estimates of the average dental claim reimbursement for 2015. As Healthy Life has hundreds of thousands of clients it is virtually impossible to calculate the population mean. Using the Excel Random Number Generator function, Bianca found a random sample of 25 dental claims submitted to Healthy Life. The amounts covered by insurance you can see in Major Assignment Data file. Please help Bianca to construct 90%, 95%, and 99% confidence intervals for the true average reimbursement. Use t-distribution and Descriptive Statistics function from Data Analysis. 2. Analyzing most recent data, Bianca's manager Dr. Klein found out that in 2015 the anti- cancer prescription drug claims submitted by Healthy Life clients contained amounts considerably greater than he anticipated. Specifically, he asked Bianca to check whether patients with Oncotype DX scores over 30 claimed, on average, more than $1000 per month. Using the systematic sampling method Bianca selected 45 patients from this category (see the Major Assignment Data file). Please help Bianca to test the claim that the population mean monthly amount of the anti-cancer prescription drug claims was over $1000 in 2015. Use Data Analysis t-Test: Two-Sample Assuming Unequal Variances and "fool" Excel approach. Use 5% significance level. Is it possible to reach the same conclusion at 1% significance level