Interpret the output from an appropriate test of hypothesis for a particular context.

This program uses Excel and https://www.lock5stat.com/StatKey/

"From the Psych_Data.xlsx dataset, use the ethnicity and therapy_prefvariables to determine whether there is evidence of a significant associationbetween ethnicity and preferred therapy method (individual, group, mixed).What type of hypothesis test will you run? State the Ho and Ha. Include an appropriate graphical display that allows you to visually assess the association between ethnicity and therapy preference. Copy/paste the graph here. Comment on any association that appears to be present.Give the test statistic, p-value, and decision from your test results (include Excel output).

ethnicity	therapy_pref
Asian	group
AfrAm	individual
AfrAm	individual
Hisp	individual
Hisp	individual
Hisp	mixed
Hisp	mixed
Cauc	mixed
Cauc	mixed
Cauc	group
Asian	group
Asian	group
AfrAm	group
AfrAm	group
Cauc	group
AfrAm	individual
Cauc	individual
Hisp	individual
Asian	individual
Cauc	individual
Hisp	mixed
AfrAm	mixed
Cauc	mixed
Hisp	group
Cauc	individual
Cauc	mixed
Cauc	mixed
Asian	mixed
AmInd	mixed
AfrAm	group
AfrAm	group
Hisp	group
Cauc	individual
Asian	individual
Cauc	individual
Hisp	individual
Cauc	mixed
Hisp	group
AfrAm	individual
Asian	individual
Hisp	individual
Asian	mixed
Hisp	mixed
AfrAm	group
AfrAm	group
Hisp	group
AfrAm	group
Hisp	individual
Cauc	individual
Hisp	group
Asian	group
Asian	group
Cauc	mixed
Cauc	mixed
Cauc	mixed
Hisp	individual
Hisp	individual
Asian	mixed
AfrAm	mixed
Hisp	group
Cauc	group
Asian	group
AfrAm	group
Asian	individual
AfrAm	individual
Cauc	mixed
Hisp	mixed
Cauc	mixed
Hisp	group
AfrAm	group
AfrAm	individual
Hisp	mixed
AfrAm	mixed
Cauc	group
Cauc	mixed
AfrAm	group
AmInd	group
Hisp	individual
Hisp	individual
Hisp	mixed
Cauc	individual
AfrAm	mixed
AfrAm	individual
AfrAm	mixed
Cauc	group
Cauc	mixed
Hisp	group
AfrAm	group
AfrAm	mixed
AmInd	group
Cauc	group
AfrAm	individual
Asian	individual
Asian	individual
AmInd	mixed
Cauc	individual
AfrAm	individual
Cauc	mixed
Hisp	mixed
AmInd	group
AfrAm	group
Cauc	individual
AfrAm	mixed
AfrAm	mixed
AfrAm	mixed
AmInd	individual
Cauc	group
Cauc	mixed
Hisp	individual
Cauc	individual
AmInd	group
Asian	individual
Cauc	mixed
AfrAm	mixed
Cauc	individual
Hisp	individual
Hisp	individual
AmInd	group
Hisp	individual
Cauc	mixed
Hisp	individual
Cauc	individual
Cauc	group
AfrAm	individual
Cauc	individual
Cauc	group
AmInd	individual
Cauc	mixed
AfrAm	mixed
Asian	individual