Deliverable 7 – Statistical Analysis Report

ByPlatinum Essays

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

  1. 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:

    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
    6. 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.

      For your final deliverable, submit your PowerPoint presentation and the Excel workbook showing your work. Do not submit your Word document.

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

Having Trouble Meeting Your Deadline?

Get your assignment on Deliverable 7 – Statistical Analysis Report completed on time. avoid delay and – ORDER NOW

Get a 20% Discount

· 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

Patient # Infectious Disease Age
1 Yes 70
2 Yes 41
3 Yes 58
4 Yes 58
5 Yes 45 Age Calculations Formulas/Answers
6 Yes 59 Mean
7 Yes 71 Median
8 Yes 71 Mode
9 Yes 72
10 Yes 67
11 Yes 60
12 Yes 65
13 Yes 73
14 Yes 73
15 Yes 42
16 Yes 45
17 Yes 65 Midrange
18 Yes 66 Range
19 Yes 44 Variance
20 Yes 51 Standard Deviation
21 Yes 71
22 Yes 66 Maximum
23 Yes 84 Minimum
24 Yes 56
25 Yes 61
26 Yes 59
27 Yes 68
28 Yes 73
29 Yes 50
30 Yes 55 Critical Value
31 Yes 77 Margin of Error
32 Yes 57 Lower Limit
33 Yes 48 Upper Limit
34 Yes 71
35 Yes 58
36 Yes 49
37 Yes 65
38 Yes 60
39 Yes 44
40 Yes 61
41 Yes 57 Test Statistic
42 Yes 63 Critical Value
43 Yes 61 P-value
44 Yes 60
45 Yes 62
46 Yes 55
47 Yes 66
48 Yes 50
49 Yes 77
50 Yes 66
51 Yes 69
52 Yes 65
53 Yes 57
54 Yes 69
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 Yes 48
65 Yes 67
66 Yes 59
67 Yes 83
68 Yes 69
69 Yes 68
70 Yes 75

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.

Order a similar assignment, and have writers from our team of experts write it for you, guaranteeing you an A

Order Solution Now

Similar Posts

multiple regression analysis

ByPlatinum Essays

For the attached data, find the multiple linear regression formula using X1 as the dependent variable and X2-X7 as the independent variables. Using whatever means necessary find the model of best fit and justify your choices. Determine what variables are significant at a sig. level of 10%.   State what independent variable if any should be…

total quality management Contributors Practice

ByPlatinum Essays

In this week's readings, you learned about the major contributors to the development of total quality management (TQM). Some of the methods that each developed are more suited to one application versus  another. Select three contributors from the list shown here whose TQM methods could be readily applied to the daily business and medical operations of a…

Pareto Analysis and Business Process Flow Charting Practice

ByPlatinum Essays

  This activity consists of two problems. Problem One Gary Seitz is director of procurement for the Forest Medical Center in Oak Park, Illinois. His medical center recently purchased more than 300 new side tables for the patient rooms from Quick-and-Cheap Furniture. His team, however, is not happy with the paint quality of these tables. They feel…