Chapter 2, Problem 1.9CP

Plot 2 bar charts for India Percent and China Percent with all axis, legend and Title labels using subplot() aligned vertically: a) India Percent vs Year – vertical bar plot b) USA Percent vs Year – horizontal bar plot

Submit a single Excel file with formulas within answer cells. Show the formulas for the answer    County Hospital contracts for an anesthesiologist’s services for a guaranteed cost of $15,000 a month. For every service the anesthesiologist provides on a procedure, the hospital budgets an incremental $200 toward the anesthesiologist’s salary.  Every time the anesthesiologist provides a service, the hospital gains revenue of $1200, which is a sixth of the overall procedure’s revenue.  Be sure to make excel do the calculations and indicate any units for the answer. How many procedures would an anesthesiologist have to work on monthly for the hospital to Break Even?

Submit a single Excel file with formulas within answer cells. Show the formulas for how to get the answer.   County Hospital contracts for an anesthesiologist’s services for a guaranteed cost of $15,000 a month. For every service the anesthesiologist provides on a procedure, the hospital budgets an incremental $200 toward the anesthesiologist’s salary.  Every time the anesthesiologist provides a service, the hospital gains revenue of $1200, which is a sixth of the overall procedure’s revenue.  Be sure to make excel do the calculations and indicate any units for the answer. The revenue for the anesthesiologist’s portion of the procedure is only a fifth of the overall procedure revenue.  What would the hospital’s monthly total revenue be for the BE procedures?

Create a Movie table with the following columns: ID - positive integer with maximum value of 50,000 Title - variable-length string with up to 50 characters Rating - fixed-length string with 4 characters ReleaseDate - date Budget - decimal value representing a cost of up to 999,999 dollars, with 2 digits for cents

The following table is in 2NF. Convert it to 3NF using proper notation: Forum (ForumNum, ForumDate, CustomerNum, LengthOfForum, PresentationCode, FacilitatorID (LastName, FirstName, Street, City, ZipCode))

How would you create that chart up top with the destination,reg price, reduced and sales price using that same flight_sales text file?

Output the information in a formatted table. The title is right justified with a width of 33. Column 1 has a width of 20. Column 2 has a width of 23. Ex: Number of Novels Authored Author name | Number of novels -------------------------------------------- Jane Austen | 6 Charles Dickens | 20 Ernest Hemingway | 9 Jack Kerouac | 22 F. Scott Fitzgerald | 8 Mary Shelley | 7 Charlotte Bronte | 5 Mark Twain | 11 Agatha Christie | 73 Ian Flemming | 14 J.K. Rowling | 14 Stephen King | 54 Oscar Wilde | 1

Question: Create a new variable with earnings conditional on working (missing for non-employed) and calculate the means of this by the group as well. Note: We need a Rmarkdown code for this one?

Draw a side-by-side bar chart to display the distribution of gender for each award the students would prefer to win for the 200 students.