qmb proyect

I need you to analize the data attached and answer the following questions:

PROJECT DETAILS

Miami Investigations, Inc. provides investigative solutions to its customers. Its customers include both 

individuals and businesses. The company is a successful local mid-sized organization located in Miami-

Dade County and employs approximately 200 individuals. Within the company there are several 

departments. These departments include Finance and Accounting, Marketing, Sales, HR, Customer 

Support, and IT. Miami Investigations, Inc. currently has established processes and is utilizing several 

systems for its business, including a MS SQL Server DBMS, a SalesForce CRM, and MS SharePoint among 

other common tools such as MS Office. Additionally, an intranet is utilized for communication of 

information to and between employees. The Company offers the following as part of its portfolio of 

services to its customers: 



Infidelity and personal investigations



Background checks



Corporate investigations



Worker’s compensation investigations



Computer fraud and forensics



Fraud and theft investigations

Miami Investigations, Inc. is growing and considering expansion of its services to another market 

segment, Broward County. You have been provided the following data on the company: 1) 5-yr budget 

forecast of expansion; 2) Price list of services offered; 3) Sample customer information from CRM; and 4) 

community income statistics for both Broward and Miami-Dade Counties.

Using the data provided, conduct an analysis using each the methods as described below. Using the 

results obtained from the analyses, determine if Miami Investigations, Inc. should expand to Broward 

County. You should provide a full explanation of the decision and use the results from items 1 and 2 below to support your decision.

1. Conduct a hypothesis test comparing the mean median income of Broward County and Miami-Dade County.

2. Looking at the services businesses purchased versus consumers purchased, conduct a one-way ANOVA to compare the average amount spent between the two groups.