Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please create a bell curve using the excel function based on the information from the T Test Two Sample Assuming Equal variances Debt in 2018
Please create a bell curve using the excel function based on the information from the T Test Two Sample Assuming Equal variances
Debt in 2018 (dollars) | Debt in 2013 (dollars) | ||||
3,287 | 3,840 | Test the Hypotheses Below | |||
4,031 | 2,575 | ||||
5,028 | 4,720 | Null Hypothesis: Mean Student Debt in 2018 is equal to Mean Student Debt in 2013 | |||
4,939 | 3,178 | Alternative Hypothesis: Mean Student Debt in 2018 is not equal to Mean Student Debt in 2013 | |||
4,555 | 4,972 | ||||
2,792 | 2,827 | Alpha Level = 0.05 | |||
2,658 | 4,964 | ||||
2,756 | 3,033 | ||||
3,422 | 3,843 | Question 1 | |||
4,431 | 4,972 | ||||
4,034 | 3,974 | F-Test Two-Sample for Variances | |||
4,310 | 3,134 | Debt in 2018 (dollars) | Debt in 2013 (dollars) | ||
4,782 | 3,120 | Mean | 3914.28 | 3773.54 | |
3,363 | 3,793 | Variance | 597942.8996 | 582060.0902 | |
2,858 | 3,909 | Observations | 50 | 50 | |
3,665 | 3,468 | df | 49 | 49 | |
4,453 | 2,536 | F | 1.027287233 | ||
4,778 | 3,795 | P(F<=f) one-tail | 0.462656015 | ||
3,492 | 4,662 | F Critical one-tail | 1.607289463 | ||
3,380 | 2,833 | ||||
4,996 | 4,097 | ||||
2,684 | 3,188 | Question 2 | |||
3,067 | 2,695 | ||||
4,236 | 3,691 | ||||
4,513 | 3,499 | 2018 | 2013 | ||
4,050 | 2,914 | Mean | 3914.28 | 3773.54 | |
3,955 | 4,102 | Variance | 597942.8996 | 582060.0902 | |
2,909 | 3,934 | Observations | 50 | 50 | |
3,592 | 4,058 | Pooled Variance | 590001.4949 | ||
2,984 | 2,659 | Hypothesized Mean Difference | 0 | ||
4,063 | 4,844 | df | 98 | ||
2,690 | 3,156 | t Stat | 0.916138206 | ||
4,735 | 3,332 | P(T<=t) one-tail | 0.180921662 | ||
4,398 | 4,793 | t Critical one-tail | 1.660551217 | ||
2,782 | 3,831 | P(T<=t) two-tail | 0.361843325 | ||
4,256 | 3,613 | t Critical two-tail | 1.984467455 | ||
4,631 | 4,882 | ||||
4,550 | 3,592 | ||||
3,561 | 4,144 | ||||
4,261 | 4,138 | ||||
4,771 | 4,956 | ||||
3,780 | 2,730 | ||||
4,988 | 3,828 | ||||
2,798 | 2,888 | ||||
3,039 | 4,803 | ||||
4,445 | 4,612 | ||||
4,988 | 3,798 | ||||
3,927 | 4,269 | ||||
3,958 | 2,646 | ||||
5,093 | 4,837 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started