In R please provide the code and steps for the following Install the dplyr package and load the library. Load the starwars data set Make a new dataframe that only contains the height and species columns from the original data set Remove all of the rows from the new dataframe that have missing values. How many rows of data were lost when the n/a values were removed? It is recommended that you use the na.omit() function for this ex: myData <- mydata %>% na.omit() Create two new dataframes that contain the heights of humans and aliens (not humans and not droids) respectively. Read the help documentation for the par() function – the first example listed is especially relevant. Create 4 images in the same window Top Left : histogram of human heights Top Right: histogram of alien heights Bottom Left: qq plot of human heights Bottom Right: qq plot of alien heights Describe the shape of the distributions and what your observations are about the heights of these two groups based on these four graphs. For the humans and the aliens individually, compute the median, mean, and standard deviation of the heights. Conduct a Wilcoxon signed rank test to test the hypothesis that the median heights of humans and aliens in Star Wars are not the same. Use a significance level of 0.05 for your test. In your report, clearly state the test hypotheses, the result, and the conclusion in the context of the problem. Conduct a hypothesis test to determine if the standard deviation of the heights of the alien population is greater than the standard deviation of the heights of the human population in Star Wars. Use a significance level of 0.05 for your test. In your report, clearly state the test hypotheses, the result, and the conclusion in the context of the problem.
SQL
SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.
Queries
A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prior to displaying the results. A search query is one type of query that many people perform several times per day. A search query is executed every time you use a search engine to find something. When you press the Enter key, the keywords are sent to the search engine, where they are processed by an algorithm that retrieves related results from the search index. Your query's results are displayed on a search engine results page, or SER.
In R please provide the code and steps for the following
- Install the dplyr package and load the library.
-
Load the starwars data set
-
Make a new dataframe that only contains the height and species columns from the original data set
-
Remove all of the rows from the new dataframe that have missing values. How many rows of data were lost when the n/a values were removed? It is recommended that you use the na.omit() function for this ex: myData <- mydata %>% na.omit()
-
Create two new dataframes that contain the heights of humans and aliens (not humans and not droids) respectively.
-
Read the help documentation for the par() function – the first example listed is especially relevant.
-
Create 4 images in the same window
-
Top Left : histogram of human heights
-
Top Right: histogram of alien heights
-
Bottom Left: qq plot of human heights
-
Bottom Right: qq plot of alien heights
Describe the shape of the distributions and what your observations are about the heights of these two groups based on these four graphs.
-
-
For the humans and the aliens individually, compute the median, mean, and standard deviation of the heights.
-
Conduct a Wilcoxon signed rank test to test the hypothesis that the median heights of humans and aliens in Star Wars are not the same. Use a significance level of 0.05 for your test. In your report, clearly state the test hypotheses, the result, and the conclusion in the context of the problem.
-
Conduct a hypothesis test to determine if the standard deviation of the heights of the alien population is greater than the standard deviation of the heights of the human population in Star Wars. Use a significance level of 0.05 for your test. In your report, clearly state the test hypotheses, the result, and the conclusion in the context of the problem.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
