# New health care program in the United States

Details:

For the following assignment, use the Rank Correlation Utilizing Excel

Use a rank correlation coefficient to test for a correlation between two variables.

Use a significance level of α=0.05.

x (cigarettes per day) 60 10 4 15 10 1 20 8 7 10 10 20

y(cotinine) 179 283 75.6 174 209 9.51 350 1.85 43.4 25.1 408 344

The new health care program in the United States makes provisions for capitation programs where health care insurers work with clinical facilities to perform risk analysis of patients to determine the cost of providing care. The following assignment might be used to assess how much a person smokes.

In a 500 words answer the following questions

• use the Rank Correlation Utilizing Excel Pearson or Spearman

• Is there a significant linear correlation?

• How would you measure the cotinine level in the body? Explain the result.

• Which one is a non-parametric test?

• Minimum two reference

What are the results, what do the results mean for this specific topic, then what those results might mean for the big picture?

REPORT HOW TO: For the statistical assignment

You will obtain your numerical answer using Excel and then compare and interpret the results in text format. This is expected to be a minimum of 500 words, references and solid academic writing.

HOW TO: Imagine that you are working in a public health facility and you have been asked to analyze this data for someone. What does it MEAN? What can you tell your supervisor about what this data means about.

DO NOT include any figures or tables... only sentences and paragraphs with citations/references.

This report IS NOT about how you did your homework assignment.

NOTE: Only the interval numbers should be stated in your report... do not state any other numbers that come from your results in Excel... the only exception would be if you wanted to include mean and standard deviation. Not including the relevant numbers and explaining what they mean or including numbers other than the ones approved will result in a lower score.

NOTE: Only the Test statistic and P-value should be stated in your report... do not state any other numbers that come from your results in Excel. Not including the relevant numbers and explaining what they mean or including numbers other than the ones approved will result in a lower score.

https://brainmass.com/statistics/data-collection/new-health-care-program-united-states-611786

#### Solution Preview

The response addresses the query posted in 646 words with APA references

//Spearman's rank correlation has a great significance for the non-normal data. This correlation is used in the case of the outliers present in the data set and for calculating the association between such two random variables. The rank correlation is used for the given data set, that is, the association between the X (cigarette per day) and Y (cotinine) in the below section. //

The given case provides an overview of the new health care program in the United States that makes provisions for capitation programs where health care insurers work with clinical facilities to perform risk analysis of patients to determine the cost of providing care. The answers in the below section will be helpful to assess how much a person smokes.

Rank correlation

Rank correlation is the statistical method used for the purpose of calculating the strength of the relationship between the two variables or two sets of ...

#### Solution Summary

The expert examines the new health care programs in the United States. The response addresses the query posted in 646 words with APA references.