Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Essentials Of Measure Theory

Authors: Carlos S Kubrusly

1st Edition

3319225065, 9783319225067

More Books

Students also viewed these Mathematics questions

Question

What are the components of a decision support system?

Answered: 1 week ago

Question

Is it possible to jam CDMA? Explain clearly.

Answered: 1 week ago