Problem 8 (8 points) Please find the attached EXCEL file named Pay. Bob wants to predict...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Problem 8 (8 points) Please find the attached EXCEL file named "Pay." Bob wants to predict the hourly pay by findings the influential factors from four aspects: Job Class, Years with Company, Years in Union, and Local. Please use EXCEL to run multiple linear regression. (1) Please code the Variables of "Local" as a dummy variable. Please list the first five observations' numbers after your coding for "Local" Please attach a screenshot of the multiple linear regression output (1 point) (2) If we denote the Variable of "Hourly Pay" as "P," "Job Class" as "J," "Years with Company" as "C," "Years in Union" as "U," and "Local" as "L," Please list the multiple linear regression model. (2 points) (3) Please discuss the model fitness by focusing on the adjusted R Square Value. (1 point) (4) If Tom knows another observation has the values of J, C, U, and L as 30, 10, 8, and Y, please help Bob to predict the hourly pay. (2 points) (5) What are the statistically significant factors for the hourly pay, are they positively significant or negatively significant? Why? (2 points) Problem 8 (8 points) Please find the attached EXCEL file named "Pay." Bob wants to predict the hourly pay by findings the influential factors from four aspects: Job Class, Years with Company, Years in Union, and Local. Please use EXCEL to run multiple linear regression. (1) Please code the Variables of "Local" as a dummy variable. Please list the first five observations' numbers after your coding for "Local" Please attach a screenshot of the multiple linear regression output (1 point) (2) If we denote the Variable of "Hourly Pay" as "P," "Job Class" as "J," "Years with Company" as "C," "Years in Union" as "U," and "Local" as "L," Please list the multiple linear regression model. (2 points) (3) Please discuss the model fitness by focusing on the adjusted R Square Value. (1 point) (4) If Tom knows another observation has the values of J, C, U, and L as 30, 10, 8, and Y, please help Bob to predict the hourly pay. (2 points) (5) What are the statistically significant factors for the hourly pay, are they positively significant or negatively significant? Why? (2 points)
Expert Answer:
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these accounting questions
-
For the borrow pit grid shown in the figure, compute the excavated volume, in m. The depths of cut at the grid points are given in the field. (30) The depths of cut (m) A0 Al BI A2 B2 A3 A4 3.6 4.3...
-
Discuss the use of dummy variables in regression analysis.
-
A multiple regression with 36 observations and three explanatory variables yields the ANOVA table in Table 11.1. a. Complete this ANOVA table. b. Can you conclude at the 1% significance level that...
-
In Figure 3-4, the current position of the demand curve is D 1 , and the price of a wireless earbud, which is a normal good, is $3. If there is an increase in consumer incomes, will the demand curve...
-
The object classication budget of a re department includes the following expense categories: Salaries Employee benets Supplies Equipment Station maintenance, utilities, etc. Vehicle...
-
Consider again the investment problem that opened the chapter. a. Suppose the portfolio manager limits the portfolio to treasury bills and treasury bonds. Using a graph, find the proportions of each...
-
Draw a cash flow diagram of any investment that exhibits both of the following properties: 1. The investment has a 4-year life. 2. The investment has a 10 percent/year internal rate of return.
-
After watching the video on expatriates, discuss the following: 1. What kind of staffing approach is being used by Dubai? Explain. 2. What does Kevin ONeal, as an expatriate, bring to Dubai? 3. What...
-
Consider the following two lines. A line whose equation is 5x - 6y= 4. = A line perpendicular to the first line. Determine the slope, m, of the line whose equation is 5x - 6y = 4. m1 56 State the...
-
Create a set of use cases for the following high-level requirements in a housing system run by the Campus Housing Service. The Campus Housing Service helps students find apartments. Owners of...
-
The risk-free rate is 2% per year and a corporate bond yields 4% per year. Assuming a recovery rate of 40% on the corporate bond. 1) What is the approximate market implied one year probability of...
-
An unknown metal is known to be either copper ( = 4.7 eV), uranium ( = 3.6 eV), zinc ( = 4.3 eV), beryllium ( = 5.0 eV), or platinum ( = 6.1 eV). Using a photospectroscope, light of 118 nm wavelength...
-
You were hired as a consultant to Fama LLC. You were provided with the following data: Target capital structure: 35 percent debt, 10 percent preferred, and 45 percent common equity. The cost of debt...
-
Consider Anne from the previous question with the utility function U = X2Y2 and facing prices Px and Py and income I. a. Write out the Lagrangian function used for deriving the compensated demand...
-
give insights into how does fiscal policy being implemented during changes/shifts in the economy affect the financial outlook relative to annual deficits and the national debt?
-
What happens if the marginal revenue curve and the marginal cost curve do not intersect? Explain.
-
Calculate net new loans using the following information: Dividends Paid: $50,000 Net New Shares Issued: $40,000 Operating Cash Flow: $185,000 Net Capital Expenditure: $60,000 Change in NWC: $25,000...
-
Rowland Textile Inc. manufactures two products: sweatshirts and T-shirts. The manufacturing process involves two activities: cutting and sewing. Expected overhead costs and cost drivers are as...
-
Clifford Johnson has a limited partnership investment and a rental condominium. Clifford actively manages the rental condominium. During 2012, his share of the loss from the limited partnership was...
-
Mary paid $2,000 of state income taxes in 2012. The total sales tax she paid during 2012 was $5,500, which included $3,000 for the cost of a new car. How should Mary treat the taxes paid on her 2012...
-
Steve Jackson (age 51) is a single taxpayer living at 3215 Pacific Dr., Del Mar, CA 92014. His Social Security number is 465-88-9415. In 2012, Steve's earnings and income tax withholding as the...
-
The purchasing officer for The Majestic Emporium has prepared a purchases budget for the financial year ending 31 March 2020, based on the following data. The cost of sales is 65% of sales, and the...
-
Greyt Dog Beds Ltd manufactures dog beds specifically designed for greyhounds and whippets. The company purchases all the required materials from external suppliers and designs and assembles the...
-
Ketton Ltd is in the process of preparing direct labour and factory overhead budgets for the year ending 30 June 2020. Relevant data are set out below. Required (a) Prepare the direct labour budget...
Study smarter with the SolutionInn App