Description
This assignment is intended to test your knowledge of how to appropriately compare two means in Excel using a data file with student debt amounts (Case Study 3 - Data File - Fall 2021.xlsx Download Case Study 3 - Data File - Fall 2021.xlsx). The data file has 50 randomly selected student debt amounts from 2018 and 50 randomly selected student debt amounts from 2013. A university representative has asked you whether the sample data provide enough evidence to believe there is a difference between the debt amounts in the two years.
After watching the accompanying videos, read the instructions and fully address all questions (Case Study 3 - Fall 2021.pdf Download Case Study 3 - Fall 2021.pdf). Run all required analyses and submit them along with the data file in a single Excel workbook that shows all your output and provide responses to all of the questions in a Word document.
The homework is due on Sunday by 11:59pm of Week 5.
Resources:
Videos:
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Please view explanation and answer below.
Debt in 2018 (dollars)
3,287
4,031
5,028
4,939
4,555
2,792
2,658
2,756
3,422
4,431
4,034
4,310
4,782
3,363
2,858
3,665
4,453
4,778
...