in excel

B A G H 1 Based on the 2020 data, annual expenditure for prescription drugs was $800 per person in the Southwest of the country 2 Northeast sample data of 70 peope showed that the annual expenditure for prescription drugs is $765 per person. 3 Use a population standard deviation of $300 to answer the following questions 4 a. Formulate hypotheses for a test to determine whether the sample data support the conclusion that 5 the population annual expenditure for prescription drugs per person is lower in the Northeast than in the Southwest 6 b. What is the value of the test statistic? 7 c. What is the p-value? 8 d. At a = .01, what is your conclusion? 9 10 11