Data analysis using the tally function

Assignment Help Database Management System
Reference no: EM132238752

Analysis 1

Background: This assignment focuses on data analysis using the tally() function. You must be able to analyze data before you try to present data through visualizations.

Assignment:

Use RStudio and R Markdown to generate a Word document with the R commands and answers to all of the data analysis questions listed below.

Submit only one document with all of your answers.

Follow the formatting requirements identified in the Install R Markdown video in Week 2.

Follow the data analysis instructions provided in the videos this week.

Use the appropriate dataset for each question. All required datasets are available on Blackboard at the bottom of this week.

Use the tally() function to produce the correct answer for each of the questions listed below.

Carefully choose the correct field operators and logical operators when writing the tally() function.

In your final Word document, circle the correct answer for each question when the results of the tally() function create a table rather than a single answer. Failure to circle the correct answer will result in zero points for that question.

Questions:

1) What percentage of females purchased a 2nd class ticket in the dataset?

2) What percentage of males purchased a 1st class ticket and survived in the dataset?

3) What percentage of males purchased a 2nd class or 3rd class ticket in the dataset?

4) What percentage of males paid for meals under $17.50 are in the dataset?

5) What percentage of males paid for meals on Saturday that was over $17.50 are in the dataset?

6) What proportion of males and females never smoked in the dataset?

7) What proportion of females do not exercise and do smoke in the dataset?

8) What proportion of males and females never smoked and exercise frequently in the dataset?

9) What percentage of petal length are greater than and equal to 4.5?

10) What proportion of species have petal widths greater than 1.0 in the dataset?

Attachment:- dataset price personal computers.rar

Reference no: EM132238752

Questions Cloud

Costly method of moving product that is not gaseous : Generally the least costly method of moving product that is not gaseous, liquid, or slurry is:
What steps could be taken to build staff confidence : How can Laura most effectively use both management and leadership skills in her role as associate director?
Design a single digit counter in base 4 that can be joined : Design a single digit counter in base 4 that can be joined up to other modules to count to larger numbers. The modules must follow the specified design so that they are compatible with modules designed by other groups. Each of the 2 light input signa..
Discuss the pros and cons in business with china and mexico : Mexico and China are both popular destinations for outsourcing, foreign direct investments and offshoring.
Data analysis using the tally function : What percentage of females purchased a 2nd class ticket in the dataset - What percentage of males paid for meals on Saturday that was over $17.50
Assume that asynchronous transmission is used with 1 start : A data source produces 7-bit IRA (International Reference Alphabet) characters. Suppose a file of 10,000 IRA characters is to be sent over a line at 4800 bps. Assume that asynchronous transmission is used with 1 start bit, 1 stop bit and 1 parity bit..
Leaders are born and not made also give suitable examples : Leaders are born and not made. also Give suitable examples
Discuss one cognitive or one pharmacological therapy : Discuss one cognitive or one pharmacological therapy you feel has significant potential in treating clients. Identify a disorder that it is used as a treatment.
Derivation and right most derivation : What is the different between left most derivation and right most derivation

Reviews

Write a Review

Database Management System Questions & Answers

  Describe what entity represents in an er mode

Describe what entity represents in an ER mode and provide examples of entities with a physical or conceptual existence. Describe how strong and weak entities differ and provide an example of each.

  Write a script that inserts a new row into customers table

Write a script that inserts a new row into the Customers table for each customer stored in the NewCustomers.xml file that's in the Exercise Starts directory.

  What is required to define a well-posed learning problem

Write an algorithm called \Find-G" to nd a maximally-general consistent hypothesis. You can assume the data will be noise-free and that the target concept is in the hypothesis space.

  Create a database to keep track of all the courses

The chairperson in the ISOM department at GMU needs to create a database to keep track of all the courses offered by the department.

  Create a role for user to complete imports & exports of data

Use the DTS utility to Import the data from the text file into your SQL Server database. Show screen shots of the import steps and provide a screen shot of the table rows in the Enterprise Manager once the data is imported.

  How to provide the necessary data to the researcher

What steps are required before the researcher can obtain any data - What would be the applicable policy and regulations based on the module lecture notes

  Explain the methods to optimize database components

Evaluate at least two methods that can be used to optimize database components such as queries, reports SQL transaction processing, and data consumption.

  Reverse-complement of a dna string

The reverse-complement of a DNA string is a new string in which each nucleotide is replaced by its complement and the string is reversed -  its complementary strand can be read in its forward direction, which is reverse of the original string's dire..

  Difference between data and information and knowledge

Briefly explain the difference between data, information, and knowledge. -  Briefly explain the difference between explicit and tacit knowledge. Give an example of each.

  Compare the four dbmss on different parameters

Explore and research the latest versions of the following database management systems (DBMSs) on the market: Oracle 11G, Microsoft SQL Server, MySQL, and IBM DB2. Compare the four DBMSs on different parameters, including pros and cons

  Draw the entity relationship model

Draw the Entity Relationship model - draw the relational schema to show the relationship between DIRECTOR and PLAY.

  Distinguish database management system and a database

Explain the difference between a database management system (DBMS) and a database.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd