# Statistics and probability with excel

**rkdud2Wkd!**

It's due on monday 7am

( https://drive.google.com/drive/folders/1wEb6yqt46NRlZ2vFFJQ13Lk7OruLcqgu?usp=sharing )

This drive include all the case study.

**Scenario**

You 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, com plete the statistical analyses, and provide a report to the regional sales director. You will do so by co mpleting the Project Two Template located in the What to Submit area below.

**Directions**

**Introduction**

**Purpose:**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.
- Describe the inference test you will use.
- Identify the test statistic.
**Level of confidence:**Discuss how you will use estimation and conference intervals to help you solve the problem.

**1-Tailed Test**

**Hypothesis:**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 co mplete 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-Tailed Test**

**Hypotheses:**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 co mplete 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 Conclusions**

**Summarize 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?

- 15 days ago
- 9

**Answer(1)**

Purchase the answer to view it

- Therelationshipcomparisonhousingpricesandhousingsquarefootageandthatofthenationalmarket..docx
- Therelationshipcomparisonhousingpricesandhousingsquarefootageandthatofthenationalmarket..pdf

**Bids(85)**

- Emily Clare
- Discount Assign
- Discount Ans
- Dr. Diana_Ashley
- Elprofessori
- Dr. Michelle_KM
- Creative Geek
- HomeMarket_Tutor
- juliusmu33
- RihAN_Mendoza
- university work
- michael smith
- PROF. ANN
- Cotton Candy
- JOHN JUNIOR001
- Noor427726
- Nightingale
- Sasha Spencer
- PROF_TOMMY
- WIZARD_KIM
- HOMWORK_WRITER
- Urgent Tutor
- Amanda Smith
- Ranchoddas Chanchad PhD
- Paula Hog
- Eva Green
- DexterMasters
- Tutor Cyrus Ken
- EssaySupremo
- Brilliant Geek
- Stano 001
- wizard kim
- Erick Tyler
- Agher Editor
- Dr.Michelle_Prof
- Brainy Brian
- brilliant answers
- Terry Roberts
- Angelina May
- Coleen Anderson
- ConsultThanos
- Prof Hangoi
- Goodwriter
- Talentedtutor
- Beaverly
- PROF_ALISTER
- A+GRADE HELPER
- Dr shamille Clara
- hassan_0102
- Proff work phd
- kim woods
- Nursing_Miss
- Rey writer
- Prof Allan
- EMMA_WRITER
- Michelle Owens
- Martin Writer
- Tutor-Cahun
- Catherine Owens
- Wendy Lewis
- Jessica Luis
- MISS MLUCK
- smart-tutor
- Essay-Shark-JW25
- Teacher A+ Work
- runge-kutta acer
- PROFJUMAAA
- ansRohan
- Emily Michael
- prof avril
- ChrisProf
- Michelle GoodMan
- DrNicNgao
- WRITER TEAM
- Sally Sutton
- Callie Thorne
- Clytemnestra
- Prof.MacQueen
- Prof.Clintonnjer
- Studybay
- Tom Kirk
- ontime papers
- Gladys.Tutor
- Charandary Sec
- M001-Miss

**other Questions(10)**

- 1111
- "Using Terminal Services Gateway” --"Terminal Services Web Access and Terminal Services Gateway"-- "Windows Media Services"-- "Windows Media Right Management"-- "Site Configuration"-- "Managing Communication Security"-- "AD RMS" .
- The Us Border patrol
- APA Format: This is for Project Management
- Art History home work, 2 questions
- History of Modern Africa from 19th Century to Present
- see below
- follow the instruction and write the essay
- HRM
- Research Methods for Health Sciences 6

### project 2

NOT RATED## 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 …

16 days ago### Statistics and probability with excel

NOT RATED( https://drive.google.com/drive/folders/1wEb6yqt46NRlZ2vFFJQ13Lk7OruLcqgu?usp=sharing )

This drive include all the case study.

**Scenario**You have been hired by your regional real estate company …

16 days ago

**Tips(0)**

**Udemy(0)**