Question: What formula do I have to put in Input Y Range, Input X Range and Output Range? how do I calculate the regession? I need
What formula do I have to put in Input Y Range, Input X Range and Output Range?

how do I calculate the regession? I need help to fill out the regession.
H K L 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 GPA Major $29,500 $46,000 $39,800 $36,500 $42,000 $31,500 3.1 3.5 3.8 2.9 3.4 2.1 SUMMARY OUTPUT $36,200 2.5 SUMMARY OUTPUT a. Using a computer, develop a regression model that could be used to predict starting salary based on GPA and major. b. Use this model to predict the starting salary for a business major with a GPA of 3.0. Salary c. What does the model say about the starting salary for a business major compared to a nonbusiness major? d. Do you believe this model is useful in predicting the starting salary? Justify your answer, using information provided in the computer output. Text to Columns Flash Remove Data Fil Duplicates Validation Consolidate What if Analysis Group Ungroup Subtotal M N 0 R S T U V Regression Input OK Input Y Range: Input X Range: Cancel Labels Constant is Zero Confidence Level: 95 % Output options Output Range: New Worksheet Ply: New Workbook Residuals Residuals Residual Plots Standardized Residuals Line Fit Plots Normal Probability Normal Probability Plots
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
