Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Standard.csv is a dataset that contains the names of various colleges. This particular case study is based on various parameters of various institutions. You are

Standard.csv is a dataset that contains the names of various colleges. This particular case study is based on various parameters of various institutions. You are expected to do Principal Component Analysis for this case study according to the instructions given in the following rubric. The data dictionary of the 'Education - Post 12th Standard.csv' can be found in the following file: Data Dictionary.xlsx

2.1) Perform Exploratory Data Analysis [both univariate and multivariate analysis to be performed]. The inferences drawn from this should be properly documented.

2.2) Scale the variables and write the inference for using the type of scaling function for this case study.

2.3) Comment on the comparison between covariance and the correlation matrix.

2.4) Check the dataset for outliers before and after scaling. Draw your inferences from this exercise.

2.5) Build the covariance matrix, eigenvalues and eigenvector.

2.6) Write the explicit form of the first PC (in terms of Eigen Vectors).

2.7) Discuss the cumulative values of the eigenvalues. How does it help you to decide on the optimum number of principal components? What do the eigenvectors indicate?
Perform PCA and export the data of the Principal Component scores into a data frame.

2.8) Mention the business implication of using the Principal Component Analysis for this case study.

Data Dictionary:

1)      Names: Names of various university and colleges




2)      Apps: Number of applications received





3)      Accept: Number of applications accepted




4)      Enroll: Number of new students enrolled




5)      Top10perc: Percentage of new students from top 10% of Higher Secondary class

6)      Top25perc: Percentage of new students from top 25% of Higher Secondary class

7)      F.Undergrad: Number of full-time undergraduate students



8)      P.Undergrad: Number of part-time undergraduate students



9)      Outstate: Number of students for whom the particular college or university is Out-of-state tuition
10)   Room.Board: Cost of Room and board





11)   Books: Estimated book costs for a student




12)   Personal: Estimated personal spending for a student



13)   PhD: Percentage of faculties with Ph.D.’s




14)   Terminal: Percentage of faculties with terminal degree



15)   S.F.Ratio: Student/faculty ratio





16)   perc.alumni: Percentage of alumni who donate




17)   Expend: The Instructional expenditure per student



18)   Grad.Rate: Graduation rate
NamesAppsAcceptEnrollTop10percTop25percF.UndergradP.UndergradOutstateRoom.BoardBooksPersonalPhDTerminalS.F.Ratioperc.alumniExpendGrad.Rate
Abilene Christian University1660123272123522885537744033004502200707818.112704160
Adelphi University218619245121629268312271228064507501500293012.2161052756
Adrian College1428109733622501036991125037504001165536612.930873554
Agnes Scott College41734913760895106312960545045087592977.7371901659
Alaska Pacific University193146551644249869756041208001500767211.921092215
Albertson College58747915838626784113500333550067567739.411972755
Albertus Magnus College35334010317454162301329057205001500909311.526886163
Albion College1899172048937681594321386848264508508910013.7371148773

Step by Step Solution

3.50 Rating (170 Votes )

There are 3 Steps involved in it

Step: 1

21 Perform Exploratory Data Analysis both univariate and multivariate analysis to be performed The inferences drawn from this should be properly documented We used histograms and boxplots from the sea ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Elementary Statistics Picturing The World

Authors: Ron Larson, Betsy Farber

6th Edition

0321911210, 978-0321911216

More Books

Students also viewed these Algorithms questions

Question

Discuss the role of social class in developing marketing strategies

Answered: 1 week ago

Question

=+b) Find the standard deviations.

Answered: 1 week ago

Question

How can Trip 7 prevent future supply chain uncertainties?

Answered: 1 week ago