https://1drv.ms/x/c/c25bc623cf46c049/EeAr49m9LWtMjMtzOXqGNc4Bst7VHHy0CfZ5SHfHia3a8A?e=4%3a605f15fb2112461fa5bb62cb5dd1148c&sharingv2=true&fromShare=true&at=9

In the Math 110 Estrada FA22 folder load the data set TransferAcademy.php(n=200) data set. Suppose that this data set was collected from a random sample of 200 students from a large US public university located in the midwest in the year 2013. Below is a description of each of the variables organized by columns: Gender: What gender do you identify as? Class: What is your current class standing? Freshmen =1, Sophomore = 2, Junior = 3 and Senior = 4 Units: How many units are you currently taking? Work: How many hours do you typically work per week? Loans: What is your current student loan balance? CC debt: What is your current Credit Card debt balance? Create a histogram for the variable \"Units\" describe the shape of the distribution and use the histogram to determine the proportion of students who are taking 15 units or more (state proportion as a fraction, decimal and percent). Include a copy of the histogram created here. Use the typical interval relative to the mean and describe the interval of typical unit load at this school. Use the typical interval relative to the median and describe the interval of typical credit card debt at this school. Use a pie chart to determine the proportion of students in this sample who are Freshmen (Class=1) State this value in fraction, decimal and percent form. Include a copy of the pie chart here. . A student would like to predict the amount of units a student takes (units) using work hours (Work). Create a least squares regression line equation to model this relationship. Using the equation you computed in question 5, interpret the meaning of the slope in the context of the problem. Use your equation from part 5 and predict the number of units a student would take if we know they are working 15 hours per week. Show your work. Create a 95% confidence interval to estimate the proportion.aisitdanisatthis.school who are