WEEK- 2 code install.packages(“dplyr”) library(dplyr) Rajeshdf = read.csv(‘c:\\Insurance.csv’) str(Rajeshdf) str(Rajeshdf) summary(Rajeshdf) agg_tbl <- Rajeshdf %>% group_by(Rajeshdf$JOB) %>% summarise(total_count=n(), .groups = ‘drop’) agg_tbl…
1.Why do auditors generally use a sampling approach to evidence gathering Auditors must balance the cost of the audit with the need for precision. 2.Which of the following statements best describes a relationship between sample size and other elements of…
Week 3 Quiz [100% Score] 1.The government taxes consumers in order to _________All of the these. 2.Horizontal equity is most closely aligned with ______________ taxes.proportional 3.If the market for loanable funds is at equilibrium and the interest rate rises, what…
Excel creating a basic dashboard Chapter 1 1) You want to create a PivotTable of your own. What is the next step after selecting any cell inside the table you are using? Select PivotTable on the Insert tab This is the action you would take to begin creating your own type of PivotTable. 2) Lee_jin created a conditional format based on a formula. What is the advantage of using a formula-based conditional format? Lee_Jin can update the rule by changing values in cells the formula references When using a formula_based value and the target is edited, the conditional format updated automatically 3) Miguel wants to modify his PivotTable to include currency. Which action allows him to do this in the PivotTable? Change the format applied to the data field This action enables Miguel to change all appropriate cells to the currency format 4) Which visual summary tool would you most likely use when you want to work flexibly with a large data set? PivotChart This type of chart will enable you to easily create a chart, and then make modifications with the fields you want to include. 5) You can use a filter to display just the highest or lowest values in a data set.…
1. To answer this question, please refer to the CRAN Packages web page referred to in the course material.Which of these packages are used for Optical Character Recognition? abbyyR 2.Using the iris data set in R, generate a box plot…
1.Consider the following gasoline sales time series data. Click on the datafile logo to reference the data. Week Sales (1000s of gallons) 1 17 2 21 3 19 4 23 5 18 6 16 7 20 8 18 9 22…
1.You need to design a backup strategy. You need to ensure that all servers are backed up every Friday night and a complete copy of all data is available with a single set of media. However, it should take minimal…
LESSON-1 Q1) which of the following functions of the database management system causes some data to be read and some data to be written into a database. Transaction Q2) which of the following applications analyses large amount of data to search for…
LESSON-7 Q1)Which of the following joins is the default type of join in a joined table, where a tuple is included in the result only if a matching tuple exists in the other relation? Inner Q2). Which of the following…
1.Carlos has just created a new subnet for the finance department. He needs to be able to allow the employees in finance to retrieve files from the sales server, which is located in another subnet. Which of the following OSI…
