You are a data analyst at ABC solutions. You received a problem for analyzing student grading...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You are a data analyst at ABC solutions. You received a problem for analyzing student grading system with the following data: SID={ 29,34,56,12,na, 31, 52, 48, 26,18), Sname={ Raman, Wipro, Karan, Dell, Rosy, John, Clark, Smith, Na, Bajaj), Gender={Male, Male, Male, Female, Female, Male, Male, Female, Male, Male), Course={CSE, ECE, CSE, MECH, ECE, CSE, BBA, LAW, CSE, ECE), Marks= (570,440,320,530,390,230,365, 440,375,290), Grade={A, B.C A,C.D.C.B.C.D) i, Identify the suitable R-data structure and write R-Code routine. [3M] i. Detect duplicated and unique values on course, Marks, and Grade [3M] i. Identify 'NA' value and print the corresponding column output [3M] iv. Replace 'Male' with 'M and CSE' with 'SCOPE' on the corresponding columns[3M] You are a data analyst at ABC solutions. You received a problem for analyzing student grading system with the following data: SID={ 29,34,56,12,na, 31, 52, 48, 26,18), Sname={ Raman, Wipro, Karan, Dell, Rosy, John, Clark, Smith, Na, Bajaj), Gender={Male, Male, Male, Female, Female, Male, Male, Female, Male, Male), Course={CSE, ECE, CSE, MECH, ECE, CSE, BBA, LAW, CSE, ECE), Marks= (570,440,320,530,390,230,365, 440,375,290), Grade={A, B.C A,C.D.C.B.C.D) i, Identify the suitable R-data structure and write R-Code routine. [3M] i. Detect duplicated and unique values on course, Marks, and Grade [3M] i. Identify 'NA' value and print the corresponding column output [3M] iv. Replace 'Male' with 'M and CSE' with 'SCOPE' on the corresponding columns[3M]
Expert Answer:
Answer rating: 100% (QA)
plss find the attached detailed solution First of all create a dataframe using above attributes ... View the full answer
Related Book For
Applied Statistics for Public and Nonprofit Administration
ISBN: 978-1285737232
9th edition
Authors: Kenneth J. Meier, Jeffrey L. Brudney, John Bohte
Posted Date:
Students also viewed these computer engineering questions
-
You are given an Expert System with the following rules: R1: IF interest rates fall, THEN bond prices will increase. R2: IF interest rates increase, THEN bond prices will decline. R3: IF interest...
-
Consider an FIR system with the following system function:? H(z) = (1 ? 0.8 e j?/2 z -1 )(1 ? 0.8 e- j?/2 z -1 ) (1 ? 1.5 e j?/4 z -1 ) (1 ? 1.5 e- j?/4 z -1 ) (a) Determine all systems that have the...
-
Ima Fastrack is a data analyst at the Oakmont Civil Service Commission. When she was first hired 3 months ago, she was satisfied with her salary of $ 24,832. In the time since she was hired, Ima has...
-
The information to prepare the statement of cash flows comes from all of the following sources except: a. comparative balance sheets. b. additional transaction data about cash provided or used during...
-
In the market for gold jewelry (unlike the market for gold ore), products come in a range of designs, styles, and levels of quality. Which of the characteristics of a competitive market is violated...
-
On August 31, 2014, the account balances of Pitre Equipment Repair were as follows: During September, the following transactions were completed: Sept. 1 Borrowed $10,000 from the bank and signed a...
-
Benny has $100,000 to invest and is considering two options: Option A: Earn 6%, investment income is taxable Option B: Earn 4.8%, investment income is tax-exempt Benny has a 24% marginal tax rate. a....
-
The following crosstabulation shows household income by educational level of the head of household Statistical Abstract of the United States, 2008). a. Develop a joint probability table. b. What is...
-
How often should a key and lock custodian audit keys?
-
The database Boston Housing.xlsx** contains information on 506 census tracts around the city of Boston. The data include housing-related information (e.g., average rooms per dwelling) as well as...
-
6) You are examining the effects of eating spinach pasta versus whole wheat pasta on cholesterol levels to see if there is a difference and have assigned people to the two groups using random...
-
According to an article on the National Recycling Coalition Web site, Dell is helping to sponsor computer recycling efforts in various U.S. communities and organizations. According to an article on...
-
I don have any info but the chapter name is ( Your relationships should not leave you exhauste) Please give me the answers in your own and easy wording Please write your answers in complete...
-
Create the first quarter budget worksheet for the textured leather option, as follows: In cells A1:B2, enter the necessary inputs for the number of shoes per pair and the % of labor for overhead.
-
Assume that Green Ox will have a manufacturer cost of $0.20 per 20oz bottle and that the retail margin will be 35%. The product will be shipped directly to the retailer (no wholesale margin to worry...
-
Based on using Circular 230 and the AICPA Code of Professional Conduct, discuss the differences between the CPA-auditor vs CPA-tax accountant (or attorney) Questions: Discuss the differences of LEGAL...
-
XYZ is a cleaning company. It bills clients a monthly fee of 10, 000 payable at the end of every quarter. For the month of April, May, and June, XYZ rendered service to ABC. ABC paid 30, 000 to XYZ...
-
For the given transfer function: Vo(s) / Vi(s) = (s^2C^2R^2 + 1) / (s^2C^2R^2 + 4sCR + 1) Assumiing that 1/(CR) = 120 PI so write the matlab code to find the magnitude plot
-
The Department of Defense is concerned about the number of Harrier crashes. The Air Force argues that the crashes result because many of these planes are piloted by marines. The data for this claim...
-
Every year, air traffic controllers are given a test of their job performance based on a computer simulation. Test scores, which range from 0 to 100, are considered a good indicator of actual job...
-
The city parks commission has decided to redevelop a community park. Some members of the commission feel that refurbishment of existing park facilities is sufficient to meet the needs of the...
-
Ibrahim bought 200 shares of a stock trading in the Abu Dhabi Securities Exchange at AED 12 (United Arab Emirates dirham) per share. Over time, the price of the stock increased to AED 18 per share....
-
Twitter is trading at \($34.50.\) Call options with a strike price of \($35\) are priced at \($2.30\) . What is the intrinsic value of the option, and what is the time value?
-
Consider a put with a strike price of \($20\) and a premium of \($4.\) If the stock price is currently \($18,\) what is the breakeven price for the buyer of the put? a. \($16\) b. $22 c. $24
Study smarter with the SolutionInn App