View + 125% ▼ Zoom 三 III Add Category Pivot Table DAILY RETURN WHEAT PRICES Credit Score Adult Before Seminar 1 2 3 4 5 608 620 610 650 640 After Seminar 646 692 715 669 725 ITT 6 7 8 9 10 11 12 680 655 602 644 656 632 664 786 700 650 660 650 680 702 + A ☑ Insert Table Chart Text Shape Media Comment Collaborate CREDIT_SCORE ACTIVE VS FAILED RETAIL COMPANY Sheet Name CREDIT_SCORE Background Format Organize Sheet Duplicate Sheet Delete Sheet

Np Ms Office 365/Excel 2016 I Ntermed
1st Edition
ISBN:9781337508841
Author:Carey
Publisher:Carey
Chapter2: Formatting Workbook Text And Data
Section: Chapter Questions
Problem 1.7CP
icon
Related questions
Question

Excel output:

The credit scores for 12 randomly selected adults who are considered high risk barrowers before and two years after they attend a personal finance seminar are given in Excel file under CREDIT SCORE sheet. 

You will run a significance test to check if there is enough evidence to support the claim that the personal finance seminar helps adults increase their credit scores. 

You’ll use α = 0.01 for significance test. 

 

a) Write out the null and alternative hypothesis associated with the research question. 

 

b) What type of statistical test will you use to answer the proposed research question? (Note: Is this a z-test or a t-test for independent or dependent samples) 

 

c) What is the critical value at the 0.01 level of significance?  Be sure and include whether this critical value is a z or t value and, if appropriate, include the degrees of freedom associated with this statistical test. 

 

d) What is the standardized test statistic? 

 

e) At 0.01 significance level what decision should be made about the null hypothesis?  In other words, should you reject or retain the null hypothesis? 

 

f) Provide a brief conclusion regarding your findings. Use your PowerPoint lecture slides for writing out the interpretation of your results. 

View
+
125% ▼
Zoom
三
III
Add Category
Pivot Table
DAILY RETURN
WHEAT PRICES
Credit Score
Adult
Before Seminar
1
2
3
4
5
608
620
610
650
640
After Seminar
646
692
715
669
725
ITT
6
7
8
9
10
11
12
680
655
602
644
656
632
664
786
700
650
660
650
680
702
+
A
☑
Insert
Table Chart Text Shape
Media Comment
Collaborate
CREDIT_SCORE
ACTIVE VS FAILED RETAIL COMPANY
Sheet Name
CREDIT_SCORE
Background
Format Organize
Sheet
Duplicate Sheet
Delete Sheet
Transcribed Image Text:View + 125% ▼ Zoom 三 III Add Category Pivot Table DAILY RETURN WHEAT PRICES Credit Score Adult Before Seminar 1 2 3 4 5 608 620 610 650 640 After Seminar 646 692 715 669 725 ITT 6 7 8 9 10 11 12 680 655 602 644 656 632 664 786 700 650 660 650 680 702 + A ☑ Insert Table Chart Text Shape Media Comment Collaborate CREDIT_SCORE ACTIVE VS FAILED RETAIL COMPANY Sheet Name CREDIT_SCORE Background Format Organize Sheet Duplicate Sheet Delete Sheet
AI-Generated Solution
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
steps

Unlock instant AI solutions

Tap the button
to generate a solution

Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning
Microsoft Visual C#
Microsoft Visual C#
Computer Science
ISBN:
9781337102100
Author:
Joyce, Farrell.
Publisher:
Cengage Learning,
New Perspectives on HTML5, CSS3, and JavaScript
New Perspectives on HTML5, CSS3, and JavaScript
Computer Science
ISBN:
9781305503922
Author:
Patrick M. Carey
Publisher:
Cengage Learning