Determine and interpret the P-Value

[roystonteo via OfficeKB.com]

Dear Experts,

I am new in this.
This is an sample question:

Past, patrons of a cinema complex have spent an average of $2.50 for popcorn
and other snacks, with a standard deviation of $0.90. The amounts of these
expenditures have been normally distributed. FOllowing an intensive publicity
campaign by a local medical society, the mean expenditure for a sample of 18
patronisis found to be $2.10. In a one-tail test at the 0.05 level of
significance, does this recent experience suggest a dedline in spending?
determine and interpret the p-value for the test.

Please help to advise.

 

[roystonteo via OfficeKB.com]

Anybody can give me his email, so i can send the spreadsheet to him for him
to help me to complete. Please quote me the amount to pay you if you are able
to solve this question

 

[Dana DeLouis]

Hi. I'll take a shot. I may be wrong thou.

I believe this is the standard reference point at 0.05...
=NORMINV(0.05,0,1)
-1.644853627

Now, for our data...

=(2.1-2.5)*SQRT(18)/0.9
-1.885618083

I believe that since -1.88 is less than -1.64, we can say there is
evidence of a decline in spending.

= = =
HTH :>)
Dana DeLouis