could anyone fix the Input Y range and Input X range for me? i always have trouble with it.

Now Database Query 18 B C D F G H 4-21 The following data give the starting salary for students who recently graduated from a local university and accepted jobs soon after graduation. The starting salary, grade-point average (GPA), and major (business or other) are provided. SALARY $29,500 $46,000 $39,800 $36,500 $42,000 $31,500 $36,200 GPA 3.1 3.5 3.8 2.9 3.4 2.1 2.5 9 Major SUMMARY OUTPUT 0 1 SUMMARY OUTPUT 2a. Using a computer, develop a regression model that could be used to predict starting salary based on GPA and major. 3 Salary + 18266 6274 4 b. Use this model to predict the starting salary for a business major with a GPA of 3.0, 5 Salary = 18266 +62743 - 37088 36 c. What does the model say about the starting salary for a business major compared to a nonbusiness major? 17 Salary of the business major which is high when to no business major as the predicted value shows: 23 d. Do you believe this model is useful in predicting the starting salapi fast bemutation information zowded in 20 21 22 There's a problem with 23 24 25 Not trying to type a formula 26 When the first character is a 27 (**) sign, Excel thinks it's a 28 you type: +1+1, cell shows: 29 30 31 32 33 34 35 To get around this, type an ap . you type: '-1+1, cell shows: 36 37 38 4.10 4.12 Ready 14.21 4.24 4.31 Consolidate Group Ungroup SEO Regression Input OK $A$2:$H$7 Input Y Range: Input X Range: Cancel $A$8:SH$9 Constant is Zero Labels Confidence Level: 95 % Output options $A:$19 Output Range: New Worksheet Ply: New Workbook Residuals Residuals Residual Plots Standardized Residuals Line Fit Plots Normal Probability Normal Probability Plots Intercept GPA COISTETTY TUOTETTE TUT 18266.4 10280.08 1.7768738 6273.954 3324.566 1.8871501 VE TWO 0.1357404 8159.3779 0.1177902 2272.1137 PETER WEICCApper 44692.171 -8159.38 4465 14820.022 -2272.11 1482 o predict starting salary based on GPA and major. ith a GPA of 3.0. ajor compared to a nonbusiness major? usiness major as the predicted value shows : 2 ustvo Aner icing information nouded in thecomputeroutout There's a problem with this formula. X Not trying to type a formula? When the first character is an equal ("=") or minus ("-") sign, Excel thinks it's a formula: you type: =1+1, cell shows: 2 To get around this, type an apostrophe () first: you type: '=1+1, cell shows: +1+1 OK E 33 Merge & Center v D23 M 4 A B D E F G . 1 2 4-21 The following data give the starting salary for students who recently graduated from a local university and accepted jobs soon after graduation. The starting salary, grade point average (GPA), and major 5 (business or other) are provided. 6 7 SALARY $29,500 $46,000 $39,800 $36,500 $42,000 $31,500 $36,200 8 GPA 3.1 3.5 3.8 2.9 3.4 2.1 2.5 9 Major Other Business Business Other Business Other Business 10 11 SUMMARY OUTPUT 12 a. Using a computer, develop a regression model that could be used to predict starting salary based on GPA and major 13 Salary 14 b. Use this model to predict the starting salary for a business major with a GPA of 3.0. 15 Salary 16 c. What does the model say about the starting salary for a business major compared to a nonbusiness major? Salary of the business major which is high when to no business major as the predicted value shows 18 d. Do you believe this model is useful in predicting the starting salary? Justify your answer, using information provided in the computer output. 19 20 21 22 23 24 25 26 27 28 29 30 17