1. Statistics
2. Correlation and Regression Analysis
3. Regression Analysis
4. 324426

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

Select the appropriate statistical test that allows you to conduct an analysis of the factors affecting hospital costs. You will have to select the correct statistical test and conduct that test in Excel.

1. Analyze your data and produce a summary describing the major findings of your analysis.

2. The variables that most affect hospital cost.

3. An overview of the P and F values in your Excel tables.

4. A discussion of the degrees of freedom and the sample size.

5. Discuss any significant relationships that present themselves in the Excel files produced from your statistical analysis
please be as detailed as possible.