Provide a summary of sample data using descriptive statistic

Assignment Help Case Study
Reference no: EM13847848

Assignment: Advanced Analytics

Objectives: The assignment will rely on a series of workshops in which  students will understand how to use SAS Enterprise Miner (EM) to combine analytics of structured and unstructured data (text) to make business predictions. The assignment will assume good working knowledge of all previously studied methods.

Mini Case Study: This mini case study will be used in all workshops of module. All amendments, extensions and assumptions should be recorded in the final submission.

Business Problem - Early Warning System

The client is US National Highway Traffic Safety Administration (NHTSA, pronounced "NITS-uh"). NHTSA is an agency of the Executive Branch of the U.S. government, part of the Department of Transportation. They are responsible for reducing deaths, injuries and economic losses resulting from motor vehicle crashes. They require an Early Warning System for potential safety issues associated with automotive vehicles due to manufacturing problems. In particular they require an analytic model to be developed, capable of predicting the likelihood of a vehicle crash, based on publicly available vehicle safety complaints. In the circumstances when the likelihood of crashes is high, NHTSA will initiate a recall of all vehicles likely to be affected.

The sample data for recreational vehicles (e.g. pick-up trucks, minivans, SUVs, etc.), is from the NHTSA. Each record was filed by individuals who had experienced problems with a specific vehicle component that may or may not have resulted in a vehicle crash.

Two data tables have been provided:

- trucks1.sas7bdat (20.5 Mb of complaints data - download from CloudDeakin)

- stoplst2.sas7bdat (word stop list - download from CloudDeakin)

There are 56,601 observations in this sample of NHTSA data, where each observation is a document (record) representing a single complaint filed with the NHTSA through their survey instrument.

Target Variable: "CRASH" Approximately 30% of the complaints (documents) describe a situation in which a vehicle crash resulted from the failure/malfunction of the specified vehicle component.

The NHTSA collects consumer complaints regarding safety related motor vehicle and motor vehicle equipment by make, model and year, and includes Vehicle Component.

Consumers are directed to a web site that guides them through submitting their complaint through a survey instrument. The complaint information is entered into NHTSA's vehicle owner's complaint database and used with other complaints to determine if a safety-related defect trend exists. (For consumers without web access, they may call NHTSA directly and an operator will collect their information and enter it into the database.)

- If a safety-related defect exists in a motor vehicle or item of motor vehicle equipment, the manufacturer must fix it at no cost to the owner. The complaint is the first step in the process.

- Government engineers analyse the problem. If warranted, the manufacturer is asked to conduct a recall. If the manufacturer does not initiate a recall, the government can order the manufacturer to initiate a recall.

- The NHTSA does not have to receive a specific number of complaints before they look into a problem. They gather all available information on a problem. Each complaint is important to them.

Mini Study Predictive Analytics Workshop and Assignment

3 of 5 Questions

Q1. Describe the business problem and the potential value of the predictive model to the Propose an analytic solution to the problem and support your recommendation with references to the conducted data and text analytics.

Q2. Provide a summary of the sample data using descriptive statistics and frequency Specifically identify any anomalous or inconsistent data characteristics, explaining the potential impact.

Q3. Describe any treatments or transformations undertaken to resolve, the anomalous or inconsistent data characteristics from question 2.

Q4. Perform text analytics on the "CSUMMARY" data item, generating at least 5 topic clusters. Provide a description for each of the clusters generated.

Q5. Develop at least three predictive models for each of the following input characteristics combinations:

a. Using only the structured data (all columns excluding: CSUMMARY and the text topic clusters)

b. Using only the unstructured data (using only the generated text topic clusters)

c. Using both structured and unstructured data

Q6. For all models provide a summary of the model assessment statistics over the and validation partitions

Q7. Select the best predictive model and provide a summary of the model and its performance.

Reference no: EM13847848

Previous Q& A

  Implied price of funding

Starware software was founded last year to develop software for gaming applications. Initially, the founder invested $800,000 and received 8 million shares of stock. Starwarenow needs to raise a second round of capital, and it has identified an in..

  Basic components of a personal computer

The history of computers in healthcare. Basic components of a personal computer. An introduction to the Electronic Health Record. Similarities and differences between the Internet, Intranet, and Extranet as used in healthcare

  What are the legal responsibilities and liabilities

Write a persuasive argument defending your position. Cover the following: Assuming the steel cable was not defective in either its design or manufacturing process, does National have a cause of action against WV Steel? What are the legal responsibi..

  Why do some economists claim

Why do some economists claim that we should not worry too much about inflation at this level?

  Important issues in compensation management

For the final assignment, your written analysis should address a number of important issues in compensation management. Write a comprehensive research paper detailing at least three major challenges and three future trends in each of the following..

  Describe the certification standards for ehr

Write a 350- to 700-word essay in which you do the following: Describe the certification standards for EHR and information systems

  Estimating hugo boss equity value

Hugo Boss AG is a German designer, manufacturer and distributor of men's and women's clothing, operating in the higher end of the clothing retail industry. During the period 2001-2008, the company consistently earned returns on equity in excess of..

  Why are market structures so important

What policies make sense to you with regard to the U.S. wheat or corn markets?

  Write a review paper about the given case study

Review Case Study 10-4, ‘Possible Illegal Discrimination at Tractors, Inc.'. After proper analysis of the system described, identify and evaluate the illegal issues, present or potential, that must be addressed.

  Decisions that acme can make and the payoffs

decisions that Acme can make and the payoffs


Write a Review


Similar Q& A

  Case study personal computer security threats

Case Study Personal Computer Security Threats

  Critical thinking applied to clinical conditions

Simulated clinical work environment demonstrating critical thinking applied to clinical conditions - Determine, in consultation with your hypothetical RN, which patient conditions need to be included in your care plan.

  Explain how the identified issues have impacted the business

Explain in detail how the identified issues have impacted the business; Make recommendations to Tom on how to improve the management of his small business.

  Do you think the customer relationship management system

What is your understanding of integrated view of the organization and its relations with suppliers and customers? If an organization wants to be competitive, what needs to be done in the system integration aspect?

  Consider array size 20 populated with random integer values

Write a recursive methodnmbDigitswhich takes an integer value as parameter and returns the number of digits of the parameter value (for examplenmbDigits(2054) is 4).

  Case study developing a culture of trust and responsibility

Developing a Culture of Trust and Responsibility

  What is continuous improvement

What is Continuous Improvement? Who would be involved in this process and what would they be doing to enable improvements - Describe the type of culture Corus is developing. How will the vision plan help to develop this culture?

  Research paper-impact on an organization marketing ovrerseas

As with any company, Cochlear must take into account the varied macro and micro factors when deciding on their target market and then developing the appropriate marketing mix.

  How do you feel about the external validity

Which factors affect the internal validity of Xaviers study given the experimental design - how do you feel about the external validity of this study?

  Oty cosmetics integrates unilever cosmetics international

What kind of M and A event is the story describing and part of the M&A event required both companies to divest assets. Why would a government regulator force them to divest certain assets as to approve an M&A event?

  Case-assessing procter and gamble acquisition of gillette

What kind of M&A event is the story describing? (Is a horizontal/vertical merger, consolidation, or other kind of event?) How do you know? Be sure to justify your response.

  Identify and analyse the issues and the implications

Discuss the legal and social framework? What implications/remedies are available - Compare India's legal issues and responses to what would be the case in Australia including the legal issues associated if it was in Australia.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd