Mall Of Elbonia Interview Results

One Sample Hypothesis Testing
I am working on a problem in Excel but I am having trouble with my T- Distribution. I am using the TDIST function but have been unsucessful in my calculations.

Here is the case scenario:

One hundred customers at the Mall of Elbonia (MoE) were given a brief interview as they concluded their shopping trips. Examine the resulting data in the Mall of Elbonia Interview Results file. For each customer (by row), the spreadsheet contains data on:

The customer's gender.
How long the customer spent in the mall.
How much he or she spent on food and clothing purchases.
The customer's rating of the mall's friendliness and attractiveness.

A.) MoE's concessions manager believes the average amount that