[Solved] Prof Double R

Assignment Prompt & Instructions

## Scenario
You have been hired by the Regional Real Estate Company to help them analyze real estate data. One of the company’s Pacific region salespeople is working to design a new advertisement. The initial draft of the advertisement states that the average cost per square foot of home sales in the Pacific region is $280. The salesperson claims that the average cost per square foot in the Pacific region is less than $280.  He wants you to make sure he can make that statement (that the average cost per square foot is less than $280) before asking for the advertisement text to be changed. In order to test his claim, you will generate a random sample size of 750 using data for the Pacific region and use this data to perform a hypothesis test.
## Prompt
Generate a sample of size 750 houses using data for the Pacific region. Then, design a hypothesis test and interpret the results using significance level α = .05. You will work with this sample in this assignment. Briefly describe how you generated your random sample.
Use the [House Listing Price by Region](https://learn.snhu.edu/content/enforced/1923642-MAT-240-17909.202551-1/course_documents/MAT%20240%20House%20Listing%20Price%20by%20Region.xlsx?ou=1923642) document to help support your work on this assignment. You may also use the [Descriptive Statistics in Excel PDF](https://learn.snhu.edu/content/enforced/1923642-MAT-240-17909.202551-1/course_documents/MAT%20240%20Descriptive%20Statistics%20in%20Excel.pdf?isCourseFile=true&ou=1923642) and [Creating Histograms in Excel PDF](https://learn.snhu.edu/content/enforced/1923642-MAT-240-17909.202551-1/course_documents/MAT%20240%20Creating%20Histograms%20in%20Excel.pdf?ou=1923642) tutorials for support.
Specifically, you must address the following rubric criteria, using the [Module Five Assignment Template Word Document](https://learn.snhu.edu/content/enforced/1923642-MAT-240-17909.202551-1/course_documents/MAT%20240%20Module%20Five%20Assignment%20Template.docx?isCourseFile=true&ou=1923642)
– **Introduction:** Describe the purpose of this analysis and how you generated your random sample size of 750 houses.
– **Hypothesis Test Setup:**Define your population parameter, including hypothesis statements, and specify the appropriate test.
– Define your population parameter.
– Write the null and alternative hypotheses.
– Specify the name of the test you will use.
– Identify whether it is a left-tailed, right-tailed, or two-tailed test.
– **Data Analysis Preparations:**Describe sample summary statistics, provide a histogram and summary, check assumptions, and identify the test significance level.
– Provide the descriptive statistics (sample size, mean, median, and standard deviation).
– Provide a histogram of your sample.
– Summarize your sample by writing a sentence describing the shape, center, and spread of your sample.
– Check whether the assumptions to perform your identified test have been met.
– Identify the test significance level. For example, α = .05.
– **Calculations:** Calculate the _p_ value, describe the _p_ value and test statistic in regard to the normal curve graph, discuss how the p value relates to the significance level, and compare the _p_ value to the significance level to reject or fail to reject the null hypothesis.
– Calculate the sample mean and standard error.
– Determine the appropriate test statistic, then calculate the test statistic.
– **Note:** This calculation is (mean – target)/standard error. In this case, the mean is your regional mean (Pacific), and the target is 280.
– Calculate the _p_ value using one of the following tests.
– **Choose your test from the following:**
– **=T.DIST.RT([test statistic], [degree of freedom])**: right-tailed test
– **=T.DIST([test statistic], [degree of freedom], 1)**: left-tailed test
– **=T.DIST.2T([test statistic], [degree of freedom])**: two-tailed test
– **Note:** The degree of freedom is calculated by subtracting 1 from your sample size.
– Using the normal curve graph as a reference, describe where the p value and test statistic would be placed.
– **Test Decision:**Compare the relationship between the p value and the significance level, and decide to reject or fail to reject the null hypothesis.
– Compare the relationship between the _p_ value and significance level.
– Decide to reject or fail to reject the null hypothesis.
– **Conclusion:**Discuss how your test relates to the hypothesis and discuss the statistical significance.
– Explain in one paragraph how your test decision relates to your hypothesis and whether your conclusions are statistically significant.
## What to Submit
Submit your completed Module Five Assignment Template as a Word document that includes your response, supporting charts/graphs, and your Excel file.
\
MAT240ModuleFiveAssignmentTemplate.docx](https://www.sweetstudy.com/files/mat240modulefiveassignmenttemplate-docx-10310927 "MAT240ModuleFiveAssignmentTemplate.docx")
\
MAT240HouseListingPricebyRegion.xlsx](https://www.sweetstudy.com/files/mat240houselistingpricebyregion-xlsx-10310929 "MAT240HouseListingPricebyRegion.xlsx")