fastfood from tidyverse and openintro packages To access the fastfood data, run the following: fastfood < openintro:: fastfood • Looking only at Burger King and Chick-Fil-A, which item has the highest calories? The answer should be saved as Q1. . What is the mean sugar amount for all items from Subway? Save the value as Q2. . What is the mean value of calories for all items from Taco Bell? Save the value as Q3. . Create a variable equal to total_fat sugar called fatXsugar. Produce a tibble that has the restaurant, item, and fatXsugar for the top 3 items, from highest to lowest. • Your answer should be in a 3 X 3 tibble called Q4 with formatting like this: # A tibble: 1 x 1 restaurant item fatXsugar 1 [name] [name] [value] 2 [name] [name] [value] 3 [name] [name] [value] How many restaurants have an average saturated fat over 10? Your answer should be one integer stored in a variable called Q5.

fastfood from tidyverse and openintro packages To access the fastfood data, run the following: fastfood < openintro:: fastfood • Looking only at Burger King and Chick-Fil-A, which item has the highest calories? The answer should be saved as Q1. . What is the mean sugar amount for all items from Subway? Save the value as Q2. . What is the mean value of calories for all items from Taco Bell? Save the value as Q3. . Create a variable equal to total_fat sugar called fatXsugar. Produce a tibble that has the restaurant, item, and fatXsugar for the top 3 items, from highest to lowest. • Your answer should be in a 3 X 3 tibble called Q4 with formatting like this: # A tibble: 1 x 1 restaurant item fatXsugar 1 [name] [name] [value] 2 [name] [name] [value] 3 [name] [name] [value] How many restaurants have an average saturated fat over 10? Your answer should be one integer stored in a variable called Q5.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Create struct HashNode and class HashTable that will be used to store students' data. For each student, it'll store the ID (string) as the key, and the first name (string), last name (string), and email (string) as the value. You can imagine a single HashNode as follows: "123456789" "Jessica" "Wolf" "abcdef@bartleby.com" HashTable should have the following attributes and methods: Attributes 1. The dynamic array that stores the data. 2. The number of elements currently stored. 3. The maximum number of elements the container can store. Methods 1. Constructor that takes from the user the maximum size of the container. 2. void insert(string ID, string firstName, string lastName, string email): uses the following hash function h2(h1(ID)) to map the key to a specific index in the table: • h1(ID): ww IDLength -1 Σ ID • h2(K) -> [0, N-1], where N is the table size In case the index that the hash function generated was already full, the insert function should add the student information in a…
Use the "College" data set from the package "ISLR", do the following: Get familiar with the data set. How many variables the data set has? What is the class of the variable "Private"? Add a new column "Enroll.rate" which is the ratio of Enroll v.s. Accept, to the data set. What are the top 10 Universities in terms of "Enroll.rate" (highest student enrollment ratio)? Get a new data frame "Mysubset" with all rows with an "Outstate" fee between 8000-9000 USD. solve using r code
Initval: endval: increments the index variable from initval to endval by .20 .10 .30
In this assignment, you should work with books.csv Download books.csvfile. This file contains the detailed information about books scraped via the Goodreads . The dataset is downloaded from Kaggle website. Each row in the file includes ten columns. Detailed description for each column is provided in the following: bookID: A unique Identification number for each book. title: The name under which the book was published. authors: Names of the authors of the book. Multiple authors are delimited with -. average_rating: The average rating of the book received in total. isbn: Another unique number to identify the book, the International Standard Book Number. isbn13: A 13-digit ISBN to identify the book, instead of the standard 11-digit ISBN. language_code: Helps understand what is the primary language of the book. num_pages: Number of pages the book contains. ratings_count: Total number of ratings the book received. text_reviews_count: Total number of written text reviews the book received.…
Present the user with a list of top Sega games, then prompt the user for which one they would like to remove, and then show the list again. The list of games is: Mortal Kombat, Contra, Streets of Rage, Shinobi, Sonic, Phantasy Star. Expected Output Here are the top Sega games: Mortal Kombat Contra Streets of Rage Shinobi Sonic Phantasy Star Which one do you think should be remove Here are the new top Sega games: Mortal Kombat Streets of Rage Shinobi Sonic Phantasy Star
in Mongo DB We want to add some students to our collection, but this time, we define the value for the _id field. (If the _id is not defined in your document, it will be added automatically.) _id: 1001 first_name: Sarah last_name: Stone email: s_stone@email.com city: Toronto status: full-time gpa: 3.4 program: CPA _id: 1002 first_name: Jack last_name: Adam email: j_adam@email.com city: North York status: part-time gpa: 3.6 program: CPA To add these students, we want to store these documents into a variable first. Define a variable named starray and add these two document to the variable. (You are storing more than one document so you need to define an array.) write the command to define the array: Now, use the starray array to insert the documents to your collection student. Write your insert statement:
What is the value of the mode when all values in the data set are distinct? NoneOneNumber of observationsZero
Load “Lock5Data” into your R console. Load “OlympicMarathon” data set in“Lock5Data”. This data set contains population of all times to finish the 2008Olympic Men’s Marathon.a. What is the population size?b. Now using “Minutes” column generate a random sample of size 5.c. Calculate the sample mean and record it (create a excel sheet or write adirect R program to record this)d. Continue steps (b) and (c) 10,000 time (that mean you have recorded 10,000sample means)What you have in step (d) is closely resemble to distribution of sample meanswith sample size 5. e. Calculate the mean of 10,000 sample means.f. Calculate the population mean (that mean using all data in “Minutes” column)g. According to the central limit theorem, if conditions satisfied, then the mean ofdistribution of sample mean should be close to the population mean. Nowcompare your results for part (e) and (f). Are they same or at least close toeach other?h. Calculate the standard deviation for 10,000 data points you have…
Load “Lock5Data” into your R console. Load “OlympicMarathon” data set in“Lock5Data”. This data set contains population of all times to finish the 2008Olympic Men’s Marathon.a. What is the population size?b. Now using “Minutes” column generate a random sample of size 5.c. Calculate the sample mean and record it (create a excel sheet or write adirect R program to record this)d. Continue steps (b) and (c) 10,000 time (that mean you have recorded 10,000sample means)
astfoodStats Assignment Description For this assignment, name your R file fastfoodStats.R For all questions you should load tidyverse, openintro, and lm.beta. You should not need to use any other libraries. suppressPackageStartupMessages(library(tidyverse)) suppressPackageStartupMessages(library(openintro)) suppressPackageStartupMessages(library(lm.beta)) The actual data set is called fastfood. Continue to use %>% for the pipe. CodeGrade does not support the new pipe. Round all float/dbl values to two decimal places. All statistics should be run with variables in the order I state E.g., "Run a regression predicting mileage from mpg, make, and type" would be: lm(mileage ~ mpg + make + type...) To access the fastfood data, run the following: fastfood <- openintro::fastfood Create a correlation matrix for the relations between calories, total_fat, sugar, and calcium for all items at Sonic, Subway, and Taco Bell, omitting missing values with na.omit(). Assign the…
Objective: This activity has the purpose of helping students to design proper hashing strategies. (Objective 3). Students Instructions: After studying this module, write the answer to the following programming assignments in a text file and submit them as an attached Word doc or PDF through the provided link in Blackboard. The deadline for submitting this assignment is indicated on "Tools", which is located in "Calendar" in the "Blackboard" platform. You will have two (2) attempt to send your answers by Assignment link before the deadline and the last submission would be considered as your final solution. This exercise has Implement a dictionary by using hashing and separate chaining. Question:
Create a data type that allows you to insert, remove the maximum, and delete the minimum (all in logarithmic time), as well as locate the maximum and find the minimum (both in constant time). Use two piles as a hint.