Question: 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
Get step-by-step solutions from verified subject matter experts
