A finalcial analyst with Don and Luk & Jar is interested in the ratio of debt to total assets (as %) for corporations that have been assigned bond ratings of (1) Baa, (2) AA, and 3 (AAA) by a rating service. Random samples of debt to total assets (as %) for five, four and three corporations were taken from the Baa, AA and AAA ratings groups, respectively. The results....

Baa AA AAA

41 25 15

31 20 18

38 17 20

31 20

26

n 5 4 3

Xbar33.40 20.50 17.67

s 6.02 3.32 2.52

Test the average ratio of deby to total assets differs from 26. USe alphs=0.05

What is the Excel command appropriate to create the p-value associated with the test associated with the tes in part a?

PLEASE HELP<<< SO DESPERATE<3