HLT 362V Week 5 Assignment, Correlation-Regression and Chi Square Excel Worksheet

HLT 362V Week 5 Assignment, Correlation-Regression and Chi Square Excel Worksheet

• Use the Excel Analysis ToolPak to find the linear correlation coefficient for the systolic and diastolic measurements.
• Use the Excel Analysis ToolPak to determine the linear regression equation that uses the systolic pressure to predict the diastolic pressure.
• What is the best predicted value for diastolic pressure given that a woman has a systolic level of 100?

HLT 362V Week 5 Workbook Exercise:

Exercise 14: Understanding Simple Linear Regression

1. According to the study narrative and Figure 1 in the Flannigan et al. (2014) study, does the APLS UK formulae under- or overestimate the weight of children younger than 1 year of age? Provide a rationale for your answer.
2. Using the values a = 3.161 and b = 0.502 with the novel formula in Figure 1, what is the … weight in kilograms (kg) for a child at 9 months of age? Show your calculations.
3. Using the values a = 3.161 and b = 0.502 with the novel formula in Figure 1, what is the … weight in kilograms for a child at 2 months of age? Show your calculations.
4. In Figure 2, the formula for calculating y (weight in kg) is Weight in kg = (0.176 × age in months) + 7.241. Identify the y intercept and the slope in this formula.
5. Using the values a = 7.241 and b = 0.176 with the novel formula in Figure 2, what is the … weight in kilograms for a child 3 years of age? Show your calculations.
6. Using the values a = 7.241 and b = 0.176 with the novel formula in Figure 2, what is the … weight in kilograms for a child 5 years of age? Show your calculations.
7. In Figure 3, some of the actual mean weights represented by the blue line with squares are above the dotted straight line for the novel formula, but others are below the straight line. Is this an expected finding? Provide a rationale for your answer.
8. In Figure 3, the novel formula is (Weight in kilograms = (0.331 × Age in months) – 6.868. What is the predicted weight in kilograms for a child 10 years old? Show your calculations.
9. Was the sample size of this study adequate for conducting simple linear regression? Provide a rationale for your answer.
10. Describe one potential clinical advantage and one potential clinical problem with using the three novel formulas presented in Figures 1, 2, and 3 in a PICU setting.

Exercise 19: Understanding Pearson Chi-Square

1. According to the relevant study results section of the Darling-Fisher et al. (2014) study, what categories are reported to be statistically significant?
2. What level of measurement is appropriate for calculating the χ2 statistic? Give two exam¬ples from Table 2 of demographic variables measured at the level appropriate for χ2.
3. What is the χ2 for U.S. practice region? Is the χ2 value statistically significant? Provide a rationale for your answer. X2= 29.68; p= <.00
4. What is the df for provider type? Provide a rationale for why the df for provider type pre¬sented in Table 2 is correct.
5. Is there a statistically significant difference for practice setting between the Rapid Assessment for Adolescent Preventive Services (RAAPS) users and nonusers? Provide a rationale for your answer.
6. State the null hypothesis for provider age in years for RAAPS users and RAAPS nonusers.
7. Should the null hypothesis for provider age in years developed for Question 6 be accepted or rejected? Provide a rationale for your answer.
8. Describe at least one clinical advantage and one clinical challenge of using RAAPS as described by Darling-Fisher et al. (2014).
9. How many null hypotheses are rejected in the Darling-Fisher et al. (2014) study for the results presented in Table 2? Provide a rationale for your answer.
10. A statistically significant difference is present between RAAPS users and RAAPS nonusers for U.S. practice region, χ2 = 29.68. Does the χ2 result provide the location of the difference? Provide a rationale for your answer.

Exercise 29: Calculating Simple Linear Regression

1. If you have access to SPSS, compute the Shapiro-Wilk test of normality for the variable age (as demonstrated in Exercise 26). If you do not have access to SPSS, plot the frequency distributions by hand. What do the results indicate?
2. State the null hypothesis where age at enrollment is used to predict the time for comple¬tion of an RN to BSN program.
3. What is b as computed by hand (or using SPSS)?
4. What is a as computed by hand (or using SPSS)?
5. Write the new regression equation.
6. How would you characterize the magnitude of the obtained R2 value? Provide a rationale for your answer.
7. How much variance in months to RN to BSN program completion is explained by knowing the student’s enrollment age?
8. What was the correlation between the actual y values and the predicted y values using the new regression equation in the example?
9. Write your interpretation of the results as you would in an APA-formatted journal.
10. Given the results of your analyses, would you use the calculated regression equation to predict future students’ program completion time by using enrollment age as x? Provide a rationale for your answer.

Exercise 35: Calculating Pearson Chi-Square

1. Do the example data in Table 35-2 meet the assumptions for the Pearson χ2 test? Provide a rationale for your answer.
2. 2. Compute the χ2 test. What is the χ2 value? 11.931
3. Is the χ2 significant at α =0.05? Specify how you arrived at your answer.
4. If using SPSS, what is the exact likelihood of obtaining the χ2 value at least as extreme as or as close to the one that was actually ….. assuming that the null hypothesis is true?
5. Using the numbers in the contingency table, calculate the percentage of antibiotic users who tested positive for candiduria.
6. Using the numbers in the contingency table, calculate the percentage of non-antibiotic users who tested negative for candiduria.
7. ………………..veterans with candiduria who had a history of antibiotic use.
8. Using the numbers in the contingency table, calculate the percentage of veterans with candiduria who had no history of antibiotic use.
9. Write your interpretation of the results as you would in an APA-formatted journal.
10. Was the sample size adequate to detect differences between the two groups in this example? Provide a rationale for your answer.

24/7 Nursing Homework Help

Stuck with your nursing assignment? From Essays to Complicated Dissertations? Our accredited nursing paper writers can answer it all!