MIS771 Descriptive Analytics Assignment Sample
Here’s the best sample of MIS771 Descriptive Analytics Assignment, written by the expert.
Introduction
The UnitedHealth Group: America’s most prominent health insurance provider provides data related to claim payment amounts, presiding physician and the claimant. The main purpose of analysis is to develop understanding of the claims paid out for medical malpractice lawsuits with focus on sample of 200. In addition, it also provides descriptive and inferential analyses and produces a report based on the findings. This report will be categorized into four sections. First section will provide summary of claim payment amount and second section will provide information on average age of claimants and the proportion of claimants with no insurance. Third section will examine the claims made by the industry reports on the drop of the average amount of paid claims below $77500 and difference in proportion of ‘MILD’ or ‘MEDIUM’ claims based on gender and the average claim amount with the involvement of a private attorney and no private attorney. It also determines claim related to lower percentage of ‘SEVERE’ claims with the involvement of an Orthopaedic surgeon than that of other specialists. In final section, it provides conclusion and limitations of the study.
Summary of claim payment amount
From data analysis, it can be determined that the average claim payment amount is $73457 for the sample of 200. The range of claim payment amount is between $1547 and $228725. It shows that the claim payment differs for the claimants with a large difference. Total value of the claim payment amount is $14,691,499. The value of standard deviation and sample variance is so high implies a large deviation of the data to the mean of this data set. It means there are large difference between the average value and the different data points. Some of the claimants get little amount while some of them get big amount of claim. In addition, Kurtosis and Skewness are highly positive indicating that data distribution of claim payment amount is asymmetrical due to high Skewness. Positive or right skewed distributions show that many people are getting relatively little while increasingly few people are getting big amount of claim.
a) The average Age of claimants
Based on analysis, it can be determined that the average age of claimants is 44.49 years. However the lower limit of average age of claimants is 42 years while upper limit of average age is 47 years.
b) The proportion of claimants with ‘No Insurance’.
The analysis suggests that the proportion of claimants with no insurance is between 5.03% and 12.97%. It means there are more claimants with Medicare/Medicaid, private, unknown and workers compensation. One of the factors that can be considered in the profile of claimant for the medical malpractice insurance claims is income level. Income level of the claimants may influence the premium value of the insurance claim. At the same time, it can be possible to determine the relationship between the income level and claim amount. In addition, education can be significant factor in the profile of claimant to determine the awareness of the claimant about the medical malpractice and related aspects. It is because there is a significant relationship between the claimants’ factors with malpractice intentions including education, being affluence and gender and age. Moreover, type of patient (in- versus out-patient) is also a considerable factor that could be effective in valuing the medical malpractice insurance claims.
a) An industry report suggests that the average amount of paid claims has dropped below $77,500. Is there any evidence to support this argument?
From ANOVA test, it can be determined that the average amount of paid claims has dropped below $77,500. It is because the most malpractice claims are settled out of the court and payments for the claims judged in the court are lower than those settled out of court.
b) A similar study last year reported that 3 out of 4 claims are with either ‘MILD’ or ‘MEDIUM’ severity conditions. Check if this statement is still valid for all patients?
From the Hypothesis test, it can be determined that the null hypothesis is ≤ 75% and alternative hypothesis is > 75%. It shows that 3 out of 4 claims are with either MILD or MEDIUM severity conditions so it fails to reject the null hypothesis as well as the statement are still valid for all patients.
c) Is there a difference in proportion of ‘MILD’ or ‘MEDIUM’ claims by patient’s Gender?
From the hypothesis test, it is determined that ‘t value’ is 0.0627 that is more than 0.05. So, there is no difference in the Gender. It can be said that the Confidence Interval for µ1 – µ2 has no difference in the hypothesis testing. At the same time, the level of confidence is 5% and intermediate calculations shows that standard error of the mean is 0.0688. So, the MILD or MEDIUM claims by patient’s Gender has no difference in the proportion.
Can we conclude that there is a difference in the proportion of ‘MILD’ or ‘MEDIUM’ claims by female patients compared to that of male patients?
From the hypothesis test, it can be determined that ‘t value’ is 0.0628 that is more than 0.05. So, it can be concluded that there is no difference in the proportion of ‘MILD’ or ‘MEDIUM’ claims. In this hypothesis test, the confidence Interval for µ1 – µ2 has no difference in the proportion of MILD or MEDIUM claims by the comparison of female patients to male patients.
d) As an industry standard, it is believed that the payment amounts are related to whether or not a private attorney represented the claimant. In particular, the average claim amount when a private attorney is involved is higher than when there is no private attorney involved. Does the data support this proposition?
According to the hypothesis test, it can be determined that null hypothesis (µ1 – µ2) is equals to zero but the alternative hypothesis is not equals to zero. It shows that that the null hypothesis is rejected so it can be said that the average claim amount is higher when a private attorney is involved as comparison than there is no private attorney involved. In addition, it is determined that the data supports this proposition that the payment amounts are related to private attorney represented the claimant or not.
e) Also, the industry stakeholders believe that private attorney representation is higher for ‘SEVERE’ claims than for claims with a ‘MEDIUM’ severity. Is this a valid statement?
From the hypothesis test, it can be determined that private attorney representation is not higher for SEVERE claims than for claims with a MEDIUM severity. The above statement is not valid as per the hypotheses test because this test failed to reject null hypothesis. So, believes of the industry stakeholders are not valid and the private attorney representation is not higher.
a) I believe that the percentage of ‘SEVERE’ claims with the involvement of an Orthopaedic surgeon is lower than that of other specialists.
From the hypothesis test, it can be determined that the percentage of SEVERE claims with the involvement of an Orthopaedic surgeon is not lower than other specialists. It is because the hypothesis shows that confidence Interval for π1 – π2 is repenting negative interval limits with 4.24% standard errors.
b) I also believe that the average claim amount for ‘SEVERE’ claims is higher when an Orthopaedic surgeon is involved than the other specialisations. Is there any evidence to support my assertions above?
In addition, the hypothesis test determined that the average claim amount for SEVERE is higher not higher when Orthopaedic surgeons are involved than other specializations. There is evidence which can support that the average claim amount for ‘SEVERE’ claims is higher in Orthopaedic surgeon than other specializations.
Conclusion
On the basis of the above analysis, it can be stated that the average age of claimants are 44.49 years. As well as, it is also concluded that the average amount of paid claims are below $77,500 with 3 out of 4 claims are with MILD and MEDIUM severity conditions. Additionally, both male and female has their proportion in ‘MILD’ or ‘MEDIUM’ claims.
Research Limitations
In this research study, researcher used primary data for collecting or gathering a relevant and accurate data efficiently. In respect to this, researcher selected sample size 200 for collecting a primary data in order to analysis the different views and opinions towards the research topic.
At the same time, researcher has an opportunity to use the secondary data in an efficient manner by collection more information and data from different online and offline sources such as books, newspaper, online blogs, and magazines and so on. On the other hand, this research study can also be used as secondary data for conduction further study on such related topic efficiently in future. This study used quantitative data by conducting a proper survey such as questionnaire efficiently for collecting a data from the selected sample size that is also a limitation regarding data collection method. For collecting a qualitative data, interview can also be conducted by the researcher in order to enhance the efficiency of the research.
References
Bruckman, L.S., Wheeler, N.R., Ma, J., Wang, E., Wang, C.K., Chou, I., Sun, J. and French, R.H., 2013. Statistical and domain analytics applied to PV module lifetime and degradation science. IEEE Access, 1, pp.384-403.
Raghupathi, W. and Raghupathi, V., 2014. Big data analytics in healthcare: promise and potential. Health information science and systems, 2(1), p.3.
Wheeler, D., Shaw, G. and Barr, S., 2013. Statistical techniques in geographical analysis. USA: Routledge.
Zhang, C. and Ré, C., 2014. Dimmwitted: A study of main-memory statistical analytics. Proceedings of the VLDB Endowment, 7(12), pp.1283-1294.
Appendix
Exhibit 1: Summary of claim payment amount
Claim payment amount | |
Mean | 73457 |
Standard Error | 2275 |
Median | 72571 |
Mode | 5400 |
Standard Deviation | 32179 |
Sample Variance | 1035455635 |
Kurtosis | 6 |
Skewness | 1.15 |
Range | 227178 |
Minimum | 1547 |
Maximum | 228725 |
Sum | 14691499 |
Count | 200 |
Exhibit 2: The average Age of claimants
Confidence Interval for mean | |
Data | |
Sample Standard Deviation | 17.69166 |
Sample Mean | 44.49 |
Sample Size | 200 |
Confidence Level | 95% |
Intermediate Calculations | |
Standard Error of the Mean | 1.2510 |
Degrees of Freedom | 199 |
t Value | 1.9720 |
Margin of Error | 2.4669 |
Confidence Interval | |
Interval Lower Limit | 42.02 |
Interval Upper Limit | 46.96 |
Exhibit 3: Proportion of claimants with ‘No Insurance’.
Confidence Interval for proportion | |
Data | |
Sample Size | 200 |
Count of Successes | 18 |
Confidence Level | 95% |
Intermediate Calculations | |
Sample Proportion | 0.09 |
Z Value | 1.9600 |
Standard Error of the Proportion | 0.020236 |
Margin of Error | 0.0397 |
Confidence Interval | |
Interval Lower Limit | 5.03% |
Interval Upper Limit | 12.97% |
Exhibit 4: Hypothesis test
Hypothesis Test for µ | |||
Hypotheses | |||
Null Hypothesis | µ | ≥ | 77500 |
Alternative Hypothesis | µ | < | 77500 |
Test Type | Lower | ||
Level of significance | |||
α | 0.05 | ||
Critical Region | |||
Degrees of Freedom | 199 | ||
Critical Value | -1.6525 | ||
Sample Data | |||
Sample Standard Deviation | 32178.49647 | ||
Sample Mean | 73457.49355 | ||
Sample Size | 200 | ||
Standard Error of the Mean | 2275.3633 | ||
t Sample Statistic | -1.7766 | ||
p-value | 0.0386 | ||
Decision | |||
Reject Null Hypothesis |
Exhibit 5: Check if this statement is still valid for all patients?
Hypothesis Test for π | |||
Hypotheses | |||
Null Hypothesis | π | ≤ | 75% |
Alternative Hypothesis | π | > | 75% |
Test Type | Upper | ||
Level of significance | |||
α | 0.05 | ||
Critical Region | |||
Critical Value | 1.6449 | ||
Sample Data | |||
Sample Size | 200 | ||
Count of ‘Successes’ | 154 | ||
Sample proportion, p | 77.00% | ||
Standard Error | 3.06% | ||
z Sample Statistic | 0.6532 | ||
p-value | 0.2568 | ||
Exhibit 6: Is there a difference in proportion of ‘MILD’ or ‘MEDIUM’ claims by patient’s Gender?
Confidence Interval for µ1 – µ2 (independent, equal variances) | |
Level of Confidence | |
Level of Confidence | 5% |
Sample Results | |
Sample 1 Data | |
Sample Standard Deviation | 0.8399 |
Sample Mean | 1.59 |
Sample Size | 200 |
Sample 2 Data | |
Sample Standard Deviation | 0.4901 |
Sample Mean | 1.605 |
Sample Size | 200 |
Intermediate Calculations | |
Degrees of Freedom | 398 |
Pooled Variance | 0.47 |
Standard Error of the Mean | 0.0688 |
t value | 0.0627 |
Confidence Interval for µ1 – µ2 | |
Interval Lower Limit | -0.02 |
Interval Upper Limit | -0.01 |
Exhibit 7: Difference in the proportion of ‘MILD’ or ‘MEDIUM’ claims by female patients compared to that of male patients
Confidence Interval for µ1 – µ2 (independent, unequal variances) | ||
Level of Confidence | ||
Level of Confidence | 5% | |
Sample Results | ||
Sample 1 Data | ||
Sample Standard Deviation | 0.839897 | |
Sample Mean | 1.59 | |
Sample Size | 200 | |
Sample 2 Data | ||
Sample Standard Deviation | 0.490077 | |
Sample Mean | 1.605 | |
Sample Size | 200 | |
Intermediate Calculations | ||
Degrees of Freedom | 320 | |
Standard Error of the Mean | 0.0688 | |
t value | 0.0628 | |
Confidence Interval for µ1 – µ2 | ||
Interval Lower Limit | -0.02 | |
Interval Upper Limit | -0.01 |
Exhibit 8: Does the data support this proposition?
Hypothesis Test for µ1 – µ2 (independent, equal variances) | |||
Hypotheses | |||
Null Hypothesis | µ1 – µ2 | = | 0 |
Alternative Hypothesis | µ1 – µ2 | ≠ | 0 |
Test Type | Two | ||
Level of significance | |||
α | 0.05 | ||
Critical Region | |||
Degrees of Freedom | 398 | ||
Lower Critical Value | -1.9659 | ||
Upper Critical Value | 1.9659 | ||
Sample Results | |||
Sample 1 Data | |||
Sample Standard Deviation | 32178.50 | ||
Sample Mean | 73457.49 | ||
Sample Size | 200 | ||
Sample 2 Data | |||
Sample Standard Deviation | 0.47 | ||
Sample Mean | 1.32 | ||
Sample Size | 200 | ||
Pooled Variance | 517727817.61 | ||
Standard Error of the Mean | 2275.3633 | ||
t Sample Statistic | 32.2833 | ||
p-value | 0.0000 | ||
Decision | |||
Reject Null Hypothesis |
Exhibit 9: Is this a valid statement?
Hypothesis Test for µ1 – µ2 (independent, unequal variances) | ||||
Hypotheses | ||||
Null Hypothesis | µ1 – µ2 | = | 0 | |
Alternative Hypothesis | µ1 – µ2 | ≠ | 0 | |
Test Type | Two | |||
Level of significance | ||||
α | ||||
Critical Region | ||||
Degrees of Freedom | 310 | |||
Lower Critical Value | -10000000.0000 | |||
Upper Critical Value | 10000000.0000 | |||
Sample Results | ||||
Sample 1 Data | ||||
Sample Standard Deviation | 0.84 | |||
Sample Mean | 1.59 | |||
Sample Size | 200 | |||
Sample 2 Data | ||||
Sample Standard Deviation | 0.47 | |||
Sample Mean | 1.32 | |||
Sample Size | 200 | |||
Standard Error of the Mean | 0.0679 | |||
t Sample Statistic | 4.0496 | |||
p-value | 0.0001 | |||
Decision | ||||
Fail to reject Null Hypothesis |
Exhibit 10: The percentage of ‘SEVERE’ claims with the involvement of an Orthopaedic surgeon is lower than that of other specialists.
Confidence Interval for π1 – π2 | |||
Level of Confidence | |||
Level of Confidence | 5% | ||
Sample Results | |||
Sample 1 Data | |||
Sample Size | 200 | ||
Count of ‘Successes’ | 46 | ||
Sample proportion, p1 | 23.00% | ||
Sample 2 Data | |||
Sample Size | 200 | ||
Count of ‘Successes’ | 48 | ||
Sample proportion, p2 | 24.00% | ||
Intermediate Calculations | |||
Pooled estimate of proportion | 23.50% | ||
Standard Error | 4.24% | ||
z value | 0.0627 | ||
Confidence Interval for π1 – π2 | |||
Interval Lower Limit | -1.27% | ||
Interval Upper Limit | -0.73% | ||
Exhibit 11: Is there any evidence to support my assertions above?
Confidence Interval for µ1 – µ2 (Dependent) | |
Level of Confidence | |
Confidence Level | 5% |
Sample Data | |
Sample Standard Deviation of Differences | 7036.444771 |
Sample Mean of Differences | 10478.06 |
Sample Size | 200 |
Intermediate Calculations | |
Standard Error of the Mean Differences | 497.5518 |
Degrees of Freedom | 199 |
t Value | 0.0628 |
Margin of Error | 31.2392 |
Confidence Interval | |
Interval Lower Limit | 10446.82 |
Interval Upper Limit | 10509.30 |
________________________________________________________________________________
Know more about UniqueSubmission’s other writing services: