After medically-supervised obese adults leave a six-month in-patient treatment program of diet and exercise to foster healthy weight loss, these patients are monitored as they transition back into their own homes. Clinical dieticians are curious if there is significant additional weight loss during the next month of home care. A random sample of 16 adults includes the following data, in pounds, which measures their weights immediately upon leaving the in-patient program (pre-test) and again after one month of home maintenance of the weight loss program (post-test).

Pre-Test	315	280	350	300	420	380	225	360
Post-Test	295	285	335	320	400	350	225	340

Pre-Test	295	360	240	305	310	255	300	360
Post-Test	280	345	245	320	300	250	305	360

At the 5% level of significance, test the claim. [COMMENTS & HINTS: Utilize the test sheet and keep it handy when answering these questions.Note that this is one collection of matched pair data, with 16 pairs. The data isstacked to fit the page.Are the samples dependent or independent? Be sure to state the hypotheses in appropriate manners. To avoid tedious manual calculations, please utilize software or spreadsheets!

QUESTION 11: According to the spreadsheet output, what is the mean pre-test weight for the test subjects, rounded tothe nearest whole pound?

QUESTION 12: According to the spreadsheet output, what is the mean post-test weight for the test subjects, rounded tothe nearest whole pound?

QUESTION 14: According to the spreadsheet output, what is the value of the appropriate test statistic,rounded to three digits?

QUESTION 15: According to the spreadsheet output, what is the appropriate critical valuefor the research hypothesis and type of testing: one tail or two,rounded to three digits?

QUESTION 18: According to the spreadsheet output, what is the p-value,expressed as a percentagerounded to two decimal places without insignificant digits?

I have no idea how to get these using XLMiner Analysis ToolPak on Excel, I don't want the manual calculations. there's two data outputs so i'm not sure what to do. the sample size says 16 but there's 32 numbers so ??? help :(