American Sentinel N755 2022 April Module 4 Assignment Latest

Question # 00822797 Posted By: Ferreor Updated on: 04/20/2022 06:31 AM Due on: 04/20/2022
Subject Nursing Topic Nursing Tutorials:
Question
Dot Image

N755 Health Statistics

Module 4 Assignment  

This assignmentis designedtoprovide you witha real-world experience of analyzingdata. Forthislesson, youwill use the excel codebook and coded data tab from Assignment 1. You will be conducting percentage and frequency for the categorical variables and measures of central tendency (mean, median, mode, minimum and maximum) for the continuous variables.

1.            Open your completed excel codebook from assignment 1 and click on the coded data tab. If you made any errors in Assignment 1, make sure to correct the errors prior to completing this assignment. Do not remove the metadata or original data tabs.

2.            To make navigation easier during your analysis, freezeyour worksheet so the Variable Names (column headings) and Facility ID numbers (row headings) are always visible. To do this, click in Cell B2, then click on the View tab click on Freeze Panes and thenFreeze panes. Now, when you scroll through your worksheet, your variable headings and Hospital ID numbers remain visible.

3.            The next step will be to start analyzing the categorical variables. Categorical variablesare nominalvariables, as the number assigned means the “name” of something. To analyzeand present categorical variables, you determine the frequencies and proportions (percentage) of responses.

When providing your written analysis of a categorical variable you should give frequency and percentage. For example, 75% (n = 112) were male and 25% (n =38) were female.

To count how many responses are within eachof thesecategories,you will use the CountIFfunction to generate frequencies.You will usethis analysis methodfor the variables Region, State, and Ownership.First you will determine how many hospitals are operating in each Region. Start with West which we know by looking in the Metadata tab was coded as a 1. Click in cell C27 and type in the formula bar =COUNTIF(C2:C25, 1)and then hit enter. This formula tells excel that if the number is “1” in cells C2 through C25 it should be counted. Next click in cell C28 and type the same formula in the formula bar, but change the 1 to 2=COUNTIF(C2:C25, 2).  Continue the same process until you have finished counting all the regions.  You will complete the same process for State and Hospital Ownership. Make sure you are changing the values and cell numbers to correspond with the metadata and cell information.

4.            For all of the categorical variables, you will want to calculate the proportions (percentages). To determine the proportions of the categorical variables you will divide the count total by the total number in the sample. In this instance the total number (n value/sample size) of hospitals is 24. To calculate the proportion of hospitals operating in the west, click in cell C31 and type in the formula bar =C27/24 and then hit enter.

5.            When you hit enter you will note that the result is a decimal.  You want a percentage, so you need to format the cell.  Click in C31 and then right click.  Choose format cells.  A text box will appear.  Choose percentage and two decimal places and hit ok. The value will change to a percentage. You will continue the same procedure for all of theRegion Counts, State Counts, and Hospital Ownership Counts.  Your divisor will always be “24” as this is your n value (sample size).

6.            Next you will analyze the continuous variables. Continuous variables should be analyzed using measures of central tendency (mean [average], median [midpoint] and mode [number that appears most often]) and measures of dispersion (standard deviation [extent of variance from the mean] and range [difference between minimum and maximum value]).

When providing your written analysis for the mean of acontinuous variable you should also give the standard deviation. For example, M = 7.5 (SD = 1.2). When presenting the median for a continuous variable you should also provide the minimum and maximum. For example, Md = 3.5 with a minimum of .02 and a maximum of 3.2. When presenting the mode, you should provide the range. For example, the mode = 10 with a range of 9.

To calculate the mean % OP Market Share, click in cell E27 and type in the formula bar =average(E2:E25) and then hit enter.

7.            To calculate the standard deviation for% OP Market Share, click in cell E28 and type in the formula bar =STDEV(E2:E25) and then hit enter.

8.            To calculate the median for % OP Market Share, click in cell E29 and type in the formula bar =median(E2:E25) and then hit enter.

9.            To calculate the minimum for % OP Market Share, click in cell E30 and type in the formula bar =min(E2:E25) and then hit enter.

10.          To calculate the maximum for % OP Market Share, click in cell E31 and type in the formula bar =max(E2:E25) and then hit enter.

 11.         Follow steps 6 through 10 to calculate the measures of central tendency for the rest of the continuous variables (% IP Market Share, Net Patient Revenue, and % NetOperating Margin). Congratulations! You have successfully completed the Descriptive Statistics! You are now ready to write your written analysis. 

12.          Your written analysis should be an APA formatted paper that includes:

•             Frequency and percentages for all categorical variables

•             Mean, standard deviation, median, minimum and maximum for all continuous variables

•             A discussion of significant findings

•             Use APA rounding rules for statistics

•             Use APA statistical abbreviation guidelines

Submit your excelcodebook and the APA formatted written analysis into the assignment 2 drop box.

 

Dot Image
Tutorials for this Question
  1. Tutorial # 00818201 Posted By: Ferreor Posted on: 04/20/2022 06:31 AM
    Puchased By: 2
    Tutorial Preview
    The solution of American Sentinel N755 2022 April Module 4 Assignment Latest...
    Attachments
    American_Sentinel_N755_2022_April_Module_4_Assignment_Latest.ZIP (18.96 KB)

Great! We have found the solution of this question!

Whatsapp Lisa