MAT 240 Project Two Guidelines and Rubric

Competency

In this project, you will demonstrate your mastery of the following competency:

• Apply statistical techniques to address research problems
• Perform hypothesis testing to address an authentic problem

Overview

In this project, you will apply inference methods for means to test your hypotheses about the housing sales market for a region of the United States. You will use appropriate sampling and statistical methods.

Scenario

You have been hired by your regional real estate company to determine if your regions housing prices and housing square footage are significantly different from those of the national market. The regional sales director has three questions that they want to see addressed in the report:

1. Are housing prices in your regional market lower than the national market average?
2. Is the square footage for homes in your region different than the average square footage for homes in the national market?
3. For your region, what is the range of values for the 95% confidence interval of square footage for homes in your market?

You are given a real estate data set that has houses listed for every county in the United States. In addition, you have been given national statistics and graphs that show the national averages for housing prices and square footage. Your job is to analyze the data, complete the statistical analyses, and provide a report to the regional sales director. You will do so by completing the Project Two Template located in the What to Submit area below.

Directions

Introduction

1. Region: Start by picking one region from the following list of regions:
2. West South Central, West North Central, East South Central, East North Central, Mid Atlantic
3. Purpose: What is the purpose of your analysis?
4. Sample: Define your sample. Take a random sample of 500 house sales for your region.
5. Describe what is included in your sample (i.e., states, region, years or months).
6. Questions and type of test: For your selected sample, define two hypothesis questions (see the Scenario above) and the appropriate type of test for each. Address the following for each hypothesis:
7. Describe the population parameter for the variable you are analyzing.
8. Describe your hypothesis in your own words.
9. Identify the hypothesis test you will use (1-Tail or 2-Tail).
10. Level of confidence: Discuss how you will use estimation and confidence intervals to help you solve the problem.

1-Tail Test

1. Hypothesis: Define your hypothesis.
2. Define the population parameter.
3. Write null (Ho) and alternative (Ha) hypotheses. Note: For means, define a hypothesis that is less than the population parameter.
4. Specify your significance level.
5. Data analysis: Summarize your sample data using appropriate graphical displays and summary statistics and confirm assumptions have not been violated to complete this hypothesis test.
6. Provide at least one histogram of your sample data.
7. In a table, provide summary statistics including sample size, mean, median, and standard deviation. Note: For quartiles 1 and 3, use the quartile function in Excel:
8. =QUARTILE([data range], [quartile number])
9. Summarize your sample data, describing the center, spread, and shape in comparison to the national information (under Supporting Materials, see the National Summary Statistics and Graphs House Listing Price by Region PDF). Note: For shape, think about the distribution: skewed or symmetric.
10. Check the conditions.
11. Determine if the normal condition has been met.
12. Determine if there are any other conditions that you should check and whether they have been met. Note: Think about the central limit theorem and sampling methods.
13. Hypothesis test calculations: Complete hypothesis test calculations.
14. Calculate the hypothesis statistics.
15. Determine the appropriate test statistic (t). Note: This calculation is (mean target)/standard error. In this case, the mean is your regional mean, and the target is the national mean.
16. Calculate the probability (p value). Note: This calculation is done with the T.DIST function in Excel:
17. =T.DIST([test statistic], [degree of freedom], True) The degree of freedom is calculated by subtracting 1 from your sample size.
18. Interpretation: Interpret your hypothesis test results using the p value method to reject or not reject the null hypothesis.
19. Relate the p value and significance level.
20. Make the correct decision (reject or fail to reject).
21. Provide a conclusion in the context of your hypothesis.

2-Tail Test

1. Hypotheses: Define your hypothesis.
2. Define the population parameter.
3. Write null and alternative hypotheses. Note: For means, define a hypothesis that is not equal to the population parameter.
4. State your significance level.
5. Data analysis: Summarize your sample data using appropriate graphical displays and summary statistics and confirm assumptions have not been violated to complete this hypothesis test.
6. Provide at least one histogram of your sample data.
7. In a table, provide summary statistics including sample size, mean, median, and standard deviation. Note: For quartiles 1 and 3, use the quartile function in Excel:
8. =QUARTILE([data range], [quartile number])
9. Summarize your sample data, describing the center, spread, and shape in comparison to the national information. Note: For shape, think about the distribution: skewed or symmetric.
10. Check the assumptions.
11. Determine if the normal condition has been met.
12. Determine if there are any other conditions that should be checked on and whether they have been met. Note: Think about the central limit theorem and sampling methods.
13. Hypothesis test calculations: Complete hypothesis test calculations.
14. Calculate the hypothesis statistics.
15. Determine the appropriate test statistic (t). Note: This calculation is (mean target)/standard error. In this case, the mean is your regional mean, and the target is the national mean.]
16. Determine the probability (p value). Note: This calculation is done with the TDIST.2T function in Excel:
17. =T.DIST.2T([test statistic], [degree of freedom]) The degree of freedom is calculated by subtracting 1 from your sample size.
18. Interpretation: Interpret your hypothesis test results using the p value method to reject or not reject the null hypothesis.
19. Compare the p value and significance level.
20. Make the correct decision (reject or fail to reject).
21. Provide a conclusion in the context of your hypothesis.
22. Comparison of the test results: Revisit Question 3 from the Scenario section: For your region, what is the range of values for the 95% confidence interval of square footage for homes?
23. Calculate and report the 95% confidence interval. Show or describe your method of calculation.

Final Conclusions

1. Summarize your findings: In one paragraph, summarize your findings in clear and concise plain language.
2. Discuss: Discuss whether you were surprised by the findings. Why or why not?

You can use the following tutorial that is specifically about this assignment:

What to Submit

To complete this project, you must submit the following:

: Use this template to structure your report and submit the finished version as a Word document. Also submit your Excel file showing all steps and calculations used in the report.

Supporting Materials

The following resources may help support your work on the project:

Data Set:

Use this data for input in your project report.

Document:

Use this data for input in your project report.

Use these tutorials for support with the Excel functions you will use in the project:

• Tutorial:
• Tutorial:
• Tutorial:
• Tutorial:

Project Two Rubric

CriteriaExceeds ExpectationsMeets ExpectationsPartially Meets ExpectationsDoes Not Meet ExpectationsValueIntroduction: PurposeExceeds expectations in an exceptionally clear manner (100%)Provides the purpose of the report (85%)Shows progress toward meeting expectations, but with errors or omissions; areas for improvement may include missing or inaccurate samples or hypotheses (55%)Does not attempt criterion (0%)5Introduction: SampleN/ADescribes what is included in the defined random sample (i.e., states, regions, or the period of time used) (100%)Shows progress toward meeting expectations, but with errors or omissions; areas for improvement may include inaccurate or very limited descriptions of what is included in the random sample (55%)Does not attempt criterion (0%)5Introduction: Questions and Type of TestExceeds expectations in an exceptionally clear and insightful manner (100%)Describes the population parameter, two hypothesis questions, and identifies the type of test for each for the defined random samples (85%)Shows progress toward meeting expectations, but with errors or omissions; areas for improvement may include missing or inaccurate descriptions, definitions, or questions (55%)Does not attempt criterion (0%)5Introduction: Level of ConfidenceExceeds expectations in an exceptionally clear, insightful, or sophisticated manner (100%)Discusses how estimation and confidence intervals will be used to help solve the problem (85%)Shows progress toward meeting expectations, but with errors or omissions; areas for improvement may include missing or inaccurate examples of how estimation and confidence intervals will be used to help solve the problem (55%)Does not attempt criterion (0%)101-Tail Test: HypothesisN/ADefines the hypothesis by defining the population parameter, writing null and alternative hypotheses, and specifying the significance level (100%)Shows progress toward meeting expectations, but with errors or omissions; areas for improvement may include missing or inaccurate definitions and specifications (55%)Does not attempt criterion (0%)51-Tail Test: Data AnalysisExceeds expectations in an exceptionally clear, insightful, or sophisticated manner (100%)Summarizes sample data using appropriate graphical displays and summary statistics, and checks the assumptions by determining if the normal condition has been met, along with other conditions, and compares with national information (85%)Shows progress toward meeting expectations, but with errors or omissions; areas for improvement may include inaccurate or insufficient analyses, summaries, or condition checks (55%)Does not attempt criterion (0%)51-Tail Test: Complete Hypothesis Test CalculationsN/ACompletes the hypothesis test calculation (100%)Shows progress toward meeting expectations, but with errors or omissions; areas for improvement may include inaccurate or inappropriate calculations, statistics, and/or graphs (55%)Does not attempt criterion (0%)51-Tail Test: InterpretationExceeds expectations in an exceptionally clear, insightful manner (100%)Interprets hypothesis test results using the p value method to reject or not reject the null hypothesis by relating the p value and significance level, making the correct decision to reject or fail to reject, and providing a contextualized conclusion (85%)Shows progress toward meeting expectations, but with errors or omissions; areas for improvement may include inaccurate or insufficient interpretations or conclusions (55%)Does not attempt criterion (0%)52-Tail Test: HypothesesN/ADefines the hypothesis by defining the population parameter, writing null and alternative hypotheses, and stating the significance level (100%)Shows progress toward meeting expectations, but with errors or omissions; areas for improvement may include missing or inaccurate definitions and specifications (55%)Does not attempt criterion (0%)52-Tail Test: Data AnalysisExceeds expectations in an exceptionally clear, insightful, or sophisticated manner (100%)Summarizes sample data using appropriate graphical displays and summary statistics, and checks the assumptions by determining if the normal condition has been met, along with other conditions (85%)Shows progress toward meeting expectations, but with errors or omissions; areas for improvement may include inaccurate or insufficient analysis, summaries, or condition checks (55%)Does not attempt criterion (0%)52-Tail Test: Hypothesis Test CalculationsN/ACompletes the hypothesis test calculation (100%)Shows progress toward meeting expectations, but with errors or omissions; areas for improvement may include inaccurate or inappropriate calculations, statistics, and/or graphs (55%)Does not attempt criterion (0%)52-Tail Test: InterpretationExceeds expectations in an exceptionally clear, insightful manner (100%)Interprets hypothesis test results using the p value method to reject or not reject the null hypothesis by relating the p value and significance level, making the correct decision to reject or fail to reject, and providing a contextualized conclusion (85%)Shows progress toward meeting expectations, but with errors or omissions; areas for improvement may include inaccurate or insufficient interpretations or conclusions (55%)Does not attempt criterion (0%)102-Tail Test: Comparison of the Test ResultsN/ACalculates the 95% confidence interval and describes method of calculation (100%)Shows progress toward meeting expectations, but with errors or omissions; areas for improvement may include inaccurate calculations or interpretations (55%)Does not attempt criterion (0%)5Final Conclusions: Summarize Your FindingsExceeds expectations in an exceptionally clear, insightful, sophisticated manner (100%)Summarizes findings in clear and concise plain language (85%)Shows progress toward meeting expectations, but with errors or omissions; areas for improvement may include inaccurate or insufficient interpretations and/or conclusions (55%)Does not attempt criterion (0%)10Final Conclusions: DiscussExceeds expectations in an exceptionally clear, insightful, or sophisticated, manner (100%)Discusses whether the findings were surprising and why (85%)Shows progress toward meeting expectations, but with errors or omissions; areas for improvement may include providing more details and evidence to support the response (55%)Does not attempt criterion (0%)10Clear CommunicationExceeds expectations with an intentional use of language that promotes a thorough understanding (100%)Consistently and effectively communicates in an organized way to a specific audience (85%)Shows progress toward meeting expectations, but communication is inconsistent or ineffective in a way that negatively impacts understanding (55%)Shows no evidence of consistent, effective, or organized communication (0%)5Total:100%