Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Q1[linear regression]. Please follow the video lectures and practice the ideas with the following dataset: GPA_Dataset.xlsx Download GPA_Dataset.xlsx (below is the data set) GPA High

Q1[linear regression]. Please follow the video lectures and practice the ideas with the following dataset:

GPA_Dataset.xlsxDownload GPA_Dataset.xlsx (below is the data set)

GPA High School GPA SAT # of Recommendation letter
2.04 2.01 1070 5
2.56 3.4 1254 6
3.75 3.68 1466 6
1.1 1.54 706 4
3 3.32 1160 5
0.05 0.33 756 3
1.38 0.36 1058 2
1.5 1.97 1008 7
1.38 2.03 1104 4
4.01 2.05 1200 7
1.5 2.13 896 7
1.29 1.34 848 3
1.9 1.51 958 5
3.11 3.12 1246 6
1.92 2.14 1106 4
0.81 2.6 790 5
1.01 1.9 954 4
3.66 3.06 1500 6
2 1.6 1046 5
2.05 1.96 1054 4
2.6 1.96 1198 6
2.55 1.56 940 3
0.38 1.6 456 6
2.48 1.92 1150 7
2.74 3.09 636 6
1.77 0.78 744 5
1.61 2.12 644 5
0.99 1.85 842 3
1.62 1.78 852 5
2.03 1.03 1170 3
3.5 3.44 1034 10
3.18 2.42 1202 5
2.39 1.74 1018 5
1.48 1.89 1180 5
1.54 1.43 952 3
1.57 1.64 1038 4
2.46 2.69 1090 6
2.42 1.79 694 5
2.11 2.72 1096 6
2.04 2.15 1114 5
1.68 2.22 1256 6
1.64 1.55 1208 5
2.41 2.34 820 6
2.1 2.92 1222 4
1.4 2.1 1120 5
2.03 1.64 886 4
1.99 2.83 1126 7
2.24 1.76 1158 4
0.45 1.81 676 6
2.31 2.68 1214 7
2.41 2.55 1136 6
2.56 2.7 1264 6
2.5 1.66 1116 3
2.92 2.23 1292 4
2.35 2.01 604 5
2.82 1.24 854 6
1.8 1.95 814 6
1.29 1.73 778 3
1.68 1.08 800 2
3.44 3.46 1424 7
1.9 3.01 950 6
2.06 0.54 1056 3
3.3 3.2 956 8
1.8 1.5 1352 5
2 1.71 852 5
1.68 1.99 1168 5
1.94 2.76 970 6
0.97 1.56 776 4
1.12 1.78 854 6
1.31 1.32 1232 5
1.68 0.87 1140 6
3.09 1.75 1084 4
1.87 1.41 954 2
2 2.77 1000 4
2.39 1.78 1084 4
1.5 1.34 1058 4
1.82 1.52 816 5
1.8 2.97 1146 7
2.01 1.75 1000 6
1.88 1.64 856 4
1.64 1.8 798 4
2.42 3.37 1324 6
0.22 1.15 704 6
2.31 1.72 1222 5
0.95 2.27 948 6
1.99 2.85 1182 8
1.86 2.21 1000 6
1.79 1.94 910 6
3.02 4.25 1374 9
1.85 1.83 1014 6
1.98 2.75 1420 7
2.15 1.71 400 6
1.46 2.2 998 7
2.29 2.13 776 6
2.39 2.38 1134 7
1.8 1.64 772 4
2.64 1.87 1304 6
2.08 2.53 1212 4
0.7 1.78 818 6
0.89 1.2 864 2

1. Please apply a multiple linear regression model, use the high school GPA, SAT and # of recommendation to predict the students' GPA.

2. Explain the model. (Eg: What is the model formula? the coefficient? R square? P-value? which variable/variables is/are statistics significant, which one/ones is/are not? What is the meaning of the coefficient? )

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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_2

Step: 3

blur-text-image_3

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

Managing Information Technology

Authors: Carol Brown, Daniel DeHayes, Jeffrey Hoffer, Wainright Marti

7th Edition

132146320, 978-0132146326

More Books

Students also viewed these General Management questions