Question
Hello, I need help with this assignment, it is for Quantitative Analysis for Business. Could you also show how to do it on excel please?
Hello, I need help with this assignment, it is for Quantitative Analysis for Business. Could you also show how to do it on excel please?
Annual Cost of College.The increasing annual cost (including tuition, room, board, books, and fees) to attend college has been widely discussed in many publications includingMoneymagazine. The Excel file "CollegeCosts" shows random samples of the annual cost of attending private and public colleges. Data are in thousands of dollars.
a. D you use a T or a normal distribution? ( Do you know the population standard deviation of annual costs for both types of colleges?)
b. Are the samples matched or independent? (Are the samples made up of the same set of students?)
c. At the 5% level of significance, test whether there is a difference between the mean annual cost of attending private and public colleges. (notice you are testing for difference, not an increase or decrease. That should tell you whether you are to do two-tail or one-tail test).
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