Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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

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_2

Step: 3

blur-text-image_3

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

Finite Math And Applied Calculus

Authors: Stefan Waner, Steven Costenoble

6th Edition

1285415132, 9781285415130

More Books

Students also viewed these Mathematics questions

Question

Describe a persuasive message.

Answered: 1 week ago

Question

Identify and use the five steps for conducting research.

Answered: 1 week ago

Question

List the goals of a persuasive message.

Answered: 1 week ago