W AutoSave @Off) U9_mini_project v Search Sabrina Tweedy ST X File Home Insert Draw Design Layout References Mailings Review View Help Table Design Layout Comments Editing Share ~ Calibri (Body) 12 ~ A" A" Aa Ap Find Paste Normal No Spacing Heading 1 Heading 2 Heading 3 Gc Replace B I U~ ab x x A LA . Dictate Editor Add-ins Select Clipboard Font Paragraph Styles Editing Voice Editor Add-ins Directions Answer all questions in the space below the question; more space can be added as needed. Be sure to label answers, write in complete sentences, and answer questions in the appropriate context. a) Enter unique identifiers (listed above) to cells C3 - C6 of the Excel project template. b ) Select a quantitative variable in cell F3 c) Select a qualitative variable in cell 14 d) List the identifiers and variables in this table: First Name Sabrina Last Name Tweedy Course Term Home Zip Code 76856 Quantitative Variable (cell F3) Anxiety Level Qualitative Variable (cell 14) Diagnosis 2) Using the data in columns C and F (beginning in row 10), perform a hypothesis test for the mean difference. a) List the type of test and your hypotheses in this table: Type of Hypothesis Test Null Hypothesis (Ho) Alternate Hypothesis (Ha) b) Using alpha = 0.05, fill in the following results in this table: Test Statistic (include the label) p-value Page 2 of 5 640 words DX Text Predictions: On % Accessibility: Investigate Focus 100% 87 Q Search LOFe A X W 1:36 PM 6/16/2024W AutoSave (Off) H J . U = U9_mini_project v Search Sabrina Tweedy ST X File Home Insert Draw Design Layout References Mailings Review View Help Table Design Layout Comments Editing Share ~ Calibri (Body) 12 ~ A" A" Aa Ap Find Normal Paste No Spacing Heading 3 Gc Replace B I U~ ab x x A LA . Heading 1 Heading 2 Dictate Editor Add-ins Select Clipboard Font Paragraph Styles Editing Voice Editor Add-ins 2) Using the data in columns C and F (beginning in row 10), perform a hypothesis test for the mean difference. a) List the type of test and your hypotheses in this table: Type of Hypothesis Test Null Hypothesis (Ho) Alternate Hypothesis (H=) b) Using alpha = 0.05, fill in the following results in this table: Test Statistic (include the label) p-value Decision c) Write a conclusion paragraph (in context) for the results. Paragraph must be at least 100 words. 2 PURDUE GLOBAL Page 2 of 5 640 words DX Text Predictions: On % Accessibility: Investigate Focus 100% 87 Q Search V W 1:36 PM 6/16/2024W AutoSave (Off) H J . U = U9_mini_project v Search Sabrina Tweedy ST X File Home Insert Draw Design Layout References Mailings Review View Help Table Design Layout Comments Editing Share ~ Calibri (Body) 12 ~ A" A" Aa Ap Find Paste Normal No Spacing Heading 3 Gc Replace B I U~ ab x x A LA . Heading 1 Heading 2 Dictate Editor Add-ins Select Clipboard Font Paragraph Styles Editing Voice Editor Add-ins GLOBAL 3) Investigate the potential relationship between two quantitative variables: a) Select two (2) quantitative variables in cell F4 and F5 (variables should be different than the one used in question 1 above. Quantitative Variable (cell F4) Qualitative Variable (cell F5) b) Using the data in columns D and E (beginning in row 10), investigate the potential relationship between the variables: i) Create a scatter plot and cut/paste the plot into the space below. i) Describe the relationship based on the scatter plot. ii) Generate a regression analysis and cut/paste results into the space below. Page 3 of 5 640 words DX Text Predictions: On % Accessibility: Investigate Focus 100% 87 Q Search mayhap A X W 1:36 PM 6/16/2024W AutoSave (Off) H J . U = U9_mini_project v Search Sabrina Tweedy ST X File Home Insert Draw Design Layout References Mailings Review View Help Table Design Layout Comments Editing Share ~ 12 ~ A" A" Aa Ap Find Calibri (Body) Normal No Spacing Heading 3 Gc Replace Paste Heading 1 Heading 2 B I U~ ab x x A LA . Dictate Editor Add-ins Select Clipboard Font Paragraph Styles Editing Voice Editor Add-ins iv) List the following (label each): Correlation Coefficient Coefficient of Determination Strength of the relationship Type of association (positive, negative, neither) Equation of the line of best fit [regression line 3 PURDUE GLOBAL v) Based on the answers to the five (5) items above, should the equation be used to predict additional values of y? -- Be sure to provide a justification using the answers to #1-5 and either the critical value for r or the p-value from the regression and not just a Yes/No answer. Page 3 of 5 640 words DX Text Predictions: On % Accessibility: Investigate Focus 100% 87 1:37 PM Q Search X W 6/16/2024AutoSave Off) H C MM570_excel_project_template_2305C (6) Search Sabrina Tweedy ST X File Home Insert Draw Page Layout Formulas Data Review View Help Comments Share X Cut Calibri 12 ~ A" A al Wrap Text AutoSum ~ Paste [A Copy BIU~ ~ SAY Merge & Center $ ~ % 9 68 98 Conditional Format as Cell Insert Delete Format Fill Sort & Find & Add-ins Analyze Format Painter Formatting Table v Styles * Clear Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Add-ins H10 vi XVfx B E F G H P Q R S U V W X Y Z AA A Student Inputs Area Quantitative Qualitative Variables Demographics Inputs Variables Inputs Selection Inputs 2 Selection First Name Sabrina Variable 1 Anxiety Level Variable 1 Cognitive Processes Rating 3 Last Name weedy Variable 2 Cognitive Speed Variable 2 Diagnosis Course Term 2305C Variable 3 Memory Capacity (Post) Variable 3 Emotional Regulation Rating 5 Home Zip Code 76856 6 Students should not select the same variable more than once per dataset. Qualitative data may not consider all contingencies. 7 Quantitative 8 Qualitative Variables Variables File Number Anxiety Level Cognitive Memory Cognitive Processes Rating Diagnosis [NOT a variable) Speed Capacity (Post) Emotional Regulation Rating 40 52 10 Very Low Schizophrenia Moderate 13 22 14 Low Normal Very Low 17 Low Psychotic Disorder Moderate 49 Very Low Normal High 17 High Obsessive compulsive Dicacdec Low Very High Normal High Very High Norma Very Low Moderate Schizophrenia Moderate 9 Low Personality Disorder Very Low 10. Low Schizophrenia Very Low 11. Very Low Dosessive-compulsive Dicards Low 12. Very High Normal High > Data + Ready Accessibility: Investigate Count: 50 70% Q Search X W 1:37 PM 6/16/2024AutoSave Off) = AD - GA MM570_excel_project_template_2305C (6) Search Sabrina Tweedy ST X File Home Insert Draw Page Layout Formulas Data Review View Help Comments Share X Cut Calibri 12 ~ A" A ap Wrap Text AutoSum ~ Paste [ Copy Conditional Format as Cell Insert Delete Format Fill BIU~ ~ MA~ Merge & Center $ ~ % 9 68 98 Sort & Find & Add-ins Analyze Format Painter Formatting Table v Styles * Clear Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Add-ins H10 : XVfx B very Low Mouerate P Q R S U V W X Y Z AA A Low Normal Very Low Low Psychotic Disorder Moderate Very Low Normal High High Obsessive-compulsive Low Very High Normal High Very High Norma Very Low Moderate Schizophrenia Moderate Low Personality Disorder Very Low Low Schizophrenia Very Low Very Low Dsessive-compulsive Low Very High Normal High Low Obsessive-compulsive Dicorder Very Low Moderate Psychotic Disorder High Low Personality Disorder Moderate High Personality Disorde Very Low Moderate Psychotic Disorder High Moderate Psychotic Disorder Very Low Low Normal Very Low Low Normal Very Low Very High Personality Disorder Low Very High Psychotic Disorder Very Low Low obsessive-compulsive Dicardor Very Low Low Normal Moderate Moderate Obsessive-compulsive Dicorder Low Very Low ersonality Disorder Moderate Very High Normal Very Low Low chizophrenia High Low Personality Disorder High Very Low Personality Disorde Low 31. Very High Obsessive-compulsiv Dicorder Low 41 32 Moderate Psychotic Disorder Very Low