Chapter 2, Problem 3.14CP

Populate the tables with the following data, Save and print a copy of each table.

find uniq data

1. Using Rstudio, Create a factor, based on the information given: Out of 27 respondents considered in the survey, the respondents specify that their favorite subjects are mathematics, statistics, and science with 12, 5, and 10 of the total respondents, respectively. Create a factor, based on the information given. 2. Using the given Rstudio in the picture, select students with grades in mathematics at most 85 and at least 85 in statistics.

Subject : Data stuctures Draw BST from the following values: 2, 9, 4, 15, 20, 7, 12, 1, 18

Using the World database, how many regions are in the continent of Antarctica?  Display this number as “Number of Regions”.  Display the name of the continent as ‘Continent’.  Also display the grand total surface area as “Total Surface Area”

One of the advantages of using Excel is that when you change some of your data, you can obtain the new result quickly. To illustrate that, we would like to know how the mean changes if one of the elements, say 35, in our data increases.Click on cell A2 where the 35 is located. Now type 56 instead.Press enter.Observe how both means automatically change into 59.6.  Ex 1.  Did the mean increase or decrease? Put your result in cell A13 Ex 2.  Why?  Put your explanation in cell A14

For the Teams data frame, derive a new variable HR_per_G for the year 2010. Determine the top 5 teams in terms of HR_per_G for the year 2010. Make a table that list the team’s name, HR and HR _per_G.

Using MySQL, create a table named CUST_MYSQL with the same fields as in Problem 16, except, use the AUTO_INCREMENT feature for the CUST_NUM field.

(MySQL) The data tables were too long to post here. Q1. Use TopBabyNamesbyState.csv1 and write queries to extract the following information:  How many unique names are there in this dataset?  Which name in which state and in which year had the highest number of occurrences.  What is the average occurrence of “Jessica” as a top name in the state of CA?