MAT 240 Module 5-3 Assignment

.docx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

240

Subject

Economics

Date

Jan 9, 2024

Type

docx

Pages

6

Uploaded by EarlUniverse4683

Report
Hypothesis Testing for Regional Real Estate Company 1 Hypothesis Testing for Regional Real Estate Company Tiana Rodriguez Southern New Hampshire University
Hypothesis Testing for Regional Real Estate Company 2 Introduction The purpose of this analysis is to prove to the head of Regional Real Estate Company that the advertisement by said salesman is worth the average cost per square foot of home sales based on $280. In order to do so I must generate a random sample size of 750 houses using data for the Pacific region and use this data to perform a hypothesis test. I have used the rand function to be able to receive the most random data possible from smallest to largest. Hypothesis Test Setup The population Parameter of interest is the mean (average) price of houses in the Pacific region. The null hypothesis states that the population mean price of houses in the Pacific region is equal to the target value of $280,000. The alternative hypothesis states the population mean price of houses in the Pacific region is not equal to $280,000, this is the two-tailed test. I will perform a two-tailed t-test. Data Analysis Preparations The Sample summary consists of 750 houses from the Pacific Region. The sample mean and Target is $263,000, the median is $202,000 and the standard deviation is $159,000. The standard error is $5.81. The Histogram sample shows a normal distribution with a slightly skewed right tail. The center of the distribution is around $263,000 and the spread is about $159,000. The assumptions are
Hypothesis Testing for Regional Real Estate Company 3 based on the random selections, thus making it normally distributed, with the assumption of the population standard deviation unknown. We will use the significance level of 0.05. To calculate the p-value we use this equation (mean-target)/(standard error), while using the t-distribution and degree of freedom(749), we calculate the p-value. Calculations Excel Function Type of Test =T.DIST.RT([test statistic], [degree of freedom]) Right-tailed =T.DIST([test statistic], [degree of freedom], 1) Left-tailed =T.DIST.2T([test statistic], [degree of freedom]) Two-tailed [ Note: The degree of freedom is calculated by subtracting 1 from your sample size.]
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help