Using the Excel Random Number Generator function, Jennifer
found a random sample of 50 dental claims submitted toHealthy 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 thatt- 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
Hi Please help me to build the histogram with bin values and make sure that it is it is approximately symmetric and bell-shaped
STAT 1112 Major Assignment Data Spring 2021 Q Search Sheet Home Insert Draw Page Layout Formulas Data Review View "+ Share ~ Connections XX Clear Show Detail ?- Properties Reapply Get External Refresh Sort Filter Text to Flash Remove Data Consolidate What-If Group Ungroup Subtotal = =Hide Detail Analysis Data Solve Data All Edit Links Advanced Columns Fill Duplicates Validation Analysis Tools Analysis E11 fx B C E G H K L M N O P Q R Dental Claim Number Amount Covered $192.75 $192.75 $350.25 $200.00 $225.00 $95.00 $375.50 $380.00 $192.75 $400.00 $230.00 $245.00 Histogram $150.00 $250.00 CONFIDENCE LEVEL 95% 1.5 7 $250.00 95% CONFIDENCE INTERVALS $340.00 Mean 266.31 Mean Frequency $225.50 Frequency Standard Error 14.5225955 0.5 Confidence Level(95.09 $156.25 Median 250 $300.00 Mode 250 Lower Higher Bin $350.00 Standard Deviation 102.69 237.12 $435.00 Sample Variance 10545.28901 $192.75 Kurtosi 9.063877842 $192.75 Skewness 2.215033968 $250.00 Rang $225.00 Minimum 95 $230.00 Maximum 750 $245.00 Sum 13315.25 $250.00 Count 50 $250.00 Confidence Level(95.0%) 29.18 $250.00 $350.00 $98.00 $405.00 $295.00 $205.00 $230.00 CONFIDENCE LEVEL 90% $245.00 90% CONFIDENCE INTERVALS $750.00 Mean 266.31 Mear 266.305 30 $250.00 Standard Error 14.5225955 Confidence Level(90.09 24.34787045 40 $250.00 Mediar 250 Lower Higher 41 $340.00 Mode 250 241.96 290.65 42 $225.50 Standard Deviation 102.69 43 $192.75 Sample Variance 10545.2890 $192.75 Kurtos 9.063877842 Problem 1 Problem 2. Problem Problem 4. Problem 5. Select destination and press ENTER or choose Paste 114%STAT 1112 Major Assignment Data Spring 2021 Q Search Sheet Home Insert Draw Page Layout Formulas Data Review View "+ Share ~ Connections XX Clear Show Detail ?- Properties Reapply Get External Refresh Sort Filter Text to Flash Remove Data Consolidate What-If Group Ungroup Subtotal = =Hide Detail Analysis Data Solve Data All Edit Links Advanced Columns Fill Duplicates Validation Analysis Tools Analysis E11 fx C E F G H K L M N 0 P Q R 10 $380.00 $192.75 10 $400.0 11 $230.00 $245.00 Histogram $150.00 $250.00 CONFIDENCE LEVEL 95% 1.5 15 $250.00 95% CONFIDENCE INTERVALS $340.00 266.31 Frequency Mear Mean $225.50 9 0.5 Frequency Standard Error 14.5225955 Confidence Level(95.09 $156.25 Median 250 $300.00 Mode 250 Lower Higher Bin $350.00 Standard Deviation 102.69 237.12 $435.00 Sample Variance 10545.28901 $192.75 Kurtosis 9.063877842 $192.75 Skewness 2.215033968 $250.00 Rang 655 $225.00 Minimum 95 $230.00 Maximum 750 $245.00 iSum 13315.25 $250.00 Count 50 $250.00 Confidence Level(95.0%) 29.18 $250.00 $350.00 $98.0 $405.00 $295.00 $205.00 $230.00 CONFIDENCE LEVEL 90% $245.00 90% CONFIDENCE INTERVALS $750.00 Mean 266.31 Mean 266.305 $250.00 Standard Error 14.5225955 Confidence Level(90.0 24.34787045 $250.00 Median 250 Lower Higher $340.00 Mode 250 241.96 290.65 $225.50 Standard Deviation 102.69 $192.75 Sample Variance 10545.28901 $192.75 Kurtosis 9.063877842 $250.00 Skewness 2.215033968 $225.00 Range 655 47 $350.00 Minimum 95 48 $250.00 Maximum 750 49 $250.00 Sum 13315.25 50 $340.00 Count 50 Confidence Level(90.0%) 4.35 E Problem 1. Problem 2. Problem 3. Problem 4. Problem 5. Select destination and press ENTER or choose Paste 114%
