BUSA537 Advanced Analytics

You may use either the local functions, or the dplyr / data.table packages to perform the following actions (do NOT use any other package for computations – for graphing, use any package): File Provided: exam1quality.xls 1. Create a data.frame object named airQ from the excel file (given).
2. Sort the data by the Wind column3. For each Temp reading in the original exam1quality data, create a plot of Temp against Ozone only if (Temp>=60). In case where the Ozone reading is not available, do NOT plot that Temp-Ozone pairing. Ensure that all the plots are on the same axis and include a suitable title that indicates the month—for example, “Ozone against Temp for Month X.
4. Create a subset of the original exam1quality data containing just three columns: Month, Day, and Solar.R. The data should only contain data for June and July. Create a new .txt file named solar, and put the data in it. (10 pts) (see next page) Q2 (30 pts) File Provided: CarPerformance.csv This file has 234 rows and 11 variables. Variable details are: You may use either the local R functions, or the dplyr / data.table packages to perform the required computations (do NOT use any other package for computations – for graphing, use any package. I use ggplot2):
1. Create a function called CarPFunction that will take CarP as input and store (on separate lines – tab-delimited) the make, model, and year of the cars that do more than 20 gallons in the city, in a file called CarPSubset.txt. Show screenshot of the file contents. NO need to submit the .txt file. 2. Find the average miles per gallon (city and highway both – listed separately) for each car model. (10 pts) 3. List the car manufacturer name against the cyl that occurs most in the given dataset. For instance, audi 6, since in the dataset it has nine 6 cylinder cars, eight 4 cylinder and one 8 cyl. (10 pts) (see next page)
Q3 In this question you will create a simplified cash register. Use the runif function to generate a float (i.e. with or without the decimal) random number between 1 and 90 (let’s call this amount). A customer owes this amount, show the amount to the user. Take the input from the keyboard for the customer to pay this amount. Customer will hand you (input) some money in an integer denomination greater than the amount. For example, if the amount is $44.37, the customer hands you 50 or 60 or 70 greater (up to 100). If the amount given is the exact amount, then you should tell them that no change is owed. Otherwise, you should calculate the number of each denomination to give them back in their change. The denominations available are dollars (1.00), quarters (0.25), dimes (0.10), and nickels (0.05). A penny should be rounded up to the nearest nickel. Once you have calculated the change you should tell the customer how much change you have given them. In order to keep your customer happy, you should always give them the fewest coins possible, do not simply give them back all their change in nickels. You are expected to use meaningful variable names and comment any code you feel requires explanation. Example case: Random Amount – $44.39 User Gives (keyboard input) – $60 Change = 60 – 44.37 = $15.61 Fewest denomination change is: 15 Dollars, 2 Quarters, 1 Dime , 1 Nickel (the 1 cent is rounded up to a nickel) What to Submit • One file. File Name: Exam 1_537_LastName_FirstName.docx or .pdf (no .zip) • In the file, post screenshots and the R-CODE for each part in sequence. If you cannot do a part, state that! e.g., • Q1 1. Show screenshot R-CODE 2. Show screenshot R-CODE 3. I could Not do this part 4. Show screenshot R-CODE • Notice the lines and double-lines demarcations above. Your files SHOULD have such sectional demarcations after each answer. • Include comments in your code. • Make sure your code is written nicely (i.e. adequate tabs, spaces, etc.) • Failure to adhere to any of the above instructions will result in point-deductions. NOTE: Due to the nature of questions, and choice of solutions, the chances of Your code matching another student’s code are slim. Thus, please do NOT plagiarize!

Representatives of our student assignment service are connoisseurs of the peculiarities of presentation in regards to academics. Your college assignment will never turn out an untoward surprise! Whether you need research for high school, an undergraduate program, or a Master’s or Doctoral degree, you will get exactly what you are looking for to sound smart and well-informed. If you are pressed for time, request our experts! We are your academic saver. It is a perfect solution for people who need academic help but has no professionals nearby to provide it. Just redirect your home tasks to us and forget about any educational issues. With us, you will get 100% plagiarism-free content delivered on time by an experienced specialist in a particular field. Main Advantages of Collaboration with Us When you order professional assignments here, you will get: Original custom papers. We value your academic reputation. Just as well, we value the years of thorough work on our reputation for reliability and never compromise the originality of delivered papers. We will never endanger both. Every custom assignment is written from zero – the only possible first stage of work on the order is research. We apply the latest plagiary checking tools on the final stage, so plagiarism has no chance to emerge in your college assignment writing. Control over the order completion. To make the process of collaboration comfortable and efficient, we offer our clients to choose the writer themselves taking into account all the requirements and the budget. For you to save nerves, having entrusted your fateful task to some qualified “stranger”, we enable communication with the assigned writer in the process of order completion. Affordable assistance. . help with college assignments. We are eager to help you start investing in your career growth today. That is why our service is so affordable. We don’t charge to pay for the latest marketing tricks or advertisements – we choose the best experts in the labor market who write great custom papers in any area, level of complexity, and time frame. Our client’s grateful feedback is a top advertising trick. On-time delivery. The quality of a paper is only valued when it is delivered within the determined time frame – you will get your custom assignment writing service in time and have a couple of days to revise it and ask for changes in case they are needed. And you will still have time to learn the material. Protection. We value your trust and take all measures needed to keep your private and banking details safe. We offer only well-tested payment methods. Due to the system of encryption and protected servers, no third party can have access to your data. Custom support 24/7. We do our best to make the process of collaboration comfortable for the customer. Our “write my assignment” help is always here for you to provide a solution to your problems, give you a prompt answer to any question, and offer clarification as to any issue related to the services. Feel free to contact us anytime! If you feel that your dissatisfaction with student life is growing every day and you just feel exhausted, don’t hesitate to change the situation for the better today. Order your first assignment from reliable custom assignment services today to evaluate the advantages. Having seen the difference once, you won’t want to go back to your previous lifestyle. You deserve to find fulfilment in other spheres of your life, have hobbies, spend time with close people but continue making progress. It is possible when you have a professional helper. Don’t put off your life for someday after graduation!