Question

In: Statistics and Probability

The following data are claims (in $millions) for Blue cross Blue shield benefits benefits for nine...

  1. The following data are claims (in $millions) for Blue cross Blue shield benefits benefits for nine states, along with the surplus (in $millions) that the company had in assets in those states.

State                  Claims          Surplus

Alabama               1425              277

Colorado                 273              100

Florida                   915             120

Illinois                  1687              259

Maine                     234                40

Montana                 142                25

North Dakota          259               57

Oklahoma               258               31

Texas                       894             141

Use the data to compute a correlation coefficient, to determine the correlation   between claims and surplus. Interpret the results accordingly explain all variables under study along with their significance. Further explain entire concept of Correlation using 5 real life situations which explains the concept of correlation in detail. Make use of appropriate reference and enrich your literature review appropriately

Solutions

Expert Solution

Let X : Claims

And Y : surplus

The following calculations are needed to compute the correlation coefficient:

X Y X*Y X2 Y2
1425 277 394725 2030625 76729
273 100 27300 74529 10000
915 120 109800 837225 14400
1687 259 436933 2845969 67081
234 40 9360 54756 1600
142 25 3550 20164 625
259 57 14763 67081 3249
258 31 7998 66564 961
894 141 126054 799236 19881
Sum = 6087 1050 1130483 6796149 194526

The correlation coefficient rr is computed using the following expression:

where

In this case, based on the data provided, we get that,

Therefore, based on this information, the sample correlation coefficient is computed as follows

Which indicates that there is a high degree correlation between the claims and surplus.

Following are the properties of correlation coefficient:

  1. Limit: Coefficient values can range from +1 to -1, where +1 indicates a perfect positive relationship, -1 indicates a perfect negative relationship, and a 0 indicates no relationship exists..
  2. Pure number: It is independent of the unit of measurement. For example, if one variable’s unit of measurement is in inches and the second variable is in quintals, even then, Pearson’s correlation coefficient value does not change.
  3. Symmetric: Correlation of the coefficient between two variables is symmetric. This means between X and Y or Y and X, the coefficient value of will remain the same.

Degree of correlation:

  1. Perfect: If the value is near ± 1, then it said to be a perfect correlation: as one variable increases, the other variable tends to also increase (if positive) or decrease (if negative).
  2. High degree: If the coefficient value lies between ± 0.50 and ± 1, then it is said to be a strong correlation.
  3. Moderate degree: If the value lies between ± 0.30 and ± 0.49, then it is said to be a medium correlation.
  4. Low degree: When the value lies below + .29, then it is said to be a small correlation.
  5. No correlation: When the value is zero.

Positive Correlation

A positive correlation is a relationship between two variables where if one variable increases, the other one also increases. A positive correlation also exists in one decreases and the other also decreases.

Examples of Positive Correlations

  • The more time you spend running on a treadmill, the more calories you will burn.

  • Taller people have larger shoe sizes and shorter people have smaller shoe sizes.

  • The longer your hair grows, the more shampoo you will need.

  • The less time I spend marketing my business, the fewer new customers I will have.

  • The more hours you spend in direct sunlight, the more severe your sunburn.

  • The more money she saves, the more financially secure she feels.

  • As the temperature goes up, ice cream sales also go up.

A negative correlation means that there is an inverse relationship between two variables - when one variable decreases, the other increases. The vice versa is a negative correlation too, in which one variable increases and the other decreases. These correlations are studied in statistics as a means of determining the relationship between two variables.

Common Examples of Negative Correlation

  • A student who has many absences has a decrease in grades.

  • As weather gets colder, air conditioning costs decrease.

  • If a train increases speed, the length of time to get to the final point decreases.

  • If a chicken increases in age, the amount of eggs it produces decreases.

No correlation examples:

For example, the relationship between intelligence quotient and weight of a person.

In that case correlation coefficient is zero.


Related Solutions

[Red Cross Red Shield] The distribution of the amount paid in health claims by Red Cross...
[Red Cross Red Shield] The distribution of the amount paid in health claims by Red Cross Red Shield (RCRS), a medical insurance company, on individual health insurance plans for college students has mean $500, median $400, and standard deviation $550. Consider the variation of the amount paid of a sample of 40 plan members. Do you think that the standard deviation of the sample mean of participants (Stdev[ ]) is smaller than, larger than, or equal to the standard deviation...
State and explain the three specific ethical finance issues regarding this situation Trigon Blue Cross/Blue Shield...
State and explain the three specific ethical finance issues regarding this situation Trigon Blue Cross/Blue Shield (Copayments) When most people are told they owe a coinsurance payment on a medical bill, they simply grimace and write a check; not Gerald Haeckel, a retiree from Richmond, Virginia. He wanted proof that he was not paying more than the 20 percent portion that his health insurance policy required. When his insurer, Trigon Blue Cross/Blue Shield, balked, the retiree besieged state and federal...
Kaiser Permanente: Best for Health Savings Account (HSA) Options Blue Cross Blue Shield: Best Large Provider...
Kaiser Permanente: Best for Health Savings Account (HSA) Options Blue Cross Blue Shield: Best Large Provider Network Unitedhealthcare: Best for Online Care Aetna: Best for Employer-Based Plans Cigna: Best for Telehealth Care HCSC: Best for Healthy Living Programs Molina Healthcare: Best for Preventive Care Many markets have at least some impediments that make it difficult for the competition to gain market share. Brand strength is a big one. Look at Blue Cross Blue Shield they continue to lead the health...
David had a grandfathered health insurance plan from Blue Shield of California.
Life and Health InsuranceDavid had a grandfathered health insurance plan from Blue Shield of California. He enrolled in the Savings 5200 (HSA Compatible) back in 2008 and been satisfied with the policy until the last couple years.When David called SPF Insurance on January 26, 2016 he explained that he had received a notice from Blue Shield telling him that the rate on his grandfathered plan was going up to a little over $900/mo. That was more than he could justify...
The following data show the annual revenue ($ millions) and the estimated team value ($ millions)...
The following data show the annual revenue ($ millions) and the estimated team value ($ millions) for the 30 Major League Baseball teams (Forbes website, January 16, 2014). Team Revenue ($ millions) Value ($ millions) Arizona Diamondbacks 195 584 Atlanta Braves 225 629 Baltimore Orioles 206 618 Boston Red Sox 336 1312 Chicago Cubs 274 1000 Chicago White Sox 216 692 Cincinnati Reds 202 546 Cleveland Indians 186 559 Colorado Rockies 199 537 Detroit Tigers 238 643 Houston Astros 196...
The following data show the annual revenue ($ millions) and the estimated team value ($ millions)...
The following data show the annual revenue ($ millions) and the estimated team value ($ millions) for the 30 Major League Baseball teams (Forbes website, January 16, 2014). Team Revenue ($ millions) Value ($ millions) Arizona Diamondbacks 195 584 Atlanta Braves 225 629 Baltimore Orioles 206 618 Boston Red Sox 336 1312 Chicago Cubs 274 1000 Chicago White Sox 216 692 Cincinnati Reds 202 546 Cleveland Indians 186 559 Colorado Rockies 199 537 Detroit Tigers 238 643 Houston Astros 196...
The following data show the annual revenue ($ millions) and the estimated team value ($ millions)...
The following data show the annual revenue ($ millions) and the estimated team value ($ millions) for the 30 Major League Baseball teams (Forbes website, January 16, 2014). Team Revenue ($ millions) Value ($ millions) Arizona Diamondbacks 195 584 Atlanta Braves 225 629 Baltimore Orioles 206 618 Boston Red Sox 336 1312 Chicago Cubs 274 1000 Chicago White Sox 216 692 Cincinnati Reds 202 546 Cleveland Indians 186 559 Colorado Rockies 199 537 Detroit Tigers 238 643 Houston Astros 196...
With the opening and growth of Florida Blue retail health insurance stores, marketers at Blue Cross...
With the opening and growth of Florida Blue retail health insurance stores, marketers at Blue Cross Blue Shield of Florida should anticipate... a. the centers losing their uniqueness as competitors copy the idea with centers of their own. b. brokers moving their business to other carriers in protest of the competition that these retail centers pose to them. c. positive publicity stemming from the uniqueness of buying health insurance at a retail "store." d. all of the above.
. You cross true breeding blue and red morning glories and get all blue offspring. a)...
. You cross true breeding blue and red morning glories and get all blue offspring. a) Based on this information alone:              i) How many loci are involved in the expression of this trait? How many alleles? What are the dominant and recessive interactions between the alleles at the locus/loci?              ii)what are the possible genotypes of the parents and F1s?              iii) Based on your hypothesized genotypes from ii, what do you expect the outcome of a cross between...
You cross true breeding blue and red morning glories and get all blue offspring. a) Based...
You cross true breeding blue and red morning glories and get all blue offspring. a) Based on this information alone: i) How many loci are involved in the expression of this trait? How many alleles? What are the dominant and recessive interactions between the alleles at the locus/loci? ii)what are the possible genotypes of the parents and F1s? iii) Based on your hypothesized genotypes from ii, what do you expect the outcome of a cross between the F1's to be?...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT