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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!