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).

File Home Insert Draw Page Layout Formulas Data Review View Help Share A = % Conditional Formatting O Clipboard Font Alignment Number Format as Table Cells Editing Analyze Sensitivity Data Cell Styles * Styles Analysis Sensitivity A Format as Table B13 X V 21. Quickly convert a range of cells to a A B C I table with its own style. H I J K Private Public 52.8 20.3 UJ 43.2 22.0 4 45.0 28.2 33.3 15.6 44.0 24.1 30.6 28.5 45.8 22.8 37.8 25.8 10 50.5 18.5 11 42.0 25.6 12 14.4 13 21.8 14