For this assignment you will use the Lab Report 2 dataset found under the evaluations module. Answer all questions using APA statistical reporting guidelines. If answers are not a whole number, round

Looking ahead to Lab 2, majority of the report is similar to Lab # 1. There are 3 new questions in Lab 2 (questions 9-11).

For Question 10, you will need to decide what type of t-test to utilize and to execute this function on excel. Please review the tutorial videos from prior weeks. Below you can find one method to execute this calculation:

Your answer for question 9 is correctly framed as a non-directional hypothesis:

 1.  Organize Your Data in Excel

Ensure you have two columns, one for each group:

     •  Column 1: “Experimental Group” (Days in Hospital)

     •  Column 2: “Control Group” (Days in Hospital)

2.  Enable the Data Analysis ToolPak (if not already enabled):

     •  Go to File > Options.

     •  Select Add-Ins on the left panel.

     •  In the Add-Ins section, click Go next to Excel Add-ins.

     •  Check the box for Analysis ToolPak and click OK.

3.  Perform the T-Test Using the Data Analysis ToolPak:

     •  Go to the Data tab and click Data Analysis in the Analysis group.

     •  Choose t-Test: Two-Sample Assuming Equal Variances (if variances are assumed equal) or t-Test: Two-Sample Assuming Unequal Variances (if variances are different).

     •  Click OK.

4.  Input the Data:

     •  Variable 1 Range: Select the range of cells representing the Experimental Group.

     •  Variable 2 Range: Select the range of cells representing the Control Group.

     •  Hypothesized Mean Difference: Enter 0 (as you are testing for differences).

     •  Labels: Check the box if your data includes headers.

     •  Alpha: Set at 0.05 (the typical significance level).

5.  Select the Output Range:

Choose where you want the results to be displayed, either on the same worksheet or a new worksheet.

6.  Interpret the Results:

The output table will provide the following:

     •  Mean and Variance of each group.

     •  t-Statistic value.

     •  Degrees of Freedom.

     •  p-Value (one-tail and two-tail).

APA Reporting of Results:

Once you obtain the results, here’s how to present them:

• Report the Means and Standard Deviations: Mention the means and standard deviations for each group in your comparison.

• State the t-Statistic and p-Value: Report the t-statistic (e.g., t(98) for 98 degrees of freedom) and the exact p-value (e.g., p < .001).

Lab Activity Report 2: Descriptive Statistics & T-test (30 points total)

For this assignment you will use the Lab Report 2 dataset found under the evaluations module. Answer all questions using APA statistical reporting guidelines. If answers are not a whole number, round to 2 decimal places. Remember to include units.

Study Background Information:

Research Question: What is the impact of a multidisciplinary admission education intervention on the number of days the patient was admitted to the hospital.

In this simulated study, adult participants admitted to the medicine unit at a Southern Ontario hospital were recruited for the study. Participants were randomly put in either the experimental or control groups. The experimental group received structured educational sessions from nursing, medicine, pharmacy, occupational therapy, and physical therapy upon admission. The control group received the standard admission education. Number of days in the hospital was measured using the patient’s admission time and adding one day for every 24hrs in hospital.

1. What is independent variable? What level of measurement is this? (1 point)

2. What is the dependent variable? What level of measurement is this? (1 point)

3. What demographic variables are used? What level of measurements are they? (2 points)

4. Calculate the applicable descriptive statistics for each demographic variable for both groups together. If a section is not applicable, put N/A and describe in a couple of sentences under the table why this is. (3 points)

5. Calculate the following descriptive statistics for the dependent variable by group and then together: (6 points)

6. Create an appropriate graphical representation for each demographic variable by group (3 variables x 2 graphs-1 per group= 6 graphs): (3 points)

7. Is the sample normally distributed? Why or why not? (1 point)

8. What do we know about the sample based on the demographic variables? (1 point)

9. State the null and alternate, non-directional hypothesis: (2 points)

10. Test the hypothesis using the correct T-test. State the results and an interpretation of the results in APA formatting. (6 points)

11. Based on these findings, list 1 educational, 1 health policy, 1 practice, and 1 future research implication. Write these as you would in a paper (max. 1 paragraph). (4 points)

Data set citation: OpenAI. (2024). CoPilot [Large language model]. Copilot (microsoft.com)