Question: A study reports that recent college graduates from New Hampshire face the highest average debt of $31,048 (The Boston Globe, May 27, 2012). A researcher

A study reports that recent college graduates from New Hampshire face the highest average debt of $31,048 (The Boston Globe, May 27, 2012). A researcher from Connecticut wants to determine how recent undergraduates from that state fare.

He collects data on debt from 40 recent undergraduates. A portion of the data is shown in the accompanying table. Assume that the population standard deviation is $5,000.

Debt

24,040

19,153

29,329

a. Use Excel to construct the 95% confidence interval for the mean debt of all undergraduates from Connecticut.

b. Use the 95% confidence interval to determine if the debt of Connecticut undergraduates differs from that of New Hampshire undergraduates.

Step by Step Solution

3.58 Rating (169 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

a x 254706 Excel command AVERAGEA2A41 At 95 confidence ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Word file Icon

1140-M-S-P-E(1193).docx

120 KBs Word File

Students Have Also Explored These Related Statistics Questions!

Related Book