Ian Stevens is a human resource analyst working for the city of Seattle. He is performing a
Question:
Ian Stevens is a human resource analyst working for the city of Seattle. He is performing a compensation analysis of city employees. The accompanying data set contains three variables: Department, Job Title, and Hourly Rate (in $). A few hourly rates are missing in the data.
a. Split the data set into a number of subsets based on Department. How many subsets are created?
b. Which subset contains missing values? How many missing values are in that data set?
c. Use the imputation strategy to replace the missing values with the mean of the variable. What is the average hourly rate for each subset?
Department Public Utilities Sustainability & Environ Dept ⠀ Public Utilities Job Title Res&Eval Asst StratAdvsr3,Exempt ⠀ Capital Prits Coord, Asst Hourly Rate 32.81 62.27 # 42.71
Step by Step Answer:
a 4 subsets were createdDept of HR IT Dept Public Utilities and Sustainability and Environ ...View the full answer
Business Analytics Communicating With Numbers
ISBN: 9781260785005
1st Edition
Authors: Sanjiv Jaggia, Alison Kelly, Kevin Lertwachara, Leida Chen
Students also viewed these Business questions
-
A teacher working for the City of Lights earns vacation pay of $2,000 during 2010. However, the vacation will not be taken until near the end of 2011. In the government-wide financial statements for...
-
A teacher working for the City of Lights will be provided with a defined benefit pension plan. The city sets up a pension trust fund to monitor the resources held for these future payments. How is...
-
A teacher working for the City of Lights earns vacation pay of $2,000 during 2013. However, the vacation will not be taken until near the end of 2014. In the government-wide financial statements for...
-
Prepare a forecast of after-tax cash flows for fiscal 2022, 2023, and 2024 for each of the two financing proposals, assuming the following: Revenue increases 5% annually. EBITDA margin is 15%. ...
-
Explain carefully the steps you would use to create an electroscope that is positively charged by induction. After you are done, suppose a charged object was brought near the top of the electroscope...
-
What factors should be considered in setting a: (a) Materials price standard; (b) Materials usage standard; (c) Labour rate standard; and (d) Labour time standard?
-
A mutual fund has provided investment yield rates for five consecutive years as follows: Determine \(r_{1}\) and \(r_{2}\), the lag 1 and lag 2 autocorrelation coefficients. Determine \(r_{1}\) and...
-
A company builds custom equipment, [t has landed a contract with a major customer. Relevant data are shown below. The complication is that the delivery has been promised in 32 weeks and the company...
-
Create the general journal entries, post to the T - Accounts, and record all applicable entries to the job sheets.a . Raw materials of $ 5 0 , 0 0 0 . 0 0 were purchased with cashb. Factory labor...
-
You receive an inheritance of half a million dollars today and will also receive a million dollars from an investment in exactly 2 years' time. If you decide to spend $373,000 now but save the...
-
Refer to the previous exercise for a description of the problem and data set. The financial analyst wants to find out if there are any missing values in the data set. a. Are there any missing values...
-
Refer to the previous exercise for a description of the data set. Denise feels that, for her presentation, it would remove some biases if the player names and team names are suppressed. Remove these...
-
Demonstrate with a vector diagram that a displacement is the same when measured in two different reference frames that are at rest with respect to each other.
-
Summarize the information that the companys mission and thorough external and internal analysis provide to guide strategy.
-
How can we collect structural data sets? Name important data types that can be used for structural analysis.
-
What type of strain can produce transected folds?
-
What is unrealistic about the domino fault model?
-
What is meant by the expression slip inversion?
-
The market model specifies a very simple relationship between a security's return and the return on the market index. Discuss some "real world" complexities that might diminish the predictive power...
-
How does the organizational structure of an MNC influence its strategy implementation?
-
a. Who is liable for additional taxes on a joint return? b. Why is this so important?
-
Can couples change from joint returns to separate returns? Separate to joint?
-
This year, Yung Tseng, a U.S. citizen, supported his nephew who is attending school in the United States. Yung is a U.S. citizen, but his nephew is a citizen of Hong Kong. The nephew has a student...
-
Explain the process in bullet points or a flowchart: Identify financial statements and inputs required. Develop assumptions based on historical data and future expectations.
-
Brew Shack is a small brewery that is trying to better understand its costs. The company, which currently uses traditional job-order costing, allocates overhead costs using a single cost driver. The...
-
HyperLens has the following budgeted cost information: Budgeted manufacturing overhead $1,928,500 Budgeted machine hours 8,000 Budgeted direct labor hours 4,200 Budgeted units 40,000 Cost Pool Total...
Study smarter with the SolutionInn App