With this data:
a)Specify the regression equation with the independent
variables.
b)Hypothesize the sign for each regression coefficient
c)Is there multicollinearity or serial correlation?
Data on university ranking:
eaching_Rating | Rating from a 0-100 scale of the quality of teaching at the university. This rating is based on the institution’s reputation for teaching, it’s student/staff ratio, it’s PhD’s/ undergraduate degrees awarded ratio, and it’s institutional income/ academic staff ratio. |
Inter_Outlook_Rating | Rating from a 0-100 scale of the international makeup of a university. This rating is based the international student percentage, international staff percentage, and the percentage of research papers from the university that include at least one international author. |
Research_Rating | Rating from a 0-100 scale of quality of research at the university. This rating is based on the university’s reputation, it’s research income/ academic staff ratio, and it’s production of scholarly papers. |
Citations_Rating | Rating from a 0-100 scale of based on the normalized average of citations by other papers per paper from the university (how often the research from the university is cited by other papers). |
Industry_Income_Rating | Rating from a 0-100 scale grading how much companies are willing to invest in the universities research. |
The formula for the 2016 rankings is as follows:
30% for Teaching Rating
7.5% for International Outlook Rating
30% for Research Rating
30% for Citations Rating
2.5% for Industry Income Rating.
Show transcribed image text World Rank University Country Teaching R Inter Outloi Research R Citations Ri Industry In Harvard Uni United Stat 2 California In United Stat 3 Massachuse United Stat 4 Stanford Un United Stat 5 Princeton U United Stat 6 University o United King 6 University o United King 8 University o United Stat 9 Imperial Col United King 10 Yale Univers United Stat 11 University o United Stat 12 University o United Stat 13 Johns Hopki United Stat 14 Cornell Univ United Stat 15 ETH Zurich Switzerland 15 University o United Stat 17 University o Canada 18 Columbia Ur United Stat 19 University o United Stat 20 Carnegie Me United Stat 21 University o Hong Kong 22 University C United King 23 University o United Stat 24 Duke Univer United Stat 25 Northweste United Stat Japan 27 Georgia Insi United Stat 28 Pohang Uniy South Kore 29 University o United Stat Canada 98.7 98.8 99.9 99.9 97.7 97.8 98.3 90.9 90.5 82.3 29.5 87.5 98.1 95.4 99.9 94 95.1 97.8 93.9 99.3 94.5 39.6 89.2 92.1 92.9 92.9 87.9 62.8 96.9 80.9 100 62.4 93.7 88.1 77.5 83.9 75.8 88.8 87.8 89.1 87.9 59.6 90.9 92.6 82.7 39.1 68.4 90.8 80.6 95.9 92.3 32.8 100 68.2 66.8 64.5 87.7 67.9 69.5 56.6 49.4 60.5 68.8 26 University o 58.1 72.6 62.5 95.1 100 89.8 42.6 32.6 96.5 98.8 80.3 30 University o
World Rank University Country Teaching R Inter Outloi Research R Citations Ri Industry In Harvard Uni United Stat 2 California In United Stat 3 Massachuse United Stat 4 Stanford Un United Stat 5 Princeton U United Stat 6 University o United King 6 University o United King 8 University o United Stat 9 Imperial Col United King 10 Yale Univers United Stat 11 University o United Stat 12 University o United Stat 13 Johns Hopki United Stat 14 Cornell Univ United Stat 15 ETH Zurich Switzerland 15 University o United Stat 17 University o Canada 18 Columbia Ur United Stat 19 University o United Stat 20 Carnegie Me United Stat 21 University o Hong Kong 22 University C United King 23 University o United Stat 24 Duke Univer United Stat 25 Northweste United Stat Japan 27 Georgia Insi United Stat 28 Pohang Uniy South Kore 29 University o United Stat Canada 98.7 98.8 99.9 99.9 97.7 97.8 98.3 90.9 90.5 82.3 29.5 87.5 98.1 95.4 99.9 94 95.1 97.8 93.9 99.3 94.5 39.6 89.2 92.1 92.9 92.9 87.9 62.8 96.9 80.9 100 62.4 93.7 88.1 77.5 83.9 75.8 88.8 87.8 89.1 87.9 59.6 90.9 92.6 82.7 39.1 68.4 90.8 80.6 95.9 92.3 32.8 100 68.2 66.8 64.5 87.7 67.9 69.5 56.6 49.4 60.5 68.8 26 University o 58.1 72.6 62.5 95.1 100 89.8 42.6 32.6 96.5 98.8 80.3 30 University o