STA 3215 Rasmussen University NCLEX Memorial Hospital PPT

User Generated

noolwrna14

Business Finance

STA 3215

Rasmussen University

STA

Description

Instructions

You are currently working at NCLEX Memorial Hospital in the Infectious Diseases Unit. Over the past few days, you have noticed an increase in patients admitted with a particular infectious disease. You believe that the ages of these patients play a critical role in the method used to treat the patients. You decide to speak to your manager, and together you work to use statistical analysis to look more closely at the ages of these patients.

You do some research and put together a spreadsheet of the data that contains the following information

  • Client number
  • Infection disease status
  • Age of the patient

Deliverable 7 - Statistical Analysis Report.xlsx

You are to put together a PowerPoint presentation that explains the analysis of your findings which you will submit to your manager. The presentation should contain all components of your findings. For review, the components of the report should include:

  1. Brief overview of the scenario and variables in the data set
  2. Discussion, calculation, and interpretation of the mean, median, mode, range, standard deviation, and variance
  3. Discussion, construction, and interpretation of the 95% confidence interval
  4. Explanation of the full hypothesis test
  5. Conclusion

The calculations should be performed in your spreadsheet that you will also submit to your manager. You can find additional information on what to add to your PowerPoint presentation in this Word document. 

Deliverable 7 - PowerPoint Instructions.docx

Use the questions in the worksheet as your guide for the contents of your presentation.

Unformatted Attachment Preview

Patient # Infectious Disease 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Age 70 41 58 58 45 59 71 71 72 67 60 65 73 73 42 45 65 66 44 51 71 66 84 56 61 59 68 73 50 55 77 57 48 71 58 49 65 60 44 61 57 63 61 60 62 *Note: Refer to the Word document in th Slide 6: Find the following statistical calcu Age Calculations Mean Median Mode Midrange Range Variance Standard Deviation Maximum Minimum Slide 8: Construct a 95% σ is unknown. Critical Value Margin of Error Lower Limit Upper Limit Slide 9, 10, 11: Perform the following hyp infectious diseases is less than 64 years o Test Statistic Critical Value P-value 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes 55 66 50 77 66 69 65 57 69 59 70 53 76 75 68 55 61 81 48 67 59 83 69 68 75 fer to the Word document in the deliverable instructions for a breakdown of requirements for each slide. nd the following statistical calculations. In your PPT, include your interpretation of the calculations and the correct units. Formulas/Answers 95% confidence interval for the population mean ages of the patients. Assume that your data is normally distributed and Perform the following hypothesis test based on the claim that the average age of all patients admitted to the hospital with diseases is less than 64 years of age. lly distributed and he hospital with Deliverable 07 Worksheet Scenario You are currently working at NCLEX Memorial Hospital in the Infectious Diseases Unit. Over the past few days, you have noticed an increase in patients admitted with a particular infectious disease. You believe that the ages of these patients play a critical role in the method used to treat the patients. You decide to speak to your manager, and together you work to use statistical analysis to look more closely at the ages of these patients. You do some research and put together a spreadsheet of the data that contains the following information: ● ● ● Client number Infection disease status Age of the patient You need the preliminary findings immediately so that you can start treating these patients. So, let’s get to work! Background information on the Data: The data set consists of 70 patients that have the infectious disease with ages ranging from 41 years of age to 84 years of age for NCLEX Memorial Hospital. Requirements: 1) Answer the questions below in a PowerPoint presentation. 2) Include the summary calculations and the formulas in your slides either symbolically or from Excel. Do not round your results. 3) Show calculations in your Excel spreadsheet. Submit both the PowerPoint and Excel files. PowerPoint Presentation Requirements Slide 1 Title Slide Title Slide 2 Provide a brief overview of the scenario you are given above and the data set Overview that you will be analyzing. Slide 3 Classify the variables in your data set. Classification • Which variables are quantitative/qualitative? • Which variables are discrete/continuous? • Describe the level of measurement for each variable included in the data set (nominal, ordinal, interval, ratio) Slide 4 What are the measures of center and why are they important? Describe each Measures of Center Slide 5 Measures of Variation individually and list any advantages or disadvantages that each may have. Slide 6 Calculations Show your results for the following calculations. Include formulas used in Excel. Interpret your results in the context of the scenario and include units of measurement for each. • Mean • Median • Mode • Mid-range • Range • Variance • Standard Deviation Slide 7 Confidence Intervals Show your responses for the follow questions: • What are confidence intervals? • What is a point estimate? • What is the best point estimate for a population mean? Explain. • Why do we need confidence intervals? Slide 8 Confidence Intervals Construct a 95% confidence interval for the population mean ages of the patients. Assume that your data is normally distributed and σ is unknown. What are the measures of variation and why are they important? Describe each individually and list any advantages or disadvantages that each may have. Show results for the following calculations in constructing the confidence interval. Include formulas used in Excel. Interpret the confidence interval. • Critical Value • Margin of Error • Upper and Lower Bounds Slide 9 Hypothesis Testing Perform the following hypothesis test based on the claim that the average age of all patients admitted to the hospital with infectious diseases is less than 64 years of age. Write the null and alternative hypothesis symbolically and include the following additional information: • Which hypothesis is the claim? • Is the test two-tailed, left-tailed, or right-tailed? Explain • Which test statistic will you use for your hypothesis test, z-test or ttest? Explain. Slide 10 Hypothesis Testing Continue the hypothesis test based on the claim that the average age of all patients admitted to the hospital with infectious diseases is less than 64 years of age. Show your results and formulas used for the following calculations: • Test Statistic • Critical Value • P-value Slide 11 Hypothesis Testing Complete the hypothesis test by explaining the following: • Decision to reject the null hypothesis or to not reject the null hypothesis. • Explain your decision using the critical value method. • Explain your reasoning using the P-value method. • Restate your conclusion in non-technical terms. Slide 12 Conclusion Conclude by recapping your ideas by summarizing the information presented in context of the scenario. • Include the mean, standard deviation, confidence interval with interpretation, and result of the hypothesis test. • What conclusions, if any, do you believe we can draw as a result of your study? • What did you learn from the project about the population based on this sample? • What did you learn about the specific statistical tests you conducted?
Purchase answer to see full attachment
Explanation & Answer:
7 Slides
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

View attached explanation and answer. Let me know if you have any questions.

Patient #

Infectious Disease

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45

Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes

Age

dummy age
70
41
58
58
45
59
71
71
72
67
60
65
73
73
42
45
65
66
44
51
71
66
84
56
61
59
68
73
50
55
77
57
48
71
58
49
65
60
44
61
57
63
61
60
62

0
0

*Note: Refer ...


Anonymous
Really helpful material, saved me a great deal of time.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags