CompetencyIn this project, you will demonstrate your mastery of the following competency:Apply statistical techniques to address research problemsPerform hypothesis testing to address an authentic problemOverviewIn 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.ScenarioYou have been hired by your regional real estate company to determine if your region’s 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:Are housing prices in your regional market higher than the national market average?Is the square footage for homes in your region different than the average square footage for homes in the national market?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.DirectionsIntroductionPurpose: What was the purpose of your analysis, and what is your approach?Define a random sample and two hypotheses (means) to analyze.Sample: Define your sample. Take a random sample of 100 observations for your region.Describe what is included in your sample (i.e., states, region, years or months).Questions and type of test: For your selected sample, define two hypothesis questions and the appropriate type of test hypothesis for each. Address the following for each hypothesis:Describe the population parameter for the variable you are analyzing.Describe your hypothesis in your own words.Describe the inference test you will use.Identify the test statistic.Level of confidence: Discuss how you will use estimation and confidence intervals to help you solve the problem.1-Tail TestHypothesis: Define your hypothesis.Define the population parameter.Write null (Ho) and alternative (Ha) hypotheses.Specify your significance level.Data analysis: Analyze the data and confirm assumptions have not been violated to complete this hypothesis test.Summarize your sample data using appropriate graphical displays and summary statistics.Provide at least one histogram of your sample data.In a table, provide summary statistics including sample size, mean, median, and standard deviation.Summarize your sample data, describing the center, spread, and shape in comparison to the national information.Check the conditions.Determine if the normal condition has been met.Determine if there are any other conditions that you should check and whether they have been met.Hypothesis test calculations: Complete hypothesis test calculations, providing the appropriate statistics and graphs.Calculate the hypothesis statistics.Determine the appropriate test statistic (t).Calculate the probability (p value).Interpretation: Interpret your hypothesis test results using the p value method to reject or not reject the null hypothesis.Relate the p value and significance level.Make the correct decision (reject or fail to reject).Provide a conclusion in the context of your hypothesis.2-Tail TestHypotheses: Define your hypothesis.Define the population parameter.Write null and alternative hypotheses.State your significance level.Data analysis: Analyze the data and confirm assumptions have not been violated to complete this hypothesis test.Summarize your sample data using appropriate graphical displays and summary statistics.Provide at least one histogram of your sample data.In a table, provide summary statistics including sample size, mean, median, and standard deviation.Summarize your sample data, describing the center, spread, and shape in comparison to the national information.Check the assumptions.Determine if the normal condition has been met.Determine if there are any other conditions that should be checked on and whether they have been met.Hypothesis test calculations: Complete hypothesis test calculations, providing the appropriate statistics and graphs.Calculate the hypothesis statistics.Determine the appropriate test statistic (t).Determine the probability (p value).Interpretation: Interpret your hypothesis test results using the p value method to reject or not reject the null hypothesis.Relate the p value and significance level.Make the correct decision (reject or fail to reject).Provide a conclusion in the context of your hypothesis.Comparison of the test results: See Question 3 from the Scenario section.Calculate a 95% confidence interval. Show or describe your method of calculation.Interpret a 95% confidence interval.Final ConclusionsSummarize your findings: Refer back to the Introduction section above and summarize your findings of the sample you selected.Discuss: Discuss whether you were surprised by the findings. Why or why not?What to SubmitTo complete this project, you must submit the following:Project Two Template: Use this template to structure your report, and submit the finished version as a Word document.Supporting MaterialsThe following resources may help support your work on the project:Data Set: House Listing Price by Region Use this data for input in your project report.Document: National Statistics and GraphsUse this data for input in your project report.Use these tutorials for support with the Excel functions you will use in the project:Tutorial: Random Sampling in ExcelTutorial: Scatterplots in ExcelTutorial: Descriptive Statistics in ExcelTutorial: Creating Histograms in Excel

Need some help filling out the work sheet.  I have attached the descriptive Statistics summary from data from last week. The Sampling distributions real estate is the questions I need help with.  I have also attached the excel spread sheet with the data information. 

QUESTION 1Data Set 1-3For her research project, Susan gathered data from 76 students who filled out a questionnaire about exercise and GPA. From the exercise portion, students were classified as sedentary, moderate, or vigorous exercisers. GPA’s were expressed in the usual decimal form. In Data Set 1-3, the number of levels of the independent variable for Susan’s experiment wasa.2;b.3;c.4;d.none of the other alternatives; answer is ____e.76;1 points QUESTION 2Data Set 1-7In Blaine’s experiment participants tasted three different picante sauces and indicated their favorite. Everyone participated after supper on Monday or Tuesday. After the participants were classified as preferring hot, medium, or mild sauce, they filled out the White Risk Inventory, a measure that yields a score of 0 to 15 and indicates how likely a person is to engage in risky adventures. The number of levels of the independent variable in Data Set 1-7 isa.cannot be determined from the information given.b.15;c.2;d.3;1 points QUESTION 3Data Set 1-3For her research project, Susan gathered data from 76 students who filled out a questionnaire about exercise and GPA. From the exercise portion, students were classified as sedentary, moderate, or vigorous exercisers. GPA’s were expressed in the usual decimal form. The independent variable for Data Set 1-3 wasa.exercise classification.b.the number of students who filled out the questionnaire;c.GPA;d.kind of project;1 points QUESTION 4In an experiment on the effect of sleep on memory, the independent variable might bea.recall score on a testb.gender of the experimenterc.number of hours of sleepd.gender of the subjects1 points QUESTION 5Your text said that the end point of analyzing a data set isa.a feeling of satisfactionb.a story that explains relationshipsc.a quantitative home based.a foundation for future research1 points QUESTION 6Epistemology deals with the nature ofa.none of the other alternatives are correctb.philosophyc.knowledged.psychology1 points QUESTION 7Data Set 1-7In Blaine’s experiment participants tasted three different picante sauces and indicated their favorite. Everyone participated after supper on Monday or Tuesday. After the participants were classified as preferring hot, medium, or mild sauce, they filled out the White Risk Inventory, a measure that yields a score of 0 to 15 and indicates how likely a person is to engage in risky adventures. The dependent variable in Blaine’s experiment (Data Set 1-7) isa.number of people who participated.b.score on the White Risk Inventory;c.day of the week they participated;d.choice of picante sauce;1 points QUESTION 8You never have a lower and an upper limit for a(n)a.categorical variableb.score on the ratio scalec.dependent variabled.IQ score1 points QUESTION 9A story that explains relationships is, according to your text,a.the categorical counterpart to a quantitative analysisb.the best hypothesis to use as a starting pointc.the end point of analyzing a data setd.a hindrance to an objective analysis of a data set1 points QUESTION 10Which of the following is not one of the four categories of statisticians described by Kirk?a.computer experts who use computers to find statistics answersb.those who are able to understand material that is presented statisticallyc.mathematical statisticians who develop new techniquesd.professional statisticians who help others1 points QUESTION 11Removing the extreme scores from both tails of the distribution before calculating a central tendency statistics produces aa.truncated meanb.re-tooled meanc.trimmed meand.two-tailed mean1 points QUESTION 12In which situation would the mean be an appropriate measure of central tendency?a.None of the other alternatives are correctb.Most of the scores are near the minimum, a few are in the middle range, and there are almost none near the maximumc.The data categories in the soil analysis are: 0-2 ppm, 3-5 ppm, 6-8 ppm, 9-11 ppm, and over 11 ppmd.We have frequency data on cows, horses, mules, and goats1 points QUESTION 13Data Set 3-1 A student was interested in the structure of the families in the U.S. He sampled 29 of his 330 classmates asking the question, “How many children are there in your family?” He compiled the answers into a simple frequency distribution: C ¦ 7 1 5 2 4 3 3 6 2 10 1 7 Refer to Data Set 3-1. The mode isa.7b.8c.10d.21 points QUESTION 14Which of the following was not listed as a requirement for a fairly complete understanding of a distribution?a.Normalityb.Central tendencyc.Formd.Variability1 points QUESTION 15The median of 4, 3, 4, 2, 3, 4, 4, isa.4.5b.3.5c.none of the other alternatives are correct; the answer is _________d.31 points QUESTION 16The mean temperature for January was 30 °F. In February the mean was 25 °F and for March the mean was 35°F. The weighted mean for these three months isa.30°Fb.less than 30°Fc.greater than 30°F1 points QUESTION 17Usually, a frequency distribution with a mean of 100 and a median of 90 isa.negatively skewedb.positively skewedc.symmetricald.cannot be determined without knowing the mode1 points QUESTION 18The situation that prompts the calculation of a weighted mean is thata.the distribution is severely skewedb.the scale of measurement is not specifiedc.the distribution has humps in both tailsd.several samples have different N’s1 points QUESTION 19Which of the following was not listed as a requirement for a fairly complete understanding of a distribution?a.Variabilityb.Densityc.Formd.Central tendency1 points QUESTION 20For a negatively skewed curve, the usual case with continuous data is thata.low scores are more frequent than high scores and the median is greater than the meanb.low scores are more frequent than high scores and the mean is greater than the medianc.high scores are more frequent than low scores and the mean is greater than the mediand.high scores are more frequent than low scores and the median is greater than the mean1 points Click Save and Submit to save and submit. Click Save All Answers to save all answers.