This is the worksheet file:

It is an R- notebook. When you open it, you will be able to download the “Rmd” file.

Save it in a folder, Also save this file

in the same folder.

Complete Research on the 1996 Kentucky Wildcats Basketball Team. The team had a record of 34-2, and were the NCAA Division I National Champions. So, obviously, they were good. Your assignment is to find 5 descriptive stats to build a narrative and tell a story of the team. Write that in MS Word and submit it. Be sure to cite your source(s) in APA format.

Please refer to the uploaded file(s) for the assignment as well as the instructions and make certain to adhere to the instructions as Clearly stated. Thanks Module 2 Discussion Read pages 17-18 in the tutorial quick guide text found below. Provide an example of 2 null and 2 alternative hypotheses. Feel free to create the null and alternative hypotheses based on your dissertation topic if you wish. ******My dissertation topic is on Truancy*****

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:

Below are 2 discussion post and a homework assignment

discussion post needs 150 words minimum for each and are to be answered separately with references if needed.

Week 5 Discussion Question 1

You have the task of identifying a question and creating 2 to 3 variables to complete a mini study. In this mini study, you will have a question, and you will collect the data for these 2 to 3 variables that answer the question you identified.

1. The adults who are invested in you should have an official role: professor, coach, counselor, pastor, parents or similar position of support. If you have difficulty reaching 6 adults to collect data from, you can use accountability partners.

2. The goal of this mini study is to identify how these invested adults use data about you to determine how they feel about the variable you selected.

3. Also determine how they measure movement in the data.

3. You will need to collect this data in a table or an Excel spreadsheet, then upload it directly into the discussion post so everyone can see it. There is no exception to this requirement.

4. You will need at least 6 participants.

5. In addition, you will identify whether the invested adults’ comments can be grouped into one of four psychological mindsets. This means: are they identifying behaviors in you that reflect your God-given ability, your belief in yourself, your attitude about life, and the things you need to do, or your motivation to do them?

6. Youre using this information to provide a psychological hypothesis about the framing of your participants for this mini study. You do not need to analyze this data in this upload, but all required information must be included for full credit, with 2 replies to classmates. Half credit will be given to student that do not have interaction with classmates.

Week 5 Discussion Question 2

Analyze the data uploaded in Discussion 1 from this week. You need to provide:

1. A null and alternative hypothesis using the proper notation.

2. You need to determine: a. central tendency, frequency, relative frequency, variance, standard deviation, of your data in a table that allows others to both see and understand your data. You will need at least 1 table per variable.

3. You will need to graph this analysis using both descriptive and inferential statistics. Spend some time selecting the most appropriate approach.

4. You will provide a narrative of this analysis results that follow the MEAL plan: M-main idea, E-evidence, A-analysis of the meaning of the results to your and your future career and life. L-link to the way you can use this information in your Christian worldview in support of data analysis results.

Week 5 Homework

book info: Textbook(s):

Title: Basic Statistics for Behavioral Sciences, 7th Edition

Author: W. Heiman, Gary W.

Publisher: Wadsworth Publishing, Cengage Advantage Books

Edition: 7th (2013)

ISBN: 978-1285054865

• Chapter 9 and Chapter 10 Homework
• Answer the following Review/Application Questions at the end of each chapter as well as the additional question(s) listed:
• Chapter 9
• Part 1 Chapter 9 Application Questions # 14, 16, 18
• Part 2 – Use this online dice roller (
• ) to roll a 6 sided die 20 times and record the numbers. What is the empirical probability of rolling a 4? What is the theoretical probability of rolling a 1?
• Chapter 10
• Part 1 Chapter 10 Application Questions # 14 (references number 13, not 11), 16, 18
• Part 2 Why can no statistical result prove that changing the independent variable causes the dependent variable to change? What one thing does a significant result prove?

Written HW #1 Please submit the original document with ONLY the answers appearing on the blanks provided, followed by your work. You are expected to show all work on pages attached following the document, and NOT on the original document.

1. Begin with the 10 heights provided to you by your instructor. (Please reach out to your instructor by Monday in Week 5 if you have not received the 10 heights.)
2. To add 10 more values to your lab data, survey or measure 10 people to find their heights. Add these heights to the Week 5 Lab Template along with the 10 provided by your instructor.
3. Determine the mean and standard deviation for the 20 values (your instructor’s 10 from Step 1A above plus your 10) by using the Week 3 Excel Spreadsheet.
4. Post a screenshot of the portion of the spreadsheet that helped you determine these values.
5. How does your height compare to the mean (average) height of the 20 values? Is your height taller, shorter, or the same as the mean of the sample?

Give some background information on the group of people you used in your study. Use the following questions to guide your answers.

1. How did you choose the participants for your study? What was the sampling method: systematic, convenience, cluster, stratified, simple random?
2. What part of the country did your study take place in?
3. What are the age ranges of your participants?
4. How many of each gender did you have in your study?
5. What are other interesting factors about your group?

Use the Week 5 Excel Spreadsheet for the following:

1. Use the Empirical Rule tab from the spreadsheet. Then, determine the 68%, 95%, and 99.7% values of the Empirical Rule in terms of the 20 heights in your height study.
2. Post a screenshot of your work from the Week 5 Excel spreadsheet.
3. What do these values tell you?
4. Post another screenshot of your work from the Normal Probability tab from the Week 5 Excel spreadsheet.
5. Based on your study results, what percent of the study participants are shorter than you? What percent are taller than you? (Example: If my height is 73 inches, then 20.86% of the relevant population is shorter. The other 79.14%, of course, is taller).

The 10 heights everyone will use are in the attached Excel document. I also listed them out here:

Heights (in)64, 64, 65, 66, 67, 69, 72, 73, 74, 75