Determine and interpret the P-Value
 

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.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200902/1

Determine and interpret the P-Value
 

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

roystonteo wrote:
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.

--
Message posted via http://www.officekb.com

Determine and interpret the P-Value
 

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

roystonteo via OfficeKB.com wrote:
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

roystonteo wrote:
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.