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 2021. 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 52 dental claims submitted to Healthy Life. The amounts covered by insurance you can see below. Please help Jennifer Nguyen to construct 90%, 95%, and 99% confidence intervals for the true average reimbursement. Make sure that t-distribution is applicable: build a histogram with the given 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 at least two decimal places. (Use Data Analysis → Histogram, and Data Analysis → Descriptive Statistics) Dental Claim Number Amount Covered 1 $192.75 2 $192.75 3 $350.25 4 $200.00 5 $225.00 6 $95.00 7 $375.50 8 $380.00 9 $192.75 10 $400.00 11 $230.00 12 $245.00 13 $150.00 14 $250.00 15 $250.00 16 $340.00 17 $225.50 18 $156.25 19 $300.00 20 $350.00 21 $435.00 22 $192.75 23 $192.75 24 $250.00 25 $225.00 26 $390.00 27 $190.00 28 $250.00 29 $250.00 30 $250.00 31 $350.00 32 $98.00 33 $405.00 34 $295.00 35 $205.00 36 $230.00 37 $245.00 38 $950.00 39 $250.00 40 $250.00 41 $340.00 42 $225.50 43 $192.75 44 $192.75 45 $250.00 46 $225.00 47 $350.00 48 $250.00 49 $250.00 50 $340.00 51 $299.00 52 $285.00 Bin $100 $200 $300 $400 $500
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 2021. As Healthy Life has many thousands of clients it is virtually impossible to calculate the population mean. Using the Excel Random Number Generator
Please help Jennifer Nguyen to construct 90%, 95%, and 99% confidence intervals for the true average reimbursement. Make sure that t-distribution is applicable: build a histogram with the given bin values, for example, $100, $200, $300, $400, and $500, and check whether it is approximately symmetric and bell-shaped. Then, use
(Use Data Analysis → Histogram, and Data Analysis → Descriptive Statistics)
Dental Claim Number | Amount Covered |
1 | $192.75 |
2 | $192.75 |
3 | $350.25 |
4 | $200.00 |
5 | $225.00 |
6 | $95.00 |
7 | $375.50 |
8 | $380.00 |
9 | $192.75 |
10 | $400.00 |
11 | $230.00 |
12 | $245.00 |
13 | $150.00 |
14 | $250.00 |
15 | $250.00 |
16 | $340.00 |
17 | $225.50 |
18 | $156.25 |
19 | $300.00 |
20 | $350.00 |
21 | $435.00 |
22 | $192.75 |
23 | $192.75 |
24 | $250.00 |
25 | $225.00 |
26 | $390.00 |
27 | $190.00 |
28 | $250.00 |
29 | $250.00 |
30 | $250.00 |
31 | $350.00 |
32 | $98.00 |
33 | $405.00 |
34 | $295.00 |
35 | $205.00 |
36 | $230.00 |
37 | $245.00 |
38 | $950.00 |
39 | $250.00 |
40 | $250.00 |
41 | $340.00 |
42 | $225.50 |
43 | $192.75 |
44 | $192.75 |
45 | $250.00 |
46 | $225.00 |
47 | $350.00 |
48 | $250.00 |
49 | $250.00 |
50 | $340.00 |
51 | $299.00 |
52 | $285.00 |
Bin |
$100 |
$200 |
$300 |
$400 |
$500 |
Step by step
Solved in 4 steps with 2 images