Assignment:
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 budgetm 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.
Attachment:- Miami Investigations.rar