dataset and would like to make sure our previously created PivotTables and PivotCharts are updated to reflect the newly added data. You can also assume that the cell

Q2. [CLO3: Transform the ERD below to a relational model using the text-based form. REPAIRSHOP RID Location Phone Number Capacity CAR CID Siand Type Release Date Provide your answer in the format given below. Table_Name(Column1, Column2, Column3, Column4,...) Note: Use solid line to indicate the primary keys and use dash line (-) to indicate the foreign keys.

Using R lab please provide the code and answer:Find the data set “HELPrct”. Construct a side by side boxplots (can be horizontal orvertical) to compare the effect of homeless or housed on the average number of drinks perday for the patients. Add title “XXXXXX – Side by side Boxplot to compare the effect ofhomeless on average number ofDrinks”.Based on the side by side boxplot; write a simple conclusion.Find the data set “HELPrct”. Construct a side by side boxplots (can be horizontal orvertical) to compare the effect of different race groups on the average number of drinksper day for the patients. Add title “XXXXXX – Side by side Boxplot to compare the effectof race groups vs on averagenumber of Drinks”.Based on the side by side boxplot; write a simple conclusion.

The InstantRide User Satisfaction team requires the average and maximum number of rides users have taken so far with InstantRide. In addition, they would like to know the total number of travels. However, they need these details with the corresponding column names Average, Maximum and Total by using the AVG, MAX and SUM functions. In order to accomplish this, you will first need to create a derived table from the TRAVELS table to pass the TRAVEL_ID count to the three mathematical functions.

Create lookup functions to complete the summary section. In cell I6, create a formula using the VLOOKUP function to display the number of hours worked in the selected week. Look up the week number in cell I5 in the range A17:G20, and return the value in the 2nd column. Use absolute references for cell I5 and the range A17:G20.

1. Use the fill handle to create two lists of percentages: (a) 4.00% through 13.00% in increments of 0.50% in the range I5:I23 and (b) 4.00% through 11.00% in increments of 1.00% in the range J4:Q4. 2. Use the Data Table button in the What-If Analysis gallery (Data tab | Forecast group) to define the range I4:Q23 as a two-input data table. Enter C8 in the ‘Row input cell’ box and C5 in the ‘Column input cell’ box (Data Table dialog box). Click OK to populate the table. 3. Format the two-input data table using a White, Background 1 font color and the fill color used in cells B3:G12. Bold ranges I4:Q4 and I5:I23. Format cells J5:Q23 to match the number format used in cells F5:G12. Place a light style border around the range I3:Q23, light style borders between columns in that same range, and a light style bottom border on the range I4:Q4. 4. Protect the worksheet so that the user can select only unlocked cells (C3:C6 and C8:C9). *Complete the following using Excel based off the document…

Part 2 of the Introduction to RStudio & Tutorial uses two variables from the Lending Club data: loan amount and homeownership. For the assignment you'll submit, you will practice using two different variables. Please make sure the assignment you submit uses the correct variables (specified in the questions below). Exploring a Single Quantitative Variable For this portion of the assignment, you'll practice using R to explore the annual_income variable in the loan50.csv data set. a. Construct a histogram of the annual income data. Include informative labels and a title. Include your histogram below. b. Construct a boxplot of the annual income data. Include informative labels and a title. Include your boxplot below. C. Using the histogram you constructed in part a and the boxplot from part b, describe the shape of the distribution of the annual income variable and comment on the presence of any outliers. d. e. Calculate the mean of the annual income data. Calculate the median of the…