College Pal
Connecting to a pal for your paper
  • Home
  • Place Order
  • My Account
    • Register
    • Login
  • Confidentiality Policy
  • Samples
  • How It Works
  • Guarantees

Sms or Whatsapp only : US:+12403895520

 

email: [email protected]
May 16, 2022

Attached you will find the following Assignment 10, which is basically the main questions ; and the following documents are the Data used to solve

Mathematics / Statistics

PLEASE READ CAREFULLY BEFORE ACCEPTING & CHECK THE ATTACHED. 

Attached you will find the following Assignment 10, which is basically the main questions ; and the following documents are the Data used to solve : 

1- Automobile…

2- CreditRiskD…

3- Collegesand….

However, I have tried to solve the problem and it seems that I got something wrong, primarily Question 2, the instructor mentioned discriminant Analysis. 

You will find my solution in ( ALLTASK file ) 

Please check and adjust the problem. 

  • attachment

    Assignment10.docx

  • attachment

    AutomobileOptions.xlsx

  • attachment

    CreditRiskData.xlsx

  • attachment

    CollegesandUniversitiesClusterAnalysisWorksheet.xlsx

  • attachment

    ALLTASK.xlsx

Chapter 10 Data Mining

Instructions: Please submit your work in one single Excel file with one tab/worksheet for each problem.

Cluster Analysis

1. (25 points) Apply single linkage cluster analysis to Berkeley, Cal Tech, UCLA, and UNC in the Excel file Colleges and Universities Cluster Analysis Worksheet and draw a dendrogram illustrating the clustering process.

Classification

2. In the Excel file Credit Risk Data, classify the following record:

a. (25 points) Using k-NN algorithm for k=1 to 5.

b. (25 points) Using discriminant analysis.

Association

3. (25 points) The Excel file Automobile Options provides data on options ordered together for a particular model of automobile. Consider the following rules:

a. Rule 1: If Fastest Engine, then Traction Control.

b. Rule 2: If Faster Engine and 16-inch Wheels, then 3 Year Warranty.

Compute the support, confidence, and lift for each of these rules.

,

Auto Market Basket

Automobile Options
Engine Warranty Wheels Sound System Other Options
Slower Engine Faster engine fastest engine no warranty 3 year warranty 5 year warranty 15 inch 16 inch alloy am/fm amfm/dvd premium Sunroof Traction Control
1 0 0 0 1 0 0 1 0 0 0 1 1 1
0 1 0 0 1 0 0 0 1 1 0 0 0 0
0 0 1 0 0 1 1 0 0 0 1 0 1 1
0 0 1 0 0 1 0 1 0 0 0 1 0 1
0 1 0 0 0 1 1 0 0 1 0 0 0 1
0 1 0 0 1 0 0 1 0 0 1 0 1 1
1 0 0 0 1 0 1 0 0 1 0 0 0 0
1 0 0 1 0 0 0 1 0 0 1 0 1 1
0 1 0 0 0 1 0 0 1 0 1 0 0 0
0 0 1 0 1 0 0 1 0 0 0 1 1 1
0 1 0 0 0 1 0 0 1 0 1 0 0 1
1 0 0 0 1 0 0 1 0 0 0 1 1 0
0 1 0 0 1 0 0 1 0 1 0 0 0 1
1 0 0 0 1 0 0 0 1 0 1 0 0 1
0 1 0 0 1 0 0 1 0 0 1 0 1 0
0 0 1 0 0 1 0 1 0 0 0 1 1 1
0 0 1 0 0 1 0 1 0 0 1 0 0 0
0 1 0 0 1 0 0 1 0 0 1 0 1 1
0 0 1 0 1 0 0 0 1 0 1 0 0 1
1 0 0 0 0 1 0 0 1 0 1 0 1 1
0 1 0 0 0 1 0 0 1 1 0 0 1 0
1 0 0 0 1 0 0 1 0 0 1 0 0 1
0 0 1 0 0 1 1 0 0 0 0 1 1 0
0 1 0 0 0 1 1 0 0 0 0 1 1 1
1 0 0 0 0 1 1 0 0 1 0 0 0 0
0 0 1 0 0 1 0 1 0 0 1 0 0 1
0 1 0 0 1 0 1 0 0 0 1 0 0 1
0 1 0 0 0 1 0 1 0 1 0 0 0 0
1 0 0 0 1 0 0 1 0 0 1 0 0 0
1 0 0 0 1 0 0 0 1 0 1 0 0 1
1 0 0 0 1 0 1 0 0 0 1 0 0 0
1 0 0 1 0 0 0 1 0 0 1 0 0 1
0 1 0 0 0 1 0 1 0 0 1 0 1 1
0 1 0 0 1 0 0 1 0 0 1 0 0 1
0 1 0 0 1 0 0 0 1 0 1 0 0 0
0 1 0 0 0 1 1 0 0 0 1 0 0 1
0 1 0 0 0 1 1 0 0 0 1 0 0 1
0 1 0 0 1 0 0 1 0 1 0 0 1 0
1 0 0 0 0 1 1 0 0 1 0 0 0 0
1 0 0 0 1 0 0 1 0 0 1 0 0 1
0 1 0 0 1 0 1 0 0 0 1 0 0 0
0 1 0 0 1 0 0 1 0 0 1 0 1 0
1 0 0 0 0 1 0 0 1 0 1 0 0 1
0 0 1 0 0 1 0 1 0 0 1 0 0 1
0 1 0 0 1 0 0 1 0 1 0 0 0 1
1 0 0 0 1 0 0 0 1 0 0 1 0 1
0 0 1 0 1 0 1 0 0 0 0 1 1 1
0 0 1 0 0 1 1 0 0 0 0 1 0 1
0 1 0 0 1 0 1 0 0 0 1 0 0 1
0 0 1 0 0 1 0 1 0 0 1 0 1 1

,

Base Data

<

Collepals.com Plagiarism Free Papers

Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS

Why Hire Collepals.com writers to do your paper?

Quality- We are experienced and have access to ample research materials.

We write plagiarism Free Content

Confidential- We never share or sell your personal information to third parties.

Support-Chat with us today! We are always waiting to answer all your questions.

As we celebrate Constitution Day and look at the things that go with Constitution Day, we have a longevity that is unknown. And other nations you;v BCO 214 PRODUCTION MANAGEMENT Describe carefully all the tasks of a Production Manager How do these tasks fit with the rest of the Organization?

Related Posts

Mathematics / Statistics

Students will learn to find and graph the equation of the least-squares line and use it to predict a value of the response variable y for a specified value of the vari

Mathematics / Statistics

Students will learn to construct a scatter diagram, estimate visually the location of the best-fitting line, and compute the sample correlation coefficient.? Read all

Mathematics / Statistics

Students will learn to identify the null and alternate hypotheses in statistical tests, recognize the types of errors and level of significance and test the mean using

Why Choose Us

Best Essay Writing Services- Get Quality Homework Essay Paper at Discounted Prices

At the risk of sounding immodest, we must point out that we have an elite team of writers. Ours isn’t a collection of individuals who are good at searching for information on the Internet and then conveniently re-writing the information obtained to barely beat Plagiarism Software. Who can’t do that?

Our writers have strong academic backgrounds with regards to their areas of writing. A paper on History will only be handled by a writer who is trained in that field. A paper on health care can only be dealt with by a writer qualified on matters health care. Thesis papers will only be handled by Masters’ Degree holders while Dissertations will strictly be handled by PhD holders. With such a system, you needn’t worry about the quality of work. Quality isn’t just an option, it is the only option. We don’t just employ writers, we hire professionals.

We have writers spread into all fields including but not limited to Philosophy, Economics, Business, Medicine, Nursing, Education, Technology, Tourism and Travels, Leadership, History, Poverty, Marketing, Climate Change, Social Justice, Chemistry, Mathematics, Literature, Accounting and Political Science.

Our writers are also well trained to follow client instructions as well adhere to various writing conventional writing structures as per the demand of specific articles.

They are also well versed with citation styles such as APA, MLA, Chicago, Harvard, and Oxford which come handy during the preparation of academic papers.

They also have unrivalled skill in writing language be it UK English or USA English considering that they are native English speakers. You also needn’t worry about logical flow of thought, sentence structure as well as proper use of phrases.

Our writers are also not the kind to decorate articles with unnecessary filler words. We respect your money and most importantly your trust in us. In writing, we will be precise and to the point and fill the paper with content as opposed to words aimed at beating the word count.

Our shift-system also ensures that you get fresh writers each time you send a job. This helps overcome occupational hazards brought about by fatigue. Hence, quality will consistently be at the top.

From our writers, you expect; good quality work, friendly service, timely deliveries, and adherence to client’s demands and specifications.

Once you’ve submitted your writing requests, you can go take a stroll while waiting for our all-star team of writers and editors to submit top quality work.

How Our Website Works

Get an Essay from Us

College Essays is the biggest affiliate and testbank for WriteDen. We hire writers from all over the world with an aim to give the best essays to our clients.

Our writers will help you write all your homework. They will write your papers from scratch. We also have a team of editors who read each paper from our writers just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE.

Step 1
To make an Order you only need to click ORDER NOW and we will direct you to our Order Page. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline. Deadline range from 6 hours to 30 days.

Step 2
Once done with writing your paper we will upload it to your account on our website and also forward a copy to your email.

Step 3
Upon receiving your paper, review it and if any changes are needed contact us immediately. We offer unlimited revisions at no extra cost.

Is it Safe to use our services?
We never resell papers on this site. Meaning after your purchase you will get an original copy of your assignment and you have all the rights to use the paper.

Pricing and Discounts
Our price ranges from $8-$14 per page. If you are short of Budget, contact our Live Support for a Discount Code. All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.
Please note we do not have prewritten answers. We need some time to prepare a perfect essay for you.

Recent Posts

  • Hello, Can someone please help me with my assignment in creating a Gantt chart? There’s a template available as well but I’m having a hard time transferring
  • Submit your completed Intervention Plan in which you: Identify one issue you want to work on with your client. Write a goal statement in SMART goal form
  • Respond to?at least two colleagues in one or more of the following ways:? Select one of the examples from the video that your colleague cited and describe
  • To apply statistical reasoning in psychology, you must be able to understand and utilize central tendency and probability calculations for various circumstan
  • Respond to the following in a minimum of 175 words: Complete problem 28 Online Shopping in Ch. 3 of your text. The data in the problem represents the number
College Pal

All Rights Reserved Terms and Conditions
College pals.com Privacy Policy 2010-2018

Credit Risk Data
Loan Purpose Checking Savings Months Customer Months Employed Gender Marital Status Age Housing Years Job Credit Risk
Small Appliance $0 $739 13 12 M Single 23 Own 3 Unskilled Low
Furniture $0 $1,230 25 0 M Divorced 32 Own 1 Skilled High
New Car $0 $389 19 119 M Single 38 Own 4 Management High
Furniture $638 $347 13 14 M Single 36 Own 2 Unskilled High
Education $963 $4,754 40 45 M Single 31 Rent 3 Skilled Low
Furniture $2,827 $0 11 13 M Married 25 Own 1 Skilled Low
New Car $0 $229 13 16 M Married 26 Own 3 Unskilled Low
Business $0 $533 14 2 M Single 27 Own 1 Unskilled Low
Small Appliance $6,509 $493 37 9 M Single 25 Own 2 Skilled High
Small Appliance $966 $0 25 4 F Divorced 43 Own 1 Skilled High
Business $0 $989 49 0 M Single 32 Rent 2 Management High
New Car $0 $3,305 11 15 M Single 34 Rent 2 Unskilled Low
Business $322 $578 10 14 M Married 26 Own 1 Skilled Low
New Car $0 $821 25 63 M Single 44 Own 1 Skilled High
New Car $396 $228 13 26 M Single 46 Own 3 Unskilled Low
Used Car $0 $129 31 8 M Divorced 39 Own 4 Management Low
Furniture $652 $732 49 4 F Divorced 25 Own 2 Skilled High
New Car $708 $683 13 33 M Single 31 Own 2 Skilled Low
Repairs $207 $0 28 116 M Single 47 Own 4 Skilled Low
Education $287 $12,348 7 2 F Divorced 23 Rent 2 Skilled High
Furniture $0 $17,545 34 16 F Divorced 22 Own 4 Skilled High
Furniture $101 $3,871 13 5 F Divorced 26 Rent 4 Skilled High
Furniture $0 $0 25 23 M Married 19 Own 4 Skilled High
Furniture $0 $485 37 23 F Divorced 27 Own 2 Management High
New Car $0 $10,723 11 15 M Single 39 Rent 2 Unskilled Low
Business $141 $245 22 33 M Single 26 Own 3 Skilled Low
Used Car $0 $0 19 58 M Single 50 Other 4 Skilled High
Used Car $2,484 $0 49 46 M Single 34 Other 1 Skilled Low
Small Appliance $237 $236 37 24 M Single 23 Rent 4 Skilled Low
Small Appliance $0 $485 19 12 M Single 23 Own 2 Skilled Low
Education $335 $1,708 37 7 M Single 46 Other 4 Skilled High
Small Appliance $3,565 $0 31 32 M Single 35 Own 3 Skilled Low
Small Appliance $0 $407 13 2 F Divorced 28 Own 2 Skilled Low
Business $16,647 $895 16 34 M Single 25 Rent 4 Skilled Low
Business $0 $150 49 46 F Divorced 36 Rent 4 Skilled High
Small Appliance $0 $490 5 41 M Single 41 Own 1 Unskilled Low
Furniture $0 $162 25 1 M Divorced 54 Own 1 Skilled High
Small Appliance $940 $715 9 40 F Divorced 43 Own 2 Unskilled Low
Small Appliance $0 $323 49 42 M Married 33 Own 1 Skilled High
New Car $0 $128 13 74 M Single 34 Own 3 Skilled High
Other $218 $0 49 0 M Single 39 Other 4 Unemployed Low
Used Car $0 $109 25 26 M Single 34 Own 3 Unskilled Low
Small Appliance $16,935 $189 37 60 M Single 30 Own 2 Skilled Low
Furniture $664 $537 31 33 M Single 48 Own 2 Skilled High
Furniture $150 $6,520 12 1 F Divorced 19 Own 1 Skilled Low
Small Appliance $0 $138 7 119 M Married 29 Rent 2 Skilled Low
Furniture $216 $0 19 3 F Divorced 26 Rent 3 Skilled High
New Car $0 $660 17 75 M Single 42 Rent 4 Skilled High
Business $0 $724 25 8 M Single 30 Rent 2 Skilled High
Small Appliance $0 $897 19 5 M Married 38 Own 4 Skilled Low
Small Appliance $265 $947 25 5 M Married 21 Own 1 Skilled High
Furniture $4,256 $0 16 36 F Divorced 32 Rent 4 Unskilled Low
Business $870 $917 28 6 M Single 35 Own 2 Skilled High
New Car $162 $595 22 10 M Divorced 46 Own 4 Skilled Low
Used Car $0 $789 25 28 M Single 37 Own 3 Management Low
Education $0 $0 37 114 M Single 39 Own 4 Management High
Furniture $0 $746 13 16 F Divorced 29 Own 3 Skilled Low
New Car $461 $140 19 32 M Single 27 Rent 3 Unskilled Low
New Car $0 $659 19 5 F Divorced 22 Rent 3 Skilled High
Furniture $0 $717 37 60 M Single 40 Own 2 Skilled High
New Car $0 $667 29 10 M Single 44 Own 2 Unskilled High
New Car $580 $0 11 8 M Single 26 Own 4 Unskilled High
Small Appliance $0 $763 13 46 F Divorced 57 Own 3 Unskilled Low
New Car $0 $1,366 19 17 M Single 34 Own 4 Unskilled Low
Small Appliance $0 $552 25 4 M Married 47 Own 4 Skilled High
Small Appliance $0 $14,643 16 115 M Single 46 Own 3 Skilled Low
Business $758 $2,665 13 31 M Single 38 Own 4 Unskilled Low
Used Car $399 $0 31 0 F Divorced 52 Own 1 Management High
Furniture $513 $442 7 0 M Single 34 Own 1 Management Low
Furniture $0 $8,357 25 5 M Single 29 Other 4 Skilled High
New Car $0 $0 22 9 M Single 39 Own 2 Unskilled High
Small Appliance $565 $863 10 81 M Single 36 Own 4 Unskilled Low
Business $0 $322 28 28 M Single 25 Own 4 Skilled Low
Furniture $0 $800 13 69 M Single 59 Own 3 Skilled High
Small Appliance $0 $656 37 85 M Single 27 Own 2 Skilled Low
New Car $166 $922 13 2 F Divorced 24 Rent 1 Skilled High
Business $9,783 $885 13 3 F Divorced 25 Own 1 Unemployed High
Business $674 $2,886 49 32 M Single 29 Own 2 Skilled Low
Repairs $0 $626 43 0 M Single 64 Own 4 Unemployed Low
Business $15,328 $0 25 9 M Single 31 Own 4 Skilled Low
New Car $0 $904 12 6 M Single 38 Own 4 Unskilled Low
Education $713 $784 61 17 M Single 41 Other 4 Skilled High
New Car $0 $806 19 3 F Divorced 22 Own 2 Unskilled High
Education $0 $3,281 19 20 F Divorced 29 Own 2 Skilled High
New Car $0 $759 16 59 M Single 32 Rent 3 Skilled High
Small Appliance $0 $680 25 3 F Divorced 34 Own 4 Skilled High
Used Car $0 $104 37 25 M Single 23 Own 4 Skilled High
Small Appliance $303 $899 13 3 M Single 21 Own 1 Skilled High
Small Appliance $900 $1,732 37 11 F Divorced 49 Other 4 Skilled High
Furniture $0 $706 31 14 M Divorced 31 Own 2 Skilled Low
Education $1,257 $0 10 65 F Divorced 40 Rent 4 Unskilled Low
Small Appliance $0 $576 7 14 F Divorced 28 Own 1 Skilled Low
Repairs $273 $904 7 2 M Married 21 Own 1 Unskilled Low
Business $522 $194 25 79 M Divorced 30 Own 4 Skilled High
Small Appliance $0 $710 25 1 F Divorced 37 Own 3 Skilled Low
Small Appliance $0 $5,564 25 93 M Single 33 Own 2 Skilled Low
Small Appliance $0 $192 46 13 M Single 22 Other 4 Skilled High
New Car $0 $637 13 21 F Divorced 23 Own 2 Unskilled High
Small Appliance $514 $405 49 13 F Divorced 21 Own 2 Skilled High
Furniture $457 $318 19 108 M Single 40 Own 1 Skilled Low
Small Appliance $5,133 $698 19 14 M Single 36 Own 2 Skilled High
New Car $0 $369 10 16 M Single 29 Own 1 Skilled Low
Retraining $644 $0 13 88 M Single 37 Own 4 Skilled Low
Furniture $305 $492 19 1 F Divorced 26 Own 1 Skilled Low
New Car $9,621 $308 25 41 M Single 37 Other 3 Skilled High
Education $0 $127 13 22 M Single 39 Rent 4 Unskilled High
Business $0 $565 19 14 M Married 27 Own 2 Skilled High
Furniture $0 $12,632 16 9 F Divorced 19 Rent 4 Skilled Low
New Car $0 $116 49 45 M Single 45 Other 4 Skilled High
Used Car $0 $178 13 89 M Single 34 Other 4 Skilled High
Small Appliance $6,851 $901 13 21 F Divorced 43 Rent 2 Unskilled Low
Furniture $13,496 $650 19 20 M Single 33 Own 1 Unskilled High
Business $509 $241 25 14 M Single 35 Own 4 Unskilled High
Used Car $0 $609 37 6 M Single 31 Other 2 Management Low
Furniture $19,155 $131 25 24 M Single 25 Own 2 Skilled Low
Furniture $0 $544 19 15 F Divorced 27 Own 2 Skilled Low
Small Appliance $0 $10,853 25 81 F Divorced 56 Rent 4 Management Low
Used Car $374 $0 25 14 M Single 45 Own 4 Management Low
Large Appliance $0 $409 49 15 M Single 53 Own 4 Skilled High
Furniture $828 $391 9 12 F Divorced 23 Own 4 Skilled High
Furniture $0 $322 13 9 F Divorced 25 Own 1 Skilled Low
Small Appliance $829 $583 7 18 F Divorced 63 Own 3 Skilled Low
Small Appliance $0 $12,242 25 53 M Single 34 Own 2 Skilled High
Furniture $0 $479 19 0 M Single 24 Own 1 Unemployed High
New Car $939 $496 19 56 M Single 35 Own 4 Skilled High
New Car $0 $466 25 42 M Single 30 Own 3 Skilled High
New Car $889 $1,583 37 79 M Single 29