I did the calculations/formulas, but I am having a hard time writing what I did based on the questions asked, can you help me.

INSERT PAGE LAYOUT MAILINGS REVIEW VIEW DESIGN REFERENCES Hypothesis Testing for Regional Real Estate Company Introduction [Include in this section a brief overview, including the purpose of this analysis.] Introduction [Briefly describe how you generated your random sample of size 750.] Setup I [Define your population parameter.] [Write the null and alternative hypotheses.] [Specify the name of the test you will use and identify whether it is a left-tailed, right- tailed, or two-tailed test.] Data Analysis Preparations [Describe the sample.] [Provide the descriptive statistics of the sample.] [Provide a histogram of the sample.] [Specify whether the assumptions or conditions to perform your identified test have been met.] [Identify the appropriate test statistic, then calculate the test statistic and identify your significance level.] Calculations [ Calculate the p value using one of the following tests: -T.DIST RT ([test statistic], [degree of freedom]) -T.DIST ([test statistic], [degree of freedom]) -T.DIST.2T([test statistic]. [degree of freedom])Hypothesis Testing for Regional Real Estate Company 3 Note: For right-tailed, use the T.DIST.RT function in Excel, left-tailed is the T.DIST function, and two-tailed is the T.DIST_2T function. The degree of freedom is calculated by subtracting 1 from your sample size.] I [Use the normal curve graph as a reference to describe where the p value and test statistic would be placed.] Test Decision [Discuss how the p value relates to the significance level.] [Compare the p value and significance level, and make a decision to reject or fail to reject the null hypothesis.] Conclusion [Explain in one paragraph how your test decision relates to your hypothesis and whether your conclusions are statistically significant.]House listing Cost per Square State Region price footage Random County square foot Population parameter being tested mean cost per square foot in the Pacific region $219,800 $105 2,085 0.93702642 WA whitman Pacific Let mu represent the mean cost per square foot in the Pacific region WN - CA placer $522,545 $224 2,334 0.17023463 Pacific 1,974 0.05707422 Mean cost per sqft based on the new advertisement:$280 $149 CA sutter Pacific $294,550 Claim: Mean cost per sqft in the Pacific region is less than $280 OR clackamas Pacific $498,236 $205 2,430 0.32305688 $347,550 $183 1,898 0.72193263 CA san joaquin Pacific Sample Mean: $243 1,760 0.14237657 7 coos Pacific $272,050 $155 OR Target: 280 8 OR umatilla Pacific $207,550 $111 1,876 0.18357557 sample_stdev/sqrt(n) 1,681 0.64559063 Standard Error: $5.75 9 CA butte Pacific $286,550 $171 (sample_mean-target)/std error 10 WA $649,050 2,000 0.20990585 Test Statistic 6.41 king Pacific $325 0.67104915 Degrees of Freedom 749 11 CA san mateo Pacific $1,271,950 $733 1,735 12 WA grays harbor Pacific $195,000 $128 1,527 0.23783552 13 CA sutter Pacific $340,050 $192 1,769 0.88579799 14 WA pierce Pacific $330,050 $155 2,128 0.81493184 Two Tailed Test 15 OR marion Pacific $397,450 $190 2,095 0.29357321 HO: u=280 16 CA sonoma Pacific $687,550 $383 1,794 0.85134261 H1: u # 280 1,966 0.30589523 P- value 0.00 Since the p-value 280 29 OR douglas Pacific $281,550 $152 1,853 0.02736839 P-value 30 WA clallam Pacific $398,121 $198 2,012 0.94159874 31 WA kitsap Pacific $379,994 $179 2,118 0.54429863 32 WA island Pacific $419,050 $206 2,039 0.74269772 33 CA kings Pacific $206,040 $124 1,659 0.37342775 Is the p-value less than the level of significance? 34 CA ake Pacific $299,050 $192 1,560 0.92990414 If yes; then reject the null hypothesis 35 HI maui Pacific $809,550 $614 1,319 0.41081511 If not: then do not reject the null hypothesis 36 WA yakima Pacific $289,300 $148 1,954 0.01556892 37 CA sutter Pacific $318,043 $170 1,871 0.58142717 38 OR columbia Pacific $324,444 $155 2,090 0.77472483 39 CA sacramento Pacific $362,500 $215 1,684 0.21753233 WA grays harbor Pacific $218,479 $146 1,494 0.44331039 ... South Atlantic East North Central East South Central Mountain Student (Pacific) Pacific West North Central READY West South Centralom 2642 Population parameter being tested mean cost per square foot in the Pacific region 3463 Let mu represent the mean cost per square foot in the Pacific region 7422 Mean cost per sqft based on the new advertisement:$280 688 Claim: Mean cost per sqft in the Pacific region is less than $280 263 557 Sample Mean: $243 557 Target: 280 63 Standard Error: $5.75 sample_stdev/sqrt(n) 85 Test Statistic -6.41 (sample_mean-target)/std error 15 Degrees of Freedom 749 52 34 Two Tailed Test HO: u=280 H1: u # 280 P- value 0.00 Since the p-value 280 P-value