You plan to develop a regression model to investigate how various factors influence academic salaries.

Before you conduct any regression analysis, you use Excel to construct a correlation matrix of all the quantitative variables in the dataset. Based on the correlation matrix, comment briefly on the associations between Salary and other quantitative variables

You conduct a stepwise regression according to the following procedure:

Step 1: Gender only

Step 2: Gender and School

Step 3: Gender, School and Rank

Step 4: Gender, School, Rank and Years of Service

Step 5: Gender, School, Rank, Years of Service and Age

Choice of reference variable: It is recommended that you choose Health and ASSO as the reference variables for the categorical variables: School and Rank.

Present the regression output for each of the five steps.

Faculty ID	Age	Years of Service	Rank	School	Gender M/F	Salary ($/year)
1	49	22	ASST	BUSINESS	F	106632
2	31	0	ASST	BUSINESS	F	80000
3	34	2	ASST	BUSINESS	F	114666
4	34	0	ASST	BUSINESS	F	112000
5	41	6	ASSO	BUSINESS	F	119962
6	28	0	ASST	BUSINESS	F	110000
7	58	23	ASSO	LIBERAL STUDIES	F	94376
8	52	22	ASST	LIBERAL STUDIES	F	83506
9	35	6	ASSO	LIBERAL STUDIES	F	81124
10	37	7	ASSO	LIBERAL STUDIES	F	75116
11	42	7	ASSO	LIBERAL STUDIES	F	83568
12	30	3	ASST	LIBERAL STUDIES	F	66958
13	57	23	PROF	LIBERAL STUDIES	F	111758
14	53	23	PROF	LIBERAL STUDIES	F	110750
15	26	0	ASST	LIBERAL STUDIES	F	74000
16	59	30	ASST	LIBERAL STUDIES	F	98926
17	39	4	ASST	LIBERAL STUDIES	F	66190
18	51	19	ASSO	LIBERAL STUDIES	F	95138
19	38	4	ASST	LIBERAL STUDIES	F	66190
20	54	21	ASSO	LIBERAL STUDIES	F	84870
21	43	17	ASSO	LIBERAL STUDIES	F	78460
22	35	0	ASST	LIBERAL STUDIES	F	56700
23	31	3	ASST	LIBERAL STUDIES	F	63666
24	41	6	ASSO	LIBERAL STUDIES	F	76908
25	31	1	ASST	LIBERAL STUDIES	F	62776
26	56	21	PROF	LIBERAL STUDIES	F	105900
27	43	18	ASSO	LIBERAL STUDIES	F	90310
28	48	20	ASSO	LIBERAL STUDIES	F	92424
29	49	21	ASST	HEALTH	F	95386
30	49	17	ASSO	HEALTH	F	87098
31	40	7	ASSO	HEALTH	F	74218
32	32	1	ASST	HEALTH	F	64800
33	37	4	ASST	HEALTH	F	71314
34	54	24	PROF	HEALTH	F	110770
Step by Step Solution ★★★★★ 3.45 Rating (155 Votes ) There are 3 Steps involved in it 1 Expert Approved Answer Step: 1 Unlock Your question is incomplete because it lacks the correlation matrix that is mention... View full answer Question Has Been Solved by an Expert! Get step-by-step solutions from verified subject matter experts Step: 2 Unlock Step: 3 Unlock Document Format (2 attachments) 609072b0987a5_21714.pdf 180 KBs PDF File 609072b0987a5_21714.docx 120 KBs Word File Students Have Also Explored These Related Accounting Questions! Q: You plan to develop a regression model to investigate how various factors influence academic salaries. Before you conduct any regression analysis, you use Excel to construct a correlation matrix of... Q: A Buick dealership would like to develop a regression model that would predict the number of cars sold per month by a dealership employee based on the employees number of years of sales experience.... Q: Use the following data to develop a regression model to predict y from x1 and x2. Comment on the output. Develop a regression model to predict y from x1 only. Compare the results of this model with... Q: Financial Statement Impact of Liability Transactions Presented below is a list of possible transactions. 1. Purchased inventory for $80,000 on account (assume perpetual system is used). 2. Issued an... Q: In an effort to model executive compensation for the year 1979, 33 firms were selected, and data were gathered on compensation, sales, profits, and employment. Consider the model (a) Fit the... Q: Background An American College conducted a study in the early 2000 to examine if there were any gender pay gaps[1] in its four schools: Business, Health, Liberal Studies and Sciences. Data were... Q: Sundar Balakrishnan, the general manager of Precision Engineering Corporation (PEC), thinks that his firms engineering services contracted to highway construction firms are directly related to the... Q: Deriving direct method presentation of cash flow from operations using data from the T-account work sheet. Refer to the data in Exhibit 15.6 for Metals Company for 2009. Derive a presentation of cash... Q: Cineplex Inc. is currently Canadas largest film exhibition organization, with theatres in six provinces. Excerpts from its 2013 financial statements are in Exhibits 2-20A to E. Required: a. Determine... Q: Delmarva Power is a utility company that would like to predict the monthly heating bill for a household in Kent County during the month of January. A random sample of households in the county was... Q: Reconsider Prob. 3 - 72. Using EES (or other) software, investigate the effect of the balloon diameter on the mass of helium contained in the balloon for the pressures of (a) 100 kPa and (b) 200 kPa.... Q: Accounting n this discussion topic, debrief your Competitive Rounds 2 and 3. What have you learned from your decisions and rationale for the solutions you implemented in Rounds 2 and 3? What do your... Q: Is this function continuous on the given interval? f ( x ) = 6 x x - 1 o n ( - 5 , 5 ) Q: What are some possible reasons for state-subsidized K-12 and college education but not child care in the United States? Q: An experiment has been conducted for four treatments with eight blocks. Complete the following analysis of variance table. Use α = .05 to test for any significant differences. Source of... Q: Klaus Herrmann, a biochemistry professor, organized Bioproducts, Inc., early this year. The firm will manufacture antibiotics using gene splicing technology. Bioproducts' charter authorizes the firm... Q: The following data are from a completely randomized design. a. At the = .05 level of significance, can we reject the null hypothesis that the means of the three treatments are equal? b. Use Fishers... Q: You are provided with the following balance sheet information and summarized income statement for Katrime Ltd.: All sales are credit sales. Accounts payable pertains exclusively to the purchase of... Q: Effective communicators are also capable of observing and Blank______ nonverbal communications. mimicking following interpreting ignoring Q: (I have attached the Gantt chart.) Review the Gantt chart and identify any problems with the project plan. How can the Gantt chart be improved? ID Task Name Duration Start Finish Predecessors i 31,... Q: Assessment Task 2 - Case study Establish operational plan and manage resource acquisition. (Skills and Knowledge Application) Using the simulated workplace and the scenario in the appendix or your... Q: Hypothetical Project: Darwin DIngos AFL Club Launch Background: The purpose of this project is to introduce the 20 th team into the AFL, The Darwin Dingos FC, based in the capital city of the... Q: Scenario The Project Manager of GDS asked you to use an Excel spreadsheet to createe a Resource Assignment Matrix specifying cost and availability. Then update the Microsoft Project file by assigning... Q: BSB60515 ADVANCED DIPLOMA OF MARKETING BSB61015 ADVANCED DIPLOMA OF LEADERSHIP AND MANAGEMENT BSB61315 ADVANCED DIPLOMA OF MARKETING AND COMMUNICATION BSB60915 ADVANCED DIPLOMA OF MANAGEMENT (HUMAN... Q: The Project Manager of GDS asked you to use an Excel spreadsheet to createe a Resource Assignment Matrix specifying cost and availability. Then update the Microsoft Project file by assigning... Previous Question Next Question Recommended Textbook Free More Books Quantitative Analysis For Management Authors: Barry Render, Ralph M. Stair, Michael E. Hanna 11th Edition 9780132997621, 132149117, 132997622, 978-0132149112 $000List:$10.36 Ask a Question and Get Instant Help! Study Help Services Sitemap Fun Definitions Become Tutor Used Textbooks Study Help Categories Recent Questions Expert Questions Campus Wear Sell Your Books Company Info Security Copyrights Privacy Policy Terms & Conditions SolutionInn Fee Scholarship Online Quiz Give Feedback, Get Rewards Get In Touch About Us Contact Us Career Jobs FAQ Student Discount Campus Ambassador Secure Payment Download Our App © 2026 SolutionInn. All Rights Reserved