Assignment -No Plagiarism PLEASE read before accepting assignment. Assignment is Due Sunday, October 18, 2015 by 1pm EST
Hypothesis Testing
Hypothesis
The formal testing of hypothesis is a critical step not to be ignored. One of the jobs of statistics is to reduce the uncertainty in our decision making. It does so by helping to identify assumptions and check the validity, in essence, what is really there. It is my personal preference to evaluate stocks or mutual funds to see if they actually exceed the average market return of 10%. The 10% return is the historical return on stocks over the past 75 years, however, each year has its own unique return. When doing so, I am interested in did this mutual fund exceed the 10% annual return. When you look at hypothesis testing there are three ways you can set them up. There are as follows:
HO: = H1: not equal Word In story problem: Is Different
Ho: < or = H1: is greater than Word In story problem: more than, increased
HO: > or = H1: Is less than Word In story problem: decreased, dropped
The hypothesis come in “pre-packaged sets” so you can’t mix and match. So when you are setting them up, look at the alternative (H1) in setting them up. Many times this is the decision that interests you the most. In this case, I wanted returns that exceeded ten percent, so I looked at the alternative hypothesis of greater than when setting up the process. What is helpful in thinking about the hypothesis and alternative hypothesis are the unique qualities of the null or HO, hypotheses. The HO hypothesis has unique characteristics. The unique characteristics is that you assume there to either be “no difference” or status quo. So, I set the hypothesis up as follows:
HO: return is less than or equal to ten percent
H1: return is greater than ten percent
For the hypothesis test, I could have chosen to have it set up two other ways and those are:
HO: the return is equal to ten percent
H1; the return is not equal to ten percent
HO: The return is greater than or equal to ten percent
H1: The return is less than ten percent.
What is helpful in thinking about the hypothesis and alternative hypothesis are the unique qualities of the null or HO, hypotheses. The HO hypothesis has unique characteristics. The unique characteristics are that you assume there to either “no difference” or status quo. In the stating of HO there is always an implied equal. To help you understand this concept lets take a trip to the local vending machine.
Hypothesis Test Thinking and a Vending Machine
Imagine yourself walking up to a vending machine. You want to purchase a bottle of Pepsi for a $1.00. You walk up to the vending machine and assume you are going to put your dollar in the machine, press the Pepsi button, and the machine will dispense the bottle of Pepsi. Do you walk up to the machine, knowing that it is not going to give you your bottle of Pepsi after you insert your dollar? If so, would you proceed with the transaction. No you wouldn’t make the transaction and willingly lose your dollar. You assume that as you approach the machine and put your money in that you will receive your Pepsi because that is what has happened time after time, this is the “status quo” segment of the hypothesis. Now, when the machine doesn’t give you your Pepsi but keeps your dollar, you REJECT the hypothesis that this machine is fair and ACCEPT the alternative hypotheses that this machine has stolen my money and is a crooked machine. Now that you know about the formal hypothesis, let’s look at the rest of the procedure to separate fact from fiction.
Remaining Hypothesis Testing Steps
Decision Rule:
The remaining steps are to set up the rules and check our results. We set our rules up ahead of time so as not to be unduly influenced by the results. So, we decide on a level of significance. This is a significant level because it determines the point at which we either accept or reject our null hypothesis. The levels are normally.10, .05 or .01. These are similar to purchasing a Pepsi in a small, medium or large, sorry; we don’t have a super size in statistics. When choosing the levels of significance, one can look at industry norm or you can choose any one of the three. Normally, the .05 level of significance is chosen because this is middle ground. So we chose the .05 level of significance.
Test Statistic
The next step is to calculate our “test statistic”. This is the statistic that our computer software generates for us. This is most easily expressed in probability or what is normally called the “P” value. The “P” stands for probability and can be thought of this way. If the “true average”, the average that is really there, not our sample results, the probability of getting a sample average which we found, is some value. Lets say that we were testing the hypothesis that our mutual fund return is less than or equal to ten percent and we input our data, test the hypothesis at the .05 level of significance. The computer software calculates a “P value” of .15. A .15 value is greater than the .05 level of significance and so we don’t reject our hypothesis and conclude the stock we are looking at has a return less than or equal to 10%. However, if the “ P value” calculated from the computer program was .04; we would have rejected the null hypothesis and concluded that the average return of this mutual fund was greater than ten percent.
Side Note: if the “P or probability value calculated “is less than the level of significance, we reject the null hypothesis and accept the alternative. We do this because we are saying that if the null hypothesis is true, the probability of getting a sample average with this result is less than the decision rule statistic.
Decision:
The decision is where you compare the probability value calculated against the critical probability value set in your decision rule. If your test probability value is less than the critical, reject the null hypothesis and accept the alternative hypothesis. The P value testing allows for you to be slightly confident, if is just on the border line of accept or reject to very confident if the probability value is very small such as .001 (1/1000)
You may need to double check your values and if unsure, you can ask yourself do I want a 5% raise or do I want a .1% raise. This is a simple way of keeping your decision correct and not confusing the decision because you misinterpreted the p values size.
Traditional Approach
In 2004, a small dealership leased 21 Chevrolet Impalas on two year leases. When the cars were returned in 2006, the mileage recorded was (see table). Is the dealers mean significantly greater than the national average of 30,000 miles for two year leased vehicles at the 10% level of significance?
T value = 21-1 = 20 , one tailed test, .10 level of significance = 1.325
HO: The average miles is less than or equal to 30,000
H1: The average miles are greater than 30,000
Decision Rule: If the T value calculated is greater than 1.325, reject HO
Test Statistic: T= ( 33,950-30,000)/ (11,866/√21)
= ( 33,950-30,000)/ (11,866/4.58)
= 3,950/ 2,590
T value =1.52
Decision: Since the Test statistic of 1.52 is greater than the T critical value of 1.325, we reject HO and conclude the cars have more mileage.
P value Approach
HO: The average miles is less than or equal to 30,000
H1: The average miles are greater than 30,000
Decision Rule: If the P value calculated is less than .10, reject HO
Test Statistic: .071
Decision: Since the Test statistic of .071 is less than the P critical value of .10, we reject HO and have weak evidence to conclude the cars have more mileage. For if the HO was true that the cars had less than or equal to 30,000 miles, the probability that you would have randomly found a sample average of 33,950 is 7.1%, therefore, it is possible but not probable.
Excel for Single Mean Hypothesis Test
Situation: I am looking to invest my time or money and a considering investing in a mutual fund and I want to know does this fund exceed the 10% annual return, which is the historical average stock market.
Step One
You will first need to open up the file or add the data into columns and be sure to have column headings as this will make it easier for you to know which column you want to highlight.
( Megastat is under add- ins )Step Two
You will not need to move your cursor up to the section where it has add ins as this is where you’ll find access to Megastat assuming you have downloaded Megastat.
( Megastat )Step Three
When you click on add-ins you will see Megastat displayed. Click on Megastat.
Step Four
(
Hypothesis tests
and commands
)
When you click on mega-stat you’ll find a drop-down menu listing multiple statistical procedures. This is where you will find access to all the statistical commands that you need to do.
Step Five
(
Test
chosen
)
You are doing a single meaning hypothesis test therefore you choose the first option Mean vs Hypothesize value because you only have one sample, and you are using the results of this to compare it against the hypothesized value for status quo or no difference in a situation. In this case, the long term average for stocks is 10% return.
Step Six
(
Step one data
)
Your first step is to move your cursor and highlight the data that you’ll want to enter into this box. This is where you are going to tell the computer to find your data.
Step Seven
(
Cells selected
) (
Data entry range
)
To choose your data simply highlight the data cells and if you have column headings you can include the column heading for it will add the heading title in the test results. The data for the New Perspective Return has been highlighted and you’ll see the corresponding cell references in the box.
Step Eight
(
Choose a test
) (
Mean Tested
) (
H1
) (
Level of significance
)
The next step is to enter what the hypothesized mean or average is for the problem. In this situation the mean is the 10% or 10. Since the sample size Is less than 30, I’ve chosen the T test.
The test HO, H1 and Decision Rule are defined
HO: The mean is equal to ten (ten goes into the hypothesized mean box)
H1: The mean is not equal to ten (not equals goes into the H1 Box)
Level of significance = .05 this goes with the 95% confidence interval box.
Note” 100% - 95% = 5%( level of significance but megastat wants you to give it the information in terms of a confidence interval.)
Step Nine
( Sample average )The final tennis is interpreting the output. For learning purposes, the entire hypothesis test will be completed to enable you to see for all of the pieces come from in the test.
|
Hypothesis Test: Mean vs. Hypothesized Value |
|||||
|
|
|
|
|
|
|
|
|
( HO Value )10.00000 |
hypothesized value |
|
|
|
|
|
14.07300 |
mean New Perspective Return in % |
|||
|
|
19.18708 |
std. dev. |
|
|
|
|
|
6.06749 |
std. error |
|
|
|
|
|
10 |
n |
|
|
|
|
|
9 |
df |
|
|
|
|
|
|
|
|
|
|
|
|
0.671 |
t |
( Test Statistic ) |
|
|
|
|
.2594 |
p-value (one-tailed, upper) |
|
||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
HO: The mean is less than or equal to ten
H1: The mean is greater than ten
Decision Rule: If the probability value calculated is less than .05, reject HO
Test Statistic: P value .2594
Decision: Since the probability value calculated of .2594 is larger than the critical value of .05, we fail to reject the null and conclude the return on the fund is less than or equal to 10. For if the HO was true that the average return on the fund is less than or equal to 10 then the probability you would have randomly found a sample average of 14.07 is 25.94% therefore is it possible and probable
0
.
4
0
.
3
0
.
2
0
.
1
0
.
0
X
D
e
n
s
i
t
y
D
i
s
t
r
i
b
u
t
i
o
n
P
l
o
t
N
o
r
m
a
l
,
M
e
a
n
=
0
,
S
t
D
e
v
=
1