Hypothesis testing I and II Responses
INSTRUCTIONS: Provide (2) 150 words response for RESPONSES 1 AND 2 below. Responses may include direct questions. In your first peer response post, look at the hypothesis test results of one of your classmates and explain what a type 1 error would mean in a practical sense. Looking at your classmate’s outcome, is a type 1 error likely or not? What specific values indicated this?
In your second peer response post, using your classmate’s values, run another hypothesis test using this scenario: A town official claims that the average vehicle in their area Does Not sell for 80th percentile of your data set. Conduct a four-step hypothesis test including a sentence at the end justifying the support or lack of support for the claim and why you made that choice. Note: this test will be different than the initial post, starting with the hypothesis scenario. Use alpha = .05 to test your claim.
Attached are the instructions or word and excel docs for both responses to help with the post.
RESPONSE 1:
Step 1: Use T-test to verify the claim. (No standard deviation) You will need to use the descriptive data from week 2.
What is the Null and Alternative Hypothesis?
Ho: µ = 40th percentile
Ha: µ > 40th percentile
“A town official claims that the average vehicle in their area sells for more than the 40th percentile of your data set.”
- To find this calculation we will use the function =PERCENTILE.INC ()
=PERCENTILE.INC (E3:E12,0.4) I tried to just put the mean down, but I didn’t get the same results.
My 40th percentile is 46658
So now my Null and alternative hypothesis is:
Ho: µ = 46658
Ha: µ > 46658
Step 2: Calculate the test statistic: ???????? = ????̅− ????/ ???? √n
- From the data we have from excel
????= (Hypothesis Mean)
????̅ =56813.7 (Mean of sample)
n= 10 (sample)
s= 33061.487 (standard Deviation)
Step 3: Calculate the P-Value.
- To calculate the function for P-value you need =T. DIST.RT() but this is considered a right tailed test.
Next: Degrees of Freedom (DF)=n-1 (10-1=9)
- My P-Value = T. DIST.RT(0.9704,9) = 0.1786
According to the problem the problem given, the alpha α is 0.05, any my P-value is 0.1786. This means that 0.1786>0.05 (P-value is more than alpha α). So according to the data, we fail to reject the null hypothesis, because P-value is more than alpha α. There isn’t enough data to support the claim, that the average vehicle sells more than the 40th percentile.
(P.S. My new numbers are in Blue and Yellow.) PLEASE FEEDBACK IT WELCOME!!!!
RESPONSE 2:
For this week’s discussion I am conducting a t-test. I am conducting a t-test because the sample size is less than thirty and the variance is unknown. We were asked to test the hypothesis that the average vehicle in our vehicle spreadsheets would sell for more than the 40th percentile of our data set. For this test, alpha is 0.05. Here is my four-step hypothesis test:
Step 1: The Hypothesis Scenario
H₀: µ=c or H₀: µ=7690.2
Hₐ: µ>c or Hₐ: µ>7690.2
Based on the use of ‘>’ we know we are using a right tailed test.
Step 2: T-Test Statistic
???????? = (????̅− ????)/(????/√n)*
TS = (18588-7690.2)/6985.884873
TS = 1.560002805
*(????/√n) is the equation for Standard Error which can be found in excel using “=’Standard_Deviation’/SQRT(n) where n is the sample size of 10.
Step 3: P Value
Being a right tailed test, we used the Excel function ‘=T.DIST.RT(TS,n-1)”.
P Value =T.DIST.RT(1.560002805,10-1)
P Value = 0.076595373
Step 4: Conclusion
a) Our P Value is greater than alpha. p>α. 0.0766>0.05.
b) Due to our P Value being greater than alpha, we failed to reject the null hypothesis.
c) There is not enough evidence to support the claim that the average vehicle in the spreadsheet would sell for more than the 40th percentile.
-Andrew
Sheet1
VEHICLE CLASS | YEAR | MAKE | MODEL | TRADE IN VALUE | MPG (city) | MPG (hw) | COMBINED | Tank Size (Gal.) | Fuel Economy* | |||||||||
Pickup | 20 | 17 | Ford | F-150 XLT | $ | 25 | 18 | 23 | 460 | |||||||||
Sedan | 2013 | Dodge | Dart Rallye | $7,428 | 36 | 29 | 15.8 | 458.2 | ||||||||||
2015 | GMC | Sierra 1500 SLE | $11,390 | 14 | 19 | 16 | 26 | 41 | ||||||||||
2012 | Fusion SE | $7,865 | 33 | 17.5 | 455 | |||||||||||||
Station Wagon | VW | Jetta SportWagon TDI | $9, | 10 | 37 | 32 | 14.5 | 464 | ||||||||||
Hatchback | 2017 | Mitsubishi | Mirage ES | $7,328 | 9.2 | 331 | ||||||||||||
2010 | Kia | Optima LX | $5,445 | 22 | 16.4 | 410 | ||||||||||||
Coupe | 2018 | Challenger R/T | $27,678 | 18.5 | 351.5 | |||||||||||||
2004 | Sonoma SLS | $6,823 | 272 | |||||||||||||||
SUV | 2019 | Tesla | Model X Long Range | $77,255 | 99e | 93e | 96e | N/A | 371** | |||||||||
Qualitative | Quantitative | Quantatative | ||||||||||||||||
*Fuel Economy = Tank Size x Combined MPG | ||||||||||||||||||
**The Tesla Model X Long Range SUV is a fully electric car and does not use gasoline | ||||||||||||||||||
Mean (x): | $18,588 | Step 1: | H0: µ=c | H0: µ= | 7690.2 | |||||||||||||
Median: | $8,487 | Ha: µ>c | Ha: µ>7690.2 | |||||||||||||||
Standard Deviation: | 22091.3076711684 | Alpha: | 0.05 | |||||||||||||||
Sample Size (n): | Standard Error: | 6985.8848732442 | ||||||||||||||||
p (success) | 0.70 | Step 2: | T-test Statistic: | 1.5600028053 | ||||||||||||||
q (failure) | 0.30 | Step 3: | p-value: | 0.0765953732 | ||||||||||||||
40th Percentile (c): | Step 4a: | p>α | 0.0766>0.05 | |||||||||||||||
Step 4b: | Failed to reject null hypothesis. | |||||||||||||||||
Step 4c: | There is not enough evidence to support the alternative hypothesis. |
Sheet1
Vehicles Ty | p | Year | Make | Mode | Price | MPG (City) | MPG (Highway) | Drive Type | |||||||||
Qualitative | Quantitative | ||||||||||||||||
SUV | 2 | 0 | 21 | Hyundai | Genesis GV80 | $ 48, | 9 | All Wheel Drive | |||||||||
Hybrid/SUV | 2021 | Lexus | GX | $ 58,665.00 | 16 | ||||||||||||
Coupe | 201 | 7 | Honda | Accord EX | $ 16,791.00 | 27 | 36 | 2 Wheel Drive-Front | |||||||||
2014 | Chevrolet | Corvette | $ 38,990.00 | 15 | 23 | 2 Wheel Drive-rear | |||||||||||
Coupe | 2020 | Toyota | Supra | $ 52,777.00 | 24 | 31 | |||||||||||
Volkswagen | Atlas | $ 43,320.00 | 22 | ||||||||||||||
Sedan | BMW | M340i | $ 50,998.00 | 30 | |||||||||||||
Camaro LT | $ 27,996.00 | 19 | 29 | ||||||||||||||
M8 | $ 119,994.00 | ||||||||||||||||
Nissan | GT-R | $ | 10 | ||||||||||||||
Sports Car | 2006 | Maserati | BirdCage 75th | $ 3,000,000.00 | 12 | ||||||||||||
Before Adding Outlier DATA | |||||||||||||||||
Mean | $ 56,813.70 | 25.5 | |||||||||||||||
Median | $ 49,949.00 | 17.5 | 22.5 | ||||||||||||||
STD: | 33061.4874137736 | 4.18993503 | 5.5226805086 | ||||||||||||||
After Adding Outlier Data | |||||||||||||||||
$ 324,376.09 | 17.9090909091 | 24.2727272727 | |||||||||||||||
887958.174169195 | 5.375026427 | 6.6346199453 | |||||||||||||||
56,813,70 | Average under 6 | ||||||||||||||||
0.6 | |||||||||||||||||
q | 0.4 | ||||||||||||||||
P(x=4) | 11.15% | Exactly 4 | |||||||||||||||
P(x<5) = P (x ≤ 5-1) = P(x ≤ 4) | 16.62% | Fewer than 5 | Hypothesis testing | Hypothesis Testing | |||||||||||||
P (x > 6)=1-p(x≤ 6)=1-p(x≤ 6) | 38.23% | More than 6 | |||||||||||||||
P(x≥4)=1-P(x≤ 4-1)=1-P(x≤ 3) | 94.52% | At least 4 | 56813.7 | Ho: µ= 40th percentile | 46668 | <---=PERCENTILE.INC(E3:E12, 0.4) | |||||||||||
Standard Error | 10454.9603060514 | H1: µ ˃ 40th percentile | |||||||||||||||
49949 | |||||||||||||||||
Week 4 | ERROR:#N/A | Ho: µ= 46668 | |||||||||||||||
New SD | 16530.7437068868 | Standard Deviation | H1: µ ˃ 46668 | ||||||||||||||
1 P(X< 56,313) mean minus $500 | 0.4879351629 | (= 48.79%) | Sample Variance | 1093061950.01111 | |||||||||||||
Kurtosis | 0.6212725883 | Standard Error | <----(S/SQRT(n)) | ||||||||||||||
Skewness | 1.1655058341 | ||||||||||||||||
2 P(X>57,813) mean Add $1000 | 0.4758982201 | (=47.58%) | Range | 103203 | Test Statics | 0.9704197532 | <---(Mean-40th Percentile)/SE | ||||||||||
Minimum | 16791 | ||||||||||||||||
Maximum | 119994 | Degree of Freedom | <---- N-1 | ||||||||||||||
3 P(X=56,813) | 0.0000241334 | (= 0%) | Sum | 568137 | |||||||||||||
Count | P Value | 0.1785963689 | <----=T.DIS.RT(TEST STATICS, DF) | ||||||||||||||
Confidence Level(95.0%) | 23650.7633431052 | ||||||||||||||||
4 P(55,313 0.0723008289 |
(=7%) |
ALPHA = α |
0.5 |
| |||||||||||||
$ 55,313.70 | (mean minus 1500) | ||||||||||||||||
$ 58,313.70 | (mean add 1500) | ||||||||||||||||
PROPORTIONAL CONFIDENCE INTERVAL | |||||||||||||||||
MEAN = 56,813.70 | T CONFIDENCE INTERVAL | Z- critical values | |||||||||||||||
SD = 33061.48742 | T= | 2.2621571628 | p-hat * q-hat= | 1.9599639845 | |||||||||||||
n = 10 | SD/√n= | /n | 0.24 | ||||||||||||||
P = 0.6 | 95% CONFIDENCE LEVEL= | SQRT ( | 0.024 | ||||||||||||||
Q = 0.4 | UPPER CONFIDENCE LEVEL= | $ 80,464.46 | Z = | 0.1549193338 | |||||||||||||
LOWER CONFIDENCE LEVEL= | $ 33,162.94 | 0.3036363149 | |||||||||||||||
ALPHA = α (1-0.25=0.975) | 0.9036363149 | 90% | |||||||||||||||
degrees of freedom (DF) (10-1=9) | 0.2963636851 | 30% |
Sheet2 (W_O Supercar)
Column1 |
Ho: µ= 57593 |
H1: µ ˃ 57593 |
Sheet 3 (With SuperCar)
With Supercar |
351923.7 |
294415.077482457 |
51887.5 |
931022.222339516 |
866802378490.011 |
9.965500215 |
3.1549042033 |
2983209 |
3000000 |
3519237 |
666013.176362728 |
INSTRUCTIONS: Provide (2) 150 words response for RESPONSES 1 AND 2 below. Responses may include direct questions. In your first peer response post, look at the hypothesis test results of one of your classmates and explain what a type 1 error would mean in a practical sense. Looking at your classmate’s outcome, is a type 1 error likely or not? What specific values indicated this?
In your second peer response post, using your classmate’s values, run another hypothesis test using this scenario: A town official claims that the average vehicle in their area Does Not sell for 80th percentile of your data set. Conduct a four-step hypothesis test including a sentence at the end justifying the support or lack of support for the claim and why you made that choice. Note: this test will be different than the initial post, starting with the hypothesis scenario. Use alpha = .05 to test your claim.
Attached are the excel docs for both responses to help with the post.
RESPONSE 1:
Step 1:
Use T-test to verify the claim. (No standard deviation) You will need to use the descriptive data from week 2.
What is the Null and Alternative Hypothesis?
Ho: µ = 40th percentile
Ha: µ > 40th percentile
“A town official claims that the average vehicle in their area sells for more than the 40th percentile of your data set.”
· To find this calculation we will use the function =PERCENTILE.INC ()
· =PERCENTILE.INC (E3:E12,0.4) I tried to just put the mean down, but I didn’t get the same results.
· My 40th percentile is 46658
So now my Null and alternative hypothesis is:
Ho: µ = 46658
Ha: µ > 46658
Step 2: Calculate the test statistic: 𝑇𝑆 = 𝑥̅− 𝜇/ 𝑠 √n
· From the data we have from excel
· 𝜇= (Hypothesis Mean)
· 𝑥̅ =56813.7 (Mean of sample)
· n= 10 (sample)
· s= 33061.487 (standard Deviation)
Step 3: Calculate the P-Value.
· To calculate the function for P-value you need =T. DIST.RT() but this is considered a right tailed test.
· Next: Degrees of Freedom (DF)=n-1 (10-1=9)
· My P-Value = T. DIST.RT(0.9704,9) = 0.1786
According to the problem the problem given, the alpha α is 0.05, any my P-value is 0.1786. This means that 0.1786>0.05 (P-value is more than alpha α). So according to the data, we fail to reject the null hypothesis, because P-value is more than alpha α. There isn’t enough data to support the claim, that the average vehicle sells more than the 40th percentile.
(P.S. My new numbers are in Blue and Yellow.) PLEASE FEEDBACK IT WELCOME!!!!
RESPONSE 2:
For this week’s discussion I am conducting a t-test. I am conducting a t-test because the sample size is less than thirty and the variance is unknown. We were asked to test the hypothesis that the average vehicle in our vehicle spreadsheets would sell for more than the 40th percentile of our data set. For this test, alpha is 0.05. Here is my four-step hypothesis test:
Step 1: The Hypothesis Scenario
H₀: µ=c or H₀: µ=7690.2
Hₐ: µ>c or Hₐ: µ>7690.2
Based on the use of ‘>’ we know we are using a right tailed test.
Step 2: T-Test Statistic
𝑇𝑆 = (𝑥̅− 𝜇)/(𝑠/√n)*
TS = (18588-7690.2)/6985.884873
TS = 1.560002805
*(𝑠/√n) is the equation for Standard Error which can be found in excel using “=’Standard_Deviation’/SQRT(n) where n is the sample size of 10.
Step 3: P Value
Being a right tailed test, we used the Excel function ‘=T.DIST.RT(TS,n-1)”.
P Value =T.DIST.RT(1.560002805,10-1)
P Value = 0.076595373
Step 4: Conclusion
a) Our P Value is greater than alpha. p>α. 0.0766>0.05.
b) Due to our P Value being greater than alpha, we failed to reject the null hypothesis.
c) There is not enough evidence to support the claim that the average vehicle in the spreadsheet would sell for more than the 40th percentile.
-Andrew