23 Feb Variables can be measured as categories (nominal or ordinal) or on a continuous range of scores (interval or ratio). For each of the variables in the CHF data set, Create a table and indicat
health & medical spreadsheet and need an explanation and answer to help me learn.
Prior to beginning work on this assignment,
Review Chapter 6 of A Practical Approach to Analyzing Healthcare Data.
Complete the following analysis of the CHF data set Download CHF data set.
Variable Types
Variables can be measured as categories (nominal or ordinal) or on a continuous range of scores (interval or ratio). For each of the variables in the CHF data set,
Create a table and indicate if the variable is nominal, ordinal, ratio, or interval.
Descriptive Statistics
Using the formulas provided in the A Practical Approach to Analyzing Healthcare Data textbook or the Data Analytics Toolpak, for the admission source (admsrc), sex, discharge destination (dischdest), and patient age category (age),
Generate the following information for each of the following descriptive statistics:
Mean
Standard Error
Median
Mode
Standard Deviation
Sample Variance
Kurtosis
Skewness
Range
Minimum
Maximum
Sum
Count
Frequency Distribution
Create a frequency distribution table for the admission source that includes each of the following:
Gender
Discharge Status
Age Category
Number of Diagnosis Codes
Chi Squared Test of Independence
The chi-squared test of independence is a statistical test used to test if there is a relationship between categorical (categories) data. For additional assistance calculating chi-square, review the Chi-Square Help Download Chi-Square Helpresource.
Complete the following:
Determine if there is an association between sex and admission source from the CHD data set.
Create the null hypothesis that there is no association between the patient sex and admission source.
Create the alternative hypothesis that there is an association between the patient sex and admission source.
Calculate the p-value.
Excel has a function called CHISQ.test to compute the probability of a particular chi-square value. Using the CHF data for sex and admission source, select a cell into which you want to enter the CHIQ.TEST function. Click on Formulas,? More functions,? Statistical menu option? and scroll down to select CHISQ.TEST.? Enter the sex range of values in the actual-range box. Enter the admission source range of values in the expected -range box. Click OK to calculate the p-value.
Indicate whether you are rejecting or accepting the null hypothesis.
A chi-square test will give you a p-value. The p-value will tell you if your test results are significant or not. A p-value of 0.05 is 5%. Small p-values, generally under 5%, usually mean you should reject the null hypothesis.
Requirements: As needed
