Is HDTV ownership related to quantity of purchases of other electronics? A Best Buy retail outlet collected the following data for a random sample of its recent customers. At α = .10, is the frequency of in-store purchases independent of the number of large-screen HDTVs owned (defined as 50 inches or more)?

In-Store Purchases Last Month
HDTVs Owned None One More Than One Row Total
None 13 14 13 40
One 18 31 31 80
Two or More 19 45 66 130
Column Total 50 90 110 250

1. Show how to calculate if it is independent, Please use excel formulas and, if using an external chart, indicate what to do and where to find values