Please download the required CSV data file here:https://drive.google.com/file/d/1R63J3Z2LtnIsdnhqdBNt-4lxEzTOxpmI/view?usp=sharing (Links to an external site.)This assignment will focus on using some of the techniques we have seen over the past three weeks for manipulating data in R. For this assignment we will be working with a dataset consisting of demographics together with weekly religious service attendance for 5000 individuals. Most of the variable names are self-explanatory, but the “Weekly Attendance” column shows a value of “1” for those who report attending religious services weekly and “0” for those who don’t. You will read this file into R and answer a few questions that will require you to apply data transforms for finding the answer.Important Formatting Instructions: Please round all answers to the nearest whole number. There should be no decimals or commas, only integers. Here some examples of what to do (good examples) and what NOT to do (bad examples):Good Examples (enter examples like these): 5, 2, 22, 11, 128, 228000Bad Examples (don’t do this!): 5.31, 2.0, 22.000, 11.88231, 128.0, 228,000INTEGRITY STATEMENTYou must work on this entirely alone without consulting with any other student. You may certainly use your notes and any class materials as well as outside R resources, but you may NOT ask others for help or seek the answers on the Internet or from any other source. This must be entirely your own work. Additionally, you may NOT discuss these answers or in any way make them public. The Honor Code is in full effect!HOW TO SUBMITUse R to answer the questions below. It is recommended to work the answers out first, then log into the website below to enter your answers. You will need to enter them all in one sitting. Please MAKE SURE to follow the formatting instructions so you don’t needlessly lose points.Once you are ready, you may log on with your NetID and enter your answers HERE (Links to an external site.)QUESTIONS1. What is the mean number of years of education?2. What is the median age?3. How many males are in this dataset?4. How many females are in this dataset?5. How many married females are in this dataset?6. How many unmarried males attend services weekly in this dataset?7. What is the median income of those who attend services weekly?8. What is the median income of those who DO NOT attend services weekly?For the next 3 questions, add a new column called “HigherEd” that provides a label based on years of education according to the following rules:Educ < 12: “None”12 <= Educ < 16: “HighSchool”16 <= Educ < 17: “College”17 <= Educ < 19: “Masters”Educ >= 19: “Doctorate”9. What is the median income for those with HigherEd = “College”?10. How many females with HigherEd = “Masters” in this data?11. How many individuals who hold a doctorate attend weekly religious services?

Throughout this course, you have covered 11 sections of the textbook and completed over 150 math problems! For this discussion board assignment, select one skill or concept you have learned in Units I–VII, and explain it to the class in your own words. In addition to your explanation, provide an example with computation or describe how this concept can be utilized in the real world. Please select a different topic than what has already been mentioned by your classmates.undefinedWhen responding to classmates, include any suggestions or expand on the topic presented by your classmate.undefinedPlease include the name of the person or question to which you are replying in the subject line. For example, "Tom's response to Susan's comment."undefinedUnit VII Homework undefinedDue: Tuesday, 05/11/2021 11:59 PM (CST)undefinedInstructionsundefinedYou have unlimited homework attempts.undefinedIn this assignment, you will be asked to calculate several statistics for a particular data set. Please click here to view the template. Complete the template as instructed and upload it in Blackboard for your professor to grade. Please note that you MUST show all work to receive maximum credit.