Real Estate Data Hypothesis Test

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 just returned to the office with a newly designed advertisement. The average cost per square foot of home sales based on this advertisement is $280. The salesperson claims that the average cost per square foot in the Pacific region is less than $280. In other words, he claims that the newly designed advertisement would result in higher average cost per square foot in the Pacific Region. He wants you to make sure he can make that statement before approving the use of the advertisement. 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 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 the assignment. Briefly describe how you generated your random sample.

Use the House Listing Price by Region Spreadsheet document and the National Summary Statistics and Graphs House Listing Price by Region PDF documents to help support your work on this assignment (files provided).

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.
Identify your significance level.
Data Analysis Preparations: Describe sample summary statistics, provide a histogram and summary, check assumptions, and find the test statistic and significance level.
Provide the descriptive statistics (sample size, mean, median, and standard deviation).
Provide a histogram of your sample.
Describe your sample by writing a sentence describing the shape, center, and spread of your sample.
Determine whether the conditions to perform your identified test have been met.
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.
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.
Choose your test from the following:
=T.DIST.RT([test statistic], [degree of freedom])
=T.DIST([test statistic], [degree of freedom], 1)
=T.DIST.2T([test statistic], [degree of freedom])
Using the normal curve graph as a reference, describe where the p value and test statistic would be placed.
Test Decision: Discuss the relationship between the p value and the significance level, including a comparison between the two, and decide to reject or fail to reject the null hypothesis.
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: 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.

Research Paper 101
Calculate your paper price
Pages (550 words)
Approximate price: -

Reasons to trust Research Paper 101

On Time Delivery

We pride ourselves in meeting the deadlines of our customers. We take your order, assign a writer but allow some more time for ourselves to edit the paper before delivering to you. You are guaranteed a flawless paper on a timely manner...

24x7 Customer Live Support

Our team at Research Paper 101 is committed to handling your paper according to the specfications and are available 24*7 for communication. Whenever you need a quick help, you can talk to our writers via the system messaging or contact support via live chat and we will deliver your message instantly.

Experienced Subject Experts

Online Experts from Research Paper 101 are qualified both academically and in their experiences. Many are Masters and Phd holders and therefore, are qualified to handle complex assignments that require critical thinking and analyses...

Customer Satisfaction

We offer dissertation papers as per students’ wishes. We also help craft out the best topics and design concept papers. By ordering with us, you are guaranteed of defending and making through those hard faced professors in the defense panel!

100% Plagiarism Free

We at Research Paper 101 take plagiarism as a serious offence. From the start, we train our writers to write all their papers from scratch. We also check if the papers have been cited appropriately. Our website also has a tool designed to check for plagiarism that has been made erroniusly. In essense, the paper you get will be 100% legit...

Affordable Prices

We understand that being a student is very challenging, some students balance between work and studies in order to survive. We therefore offer pocket friendly rates that are very competitive in the market.

Try it now!

Calculate the price of your order

Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

No need to work on your paper at night. Sleep tight, we will cover your back. We offer all kinds of writing services.

Essays

Essay Writing Service

No matter what kind of academic paper you need and how urgent you need it, you are welcome to choose your academic level and the type of your paper at an affordable price. We take care of all your paper needs and give a 24/7 customer care support system.

Admissions

Admission Essays & Business Writing Help

An admission essay is an essay or other written statement by a candidate, often a potential student enrolling in a college, university, or graduate school. You can be rest assurred that through our service we will write the best admission essay for you.

Reviews

Editing Support

Our academic writers and editors make the necessary changes to your paper so that it is polished. We also format your document by correctly quoting the sources and creating reference lists in the formats APA, Harvard, MLA, Chicago / Turabian.

Reviews

Revision Support

If you think your paper could be improved, you can request a review. In this case, your paper will be checked by the writer or assigned to an editor. You can use this option as many times as you see fit. This is free because we want you to be completely satisfied with the service offered.

error:
Need help? Chat with Us