Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I interpret the result of a chitest? | Excel Discussion (Misc queries) | |||
How do I create and interpret a river diagram? | Charts and Charting in Excel | |||
How do I interpret a stock chart ? | Excel Discussion (Misc queries) | |||
How do I interpret Regression alanysed data ? | Excel Worksheet Functions | |||
Why does Excel interpret 2/29 as Feb 1st? | Excel Discussion (Misc queries) |