Many regions in North and South Carolina and Georgia have experienced rapid population growth over the last 10 years. It is expected that the growth will continue over the next 10 years. This has motivated many of the large grocery store chains to build new stores in the region. The Kelley's Super Grocery Stores Inc. chain is no exception.The director of planning for Kelley's Super Grocery Stores wants to study adding more stores in this region. The director collected data on the amount families spend on groceries (in $1000) for a random sample of 25 families in the areas. Data can be found in file STORES.Test to determine if the mean amount families spend on groceries is different from $5,000 using a 5% level of significance.State the hypotheses, the test statistic and p-value. State the decision (whether to reject HO or not) and your conclusion in the context of the question.Explain each step to find the solution of the questions.Include screenshot of any excel output if any.

Amount spend on groceries 5.04 4.08 5.76 B.48 4.2 4.32 5.04 6.12 3.24 B.24 6.6 4.92 6.6 LD 8.36 4.68 4.32 5.52 4.86 5.4 4.9