trying to create a Right tailed test

H0:u=342,365

Ha:u 342,365

For a Right tailed test

Hypothesis Test Calculations:

[Determine the appropriate test statistic (t).]

This calculation is (mean - target)/standard error. In this case, the mean is your regional mean, and the target is the national mean.]

[Calculate the probability (pvalue).]

This calculation is done with the TDIST.2T function in Excel: =T.DIST.RT([test statistic], [degree of freedom]). The degree of freedom is calculated by subtracting 1 from your sample size.]

Interpretation

[Relate the pvalue and significance level.]

[Make the correct decision (reject or fail to reject).]

[Provide a conclusion in context to your hypothesis.]

Calculate the 95% confidence interval and show or describe the method of calculation.]

[Interpret the confidence 95% confidence interval in context.]

My Data

Mean	228994.1536
Median	215050
Mode	169950
Standard Deviation	79432.17347
Count	500

Cost Per Sq Ft 120 140 100 60 80 20 40 0 [$41, $53] ($53, $65] ($65, $77] ($77, $89] ($89, $101] ($101, $113] ($113, $125] Listing Prices of homes in the East South Central Region Liting Price ($125, $137] ($137, $149] ($149, $161] ($161, $173] ($173, $185] ($185, $197] ($197, $209] ($209, $221]Summary Statistics n Mean Median Std. Dev. Min D3 Max Listing 1,000 342,365 318,000 125,914 135,300 265,250 381,600 987,600 price (S Cost per 1,000 169 166 41 71 139 191 344 square foot ($) Square 1,000 2,111 1,881 921 1,101 1,626 2,215 6,516 feet This graph shows the frequency for listing price. Nation d Lating Prices Is 200 100 living price This graph shows the frequency for square feet. National Listing's Square Feet 300