+61-413 786 465

[email protected]

## Programming

 C/C++ Java DOT NET Python Assembly C Sharp Perl COBOL Visual Basic CAD/CAM Object Oriented Programming Asp.NET PHP JSP Shell Scripting Java Script Ajax CSS/HTML Joomla Wordpress Megento Photoshop DBMS PL-SQL Oracle MS-SQL MS-ACCESS My-SQL SYBASE FOXPRO Excel Programming Language Mobile Applications

Home >> DBMS

problem 1) Categorical variable tread Pattern = {A, B} and numerical variable tread Depth are used to classify Handling = {good, poor} of a vehicle. Depth is normally distributed with mean 9 and standard deviation 3 when Handling is good and mean 16 and standard deviation 4 when Handling is poor.

There are 300 rows of data for training and the number of rows of data for each combination of Pattern and Handling are given in the table below.

Given row x0 = (Pattern = A, Depth=12). Use a naive Bayes’ classifier to compute the class of Handling assigned to x0. Show your work for full credit.

problem 2) Consider the following neural network for two predictors Thickness and Alignment and two classes Print Quality High and Low. Some weights are shown in the table, including weights for constant (threshold) nodes that link to each output node.

Suppose input data row x0 produces z1 = 0.5 at node H1 and z2 = 0.4 at node H2. Assume the softmax function is used at the outputs. Compute the output at each output node. To what Print Quality class is row x0 assigned?

problem 3) In either the design or training of a neural network, provide a list of several ways to reduce the complexity of the model.

problem 4) Consider a support vector machine with three inputs x1, x2, and x3. Assume there are only two support vectors with values and parameters as follows:

problem 5) Consider one versus the rest voting used for classifier with three classes {a, b, c}. Given a row of data denoted as x0 suppose that the classifier for a versus the rest predicts the rest, b versus the rest predicts the rest, and c versus the rest predicts c. What are the votes for each class for x0?

problem 6) Consider the data with categorical predictor x1 = {green or red} and numerical predictor x2 and the class variable y shown in the following table. The weights for a round of boosting are also shown in the table. Suppose the classifier built from this round of boosting assigns y = 1 for x2 < 0.45 and y = -1 for x2 > 0.45. Compute the coefficient α for this classifier in the boost algorithm.

problem 7) A data set with 1000 rows is input to a neural network in Weka. The test option is set to 10-fold cross validation and the neural network option validationSetSize = 20%. How many rows of data are used in a validation set in a fold?

A support vector machine in Weka uses a Gaussian (radial basis function) kernel with parameter gamma. Gamma should be selected less than or equal to one. Circle True or False.

A support vector machine in Weka uses a Gaussian (radial basis function) kernel with parameter gamma = 0.2. This corresponds to the parameter σ2 equal to what value?

problem 8) Given a dataset with 1000 rows and 25 predictors labeled x1, x2, …,x25 to classify into two classes {a, b}. Consider the small random forest with 3 trees and one split in each tree as shown below. Here 5 predictors are selected randomly at each node. The class assigned to each leaf node is also shown.

a) Given a row of data x0 with x1= green, x5 = 4, x9 = 9, predict the class label for the row.

b) For Tree1, it can be concluded that the best split among all 25 predictors is obtained from x1. Circle True or False.

c) Approximately 368 rows are expected to be out of bag for Tree 1. Circle True or False.

d) Categorical variables are coded to {0, 1} indicator variables in a random forest. Circle True or False.

problem 9) Suppose the random sample used for each tree in the previous random forest is decreased from 1000 rows to 500 rows. Circle ALL that are true for the ensemble classifier.

a) Variance of predictions is expected to decrease.

b) Bias of predictions is expected to decrease.

c) Each base classifier is expected to have more out of bag rows of data.

d) Generalization error is expected to decrease.

problem 10) A Bayesian network is shown for the variables paper Thickness, paper Alignment and Print Quality. The conditional probabilities are provided in the tables beside the nodes. Here, Thickness = {high or low}, Alignment = {straight or angled}, and Print Quality = {good or bad}.

find out the following quantities from the information in the Bayesian network.

a) P(Alignment = straight)

b) P(Alignment = straight | Print Quality = good)

DBMS, Programming

• Category:- DBMS
• Reference No.:- M9377

Have any Question?

## Related Questions in DBMS

### Database design and development assignment -assessment task

Database Design and Development Assignment - Assessment task - 1. Normalization a) Map the ERD, from the sample solution, into a set of relations in at least Third Normal Form (3NF). You must ensure that your relations m ...

### Project outline and requirements provide a brief

Project Outline and Requirements Provide a brief description of the organization (can be hypothetical) that will be used as the basis for the projects in the course. Include company size, location(s), and other pertinent ...

### Sql transactions exercisesconsider table itemnameprice

SQL Transactions Exercises Consider table Item(name,price) where name is a key, and the following two concurrent transactions. T1: Begin Transaction; Update Item Set price = 2*price Where name = 'pencil'; Insert Into Ite ...

### Question 1 describe 1nf 2nf 3nf2 explain why 4nf is a

Question: 1: Describe 1NF, 2NF, 3NF. 2: Explain why 4NF is a normal form more desirable than BCNF. The response must be typed, single spaced, must be in times new roman font (size 12) and must follow the APA format.

### Sqlquery 1 how many products have standard price less than

SQL Query 1. How many products have standard price less than 1000? Query 2: Display all attributes for products made of "Cherry" from Product table w/o referring to column names. Query 3: Display all product names having ...

### Question 1 a- consider that you are asked to design an

Question: 1. (a)- Consider that you are asked to design an entity relationship diagram based on the below scenario: A university consists of a number of departments (id, d_name) and each department offers some courses. A ...

### Question lab 1 creating a database designthis assignment

Question: Lab 1: Creating a Database Design This assignment contains two (2) Sections: Database Design Diagram and Design Summary. You must submit both sections as separate files in order to complete this assignment. Not ...

### Solve the following questions using oracle you are not

Solve the following questions using Oracle. You are not allowed to use the syntax of any DBMS other than Oracle. Make sure to upload an electronic copy of your solution to your CSC335 TRACE folder. Name the file hw4.sql. ...

### Suppose that we have a table of house prices and a table of

Suppose that we have a table of house prices and a table of zip codes: • hprices(hid (PK),address,bedrooms,price,zipcode) • zipcodes(zipcode (PK),state) Write a SQL query that finds the average, maximum, and minimum pric ...

### Questionsuppose a prolog database exists that gives

Question: Suppose a Prolog database exists that gives information about states and capital cities. Some cities are big, others small. Some states are eastern, others are western. a. Write a query to find all the small ca ...

• 13,132 Experts

## Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

### Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

### Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

### Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of \$ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

### Compute the present value of an 1150 payment made in ten

Compute the present value of an \$1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

### Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of \$ 699 per year for 19 years, given a discount rate of 6 percent per annum. As