Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 947
Default 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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I interpret the result of a chitest? Anne Excel Discussion (Misc queries) 1 May 22nd 08 04:44 PM
How do I create and interpret a river diagram? Roland Wagner Charts and Charting in Excel 1 April 15th 08 07:34 PM
How do I interpret a stock chart ? andley Excel Discussion (Misc queries) 1 July 26th 07 07:41 PM
How do I interpret Regression alanysed data ? Jay Excel Worksheet Functions 1 January 25th 07 04:57 AM
Why does Excel interpret 2/29 as Feb 1st? Jo Excel Discussion (Misc queries) 6 February 26th 05 06:06 PM


All times are GMT +1. The time now is 12:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"