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

Develop a outline of a long-range information system plan

Develop a detailed outline of a long-range information system plan for Clarion-Milwaukee. Analysis of current and future environment, including business, information technolog

Label case questions as paragraph headings

Demonstrate graduate level work including appropriate research and critical thinking skills. Prepare a written analysis (not a question/answer format). Label case questions as

How would you address the findings in a presentation

Discuss how the Uruguay Round and the Doha Development Agenda impact agricultural subsidies. Discuss the findings in Table 7.3. How would you address the findings in a present

Identify the key and underlying issues

Identify the key and underlying issues. This is not a simple listing, but more of an in-depth analysis and how these apply to the concepts and theories you have learned with

Design and implement the new intranet capabilities in-house

Design and implement the new intranet capabilities in-house, using mostly existing hardware and software. Purchase access to specialized software to support this new capabilit

Describe whether the investment in the truck is profitable

Analyze whether the investment in the truck is profitable. Explain whether it is more beneficial for Frank to close his business. Explain what you would do in this same situat

Prepare presentation for case fox v mountain west electric

Do significant research outside of the book and demonstrate that you have in a very obvious way. This refers to research beyond the legal research - Show your Analysis and R

What are some of impacts that baldrige program has provided

Develop a cause-and-effect diagram that might clarify the source of errors. What tools might the supervisor use to study ways to reduce the number of errors? What are some of


Write a Review

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