Question

Jennifer Nguyen, a Humber College Healthcare Management program graduate insurance who always had only 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. As Jennifer is on probation, please help her to complete the following six tasks. In problems 2-6, state hypotheses Ho and H 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 the Major Assignment Data file. You can also find useful information on the Blackboard in Excel Instructions folder. DENTAL BENEFITS CLAIM FORM 1. Jennifer's manager Dr. Jonathan Steinberg, who has degrees and publications in both mathematical statistics and medical science, asked her to find estimates of the average dental claim reimbursement for 2019. As Healthy Life has many thousands of clients it is virtually impossible to calculate the population mean. Using the Excel Random Number Generator function, Jennifer found a random sample of 50 dental claims submitted to Healthy Life. The amounts covered by insurance you can see in the Major Assignment Data file. Please help Jennifer Nguyen to construct 90%, 95%, and 99% confidence intervals for the true average reimbursement. Make sure that I distribution is applicable: build a histogram with the bin values, for example, $100, $200, $300, $400, and $500, and check whether it is approximately symmetric and bell-shaped. Then, use Descriptive Statistics function from Data Analysis. Constructing confidence intervals, please round values to two decimal places.

Answer 1

Confidence Level(95.0%) E F H M N 2. 3 4 Column 1 6 8 9 10 11 12 13 Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count Confidence Level(95.0%) Dental Amount 192.75 2 192.75 3 350.25 4 200 225 6 95 7 375.5 8 380 9 192.75 10 400 11 230 12 245 13 150 14 250 15 250 16 340 17 225.5 18 156.25 19 300 20 350 21 435 22 192.75 23 192.75 24 250 25 225 266.305 14.5226 250 250 102.69 10545.3 9.06388 2.21503 655 95 750 13315.3 50 29.1842 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 חבר Sheet1 AVERAGE 1 COUNT

153 E F H к M N 27 28 29 30 31 32 33 34 35 36 37 38 39 40 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 G 250 225 230 245 250 250 250 350 98 405 295 205 230 245 750 250 250 340 225.5 192.75 192.75 250 225 350 250 250 340 41 42 43 Mean Confidence Level(95.0%) 266.305 29.1842 44 45 46 lower confidence upper confidence 237.121 295.489 47 44 48 49 50 51 52 53 45 46 47 48 49 50 СА Sheet1 +

for further queries you can comment me in comment section..

Thanks ..