STA3215CBE Section 01CBE Inferential Statistics and Analytics (11 Weeks) – CBE – 2022 Winter Quarter
Deliverable 7 – Statistical Analysis Report
Deliverable 7 – Statistical Analysis Report
Assignment Content
Competencies
Describe the data using the measures of central tendency and measures of variability.
Apply the normal distribution, standard normal distribution, and central limit theorem.
Develop a confidence interval for a population parameter.
Evaluate hypothesis tests for population parameters from one population.
Evaluate hypothesis tests for population parameters from two populations.
Determine the linear correlation and regression equation between two variables to make predictions for the dependent variable.
Student Success Criteria
View the grading rubric for this deliverable by selecting the “This item is graded with a rubric” link, which is located in the Details & Information pane.
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:
Brief overview of the scenario and variables in the data set
Discussion, calculation, and interpretation of the mean, median, mode, range, standard deviation, and variance
Discussion, construction, and interpretation of the 95% confidence interval
Explanation of the full hypothesis test
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 x
Use the questions in the worksheet as your guide for the contents of your presentation.
For your final deliverable, submit your PowerPoint presentation and the Excel workbook showing your work. Do not submit your Word document.
Deliverable07 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
Title Slide
Slide 2
Overview
Provide a brief overview of the scenario you are given above and the data set that you will be analyzing.
Slide 3
Classification
Classify the variables in your data set.
· 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
Measures of Center
What are the measures of center and why are they important? Describe each individually and list any advantages or disadvantages that each may have.
Slide 5
Measures of Variation
What are the measures of variation and why are they important? Describe each 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.
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 t-test? 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?
>Data and Calculations
0
1
Yes Yes Yes Yes Yes Yes Yes 73 Yes Yes 45 Yes 65 Yes Yes Yes Yes 71 Yes 66 Yes Yes Yes Yes Yes Yes 73 Yes Yes Yes Yes Yes Yes 71 Yes 58 Yes Yes 65 Yes 60 Yes 44 Yes 61 Yes 57 Critical Value Yes 61 Yes 55 Yes 66 Yes 65 Yes 57 Yes 69 Yes 48 Slide 6: Find the following statistical calculations. In your PPT, include your interpretation of the calculations and the correct units. *Note: Refer to the Word document in the deliverable instructions for a breakdown of requirements for each slide. Slide 8: Construct a 95% confidence interval for the population mean ages of the patients. Assume that your data is normally distributed and σ is unknown. Slide 9, 10, 11: 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.
Patient #
Infectious Disease
Age
1
Yes
7
2 Yes
4
3
5
8
4 Yes
58
5 Yes
45
Age Calculations
Formulas/Answers
6
5
9
Mean
7 Yes
71
Median
8 Yes 71
Mode
9 Yes
72
10
67
11
60
12
65
13
73
14
15
42
16
17
Midrange
18
66
Range
19
44
Variance
20
51
Standard Deviation
21
22
Maximum
23
84
Minimum
24
56
25
61
26
59
27
68
28
29
50
30
55
Critical Value
31
77
Margin of Error
32
57
Lower Limit
33
48
Upper Limit
34
35
36
49
37
38
39
40
41
Test Statistic
42 Yes
63
43
P-value
44 Yes 60
45 Yes
62
46
47
48 Yes 50
49 Yes 77
50 Yes 66
51 Yes
69
52
53
54
55 Yes 59
56 Yes
70
57 Yes 53
58 Yes
76
59 Yes
75
60 Yes 68
61 Yes 55
62 Yes 61
63 Yes
81
64
65 Yes 67
66 Yes 59
67 Yes
83
68 Yes 69
69 Yes 68
70 Yes 75