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
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.
Unlock instant AI solutions
Tap the button
to generate a solution