# Choose a local company in the industry of your liking from the following list Restaurant/ hotel, hospital, internet/cable, construction, grocery store,

Learning Objective: State Mandated Outcomes numbered 3,5,7,8 and 10.
3.Compute descriptive statistics, construct graphs for data analysis, and interpret outcomes.
5.Calculate expected values to evaluate multiple outcomes of a decision.
7.Construct and interpret confidence intervals for means and proportions.
8.Formulate, perform, and interpret hypotheses tests (one and two population parameters).
10.Use statistical software to graph, compute, and analyze statistical data

Choose a local company in the industry of your liking from the following list:
Restaurant/ hotel,
hospital,
internet/cable,
construction,
grocery store,
insurance,
automobile
banking/fianace/loan
You should be done with the following four First in Part A:
Step by Step Instructions:
1.Make sure, you do have a data access from the chosen company in the above industry for two different time periods or two different locations in the same time period.
2.Suppose you work on quality control in that company. Your job is to do monthly checks on the quality of service by collecting data on key areas. Your company is watching sales by collecting data on location, and three variables.
3.Select the three variables of your choice (based on data availability).
4.You are to prepare a Managerial Report answering the following (show the work for each of the following at the end of managerial report)
1. Use appropriate descriptive statistics to summarize each of the three variables. (Covered in Chapter-2)
2. Use appropriate descriptive statistics to summarize each of the three variables for the comparison year/quarter/location (dependent on what you chose in #1 – location or time). (Covered in Chapter-2)
3. Compare your summary results. Discuss any specific statistical results in visuals that would help the reader to understand your point. (Covered in Chapter-2)

Example
Make sure, you do have a data access from that company. Suppose you work on quality control in that company. Your job is to do monthly checks on the quality of service by collecting data on key areas. Your company is watching sales by collecting data on location, and three variables – list price, sale price, and number of days it takes to sell each residential single-family housing unit. Each single-family housing unit is classified as “Collin” if it is located within Collin county or “Non-Collin” if it is located near (within 50 miles), but not in Collin county.
Part-A:
You are to prepare a Managerial Report answering the following (show the work for each of the following at the end of managerial report)
1. Use appropriate descriptive statistics to summarize each of the three variables for the Collin housing units. (Covered in Chapter-2)
2. Use appropriate descriptive statistics to summarize each of the three variables for the Non-Collin housing units. (Covered in Chapter-2)
3. Compare your summary results. Discuss any specific statistical results that would help a real estate agent understand the DFW housing market. (Covered in Chapter-2)
Part-B :
4. Develop a 95% confidence interval estimate of the population mean sales price and population mean number of days to sell for Collin housing units. Interpret your results.
5. Develop a 95% confidence interval estimate of the population mean sales price and population mean number of days to sell for Non-Collin housing units. Interpret your results.
Assume the branch manager requested estimates of the mean selling price of Collin housing units with a margin of error of \$40,000 and the mean selling price of Non-Collin housing units with a margin of error of \$15,000. Using 95% confidence, how large should the sample sizes be?
7. Your company just signed contracts for two new listings: a Collin housing unit with a list price of \$589,000 and a Non-Collin housing unit with a list price of \$285,000. What is your estimate of the final selling price and number of days required to sell each of these units?

Part-B
Excel Exercise
1. Develop a 95% confidence interval estimate of the population mean sales price and population mean number of days to sell for Collin housing units using excel. Attach the excel file to your report. Also enlist the steps explaining how you used excel.
2. Develop a 95% confidence interval estimate of the population mean sales price and population mean number of days to sell for Non-Collin housing units using excel. Attach the excel file to your report. Also enlist the steps explaining how you used excel.
(Hint: Review the guidelines for Interval Estimation Using Excel)

Pages (550 words)
Approximate price: -

Why Choose HelpHub

Quality Researched Papers

We always make sure that writers follow all your instructions precisely. You can choose your academic level: high school, college/university or professional, and we will assign a writer who has a respective degree.

Qualified Writers

We have hired a team of professional writers experienced in academic and business writing. Most of them are native speakers and PhD holders able to take care of any assignment you need help with.

Unlimited Revisions

If you think we missed something, send your order for a free revision. You have 10 days to submit the order for review after you have received the final document. You can do this yourself after logging into your personal account.

On Time Delivery

All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension. We will always strive to deliver on time.

Original & Confidential

We use several writing tools checks to ensure that all documents you receive are free from plagiarism. Our editors carefully review all quotations in the text.

Our support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.

Try it now!

## Calculate the price of your order

Total price:
\$0.00

How it works?

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

HelpHub Writing Services

No need to work on essay at night. Sleep tight, we will cover your back. We offer all kinds of essay writing services.

## Essay Writing Service

No matter what kind of academic paper you need and how urgent you need it, you are welcome to choose your academic level and the type of your paper at an affordable price. We take care of all your paper needs and give a 24/7 customer care support system.