PH 520 West Coast University Week 4 Categorical and Continuous Variables Statistics Project

Open up the small Excel database that is linked below.

Week 4 Database

With this database, you will:

  1. Identify and list categorical and continuous variables.
  2. Calculate frequencies and percentages for all of the categorical variables, and means, and standard deviations for the continuous variables.
  3. Run a one-sample z test of proportions for one categorical variable. Here is an example in terms of wording: “Is the proportion of English speaking patients greater than 50%?” Using .05 level of significant test the appropriate hypotheses.
    1. Write the null and alternate hypotheses
    2. What is the proportion of English speaking patients
    3. What is the standard error and z statistics
    4. Find critical z and p value. Is the p value significant? Conclusion?
  4. Run an independent samples t-test to compare two groups of people (specified by a dichotomous variable) on one continuous variable. Using .05 level of significant test the appropriate hypotheses. In order to run this test statistics you have to re-arrange your data.
    1. Write the null and alternate hypotheses.
    2. What is the calculated mean for each group?
    3. What is the confidence interval for each group?
    4. What is the critical t value?
    5. Is the p value significant? Conclusion?

Need Excel help? Click on the Excel Function Help Workbook under Course Materials.

Expert Solution Preview

Introduction: In this assignment, you will be working with a small Excel database to identify and list categorical and continuous variables, calculate frequencies and percentages for categorical variables, means and standard deviations for continuous variables, run a one-sample z test of proportions for a categorical variable and an independent samples t-test to compare two groups of people on one continuous variable.

1. To identify and list categorical and continuous variables, open the Excel database and go through each column to determine the type of data it contains. Categorical variables are those that represent non-numerical data, such as gender, race, or occupation. Continuous variables are those that represent numerical data, such as age, height, or weight.

2. To calculate frequencies and percentages for categorical variables, use Excel functions such as COUNTIF and COUNTA to count the number of occurrences of each category and the total number of values in the column. Then, divide the count of each category by the total count to get the percentage. To calculate means and standard deviations for continuous variables, use Excel functions such as AVERAGE and STDEV.

3. To run a one-sample z test of proportions for a categorical variable, follow these steps:

– Write the null and alternate hypotheses. The null hypothesis would be that the proportion of English speaking patients is equal to 50%, while the alternate hypothesis would be that the proportion is greater than 50%.
– Find the proportion of English speaking patients by counting the number of patients who speak English and dividing it by the total number of patients.
– Calculate the standard error by dividing the square root of (p * (1 – p) / n) where p is the proportion from step 2 and n is the sample size.
– Calculate the z statistic by subtracting the hypothesized proportion from the sample proportion and dividing the result by the standard error.
– Find the critical z and p values using a z table or Excel function such as NORMSINV. If the calculated p value is less than 0.05, then the result is significant and we can reject the null hypothesis. Otherwise, we fail to reject the null hypothesis.

4. To run an independent samples t-test to compare two groups of people on one continuous variable, follow these steps:

– Write the null and alternate hypotheses. The null hypothesis would be that there is no difference between the means of the two groups, while the alternate hypothesis would be that there is a significant difference.
– Calculate the mean for each group using Excel functions such as AVERAGE and filter the data to separate the two groups.
– Calculate the confidence interval for each group using Excel functions such as CONFIDENCE.
– Find the critical t value using a t table or Excel function such as TINV.
– Calculate the t-statistic by subtracting the mean of one group from the mean of the other and dividing by the standard error.
– Find the p value using Excel function such as TDIST. If the p value is less than 0.05, then we can reject the null hypothesis and conclude that there is a significant difference between the two groups. Otherwise, we fail to reject the null hypothesis.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Describe and critique a current article that relates to Nursing Assignment Help

Describe and critique a current article that relates to hospital financing and competitive practices in healthcare. (Article should be from a scholarly, peer-reviewed journal published within the last 3-5 years). Submit 1,000-1,500-word paper with a KU title page and reference page in a scholarly format. You are a medical professor

GCU Patient Preferences in Care Discussion Reply Nursing Assignment Help

please respond to the following discussion as a peer making a comment. Hello everyone, Integrating patient preferences and values with clinician expertise is essential when making evidence-based decisions. This approach leads to patient-centered care, improves treatment adherence, and enhances health outcomes. Patients’ unique values, beliefs, priorities, and circumstances can significantly

UM Administrator in Training Rotation Experience Report Nursing Assignment Help

Complete and Submit the Three Sections of the Report for the Assignment: AIT Experience: LTC Settings and Services Report Template (ATTACHED) APA: Include APA 7th Edition Formatted Reference Page. ALL RESPONSES IN PARAGRAPH FORM. Complete Section 1 of the Report Select the Long Term Care (LTC) Settings and Services: ALREADY

NYU Autoimmune Disease of Myelin Abstract Nursing Assignment Help

`The disease is called MS You should read Wikipedia “Immune System”, “Antibody”,  “Antigen”, “T  cell”, “B cell”, “Macrophage”, “Dendritic cell”  for writing your abstract. It would also be good to read the Wikipedia article on MS.  The purpose of writing an abstract is to condense the material you have read

Within the Professions of Psychology Paper Nursing Assignment Help

PSY 540 Final Project Guidelines and Rubric Overview Within the professions of psychology, it can be typical for you to work on proposals for programs, studies, or new initiatives. For example, you may work for a university that regularly partners with foundations and corporations to identify grant opportunities for projects

Professional Ethics Instructions Baccalaureate education Nursing Assignment Help

Professional Ethics Instructions Baccalaureate education includes the development of professional values and value-based behavior (AACN, 2008). Ethics define professional ethics and their importance in the healthcare environment. The American Nurses Association has approved 13 standardized languages that support nursing care.  The benefits of standardized language include: better communication among nurses

Select one of the following populations: Aging Nursing Assignment Help

Select one of the following populations: Aging Population Homelessness Migrant Workers LGBTQIA+ Other Identified Vulnerable Populations from Your Reading Then complete the following steps for your discussion post: Identify which vulnerable population you have chosen to use for this post and describe what this vulnerable population looks like in your

WGU Population Health Data Analysis Paper Nursing Assignment Help

In this course, you learned that Informatics for Transforming Nursing Care integrates nursing science with multiple information and analytical sciences to identify, define, manage, and communicate data, information, knowledge, and wisdom in nursing practice. This provides knowledge and skills to apply informatics concepts, communications, and data critical to facilitating interprofessional

Professional EthicsInstructions Baccalaureate education Nursing Assignment Help

Professional EthicsInstructions Baccalaureate education includes the development of professional values and value-based behavior (AACN, 2008). Ethics define professional ethics and their importance in the healthcare environment. The American Nurses Association has approved 13 standardized languages that support nursing care.  The benefits of standardized language include: better communication among nurses and

HSA 599 SU Public Health Emergencies Discussion Nursing Assignment Help

I’m working on a health & medical discussion question and need the explanation and answer to help me learn. Discuss a life-threatening event or a natural disaster in your community, such as a severe weather event, terrorist attack, or other type of public health emergency. Examine an overall strategy that

Develop a literature map or a visual representation of the Nursing Assignment Help

Develop a literature map or a visual representation of the Public Health Informatics literature.  Also include a powerpoint presentation explaining the literature map with the slides Constructing a literature map helps you: develop an understanding of the key issues and research findings in the literature organize ideas see how different research studies