# 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: -

Quality Research Papers

We always make sure that our academic writers follow all your instructions precisely. You can choose your academic level and we will assign a writer who has a respective degree.

We have a team of professional writers with experience in academic and business writing. Many are native speakers and able to perform any task for which you need help.

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.

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. Otherwise a 100% refund is guaranteed.

Original & Confidential

We use several writing tools checks to ensure that all documents you receive are free from plagiarism. We also promise maximum confidentiality in all of our services.

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.

Whether you have an urgent deadline or those that have time. You can take some time and relax after trusting us with your paper. We make sure that we conduct the academic writing services diligently.

## Essay Writing Service

Among the wide variety of academic work, essay writing is one of the simplest a student can ever come across. Usually, it is a task which students encounter and learn how to write whilst in high school. However, the case is quite different when it comes to university and college.

Term Paper Writing

Are you looking for an online writing firm that can offer you reliable custom term paper writing help? Is your wish and desire to get someone who can guide you throughout the process of writing term papers? If yes, then you have come to the right place.

Coursework Writing Help

Coursework is essential for every student in order to graduate from college. However, most of it is deadline-centric, and that becomes a challenge to most learners. With the amount of work, learners are receiving every day, finding time to work on every task is not easy.

Online Homework Help

Online homework help services are an answer to every challenge that students go through. Despite the difference in the needs and levels of learning, all students can benefit from these services. Acemyhomework is one of the best online homework help service companies you can find on the internet.