Assessment

To complete the assessment, you must first conduct statistical tests. The resources below will help you conduct each required test:

• : Download and read the instructions for conducting statistical tests (descriptive statistics, hypothesis testing, correlational testing) and using AI to analyze statistical data.
• Demonstration Videos: Watch the following videos to understand how to conduct each required statistical testing using the Microsoft Excel Analysis ToolPak:
• : Use this dataset to conduct each required statistical test.

Read the following scenario to use for this assessment:

You are a research assistant in the psychology department at a growing university. As part of the universitys strategic initiative to enhance employee well-being and retention, the administration asked your department to conduct a study on job satisfaction among university staff.

Your specific research focus was on workplace happiness and employee engagement. To conduct the research, you designed and distributed a survey targeting university employees, designed to address the following research questions:

• Research Question 1: What variables positively affect workplace happiness and engagement?
• Research Question 2: What variables negatively impact workplace happiness and engagement?

Your survey collected data from 50 participants and included the following variables:

• Demographic information: Gender and age
• Workplace dynamics: Quality of relationship with direct supervisors and coworkers
• Work arrangements: Telecommuting schedule (e.g., fully remote, hybrid, or on-site)
• Outcome measures: Self-reported ratings of workplace happiness and workplace engagement

You organized the data into 2 categories for analysis:

• Dependent Variables: These are the outcomes you are measuring. In the Employee Happiness and Engagement dataset, the dependent variables are workplace happiness and engagement.
• Independent Variables: These are the predictors or factors you are analyzing to determine their influence on employee happiness and engagement. In the Employee Happiness and Engagement dataset, the independent variables include:
• Gender
• Age
• Quality of relationship with direct supervisors
• Quality of relationship with coworkers
• Telecommuting status (e.g., fully remote, hybrid, or on-site)

Your next step is to conduct statistical tests and analyze the data collected using both traditional statistical testing methods and AI-assisted data analysis. Your results will help the university identify key factors that contribute to or detract from a positive work experience, providing valuable insights for university leadership to inform future policies and practices.

Assessment Deliverable

This summative assessment has 3 parts:

• Part 1: Statistical Testing and Analysis
• Part 2: AI Statistical Testing and Analysis
• Part 3: Research Analysis Report

Review the guidelines and requirements for each part carefully before completing the assessment.

Part 1: Traditional Statistical Testing and Analysis

Select 1 of the research questions to use for this assessment.

Review the provided .

Select the appropriate test(s) and run the statistical test(s) (descriptive statistics, hypothesis testing, correlational test) in Excel and save the output results. You will submit these results with your final deliverable.

Follow the steps provided in the to conduct the tests.

Analyze the results and determine what they mean in reference to the research question.

Write a 700- to- 1,050-word analysis of the testing results. Do the following:

• Describe the statistical tests and independent variables you used to analyze the dataset.
• Summarize the results of each statistical test conducted.
• Explain your analysis of the testing results in relation to the research question.
• Propose a recommendation for employee happiness and engagement based on your analysis.

Part 2: AI Statistical Testing and Analysis

Create a prompt for an AI platform to analyze the statistical results according to the selected research question. Use the AI platform to analyze the results. Save this analysis as a screenshot and submit this with your final deliverable.

Write a 350- to 525-word evaluation of the strengths and limitations of using the AI platform for data analysis. Do the following:

• Compare the AI platforms data analysis with the traditional data analysis you completed in Part 1. Include the following details:
• The prompt you created
• A description of the method and type of statistics used by the AI
• A summary of the conclusions the AI tool made
• A reflection of your experience using AI to conduct data analysis. Consider these guiding questions:
• What are some strengths and limitations of using the AI tool to analyze data?
• What are some ethical considerations to consider when using an AI platform for data analysis in research?

Part 3: Research Analysis Report

Compile the following components from Part 1 and 2 into a research analysis report to present to the university administration. Include the following:

• A screenshot of the Excel output of each statistical test conducted
• Your 700- to- 1,050-word analysis from Part 1
• The prompt you created for the AI platform
• A screenshot of the AI-generated data analysis
• Your 350- to 525-word evaluation from Part 2

Submit your assessment.

Assessment Support

• Review the for guidance on deliverable expectations.
• Refer to the slide presentations below as needed to complete your statistical tests. These slides will help you quickly locate key testing steps and examples without rewatching the statistical testing demonstration videos. Be sure to review the speaker notes included in each presentation, as they offer additional explanations and guidance to help you understand how to complete each test accurately: