2.Consider the built-in USArrests data frame. (a) Determine the number of rows and columns for this data frame. (b) Calculate the median of each column of this data frame. (c) Change the row name (full name of the state) to its abbreviation (e.g. Alabama to AL, Michigan to MI). (d) Find the average per capita murder rate (Murder) in regions where the percentage of the population living in urban areas (UrbanPop) exceeds 77%. (e) Compare (d) with the average per capita murder rate where urban area population is less than 50%

2.Consider the built-in USArrests data frame. (a) Determine the number of rows and columns for this data frame. (b) Calculate the median of each column of this data frame. (c) Change the row name (full name of the state) to its abbreviation (e.g. Alabama to AL, Michigan to MI). (d) Find the average per capita murder rate (Murder) in regions where the percentage of the population living in urban areas (UrbanPop) exceeds 77%. (e) Compare (d) with the average per capita murder rate where urban area population is less than 50%

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter2: Formatting Workbook Text And Data

Section: Chapter Questions

Problem 3.14CP

See similar textbooks

Similar questions

6. Normalize the data (use mean and mean absolute deviation).
1. Help needed asap! For the following group of data 100, 200, 400, 800, 1500 Normalize the data by min-max normalization so that the transformed data falls in the range [0.0 10.0].
Use R language to complete assignment. Load the Iris dataset and answer the following questions with the help of R code given. State the descriptive statistics, including maximum, minimum, average, median, range, sum and standard deviation for of Sepal length, sepal width, petal length and petal width. Create and show histogram plots of Sepal length, sepal width, petal length and petal width. In the Question 2, Which histogram plots do resemble normal distribution? Discuss. Create and show a scatter plot of sepal width and sepal length. What trend do you see? Discuss. What other data visualization or analysis can be done on this dataset? Give some ideas. library(psych) library(ggplot2) Data(iris) head(iris) psych::describe(iris) # Create a scatter plot ggplot(iris, aes(x = Sepal.Length, y = Sepal.Width, color = Petal.Length, size = Petal.Width, shape = Species)) + geom_point() + scale_color_gradient(low = "blue", high = "red") + labs(title = "Iris Dataset:…
Problem. Create a truth table for the expression p V (q^-r), by filling in the indicated columns one at a time.
Problem 1: Given the dataset produce the following tables: a. A table based on Petal Length a value of less than or equal to 1.4 b. A table with any variety except Setosa variety and Petal Width of less than 2.1 c. A table with an additional feature column computing the ratio of Petal Length/Petal Width. petal.length petal.width variety 1.4 0.2 Setosa 1.4 0.2 Setosa 1.3 0.2 Setosa 1.5 0.2 Setosa 1.4 0.2 Setosa 1.7 0.4 Setosa 1.4 0.3 Setosa 1.5 0.2 Setosa 1.4 0.2 Setosa 1.5 0.1 Setosa 1.5 0.2 Setosa 1.6 0.2 Setosa 1.4 0.1 Setosa 1.1 0.1 Setosa 1.2 0.2 Setosa 1.5 0.4 Setosa 1.3 0.4 Setosa 1.4 0.3 Setosa 1.7 0.3 Setosa 1.5 0.3 Setosa 1.7 0.2 Setosa 1.5 0.4 Setosa 1 0.2 Setosa 1.7 0.5 Setosa 1.9 0.2 Setosa 1.6 0.2 Setosa 1.6 0.4 Setosa 1.5 0.2 Setosa 1.4 0.2 Setosa 1.6 0.2 Setosa 1.6 0.2 Setosa 1.5 0.4 Setosa 1.5 0.1 Setosa 1.4 0.2 Setosa 1.5 0.2 Setosa 1.2 0.2 Setosa 1.3 0.2 Setosa 1.4 0.1 Setosa 1.3 0.2…
Normalization should be defined.
Q4) Using KNN, classify the following data (40,80,?) where k-3 and 5 using the Manhattan distance: (25,40,N) (35,60,N) (45,80,N) (20,95,Y) (40,60,Y) (60,100,Y) (20,20,N) (30,150,Y)
Normalization Diagram. See the attached picture.
Create median with only built-in min-max and arithmetic operations.
The following table shows the student grades for Q1 and Q2 assessment activities. Calculate the mean and mode for Q1 and Q2 grades Calculate the range and standard deviation for Q1 grades and Q2 grades Student Number Q1 Grade Q2 Grade Total student Grade 1 85 79 164 2 96 85 181 3 84 76 160 4 75 76 151 5 64 94 158 6 83 83 166 7 92 92 184 8 74 71 145 9 67 81 148 10 81 93 174 11 93 72 165
Read the numerical data from Data.txt and find the average of the first row and themin of the second row.
SQL Data Manipulation Consider the following tables with sample data: Hospital (hospitalNo, name, address, city, capacity) Doctor (doctorNo, name, specialty, salary, hospitalNo) Patient (patientNo, name, phoneNo, age, doctor) Hospital hospitalNo city capacity address 1493 Cambridge St Boston 2 East 101st St New York 700 name H117 Cambridge 600 H120 Mount Sinai *******E 潮 ...*** Doctor cpecialty salary hospitalNo | 180000 | 225000 H120 doctorNo name D201 Cardiologist Robert Donald Xin Wang H117 D205 Neurologist 林 ****** 淋琳業 Patient patientNo P366 name phoneNo Arthur Gluck age doctor D201 72 617-482-5801 P351 Lisa Hershman 212-353-1463 46 D205 Perform the following tasks using SQL statements: