A survey was conducted for 30 university students to understand overall satisfaction on their university. It is believed that several factors(location, lecture, facilities, homepage) affect overall satisfaction. By using statistical tools, figure out the relationship between overall satisfaction and the other factors and develop an regression equations for that. Student Overall satisfaction 5 Satisfaction Satisfaction on on location lectures 3 5 Satisfaction on facilities 4 5 Satisfaction on homepage 7 1 2 5 5 6 5 3 5 6 6 7 5 8 9 4 6 6 5 5 6 5 6 6 8 6 6 7 9 7 6 8 7 7 6 7 5 7 6 8 8 9 7 7 8 8 6 6 9 10 7 8 9 6 8 7 8 7 6 6 5 11 12 13 14 7 9 7 7 7 8 7 8 7 8 7 7 7 9 8 15 16 8 8 8 9 8 7 9 9 8 17 9 9 9 7 9 9 8 10 9 9 10 18 19 9 8 8 7 20 10 8 7 9 6 1) Derive the correlation coefficient between each factor. 2) By using the factors with a correlation of 0.7 or more, derive a multiple linear regression. 3) Predict the overall satisfaction level of a student who scored 6 points on location, lecture, facilities and homepage satisfaction. Please detailed EXCEL solution! A survey was conducted for 30 university students to understand overall satisfaction on their university. It is believed that several factors(location, lecture, facilities, homepage) affect overall satisfaction. By using statistical tools, figure out the relationship between overall satisfaction and the other factors and develop an regression equations for that. Student Overall satisfaction 5 Satisfaction Satisfaction on on location lectures 3 5 Satisfaction on facilities 4 5 Satisfaction on homepage 7 1 2 5 5 6 5 3 5 6 6 7 5 8 9 4 6 6 5 5 6 5 6 6 8 6 6 7 9 7 6 8 7 7 6 7 5 7 6 8 8 9 7 7 8 8 6 6 9 10 7 8 9 6 8 7 8 7 6 6 5 11 12 13 14 7 9 7 7 7 8 7 8 7 8 7 7 7 9 8 15 16 8 8 8 9 8 7 9 9 8 17 9 9 9 7 9 9 8 10 9 9 10 18 19 9 8 8 7 20 10 8 7 9 6 1) Derive the correlation coefficient between each factor. 2) By using the factors with a correlation of 0.7 or more, derive a multiple linear regression. 3) Predict the overall satisfaction level of a student who scored 6 points on location, lecture, facilities and homepage satisfaction. Please detailed EXCEL solution